Table Details
| Property | Value |
|---|---|
| Table Name | hedera.raw.blocks |
| Table Status | Beta 🌱 |
| Unique Key | number |
| Clustering Key(s) | to_date("timestamp_from") |
| Search Optimization | number, hash |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| number | NUMBER(38,0) | Block number |
| hash | VARCHAR(16777216) | Hash of the block |
| timestamp_from | TIMESTAMP_NTZ(9) | Start timestamp of the block |
| timestamp_to | TIMESTAMP_NTZ(9) | End timestamp of the block |
| num_transactions | NUMBER(38,0) | Number of transactions in the block |
| hapi_version | VARCHAR(16777216) | HAPI version used for this block |
| name | VARCHAR(16777216) | Name of the block |
| logs_bloom | VARCHAR(16777216) | Bloom filter for logs in the block |
| size | NUMBER(38,0) | Size of the block in bytes |
| gas_used | NUMBER(38,0) | Total gas used by transactions in the block |
| parent_hash | VARCHAR(16777216) | Hash of the parent block |
| timestamp_from_raw | NUMBER(29,9) | Raw timestamp from as decimal |
| timestamp_to_raw | NUMBER(29,9) | Raw timestamp to as decimal |
| extra_evm_fields | VARIANT | Additional EVM-specific fields |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |