ohlc_roni_v2_1

Returns the latest DEX trades by token, where DEX smart contract is 0x88e6…5640: block time, sum of trade amount, sum of trade amount in USD, trade price and price in USD.

By George · saved 26 June 2024 · run 3 times · Bitquery API v2

What it returns

Filters

The query

{
  EVM(dataset: realtime) {
    DEXTradeByTokens(
      orderBy: {descendingByField: "Block_Time"}
      where: {Trade: {Dex: {SmartContract: {is: "0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640"}}}}
      limitBy: {by: Transaction_Hash, offset: 1}
    ) {
      Block {
        Time(interval: {in: minutes, count: 5})
      }
      volume: sum(of: Trade_Amount)
      volumeInUSD: sum(of: Trade_AmountInUSD)
      Trade {
        high: Price(maximum: Trade_Price)
        low: Price(minimum: Trade_Price)
        open: Price(minimum: Block_Number)
        close: Price(maximum: Block_Number)
        highInUSD: PriceInUSD(maximum: Trade_PriceInUSD)
        lowInUSD: PriceInUSD(minimum: Trade_PriceInUSD)
        openInUSD: PriceInUSD(minimum: Block_Number)
        closeInUSD: PriceInUSD(maximum: Block_Number)
      }
    }
  }
}

Similar queries