Tron TokenOHLC + totalLiquidyty

Returns DEX trades by token and balance updates on Tron, where currency smart contract is TEzL3P…qx2C, balance update address is TTfvyr…7AAw and trade amount is above 0, sorted by block time: block time, buyer, seller, smart contract, protocol name, protocol family, currency symbol and 10 more fields.

By Nadia · saved 20 September 2024 · run 6 times · Bitquery API v2

What it returns

Filters

The query

query TokenOHLC($token: String, $vault: String) {
  Tron {
    DEXTradeByTokens(
      orderBy: {ascendingByField: "Block_Time"}
      where: {Trade: {Amount: {gt: "0"}, Currency: {SmartContract: {is: $token}}}, Transaction: {Result: {Success: true}}}
    ) {
      Block {
        Time(interval: {count: 5, in: minutes})
        allTime: Time
      }
      Trade {
        Buyer
        Seller
        Dex {
          SmartContract
          ProtocolName
          ProtocolFamily
        }
        Currency {
          Symbol
          Name
          SmartContract
        }
        Price
        Amount
        Side {
          AmountInUSD
          Amount
        }
        open: Price(minimum: Block_Number)
        close: Price(maximum: Block_Number)
        min: Price(maximum: Trade_Price)
        max: Price(minimum: Trade_Price)
        closeUsd: PriceInUSD(maximum: Trade_PriceInUSD)
      }
      volume: sum(of: Trade_Side_Amount)
      volumeUsd: sum(of: Trade_Side_AmountInUSD)
    }
    DexPools: BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: $vault}}, Currency: {SmartContract: {is: $token}}}
    ) {
      totalLiquidity: sum(of: BalanceUpdate_Amount)
      Currency {
        SmartContract
        Name
        Symbol
        Decimals
      }
    }
  }
}

Variables

{
  "token": "TEzL3PwyvHhBr33kudx2da27dxSZ6Lqx2C",
  "vault": "TTfvyrAz86hbZk5iDpKD78pqLGgi8C7AAw"
}

Similar queries