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