Copy of top-example-buy-sell
Returns 3000 DEX trades by token on Ethereum, where currency smart contract is 0x8802…1ab6, sorted by volume, highest first: from, to, count, sum of trade amount and sum of trade side amount in USD.
What it returns
- from
- to
- count
- sum of trade amount
- sum of trade side amount in USD
Filters
- currency smart contract is 0x8802…1ab6
The query
query TopTraders {
EVM(network: eth, dataset: archive) {
DEXTradeByTokens(
orderBy: {descendingByField: "volume"}
limit: {count: 3000}
where: {Trade: {Currency: {SmartContract: {is: "0x8802269D1283cdB2a5a329649E5cB4CdcEE91ab6"}}}, TransactionStatus: {Success: true}}
) {
Transaction {
From
To
}
count(distinct: Transaction_To)
buys: count(if: {Trade: {Side: {Type: {is: buy}}}})
sells: count(if: {Trade: {Side: {Type: {is: sell}}}})
volume: sum(of: Trade_Amount)
volumeUsd: sum(of: Trade_Side_AmountInUSD)
}
}
}
Similar queries
- CRV hourly OHLC on Curve - Ethereum · Ethereum · DEXTradeByTokens
- Top Metric liquidity pools by 24h volume on Ethereum · Ethereum · DEXTradeByTokens
- ATH of eth token · Ethereum · DEXTradeByTokens
- historical price and historical volume · Ethereum · DEXTradeByTokens
- topTraders EVM · Ethereum · DEXTradeByTokens