uniswap_pool_volfilter

Returns 10 DEX trades on Ethereum, where block date is 2024-03-22, sorted by token1 vol: count, sum of trade buy amount in USD, sum of trade sell amount in USD, pair name and smart contract.

By George · saved 21 June 2024 · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(dataset: archive, network: eth) {
    DEXTrades(
      orderBy: {ascendingByField: "token1_vol"}
      limit: {count: 10}
      where: {Block: {Date: {is: "2024-03-22"}}}
    ) {
      Buyers: count(distinct: Trade_Buy_Buyer)
      Sellers: count(distinct: Trade_Buy_Seller)
      token1_vol: sum(of: Trade_Buy_AmountInUSD, selectWhere: {ge: "10000", le: "10000000"})
      token2_vol: sum(of: Trade_Sell_AmountInUSD, selectWhere: {ge: "10000", le: "10000000"})
      Trade {
        Dex {
          Pair {
            Name
            SmartContract
          }
        }
      }
    }
  }
}

Similar queries