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