ohlcv_roni_v2

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, price in USD, currency name, smart contract and 4 more fields.

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_timestamp"}
      where: {Trade: {Dex: {SmartContract: {is: "0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640"}}}}
    ) {
      Block {
        timestamp: 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)
        Currency {
          Name
          SmartContract
          Symbol
        }
        Side {
          Currency {
            Name
            SmartContract
            Symbol
          }
        }
      }
    }
  }
}

Similar queries