balance updates

Returns balance updates on Solana, where account owner is FR45dT…RiDy, currency mint address is So1111…1112 or 111111…1111 and block time before 2025-02-20, sorted by balance update post balance sol maximum, highest first: account owner, account address, pre balance in USD, post balance in USD and count.

By dsdsdf · saved 20 February 2025 · run 21 times · Bitquery API v2

What it returns

Filters

The query

{
  Solana {
    BalanceUpdates(
      orderBy: {descendingByField: "BalanceUpdate_PostBalanceSOL_maximum"}
      where: {Block: {Time: {before: "2025-02-20T17:00:00Z"}}, BalanceUpdate: {Account: {Owner: {in: ["FR45dTqbKgxeKR2jCwmHPaB3AFnfHuyZZx1i5tVdRiDy"]}}, Currency: {MintAddress: {in: ["So11111111111111111111111111111111111111112", "11111111111111111111111111111111"]}}}, Transaction: {Result: {Success: true}}}
    ) {
      BalanceUpdate {
        Account {
          Owner
          Address
        }
        PreBalanceSOL: PreBalanceInUSD(
          minimum: Block_Slot
          if: {BalanceUpdate: {Currency: {MintAddress: {is: "11111111111111111111111111111111"}}}}
        )
        PostBalanceSOL: PostBalanceInUSD(
          maximum: Block_Slot
          if: {BalanceUpdate: {Currency: {MintAddress: {is: "11111111111111111111111111111111"}}}}
        )
        PreBalanceWSOL: PreBalanceInUSD(
          minimum: Block_Slot
          if: {BalanceUpdate: {Currency: {MintAddress: {is: "So11111111111111111111111111111111111111112"}}}}
        )
        PostBalanceWSOL: PostBalanceInUSD(
          maximum: Block_Slot
          if: {BalanceUpdate: {Currency: {MintAddress: {is: "So11111111111111111111111111111111111111112"}}}}
        )
      }
      count
    }
  }
}

Similar queries