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

Blocks are the building blocks of blockchains and rollups. A block contains transactions which will alter the state of an EVM system incrementally. Transaction within a block can only be executed one after the other, not in parallel.

### Table Details

| Property            | Value                  |
| ------------------- | ---------------------- |
| Table Name          | `hyperevm.raw.blocks`  |
| Table Status        | Production-Ready       |
| Unique Key          | `number`               |
| Clustering Key(s)   | `to_date("timestamp")` |
| Search Optimization | `miner`                |

### Table Columns

| Column Name                 | Data Type         | Description                                                                                                                                    |
| --------------------------- | ----------------- | ---------------------------------------------------------------------------------------------------------------------------------------------- |
| timestamp                   | TIMESTAMP\_NTZ(9) | The unix timestamp for when the block was collated.                                                                                            |
| number                      | NUMBER(38,0)      | The length of the chain, in blocks.                                                                                                            |
| hash                        | VARCHAR(66)       | Unique identifier of a block.                                                                                                                  |
| parent\_hash                | VARCHAR(66)       | Unique identifier of the block preceding this block, also known as the parent block.                                                           |
| nonce                       | VARCHAR(42)       | The hash of the generated proof-of-work. null if pending.                                                                                      |
| sha3\_uncles                | VARCHAR(66)       | An array of uncle hashes.                                                                                                                      |
| logs\_bloom                 | VARCHAR(16777216) | The bloom filter for the logs of the block.                                                                                                    |
| transactions\_root          | VARCHAR(66)       | The root of the transaction trie of the block.                                                                                                 |
| state\_root                 | VARCHAR(66)       | The root of the final state trie of the block.                                                                                                 |
| receipts\_root              | VARCHAR(66)       | The root of the receipts trie of the block.                                                                                                    |
| miner                       | VARCHAR(42)       | The address of the beneficiary to whom the mining rewards were given.                                                                          |
| difficulty                  | NUMBER(38,0)      | The integer of the difficulty for this block.                                                                                                  |
| total\_difficulty           | VARCHAR(66)       | The integer of the total difficulty of the chain until this block.                                                                             |
| size                        | NUMBER(38,0)      | The size of the block, in bytes, as determined by the gas\_limit.                                                                              |
| extra\_data                 | VARCHAR(16777216) | The "extra data" field of this block.                                                                                                          |
| gas\_limit                  | NUMBER(38,0)      | Gas limit of the current block.                                                                                                                |
| gas\_used                   | NUMBER(38,0)      | Total gas used in the block.                                                                                                                   |
| transaction\_count          | NUMBER(38,0)      | Number of transactions included in this block.                                                                                                 |
| base\_fee\_per\_gas         | NUMBER(38,0)      | Post London Upgrade (EIP1559), this represents the minimum gas\_used required for a transaction to be included in a block. Represented in wei. |
| blob\_gas\_used             | NUMBER(38,0)      | Total blob gas used by all blob transactions in the block. Introduced in EIP-4844 (Dencun upgrade) for proto-danksharding.                     |
| excess\_blob\_gas           | NUMBER(38,0)      | The excess blob gas from the previous block, used to calculate blob gas price.                                                                 |
| parent\_beacon\_block\_root | VARCHAR(66)       | The root of the parent beacon block, linking execution layer blocks to consensus layer blocks.                                                 |
| withdrawals\_root           | VARCHAR(66)       | Root hash of the withdrawals list in the block; part of the block header introduced in Ethereum post-merge for validator withdrawals.          |
| withdrawals                 | VARIANT           | List of validator withdrawals (from the beacon chain) included in the block                                                                    |
| \_created\_at               | TIMESTAMP\_NTZ(9) | Timestamp when the record was created.                                                                                                         |
| \_updated\_at               | TIMESTAMP\_NTZ(9) | Timestamp when the record was last updated.                                                                                                    |

### Related Docs

* [EVM Raw Blocks](/historical-data/supported-blockchains/evm/core-schemas/raw/blocks)
