> ## 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 | `unichain.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](https://docs.allium.so/historical-data/supported-blockchains/evm/core-schemas/snapshots/balances.md)
