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

# Balance Snapshots

### Table Details

| Property | Value |
| - | - |
| Table Name | `sui.raw.balance_snapshots` |
| Table Status | Production-Ready |
| Unique Key | `checkpoint_timestamp`, `unique_id` |
| Clustering Key(s) | `to_date("checkpoint_timestamp")` |
| Search Optimization | `unique_id`, `transaction_block_digest`, `coin_type`, `object_id`, `root_object_id` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| checkpoint\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of when the Sui checkpoint was created. |
| checkpoint\_sequence | NUMBER(38,0) | Monotonically increasing sequence number of the Sui checkpoint. |
| transaction\_block\_digest | VARCHAR(16777216) | Base58-encoded digest of the Sui transaction block. |
| holder\_id | VARCHAR(16777216) | Object that directly holds the balance. |
| root\_object\_id | VARCHAR(16777216) | Top-level object the holder belongs to (e.g. the pool or `BalanceManager` owning a dynamic field). Use this to roll balances up to a holder. |
| coin\_type | VARCHAR(16777216) | Fully-qualified Move type of the coin whose balance or supply is recorded (e.g. `0x2::sui::SUI`). Addresses inside the type are shortened to canonical form with leading zeros stripped, and generic parameters are separated by a comma and space, matching Sui JSON-RPC rendering. |
| raw\_balance | NUMBER(38,0) | Total `Balance` of this coin type held in the object after the transaction, in raw units. 0 when deleted or wrapped; null on rows that only carry a `Supply`. |
| raw\_pre\_balance | NUMBER(38,0) | Same as `raw_balance`, before the transaction. Null when created or unwrapped. |
| raw\_supply | NUMBER(38,0) | `Supply` after the transaction. Null unless the object holds a `Supply`. |
| raw\_pre\_supply | NUMBER(38,0) | `Supply` before the transaction. Null unless the object held a `Supply`. |
| raw\_balance\_str | VARCHAR(16777216) | `raw_balance` as an exact decimal string. |
| raw\_pre\_balance\_str | VARCHAR(16777216) | `raw_pre_balance` as an exact decimal string. |
| raw\_supply\_str | VARCHAR(16777216) | `raw_supply` as an exact decimal string. |
| raw\_pre\_supply\_str | VARCHAR(16777216) | `raw_pre_supply` as an exact decimal string. |
| state | VARCHAR(16777216) | What the transaction did to the object: `created`, `mutated`, `deleted`, `wrapped` or `unwrapped`. |
| object\_id | VARCHAR(16777216) | ID of the changed object. |
| object\_type | VARCHAR(16777216) | Move type of the changed object. |
| version | NUMBER(38,0) | Object version after the transaction. Null when deleted or wrapped. |
| input\_version | NUMBER(38,0) | Object version before the transaction. Null when created or unwrapped. |
| source | VARCHAR(16777216) | Snapshot source. Always `object` for now. |
| holder\_type | VARCHAR(16777216) | Kind of holder. Always `object` for now. |
| transaction\_block\_status | VARCHAR(16777216) | Execution result of the transaction block: `success` or `failure`. |
| checkpoint\_digest | VARCHAR(16777216) | Hash digest of the Sui checkpoint. |
| balance\_snapshot\_index | NUMBER(38,0) | Zero-based position of the row within its transaction and source. An object that cannot be decoded is skipped but still takes an index slot, so gaps in the sequence mark undecodable objects. |
| owner | VARIANT | Owner of the changed object as JSON: `{"AddressOwner": "0x..."}`, `{"ObjectOwner": "0x..."}`, `{"Shared": {"initial_shared_version": n}}`, `{"ConsensusAddressOwner": {"owner": "0x...", "start_version": n}}`, or the string `"Immutable"`. For deleted or wrapped objects, this is the owner before the change. |
| unique\_id | VARCHAR(16777216) | `transaction_block_digest`, `source`, `holder_id` and `coin_type` joined into one key. |
| \_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. |