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.
What it returns
- count
- buy seller
- buy amount
- buy amount in USD
- average of trade buy amount in USD
- average of trade buy amount
Filters
- buy currency smart contract is 0x8335…2913
- buy seller is 0xf977…acec, 0xd451…c0fb or 48 more
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
- Zora Trades For A Wallet Up To A Block · Base · DEXTrades
- dex_trade_by_tx_base · Base · DEXTrades
- base dextrades · Base · DEXTrades
- trades · Ethereum · DEXTrades
- base_aerodrome_slipstream · Base · DEXTrades