opsin OHLC

Returns 100 DEX trades by token on Ethereum, where currency smart contract is 0x1945…3F6B, side currency smart contract is 0xc02a…6cc2 and side type is buy, sorted by block testfield, highest first: block time, sum of trade amount, price in USD and count.

By Divyasshree · saved 9 October 2024 · run 64 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: "0x1945E804B8A25b98ab140e58295404d768cA3F6B"}}, Side: {Currency: {SmartContract: {is: "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"}}, Type: {is: buy}}}, Block: {Time: {till: "2024-12-09T23:59:59Z"}}}
      limit: {count: 100}
    ) {
      Block {
        testfield: Time(interval: {in: minutes, count: 1})
      }
      volume: sum(of: Trade_Amount)
      Trade {
        high: PriceInUSD(maximum: Trade_PriceInUSD)
        low: PriceInUSD(minimum: Trade_PriceInUSD)
        open: PriceInUSD(minimum: Block_Number)
        close: PriceInUSD(maximum: Block_Number)
      }
      count
    }
  }
}

Similar queries