v2-equivalant-ohlc-and-volume-inUSD

Returns DEX trades by token on Ethereum, where currency smart contract is 0xb23d…28CF, side currency smart contract is 0xC02a…6Cc2 and DEX protocol family is Uniswap: currency symbol, smart contract, price in USD, side currency symbol, side smart contract, count, sum of trade amount in USD and block time.

By Kshitij Mahajan · saved 26 September 2024 · run 4 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(network: eth) {
    DEXTradeByTokens(
      where: {Trade: {Currency: {SmartContract: {is: "0xb23d80f5FefcDDaa212212F028021B41DEd428CF"}}, Side: {Currency: {SmartContract: {is: "0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2"}}}, PriceAsymmetry: {lt: 1}, Dex: {ProtocolFamily: {is: "Uniswap"}}}, Block: {Time: {since: "2024-09-26T10:00:00Z"}}}
    ) {
      Trade {
        Currency {
          Symbol
          SmartContract
        }
        open: PriceInUSD(minimum: Block_Number)
        close: PriceInUSD(maximum: Block_Number)
        high: PriceInUSD(maximum: Trade_PriceInUSD)
        low: PriceInUSD(minimum: Trade_PriceInUSD)
        Side {
          Currency {
            Symbol
            SmartContract
          }
        }
      }
      trades: count
      volume: sum(of: Trade_AmountInUSD)
      Block {
        Time(interval: {count: 30, in: minutes})
      }
    }
  }
}

Similar queries