volume with intervals tron

Returns DEX trades by token on Tron, where currency smart contract is TR7NHq…Lj6t, block time after 2024-12-14 and block time before 2024-12-14, sorted by block OHLC interval: block time, sum of trade amount in USD and median of trade price in USD.

By kirill · saved 17 December 2024 · Bitquery API v2

What it returns

Filters

The query

query MyQuery($token: String, $from_date_time: DateTime, $to_date_time: DateTime, $min_amount: String) {
  Tron(dataset: archive) {
    aggregatedVolume: DEXTradeByTokens(
      where: {Trade: {Currency: {SmartContract: {is: $token}}, AmountInUSD: {gt: $min_amount}}, Block: {Time: {after: $from_date_time, before: $to_date_time}}}
      orderBy: {ascendingByField: "Block_OHLC_interval"}
    ) {
      Block {
        OHLC_interval: Time(interval: {in: minutes, count: 10})
      }
      totalVolumeInUSD: sum(of: Trade_AmountInUSD)
      price_median: median(of: Trade_PriceInUSD)
    }
  }
}

Variables

{
  "token": "TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t",
  "min_amount": "100",
  "from_date_time": "2024-12-14T12:42:35Z", "to_date_time": "2024-12-14T14:42:35Z"
}

Similar queries