> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## 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

<TableSample tableSchema="solana" tableName="account_activity" />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.