matic interval 1 day

Returns DEX trades by token on Polygon, where side currency smart contract is 0x3c49…3359, 0x2791…4174 or 3 more, currency smart contract is 0x0d50…1270 and block time since 2023-11-04, sorted by block time: block time, quantile of trade price in USD, average of trade price in USD and sum of trade side amount in USD.

By Nadia · saved 4 November 2024 · run 6 times · Bitquery API v2

What it returns

Filters

The query

query tradingView($network: evm_network, $dataset: dataset_arg_enum, $interval: Int, $token: String, $usdc: String!, $usdcpos: String!, $usdt: String!, $weth: String!, $wmatic: String!, $time_ago: DateTime) {
  EVM(network: $network, dataset: $dataset) {
    DEXTradeByTokens(
      orderBy: {ascendingByField: "Block_Time"}
      where: {Trade: {Side: {Currency: {SmartContract: {in: [$usdc, $usdcpos, $usdt, $weth, $wmatic]}}}, Currency: {SmartContract: {is: $token}}}, Block: {Time: {since: $time_ago}}}
    ) {
      Block {
        Time(interval: {count: $interval, in: minutes})
      }
      min: quantile(of: Trade_PriceInUSD, level: 0.05)
      max: quantile(of: Trade_PriceInUSD, level: 0.95)
      close: average(of: Trade_PriceInUSD)
      open: average(of: Trade_PriceInUSD)
      volume: sum(of: Trade_Side_AmountInUSD)
    }
  }
}

Variables

{
  "network": "matic",
  "token": "0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270",
  "usdc": "0x3c499c542cef5e3811e1192ce70d8cc03d5c3359",
  "usdcpos": "0x2791bca1f2de4661ed88a30c99a7a9449aa84174",
  "usdt": "0xc2132d05d31c914a87c6611c10748aeb04b58e8f",
  "weth": "0x7ceb23fd6bc0add59e62ac25578270cff1b9f619",
  "wmatic": "0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270",
  "dataset": "combined",
  "time_ago": "2023-11-04T11:26:18Z",
  "interval": 1440
}

Similar queries