all-traders-sort
Returns 500 DEX trades by token on Ethereum, where currency smart contract is 0x8802…1ab6, sorted by bought: from, to, sum of trade side amount in USD and sum of trade amount.
What it returns
- from
- to
- sum of trade side amount in USD
- sum of trade amount
Filters
- currency smart contract is 0x8802…1ab6
The query
query TopTraders {
EVM(network: eth, dataset: combined) {
DEXTradeByTokens(
orderBy: {ascendingByField: "bought", descendingByField: "sold"}
limit: {count: 500}
where: {Trade: {Currency: {SmartContract: {is: "0x8802269D1283cdB2a5a329649E5cB4CdcEE91ab6"}}}, TransactionStatus: {Success: true}}
) {
Transaction {
From
To
}
bought: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}}
selectWhere: {gt: "0"}
)
sold: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}}
selectWhere: {gt: "0"}
)
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