ohlc for a pair on Arbitrum

Returns DEX trades by token on Arbitrum, where side currency smart contract is 0xff97…5cc8, currency smart contract is 0x912c…6548 and block time since 2024-11-17, sorted by block time: block time, price in USD and sum of trade amount in USD.

By Kshitij Mahajan · saved 20 November 2024 · Bitquery API v2

What it returns

Filters

The query

query tradingViewPairs($network: evm_network, $dataset: dataset_arg_enum, $interval: Int, $token: String, $base: String, $time_ago: DateTime) {
  EVM(network: $network, dataset: $dataset) {
    DEXTradeByTokens(
      orderBy: {ascendingByField: "Block_Time"}
      where: {Trade: {Side: {Amount: {gt: "0"}, Currency: {SmartContract: {is: $token}}}, Currency: {SmartContract: {is: $base}}}, Block: {Time: {since: $time_ago}}}
    ) {
      Block {
        Time(interval: {count: $interval, in: minutes})
      }
      Trade{
        open: PriceInUSD(minimum: Block_Time)
        close: PriceInUSD(maximum: Block_Time)
        max: PriceInUSD(maximum: Trade_PriceInUSD)
        min: PriceInUSD(minimum: Trade_PriceInUSD)
      }
      volume: sum(of: Trade_AmountInUSD)
    }
  }
}

Variables

{
  "network": "arbitrum",
  "base": "0x912ce59144191c1204e64559fe8253a0e49e6548",
  "token": "0xff970a61a04b1ca14834a43f5de4533ebddb5cc8",
  "time_ago": "2024-11-17T07:59:49Z",
  "interval": 5,
  "dataset": "realtime"
}

Similar queries