non_optimal_query

Returns balance updates on Solana, where account address is A4edbh…REPq, block time after 2024-10-04 and block time before 2024-10-04: transaction signature, success, currency mint address, decimals, post balance, pre balance, balance update amount and 2 more fields.

By Omkar_BQ · saved 4 October 2024 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query LPBalance($account: String!, $after: DateTime!, $before: DateTime!) {
  Solana {
    BalanceUpdates(
      where: {Block: {Time: {after: $after, before: $before}}, BalanceUpdate: {Account: {Address: {is: $account}}}}
    ) {
      Transaction {
        Signature
        Result {
          Success
        }
      }
      BalanceUpdate {
        Currency {
          MintAddress
          Decimals
        }
        PostBalance
        PreBalance
        Amount
        Account {
          Address
        }
      }
      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