getHoldersBuys

Returns DEX trades on Base, where buy currency smart contract is 0x8335…2913 and buy seller is 0xf977…acec, 0xd451…c0fb or 48 more: count, buy seller, buy amount, buy amount in USD, average of trade buy amount in USD and average of trade buy amount.

By Maximiliano Malvido · saved 2 December 2024 · Bitquery API v2

What it returns

Filters

The query

query getHoldersBuyCounts(
  $dataset: dataset_arg_enum!
  $network: evm_network!
  $wallets: [String!]!
  $tokenAddress: String!
) {
  EVM(network: $network, dataset: $dataset) {
    Sells: DEXTrades(
      where: {
        TransactionStatus: { Success: true }
        Trade: { Buy: { Currency: { SmartContract: { is: $tokenAddress } }, Seller: { in: $wallets } } }
      }
    ) {
      BuysCounts: count
      Sellers: Trade {
        Buy {
          Seller
          Amount
          AmountInUSD
        }
      }
      AvgAmountInUSD: average(of: Trade_Buy_AmountInUSD)
      AvgAmount: average(of: Trade_Buy_Amount)
    }
  }
}

Variables

{
  "network": "base",
  "dataset": "archive",
  "tokenAddress": "0x833589fcd6edb6e08f4c7c32d4f71b54bda02913",
  "wallets": [
    "0xf977814e90da44bfa03b6295a0616a897441acec",
    "0xd451e3919950963e9c1ca2f78a987dbd7937c0fb",
    "0x21bd501f86a0b5ce0907651df3368da905b300a9",
    "0xadbbe373b5b5f72c59c0311cffbded51f0c5f434",
    "0x0b0a5886664376f59c351ba3f598c8a8b4d0a6f3",
    "0x95f90ce2e3abaed29eeebdb42e1fdb146e0f848a",
    "0x607094ed3a8361bb5e94dd21bcbef2997b687478",
    "0x336307f2d8390035ba926a61a86b45ca9dc91e57",
    "0x9b4fc9e22b46487f0810ef5dfa230b9f139e5179",
    "0x57a7560d0ec28065762203c0d633943298eac7c0",
    "0xee81b5afc73cf528778e0ed98622e434e5efadb4",
    "0x7c310a03f4cfa19f7f3d7f36dd3e05828629fa78",
    "0x8196f70b2c17ba58d8ef56ad62087ee8231be33a",
    "0x67857ee12929e74082f1cae64ef4221830c39113",
    "0x1b4c15b991543a6082213a88276e7a83c9985676",
    "0xa2908f1758d1cc3990f4a2da8dea0aa2ecf1b913",
    "0x49866a9cfe9129fbb0b93dcdb4b5eb758ee3f9be",
    "0x27724b0d4fb98a89a092e6a4adbc09154c182637",
    "0x122fdd9fecbc82f7d4237c0549a5057e31c8ef8d",
    "0xd5c41fd4a31eaaf5559ffcc60ec051fcb8ecc375",
    "0x7c41fdced2ea646ed85665d1a9b28e6632b61c41",
    "0x3304e22ddaa22bcdc5fca2269b418046ae7b566a",
    "0x6cdcb1c4a4d1c3c6d054b27ac5b77e89eafb971d",
    "0x315503ad1c0f1b6d958cdceb7e46413f32bc3b5a",
    "0xaac391f166f33cdaefaa4afa6616a3bea66b694d",
    "0xb4807865a786e9e9e26e6a9610f2078e7fc507fb",
    "0xf213f2d02837012dc0236cc105061e121bb03e37",
    "0xb2cc224c1c9fee385f8ad6a55b4d94e92359dc59",
    "0xbde0c70bdc242577c52dfad53389f82fd149ea5a",
    "0x99d8fe9ee2e829ad5a08ab5ed8f2f961458d1f25",
    "0x42f35626c02a5b12947fa9f04a93bb4f42d4d9bb",
    "0xcf89d53ae542c2addba14b81f195ba31c68afd53",
    "0x9aee0e40ec38fd7bc84a878308617e8f56ebb7ff",
    "0x1ad3fa336c5386ef86b539fc4fd6b58b5d0e8de5",
    "0x27b068a5142c055f226670563c81ff5de0d56578",
    "0x31f6468bbb841d48890c8483329698693760c805",
    "0x96fdb5fabcf5fe3e54077f5d35c505a1d3a3a851",
    "0x4b9e5882f3d8256444d540464cb0c3fd4b929464",
    "0x3d218ba6bcd6125b40ca0fa52bd646b6d792d39d",
    "0x9999852dd63e551dda72b748f1e7de223a13d6bf",
    "0xbdcbe60419f46931fed8ee58ed89433779e0cb73",
    "0x0f018ac4ee11a2ba52f102be414e8c2c6e240a1a",
    "0xcdac0d6c6c59727a65f871236188350531885c43",
    "0xbaed383ede0e5d9d72430661f3285daa77e9439f",
    "0xbbbbbbbbbb9cc5e90e3b3af64bdaf62c37eeffcb",
    "0x8f1e2f1e5d472c8f3452109a224ad8d960a4fc4b",
    "0x559756d476d5ed4533edc3ac98e5a9468176378c",
    "0x8dd9751961621fcfc394d90969e5ae0c5babe147",
    "0x6d0b9c9e92a3de30081563c3657b5258b3ffa38b",
    "0xbaa850bc2ecc6a4f356445f4a853281a42bd2fbb"
  ]
}

Similar queries