Example query OHLC quantile

Returns DEX trades by token on Polygon, where side currency smart contract is 0x7ceb…f619, currency smart contract is 0x0d50…1270 and side amount is above 0, sorted by block time: block time, quantile of trade price in USD, average of trade price in USD and sum of trade side amount.

By Aleksey · saved 26 September 2024 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query tradingViewPairs($network: evm_network, $token: String, $base: String) {
  EVM(network: $network) {
    DEXTradeByTokens(
      orderBy: {ascendingByField: "Block_Time"}
      where: {Trade: {Side: {Amount: {gt: "0"}, Currency: {SmartContract: {is: $base}}}, Currency: {SmartContract: {is: $token}}}}
    ) {
      Block {
        Time(interval: {count: 5, in: minutes})
      }
      
      min: quantile(of: Trade_PriceInUSD level: 0.05)
      max: quantile(of: Trade_PriceInUSD level: 0.95)
      close: average(of: Trade_PriceInUSD)
      
      
      volume: sum(of: Trade_Side_Amount)
    }
  }
}

Variables

{
  "network": "matic",
  "token": "0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270",
  "base": "0x7ceb23fd6bc0add59e62ac25578270cff1b9f619"
}

Similar queries