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