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