historical liq at a certain time

Returns balance updates on Ethereum, where balance update address is 0xd726…25Bd and block time till 2024-08-05, sorted by balance, highest first: currency name, smart contract, currency symbol, sum of balance update amount and balance update address.

By Akshat · saved 5 August 2024 · Bitquery API v2

What it returns

Filters

The query

query MyQuery($poolAddresses: [String!]) {
  EVM(dataset: combined, network: eth) {
    historical_liq_at_some_time: BalanceUpdates(
      where: {BalanceUpdate: {Address: {in: $poolAddresses}}, Block: {Time: {till: "2024-08-05T01:00:00Z"}}}
      orderBy: {descendingByField: "balance"}
    ) {
      Currency {
        Name
        SmartContract
        Symbol
      }
      balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
      BalanceUpdate {
        Address
      }
    }
  }
}

Variables

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

Similar queries