Table description
Thesolana.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 |