Recent Top Traders by Pair Address
Returns DEX trades by token on Ethereum, where DEX smart contract is 0x65bE…b2b0, sorted by volume, highest first: from, protocol name, protocol family, currency symbol, currency name, smart contract, side currency name and 4 more fields.
What it returns
- from
- protocol name
- protocol family
- currency symbol
- currency name
- smart contract
- side currency name
- side currency symbol
- side smart contract
- sum of trade side amount in USD
- sum of trade amount
Filters
- DEX smart contract is 0x65bE…b2b0
The query
query TopTraders($pair: String) {
EVM(network: eth, dataset: combined) {
DEXTradeByTokens(
orderBy: {descendingByField: "volume"}
where: {Trade: {Dex: {SmartContract: {is: $pair}}}, TransactionStatus: {Success: true}}
) {
Transaction {
From
}
Trade {
Dex {
ProtocolName
ProtocolFamily
}
Currency {
Symbol
Name
SmartContract
}
Side {
Currency {
Name
Symbol
SmartContract
}
}
}
boughtUSD: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}}
selectWhere: {gt: "0"}
)
soldUSD: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}}
selectWhere: {gt: "0"}
)
boughtAmount: sum(
of: Trade_Amount
if: {Trade: {Side: {Type: {is: sell}}}}
selectWhere: {gt: "0"}
)
soldAmount: sum(
of: Trade_Amount
if: {Trade: {Side: {Type: {is: buy}}}}
selectWhere: {gt: "0"}
)
volume: sum(of: Trade_Amount)
volumeUsd: sum(of: Trade_Side_AmountInUSD)
}
}
}
Variables
{
"pair": "0x65bE3A91e189555Be1524262B7a9a1E66296b2b0"
}
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