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

# Balances

### Table Details

| Property            | Value                                      |
| ------------------- | ------------------------------------------ |
| Table Name          | `robinhood.snapshots.balances`             |
| Table Status        | Production-Ready                           |
| Unique Key          | `block_number`, `address`, `token_address` |
| Clustering Key(s)   | `block_timestamp::date`                    |
| Search Optimization | `address`, `token_address`                 |

### Table Columns

| Column Name         | Data Type         | Description                                                                             |
| ------------------- | ----------------- | --------------------------------------------------------------------------------------- |
| address             | VARCHAR(42)       | The wallet or contract address holding the token balance.                               |
| token\_address      | VARCHAR(42)       | The contract address of the token, or the native token sentinel address.                |
| raw\_balance        | VARCHAR(16777216) | The unnormalized token balance at this block, stored as a string to preserve precision. |
| block\_number       | NUMBER(38,0)      | The block number at which this balance snapshot was recorded.                           |
| block\_timestamp    | TIMESTAMP\_NTZ(9) | The timestamp of the block at which this balance snapshot was recorded.                 |
| block\_hash         | VARCHAR(66)       | The hash of the block at which this balance snapshot was recorded.                      |
| is\_balance\_change | BOOLEAN           | Whether this snapshot was triggered by a balance-changing event in this block.          |
| \_metadata          | VARIANT           | Internal metadata from the balance ingestion pipeline.                                  |
| \_error             | VARIANT           | Error information if the balance fetch encountered an issue.                            |
| \_source            | VARCHAR(16777216) | The data source or ingestion pipeline that produced this record.                        |
| \_created\_at       | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                |
| \_updated\_at       | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                           |

### Related Docs

* [EVM Snapshots Balances](/historical-data/supported-blockchains/evm/core-schemas/snapshots/balances)