OHLC-of-AERO-Coin

Returns 10 DEX trades by token on Base, where currency smart contract is 0x9401…8631, side currency smart contract is 0x8335…2913 and side type is buy, sorted by block testfield, highest first: block time, sum of trade amount, trade price and count.

By Kshitij Mahajan · saved 10 July 2024 · run 1 time · Bitquery API v2

What it returns

Filters

The query

{
  EVM(network: base, dataset: combined) {
    DEXTradeByTokens(
      orderBy: {descendingByField: "Block_testfield"}
      where: {Trade: {Currency: {SmartContract: {is: "0x940181a94A35A4569E4529A3CDfB74e38FD98631"}}, Side: {Currency: {SmartContract: {is: "0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913"}}, Type: {is: buy}}}}
      limit: {count: 10}
    ) {
      Block {
        testfield: Time(interval: {in: hours, count: 1})
      }
      volume: sum(of: Trade_Amount)
      Trade {
        high: Price(maximum: Trade_Price)
        low: Price(minimum: Trade_Price)
        open: Price(minimum: Block_Number)
        close: Price(maximum: Block_Number)
      }
      count
    }
  }
}

Similar queries