Current liquidity, historical liquidity and initial liquidity of pools on etherum

Returns transfers and balance updates on Ethereum, where transfer receiver is 0xd726…25Bd, balance update address is 0xd726…25Bd and block time till 2024-08-04, 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 5 August 2024 · run 10 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
        }
      }
    }
    historical_liq_at_some_time: BalanceUpdates(
      where: {BalanceUpdate: {Address:  {in: $poolAddresses}} Block:{Time:{till: "2024-08-04T01:00:00Z"}}}
      orderBy: {descendingByField: "balance"}
    ) {
      Currency {
        Name
        SmartContract
        Symbol
      }
      balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
      BalanceUpdate {
        Address
      }
    }
    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":["0xd726e3B6858d81aB6Ad5b7cbb7a62EA00C5C25Bd"]}

Similar queries