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

# Actor State Snapshots 🌱

### Table Details

| Property          | Value                                          |
| ----------------- | ---------------------------------------------- |
| Table Name        | `filecoin.raw.actor_state_snapshots`           |
| Table Status      | Beta 🌱                                        |
| Unique Key        | `tipset_timestamp`, `tipset_height`, `address` |
| Clustering Key(s) | `to_date("tipset_timestamp")`                  |

### Table Columns

| Column Name       | Data Type         | Description                                                                                                                                            |
| ----------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ |
| tipset\_height    | NUMBER(38,0)      | Filecoin tipset height (block height). A tipset is a set of blocks at the same height that form the canonical chain.                                   |
| tipset\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the Filecoin tipset.                                                                                                                |
| address           | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| state\_pre        | VARIANT           | CID of the actor state before this message's execution                                                                                                 |
| state\_post       | VARIANT           | CID of the actor state after this message's execution                                                                                                  |
| balance\_change   | VARCHAR(16777216) | Change in token balance from this transfer. Positive for inflows, negative for outflows.                                                               |
| \_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.                                                                                          |