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.

By Moana · saved 24 November 2024 · run 1 time · Bitquery API v2

What it returns

Filters

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