Liquidity-of-a-Pool

Returns balance updates on Base, where balance update address is 0x1e03…c755 and currency smart contract is 0x4200…0006 or 0xa999…50f6, sorted by balance, highest first: currency name and sum of balance update amount.

By Kshitij Mahajan · saved 9 July 2024 · run 13 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(dataset: combined, network: base) {
    BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: "0x1e039aade407a94df380649b33b52cb8ad41c755"}}, Currency: {SmartContract: {in: ["0x4200000000000000000000000000000000000006", "0xa999542c71febba77602fbc2f784ba9ba0c850f6"]}}}
      orderBy: {descendingByField: "balance"}
    ) {
      Currency {
        Name
      }
      balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
    }
  }
}

Similar queries