> ## 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          | `beacon.raw.blocks`             |
| Table Status        | Production-Ready                |
| Unique Key          | `slot_timestamp`, `slot_number` |
| Clustering Key(s)   | `to_date("slot_timestamp")`     |
| Search Optimization | `slot_number`                   |

### Table Columns

| Column Name                 | Data Type         | Description                                                                                                                                                                                                                       |
| --------------------------- | ----------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| attestation\_count          | NUMBER(38,0)      | The number of attestations included in the block.                                                                                                                                                                                 |
| attestations                | VARIANT           | Total rewards from attestations included in the block.                                                                                                                                                                            |
| attester\_slashings         | VARIANT           | Rewards from attester slashings included in the block.                                                                                                                                                                            |
| blob\_kzg\_commitments      | VARIANT           | KZG commitments for blobs included in the block.                                                                                                                                                                                  |
| bls\_to\_execution\_changes | VARIANT           | List of BLS to execution changes included in the block.                                                                                                                                                                           |
| deposits                    | VARIANT           | List of deposits included in the block.                                                                                                                                                                                           |
| eth1\_data                  | VARIANT           | Data related to the Ethereum 1.0 chain.                                                                                                                                                                                           |
| execution\_payload          | VARIANT           | The execution payload of the block.                                                                                                                                                                                               |
| graffiti                    | VARCHAR(16777216) | Graffiti data included in the block.                                                                                                                                                                                              |
| proposer\_slashings         | VARIANT           | Rewards from proposer slashings included in the block.                                                                                                                                                                            |
| randao\_reveal              | VARCHAR(16777216) | The RANDAO reveal for the block.                                                                                                                                                                                                  |
| sync\_aggregate             | VARIANT           | Total rewards from sync committee participation included in the block.                                                                                                                                                            |
| voluntary\_exits            | VARIANT           | List of voluntary exits included in the block.                                                                                                                                                                                    |
| eth1\_block\_hash           | VARCHAR(16777216) | 0xc0efee09619b108b8c184d7c4981b96bcef8fe63e6887f3ee20728d5ca6d6e67                                                                                                                                                                |
| eth1\_block\_number         | VARCHAR(16777216) | 17,030,996                                                                                                                                                                                                                        |
| eth1\_block\_timestamp      | VARCHAR(16777216) | 2023-04-12 09:19:47                                                                                                                                                                                                               |
| eth1\_deposit\_count        | NUMBER(38,0)      | The number of deposits in the Ethereum 1.0 block.                                                                                                                                                                                 |
| parent\_root                | VARCHAR(16777216) | The parent root of the block.                                                                                                                                                                                                     |
| proposer\_index             | NUMBER(38,0)      | Index of the validator who proposed the block.                                                                                                                                                                                    |
| slot                        | NUMBER(38,0)      | The slot number of the block.                                                                                                                                                                                                     |
| state\_root                 | VARCHAR(16777216) | The root of the final state trie of the block.                                                                                                                                                                                    |
| execution\_optimistic       | BOOLEAN           | If the slot/epoch is executed optimistically.                                                                                                                                                                                     |
| finalized                   | BOOLEAN           | If the slot/epoch is finalized.                                                                                                                                                                                                   |
| version                     | VARCHAR(16777216) | The version of the block.                                                                                                                                                                                                         |
| slot\_number                | NUMBER(38,0)      | Slot number of the state where the pending deposits to beacon chain is fetched.                                                                                                                                                   |
| slot\_timestamp             | TIMESTAMP\_NTZ(9) | Slot timestamp of the state where the pending deposits to beacon chain is fetched.                                                                                                                                                |
| transaction\_count          | NUMBER(38,0)      | Number of transactions included in this block.                                                                                                                                                                                    |
| withdrawal\_count           | NUMBER(38,0)      | The number of withdrawals included in the block.                                                                                                                                                                                  |
| 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.                                                                                                                                                                                       |
| execution\_requests         | VARIANT           | List of execution requests included in the block. Applicable post-pectra update.                                                                                                                                                  |
| validator\_count            | NUMBER(38,0)      | Total number of validators in the validator registry at the start of the epoch (from the epoch's first-slot state). On blocks this is constant across all slots of the epoch since the registry only changes at epoch boundaries. |
| epoch\_number               | NUMBER(38,0)      | Epoch number of the state this record was read from.                                                                                                                                                                              |

### Related Docs

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