Top-traders-in-eth
Returns 20 DEX trades by token, where currency smart contract is 0xC902…f3Ad, sorted by volume, highest first: protocol name, protocol family, currency symbol, currency name, smart contract, sum of trade side amount in USD and sum of trade amount.
What it returns
- protocol name
- protocol family
- currency symbol
- currency name
- smart contract
- sum of trade side amount in USD
- sum of trade amount
Filters
- currency smart contract is 0xC902…f3Ad
The query
query TopTraders($token: String) {
EVM {
DEXTradeByTokens(
orderBy: {descendingByField: "volume"}
limit: {count: 20}
where: {Trade: {Currency: {SmartContract: {is: $token}}}, TransactionStatus: {Success: true}}
) {
Trade {
Dex {
ProtocolName
ProtocolFamily
}
Currency {
Symbol
Name
SmartContract
}
}
bought: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}}
selectWhere: {gt: "0"}
)
sold: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}}
selectWhere: {gt: "0"}
)
volume: sum(of: Trade_Amount)
volumeUsd: sum(of: Trade_Side_AmountInUSD)
}
}
}
Variables
{
"token": "0xC90242Cd9959b7Be6EC01B5e99702Ee21161f3Ad"
}
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