Table Details
| Property | Value |
|---|---|
| Table Name | starknet.raw.blocks |
| Table Status | Production-Ready |
| Unique Key | number |
| Clustering Key(s) | to_date("timestamp") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| number | NUMBER(38,0) | The length of the chain, in blocks. |
| timestamp | TIMESTAMP_NTZ(9) | The unix timestamp for when the block was collated. |
| hash | VARCHAR(16777216) | Unique identifier of a block. |
| parent_hash | VARCHAR(16777216) | Unique identifier of the block preceding this block, also known as the parent block. |
| new_root | VARCHAR(16777216) | The new state root after applying this block’s transactions. |
| sequencer_address | VARCHAR(16777216) | The address of the sequencer that produced this block. |
| status | VARCHAR(16777216) | The status of the block |
| starknet_version | VARCHAR(16777216) | The version of the Starknet protocol used for this block. |
| l1_da_mode | VARCHAR(16777216) | The data availability mode for L1 (e.g., ‘BLOB’, ‘CALLDATA’). |
| l1_data_gas_price_fri | NUMBER(38,0) | The L1 data gas price in FRI (Field Representation Integer) units. |
| l1_gas_price_fri | NUMBER(38,0) | The L1 gas price, denominated in fri |
| l2_gas_price_fri | NUMBER(38,0) | The L2 gas price, denominated in fri |
| l1_data_gas_price_wei | NUMBER(38,0) | The L1 data gas price, denominated in wei |
| l1_gas_price_wei | NUMBER(38,0) | The L1 gas price, denominated in wei |
| l2_gas_price_wei | NUMBER(38,0) | The L2 gas price, denominated in wei |
| transaction_count | NUMBER(38,0) | Number of transactions included in this block. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when the record was created. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when the record was last updated. |