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

Point-in-time snapshots of token balances for every address. Each row represents a balance snapshot at a specific block, capturing the raw token balance held by an address.

### Table Columns

Unique Key: `block_number`, `address`, `token_address`

| Column Name         | Data Type         | Description                                                                             |
| ------------------- | ----------------- | --------------------------------------------------------------------------------------- |
| address             | VARCHAR           | The wallet or contract address holding the token balance.                               |
| token\_address      | VARCHAR           | The contract address of the token, or the native token sentinel address.                |
| raw\_balance        | VARCHAR           | 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           | 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           | 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.                           |