pnl-2
Returns 3000 DEX trades by token on Ethereum, where currency smart contract is ${token}, sorted by volume, highest first: 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 ${token}
The query
query TopTraders {
EVM(network: eth, dataset: combined) {
DEXTradeByTokens(
orderBy: {descendingByField: "volume"}
limit: {count: 3000}
where: {Trade: {Currency: {SmartContract: {is: "${token}"}}}, 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