Base Uniswap 3 empty dex pairs

Returns DEX trades on Base, where DEX protocol name is uniswap_v3 and block time since 2024-06-03: buy currency symbol, buy price, sell currency symbol, sell price, smart contract, pair name, sum of trade buy amount and sum of trade sell amount.

By Coinranking · saved 6 June 2024 · run 7 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(dataset: realtime, network: base) {
    DEXTrades(
      where: {
        Trade: {
          Dex: {
            # Pair: {
            #   SmartContract: {
            #     in: ["0x06cd6245156c3608ae67d690c125e86a8bc6a88c"]
            #   }
            # }
            ProtocolName: { is: "uniswap_v3" }
          }
        }
        Block: { Time: { since: "2024-06-03T10:51:31.046Z" } }
      }
    ) {
      Trade {
        Buy {
          Currency {
            Symbol
          }
          High: Price(maximum: Trade_Buy_Price)
          Low: Price(minimum: Trade_Buy_Price)
          Open: Price(minimum: Block_Number)
          Close: Price(maximum: Block_Number)
        }
        Sell {
          Currency {
            Symbol
          }
          High: Price(maximum: Trade_Sell_Price)
          Low: Price(minimum: Trade_Sell_Price)
          Open: Price(minimum: Block_Number)
          Close: Price(maximum: Block_Number)
        }
        Dex {
          Pair {
            SmartContract
            Name
          }
        }
      }
      volumeBuy: sum(of: Trade_Buy_Amount)
      volumeSell: sum(of: Trade_Sell_Amount)
    }
  }
}

Similar queries