solana.account_activity

Track every SOL and SPL token balance change per account per transaction — essential for wallet activity monitoring, treasury tracking, compliance auditing, and building real-time portfolio analytics on Solana.

Table description

The solana.account_activity table contains information from the transactions table focused on account usage. Each row contains all information about an account’s usage in a transaction.

Table Schema

Column	Type	Description
block_date	DATE	The date of the block this account activity occurred in
block_slot	BIGINT	The slot number of the block containing this activity
block_time	TIMESTAMP	The timestamp of the block this activity belongs to
address	VARCHAR	The Solana account address involved in the transaction
tx_index	INTEGER	The index position of the transaction within the block
token_mint_address	VARCHAR	The mint address of the SPL token involved, null for native SOL transfers
tx_id	VARCHAR	The unique transaction signature/ID
block_hash	VARCHAR	The hash of the block containing this transaction
tx_success	BOOLEAN	Whether the transaction completed successfully
signed	BOOLEAN	Whether this account signed the transaction
writable	BOOLEAN	Whether this account had write access in the transaction
pre_balance	BIGINT	The account’s SOL balance (in lamports) before the transaction
post_balance	BIGINT	The account’s SOL balance (in lamports) after the transaction
balance_change	BIGINT	The net change in SOL balance (in lamports) from this transaction
pre_token_balance	DECIMAL(38,18)	The account’s SPL token balance before the transaction (decimal-adjusted)
post_token_balance	DECIMAL(38,18)	The account’s SPL token balance after the transaction (decimal-adjusted)
token_balance_change	DECIMAL(38,17)	The net change in SPL token balance from this transaction (decimal-adjusted)
token_balance_owner	VARCHAR	The owner address of the token account

Table Sample