Account activity

Solana.account_activity

This table contains information from the transactions table focused on account usage. Each row contains all information about an account's usage in a transaction.

Column Name	Column Type	Description
block_slot	bigint	The slot of the block this transaction was in.
block_hash	string	The hash of the block this transaction was in
block_time	timestamp	The timestamp that this account usage occurred
block_date	date	The date this account usage occurred
address	string	The address of the account, also referred to as public key
tx_index	int	The index of this transaction in the block
tx_id	string	The ID of the transaction in which this account usage occurred
tx_success	boolean	The transaction succeeded and was committed
signed	boolean	This account signed this transaction
writeable	boolean	This account was granted read-write access in this transaction
pre_balance	bigint	The balance of this account before the transaction was processed
pre_token_balance	decimal	The token balance before the transaction was processed
post_balance	bigint	The balance of this account after the transaction was processed
post_token_balance	decimal	The token balance after the transaction was processed
balance_change	bigint	The balance change that occurred as part of the transaction
token_balance_change	decimal	The balance change that occurred as part of the transaction
token_mint_address	string	The address the associated token address is minting from (i.e. the actual token address)
token_owner_address	string	The address that owns this token address