top buyers of a currency on uniswap v4 arbitrum
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: arbitrum, dataset: combined) archive full history combined archive + realtime in one resu
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 0xaf88…5831
- trade pool ID is 0x0958…a722
- 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: arbitrum, 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: arbitrum) {
DEXTrades(
orderBy: {descendingByField: "bought_in_usd"}
limit: {count: 100}
where: {Trade: {Dex: {ProtocolName: {is: "uniswap_v4"}}, Buy: {Currency: {SmartContract: {is: "0xaf88d065e77c8cc2239327c5edb3a432268e5831"}}}, PoolId: {is: "0x09588c415f6c809de684d3dd749e76d6bf0c12ac37d1d59a79e746013384a722"}}}
) {
Trade {
Sell {
Currency {
Name
Symbol
SmartContract
Decimals
}
Buyer
}
}
bought: sum(of: Trade_Buy_Amount)
bought_in_usd: sum(of: Trade_Buy_AmountInUSD)
}
}
}
Similar queries
- trades · Ethereum · DEXTrades
- List of DEX supported · Arbitrum · DEXTrades
- Param - first 1000 · Arbitrum · DEXTrades
- top sellers of a token on uniswap v4 arbitrum · Arbitrum · DEXTrades
- Latest Trades for a currency pair on arbitrum · Arbitrum · DEXTrades