bitquery get liquidity pool

Returns balance updates on BNB Chain, where balance update address is 0x472e…78d2 and currency smart contract is 0xbb4c…095c, sorted by balance, highest first: currency name, smart contract, currency symbol, sum of balance update amount in USD, balance update address, balance update amount and amount in USD.

By Takem Darlington · saved 2 August 2024 · run 4 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(dataset: combined, network: bsc) {
    BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: "0x472e71c0e729cbe32b883502f833e6e8f2cd78d2"}}, Currency: {SmartContract: {is: "0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c"}}}
      orderBy: {descendingByField: "balance"}
    ) {
      Currency {
        Name
        SmartContract
        Symbol
      }
      balance: sum(of: BalanceUpdate_AmountInUSD, selectWhere: {gt: "0"})
      BalanceUpdate {
        Address
        Amount
        AmountInUSD
      }
    }
  }
}

Similar queries