Table Details
| Property | Value |
|---|---|
| Table Name | aptos.raw.blocks |
| Table Status | Production-Ready |
| Unique Key | block_height, block_timestamp |
| Clustering Key(s) | to_date("block_timestamp") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| block_hash | VARCHAR(16777216) | The hash of the block at the specified height |
| block_height | NUMBER(38,0) | The height of the block |
| block_timestamp | TIMESTAMP_NTZ(9) | The time at which the block was created/added to the chain |
| first_version | NUMBER(38,0) | The version number of the first transaction in the block |
| last_version | NUMBER(38,0) | The version number of the last transaction in the block |
| transaction_count | NUMBER(38,0) | Number of transactions in the block |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update |