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.
What it returns
- currency mint address
- decimals
- post balance
- pre balance
- account address
- sum of balance update amount
- block time
Filters
- account owner is A4edbh…REPq
- block time after 2024-10-04
- block time before 2024-10-04
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
- holders with time · Solana · BalanceUpdates
- holders · Solana · BalanceUpdates
- traders · Solana · BalanceUpdates
- Solana BalanceUpdates1 · Solana · BalanceUpdates
- Solana BalanceUpdates · Solana · BalanceUpdates