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 | stacks.raw.blocks |
| Table Status | Production-Ready |
| Unique Key | height |
| Clustering Key(s) | to_date("burn_block_time") |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| canonical | BOOLEAN | Indicates if the block corresponds to the canonical chain tip. |
| height | NUMBER(38,0) | The height of the block in the blockchain. |
| hash | VARCHAR(16777216) | The unique identifier or hash of the block. |
| miner_block_time | TIMESTAMP_NTZ(9) | The timestamp set by the miner when producing the block. |
| index_block_hash | VARCHAR(16777216) | The hash of the index block. |
| parent_block_hash | VARCHAR(16777216) | The hash of the parent block. |
| burn_block_time | TIMESTAMP_NTZ(9) | Unix timestamp (in seconds) indicating when the corresponding burn block was mined. |
| burn_block_hash | VARCHAR(16777216) | Hash of the anchor chain block. |
| burn_block_height | NUMBER(38,0) | Height of the anchor chain block. |
| miner_txid | VARCHAR(16777216) | Anchor chain transaction ID. |
| parent_microblock_hash | VARCHAR(16777216) | The hash of the last streamed block that precedes this block to which this block is to be appended. |
| parent_microblock_sequence | NUMBER(38,0) | The sequence number of the last streamed block that precedes this block to which this block is appended. |
| txs | VARIANT | List of transactions included in the block. |
| microblocks_accepted | VARIANT | List of microblocks that were accepted in this anchor block. Does not include orphaned microblocks. |
| microblocks_streamed | VARIANT | List of microblocks streamed/produced by this anchor block’s miner. |
| execution_cost_read_count | NUMBER(38,0) | Execution cost read count. |
| execution_cost_read_length | NUMBER(38,0) | Execution cost read length. |
| execution_cost_runtime | NUMBER(38,0) | Execution cost runtime. |
| execution_cost_write_count | NUMBER(38,0) | Execution cost write count. |
| execution_cost_write_length | NUMBER(38,0) | Execution cost write length. |
| microblock_tx_count | VARIANT | The count of transactions in microblocks. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update. |