Pool Liquidity

Returns 10 balance updates on Ethereum, where balance update address is 0x88e6…5640, currency smart contract is 0xa0b8…eb48 or 0xc02a…6cc2 and block time till 2024-05-29, sorted by block time: sum of balance update amount, balance update address, currency name, currency symbol, smart contract, block time, balance update amount and balance update type.

By Vishal · saved 29 May 2024 · run 10 times · Bitquery API v2

What it returns

Filters

The query

{
  EVM(dataset: combined, network: eth) {
    BalanceUpdates(
      where: {Block: {Time: {till: "2024-05-29T00:00:00Z"}}, BalanceUpdate: {Address: {is: "0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640"}}, Currency: {SmartContract: {in: ["0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48", "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"]}}}
    ) {
      balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
      BalanceUpdate {
        Address
      }
      Currency {
        Name
        Symbol
        SmartContract
      }
    }
    liquidityChanges: BalanceUpdates(
      where: {Block: {Time: {since: "2023-11-27T00:00:00Z"}}, BalanceUpdate: {Address: {is: "0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640"}}, Currency: {SmartContract: {in: ["0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48", "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"]}}}
      orderBy: {ascending: Block_Time}
      limit: {count: 10}
    ) {
      Currency {
        Name
      }
      Block {
        Time
      }
      BalanceUpdate {
        Amount
        Type
      }
    }
  }
}

Similar queries