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