solana.account_activity - Dune Docs

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