top buyers of a currency on uniswap v4 pool base
Returns 100 DEX trades on Base, where buy currency smart contract is 0x4200…0006, trade pool ID is 0x7c76…4f30 and DEX protocol name is uniswap_v4, sorted by bought in USD, highest first: sell currency name, sell currency symbol, sell smart contract, sell decimals, sell buyer, sum of trade buy amount and sum of trade buy amount in USD.
What it returns
- sell currency name
- sell currency symbol
- sell smart contract
- sell decimals
- sell buyer
- sum of trade buy amount
- sum of trade buy amount in USD
Filters
- buy currency smart contract is 0x4200…0006
- trade pool ID is 0x7c76…4f30
- DEX protocol name is uniswap_v4
The query
{
EVM(network: base) {
DEXTrades(
orderBy: {descendingByField: "bought_in_usd"}
limit: {count: 100}
where: {Trade: {Dex: {ProtocolName: {is: "uniswap_v4"}}, Buy: {Currency: {SmartContract: {is: "0x4200000000000000000000000000000000000006"}}}, PoolId: {is: "0x7c76fa7f6d64061837c3e03002f6362daa51ff9cc3c0ebbed69f140ca3844f30"}}}
) {
Trade {
Sell {
Currency {
Name
Symbol
SmartContract
Decimals
}
Buyer
}
}
bought: sum(of: Trade_Buy_Amount)
bought_in_usd: sum(of: Trade_Buy_AmountInUSD)
}
}
}
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