delabs_ohlc_eth

Returns DEX trades by token, where side currency smart contract is 0xc02a…6cc2 and currency smart contract is 0xdac1…1ec7, sorted by block time: block time, block number, sum of trade amount, buyer, trade amount, currency name, currency symbol and 10 more fields.

By George · saved 13 June 2024 · run 1 time · Bitquery API v2

What it returns

Filters

The query

{
  EVM(dataset: realtime) {
    DEXTradeByTokens(
      orderBy: {ascendingByField: "Block_Time"}
      where: {Trade: {Side: {Currency: {SmartContract: {is: "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"}}}, Currency: {SmartContract: {is: "0xdac17f958d2ee523a2206206994597c13d831ec7"}}}}
    ) {
      Block {
        Time(interval: {in: hours, count: 1})
        lastTradeTime: Time(maximum: Block_Time)
        FirstTradeTime: Time(minimum: Block_Time)
        LastTradeBlock: Number(maximum: Block_Number)
        FirstTradeBlock: Number(minimum: Block_Number)
      }
      volume: sum(of: Trade_Amount)
      Trade {
        Buyer
        Amount
        Currency {
          Name
          Symbol
        }
        Dex {
          Pair {
            SmartContract
          }
          OwnerAddress
          ProtocolName
          SmartContract
        }
        Seller
        Price
        Sender
        Side {
          Currency {
            Name
            Symbol
          }
          Amount
        }
        high: Price(maximum: Trade_Price)
        low: Price(minimum: Trade_Price)
        open: Price(minimum: Block_Number)
        close: Price(maximum: Block_Number)
      }
      count
    }
  }
}

Similar queries