Raw
Blocks
Table Columns
Unique Key:
| Column Name | Data Type | Description |
|---|---|---|
| number | BIGINT | Block number |
| hash | VARCHAR | 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 | BIGINT | Number of transactions in the block |
| hapi_version | VARCHAR | HAPI version used for this block |
| name | VARCHAR | Name of the block |
| logs_bloom | VARCHAR | Bloom filter for logs in the block |
| size | BIGINT | Size of the block in bytes |
| gas_used | BIGINT | Total gas used by transactions in the block |
| parent_hash | VARCHAR | Hash of the parent block |
| timestamp_from_raw | DECIMAL(29,9) | Raw timestamp from as decimal |
| timestamp_to_raw | DECIMAL(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 |