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

# Blocks

### Table Details

| Property          | Value                  |
| ----------------- | ---------------------- |
| Table Name        | `casper.raw.blocks`    |
| Table Status      | Production-Ready       |
| Unique Key        | `timestamp`, `height`  |
| Clustering Key(s) | `to_date("timestamp")` |

### Table Columns

| Column Name                      | Data Type         | Description                                                                |
| -------------------------------- | ----------------- | -------------------------------------------------------------------------- |
| timestamp                        | TIMESTAMP\_NTZ(9) | Timestamp at which the block was proposed.                                 |
| height                           | NUMBER(38,0)      | Height of the block.                                                       |
| hash                             | VARCHAR(66)       | Hash of the block.                                                         |
| parent\_hash                     | VARCHAR(66)       | Hash of the parent block.                                                  |
| last\_switch\_block\_hash        | VARCHAR(16777216) | Hash of the most recent switch block (era boundary block).                 |
| era\_id                          | NUMBER(38,0)      | Era (epoch) the block belongs to.                                          |
| current\_gas\_price              | NUMBER(38,0)      | Gas price multiplier active for this block.                                |
| proposer                         | VARCHAR(16777216) | Public key of the validator that proposed the block.                       |
| accumulated\_seed                | VARCHAR(16777216) | Accumulated randomness seed carried forward from prior blocks.             |
| body\_hash                       | VARCHAR(16777216) | Hash of the block body.                                                    |
| state\_root\_hash                | VARCHAR(16777216) | Global state root hash after applying this block.                          |
| random\_bit                      | BOOLEAN           | Random bit contributed by the proposer for leader selection.               |
| protocol\_version                | VARCHAR(16777216) | Casper protocol version active at this block.                              |
| api\_version                     | VARCHAR(16777216) | Node API version that produced this block payload.                         |
| proofs                           | VARIANT           | Finality signatures (validator proofs) included with the block.            |
| era\_end                         | VARIANT           | Era-end metadata (validator weights, rewards); null for non-switch blocks. |
| transactions                     | VARIANT           | List of transaction hashes included in the block.                          |
| transaction\_count               | NUMBER(38,0)      | Number of transactions included in the block.                              |
| reward\_count                    | NUMBER(38,0)      | Number of rewards distributed in the block (typically on switch blocks).   |
| \_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.              |
| ces\_event\_count                | NUMBER(38,0)      | Number of CES (Casper Event Standard) events emitted in the block.         |
| contract\_count                  | NUMBER(38,0)      | Number of contracts deployed or updated in the block.                      |
| native\_balance\_snapshot\_count | NUMBER(38,0)      | Number of native CSPR balance snapshots captured for the block.            |