Current liquidity and initial liquidity of pools on etherum

Returns transfers and balance updates on Ethereum, where transfer receiver is 0xf48a…528a and balance update address is 0xf48a…528a, 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 4 August 2024 · run 6 times · Bitquery API v2

What it returns

Filters

The query

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

Variables

{"poolAddresses":["0xf48a0f3e96607833447d83d29fba99c2721b528a"]}

Similar queries