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

# State Diffs 🌱

### Table Details

| Property          | Value                           |
| ----------------- | ------------------------------- |
| Table Name        | `ethereum.raw.state_diffs`      |
| Table Status      | Beta 🌱                         |
| Unique Key        | `transaction_hash`, `unique_id` |
| Clustering Key(s) | `to_date("block_timestamp")`    |

### Table Columns

| Column Name       | Data Type         | Description                                                                                                                                                                           |
| ----------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| block\_timestamp  | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                                                                               |
| block\_number     | NUMBER(38,0)      | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block.                                                         |
| block\_hash       | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block.                                                                                        |
| transaction\_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                                                                           |
| 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.                                |
| output            | VARCHAR(16777216) | ABI-encoded return value of a function call. Null if the call reverted or produced no output.                                                                                         |
| property          | VARCHAR(16777216) | State property that changed (e.g. balance, nonce, code, storage).                                                                                                                     |
| storage\_key      | VARCHAR(16777216) | Storage slot key that changed, for storage-type diffs.                                                                                                                                |
| change\_type      | VARCHAR(16777216) | Type of state change (e.g. create, update, delete).                                                                                                                                   |
| from\_value       | VARCHAR(16777216) | Value of the property before the transaction.                                                                                                                                         |
| to\_value         | VARCHAR(16777216) | Value of the property after the transaction.                                                                                                                                          |
| state\_diff       | VARIANT           | Structured representation of the full state change.                                                                                                                                   |
| unique\_id        | VARCHAR(16777216) | Allium's deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |