WETH-USDT OHLC on Ethereum

Returns 10 DEX trades by token on Ethereum, where currency smart contract is 0xdac1…1ec7, side currency smart contract is 0xc02a…6cc2 and side type is buy, sorted by block testfield, highest first: block time, sum of trade amount, trade price and count.

By Divyasshree · saved 21 May 2024 · run 47 times · Bitquery API v2

What it returns

Filters

The query

{
  EVM(network: eth, dataset: archive) {
    DEXTradeByTokens(
      orderBy: {descendingByField: "Block_testfield"}
      where: {Trade: {Currency: {SmartContract: {is: "0xdac17f958d2ee523a2206206994597c13d831ec7"}}, Side: {Currency: {SmartContract: {is: "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"}}, 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