Initial and current liquidity of a pool

Returns transfers and balance updates on Ethereum, where transfer receiver is 0x4261…c344 or 0x44cc…c8e7 and balance update address is 0x4261…c344 or 0x44cc…c8e7, sorted by balance, highest first: transaction hash, receiver, transfer amount, smart contract, currency name, currency symbol, sum of balance update amount and balance update address.

By Akshat · saved 29 July 2024 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(dataset: realtime, network: eth) {
    Initial_liquidity: Transfers(
      limitBy:{by:Transfer_Receiver count:2}
      orderBy: {ascending: Block_Time}
      where: {Transfer: {Receiver: {in: ["0x42619f1eb89b993f7f5193de6ab1423a703fc344","0x44cc738e692921e7ac967367b800b8e132e5c8e7"]}}}
    ) {
      Transaction {
        Hash
      }
      Transfer {
        Receiver
        Amount
        Currency {
          SmartContract
          Name
          Symbol
        }
      }
    }
    Current_liquidity: BalanceUpdates(
      where: {BalanceUpdate: {Address:  {in: ["0x42619f1eb89b993f7f5193de6ab1423a703fc344","0x44cc738e692921e7ac967367b800b8e132e5c8e7"]}}}
      orderBy: {descendingByField: "balance"}
    ) {
      Currency {
        Name
        SmartContract
      }
      balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
      BalanceUpdate {
        Address
      }
    }
  }
}

Similar queries