Optimal query balances

Returns balance updates on Solana, where account owner is A4edbh…REPq, block time after 2024-10-04 and block time before 2024-10-04: currency mint address, decimals, post balance, pre balance, account address, sum of balance update amount and block time.

By Yufei Du · saved 4 October 2024 · run 16 times · Bitquery API v2

What it returns

Filters

The query

query LPBalance($account: String!, $after: DateTime!, $before: DateTime!) {
  Solana(aggregates: only) {
    BalanceUpdates(
      where: {Block: {Time: {after: $after, before: $before}}, BalanceUpdate: {Account: {Owner: {is: $account}}}
      }
    ) {
      BalanceUpdate {
        Currency {
          MintAddress
          Decimals
        }
        PostBalance(maximum: Block_Slot)
        PreBalance(minimum: Block_Slot)
        Account {
          Address
        }
      }
      Amount: sum(of: BalanceUpdate_Amount)
      Block {
        Time
      }
    }
  }
}

Variables

{"account":"A4edbhwXnc92jR5fb93g7cSFRv4zhJEmpkCPfHtwREPq","after":"2024-10-04T04:00:50.314655+00:00","before":"2024-10-04T08:10:57.266026+00:00"}

Similar queries