top sellers of a currency on uniswap v4 pool base
Returns 10 DEX trades on Base, where sell currency smart contract is 0x4200…0006, trade pool ID is 0x7c76…4f30 and DEX protocol name is uniswap_v4, sorted by sold in USD, highest first: buy currency name, buy currency symbol, buy smart contract, buy decimals, buy seller, sum of trade buy amount and sum of trade buy amount in USD.
What it returns
- buy currency name
- buy currency symbol
- buy smart contract
- buy decimals
- buy seller
- sum of trade buy amount
- sum of trade buy amount in USD
Filters
- sell 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: "sold_in_usd"}
limit: {count: 10}
where: {Trade: {Dex: {ProtocolName: {is: "uniswap_v4"}}, Sell: {Currency: {SmartContract: {is: "0x4200000000000000000000000000000000000006"}}}, PoolId: {is: "0x7c76fa7f6d64061837c3e03002f6362daa51ff9cc3c0ebbed69f140ca3844f30"}}}
) {
Trade {
Buy {
Currency {
Name
Symbol
SmartContract
Decimals
}
Seller
}
}
sold: sum(of: Trade_Buy_Amount)
sold_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