top sellers of a token on uniswap v4 pool optimism
Historical data This query uses the realtime dataset (the default), which holds only a recent window - hours to days depending on the cube. For older data add a dataset to the top-level element: EVM(network: optimism, dataset: combined) archive full history combined archive + realtime in one resu
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 0x0b2c…ff85
- trade pool ID is 0x7ecc…b901
- DEX protocol name is uniswap_v4
The query
# Historical data
# This query uses the realtime dataset (the default), which holds only a
# recent window - hours to days depending on the cube.
#
# For older data add a dataset to the top-level element:
#
# EVM(network: optimism, dataset: combined)
#
# archive full history
# combined archive + realtime in one result
#
# Archive and combined need the historical data add-on:
# https://bitquery.io/pricing
#
# Datasets: https://docs.bitquery.io/docs/graphql/dataset/archive/
# Retention: https://docs.bitquery.io/docs/graphql/data-coverage-retention/
#
{
EVM(network: optimism) {
DEXTrades(
orderBy: {descendingByField: "sold_in_usd"}
limit: {count: 10}
where: {Trade: {Dex: {ProtocolName: {is: "uniswap_v4"}}, Sell: {Currency: {SmartContract: {is: "0x0b2c639c533813f4aa9d7837caf62653d097ff85"}}}, PoolId: {is: "0x7ecc49f61e5c082ccd8d242dae2ffe8eb0b3b833c870b1f291753b37299db901"}}}
) {
Trade {
Buy {
Currency {
Name
Symbol
SmartContract
Decimals
}
Seller
}
}
sold: sum(of: Trade_Buy_Amount)
sold_in_usd: sum(of: Trade_Buy_AmountInUSD)
}
}
}
Similar queries
- Velodrome v2 Pool Swaps on Optimism · Optimism · DEXTrades
- trades · Ethereum · DEXTrades
- List of DEX supported · Optimism · DEXTrades
- top buyers of a currency on uniswap v4 optimism · Optimism · DEXTrades
- Latest Trades for a currency pair on optimism · Optimism · DEXTrades