getTokenLiquidity

Returns balance updates on BNB Chain, where balance update address is 0x3354…b184, currency smart contract is 0x55d3…7955 or 0xc447…bcfc and block time till 2024-10-17, sorted by balance in USD, highest first: currency symbol, currency name and sum of balance update amount.

By Jose · saved 17 October 2024 · run 9 times · Bitquery API v2

What it returns

Filters

The query

query getTokenLiquidity(
  $dataset: dataset_arg_enum!
  $network: evm_network!
  $tokenAddress: String!
  $sideTokenAddress: String!
  $pairAddress: String!
  $till: DateTime!
) {
  EVM(dataset: $dataset, network: $network) {
    BalanceUpdates(
      where: {Block: {Time: {till: $till}}, BalanceUpdate: {Address: {is: $pairAddress}}, Currency: {SmartContract: {in: [$tokenAddress, $sideTokenAddress]}}}
      orderBy: {descendingByField: "BalanceInUSD"}
    ) {
      Currency {
        Symbol
        Name
      }
      BalanceInUSD: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0.001"})
    }
  }
}

Variables

{
  "network": "bsc",
  "dataset": "combined",
  "pairAddress": "0x335494be8b5dd04d7e58d67fd91fae8038c5b184",
  "tokenAddress": "0x55d398326f99059ff775485246999027b3197955",
  "sideTokenAddress": "0xc4473ddda7d05a8e7fa41a741de4489a196fbcfc",
  "till": "2024-10-17T05:35:27.481Z"
}

Similar queries