Top 500 Pancake V2
Returns 10 DEX trades by token on BNB Chain, where currency smart contract is 0xe9e7…7d56 and block time after 2024-11-23, sorted by USD, highest first: decimals, currency name, currency symbol, smart contract, side decimals, side currency name, side currency symbol and 3 more fields.
What it returns
- decimals
- currency name
- currency symbol
- smart contract
- side decimals
- side currency name
- side currency symbol
- side smart contract
- sum of trade amount in USD
- count
Filters
- currency smart contract is 0xe9e7…7d56
- block time after 2024-11-23
The query
query tokenTrades($network: evm_network, $token: String, $yesterday_at_midnight: DateTime) {
EVM(network: $network) {
DEXTradeByTokens(
limit: {count: 10}
orderBy: {descendingByField: "usd"}
where: {Trade: {Currency: {SmartContract: {is: $token}}}, Block: {Time: {after: $yesterday_at_midnight}}}
) {
Trade {
Currency {
Decimals
Name
Symbol
SmartContract
}
Side {
Currency {
Decimals
Name
Symbol
SmartContract
}
}
}
usd: sum(of: Trade_AmountInUSD)
count
}
}
}
Variables
{
"network": "bsc",
"token": "0xe9e7cea3dedca5984780bafc599bd69add087d56",
"yesterday_at_midnight": "2024-11-23T00:00:00Z"
}
Similar queries
- bStocks 3am: QQQB 30-day DEX volume · BNB Chain · DEXTradeByTokens
- bStocks 3am: tokenized Tesla 30-day volume · BNB Chain · DEXTradeByTokens
- bsc token ohlcv · BNB Chain · DEXTradeByTokens
- optimized query to get pools data · Ethereum · DEXTradeByTokens
- KTI_primeiros_trades · BNB Chain · DEXTradeByTokens