> ## 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.

# Blocks

### 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.                                                                           |