Blocks
The beacon.raw.blocks table provides comprehensive slot-level data for the Beacon Chain, encompassing both consensus and execution layer information.
In instances where slots are missed, the corresponding consensus and execution data will be recorded as null, indicating the absence of activity for those slots.
Table Columns
Unique Key: slot_number
| Column Name | Description |
|---|---|
| ATTESTATION_COUNT | The number of attestations included in the block. |
| ATTESTATIONS | List of attestations included in the block. |
| ATTESTER_SLASHINGS | List of attester slashings included in the block. |
| BLOB_KZG_COMMITMENTS | KZG commitments for blobs included in the block. |
| BLS_TO_EXECUTION_CHANGES | List of BLS to execution changes included in the block. |
| DEPOSITS | List of deposits included in the block. |
| ETH1_DATA | Data related to the Ethereum 1.0 chain. |
| EXECUTION_PAYLOAD | The execution payload of the block. |
| GRAFFITI | Graffiti data included in the block. |
| PROPOSER_SLASHINGS | List of proposer slashings included in the block. |
| RANDAO_REVEAL | The RANDAO reveal for the block. |
| SYNC_AGGREGATE | Sync aggregate data included in the block. |
| VOLUNTARY_EXITS | List of voluntary exits included in the block. |
| ETH1_BLOCK_HASH | The hash of the Ethereum 1.0 block. |
| ETH1_BLOCK_NUMBER | The number of the Ethereum 1.0 block. |
| ETH1_BLOCK_TIMESTAMP | The timestamp of the Ethereum 1.0 block. |
| ETH1_DEPOSIT_COUNT | The number of deposits in the Ethereum 1.0 block. |
| PARENT_ROOT | The parent root of the block. |
| PROPOSER_INDEX | The index of the proposer for the block. |
| SLOT | The slot number of the block. |
| STATE_ROOT | The state root of the block. |
| EXECUTION_OPTIMISTIC | Indicates if the block is execution optimistic. |
| FINALIZED | Indicates if the block is finalized. |
| VERSION | The version of the block. |
| SLOT_NUMBER | The slot number of the block. |
| SLOT_TIMESTAMP | The timestamp of the slot. |
| TRANSACTION_COUNT | The number of transactions included in the block. |
| WITHDRAWAL_COUNT | The number of withdrawals included in the block. |
| WITHDRAWALS | List of withdrawals included in the block. |
| EXECUTION_REQUESTS | List of execution requests included in the block. Applicable post-pectra update. |
| _CREATED_AT | The timestamp when the block data was created. |
| _UPDATED_AT | The timestamp when the block data was last updated. |
Blocks
The beacon.raw.blocks table provides comprehensive slot-level data for the Beacon Chain, encompassing both consensus and execution layer information.
In instances where slots are missed, the corresponding consensus and execution data will be recorded as null, indicating the absence of activity for those slots.
Table Columns
Unique Key: slot_number
| Column Name | Description |
|---|---|
| ATTESTATION_COUNT | The number of attestations included in the block. |
| ATTESTATIONS | List of attestations included in the block. |
| ATTESTER_SLASHINGS | List of attester slashings included in the block. |
| BLOB_KZG_COMMITMENTS | KZG commitments for blobs included in the block. |
| BLS_TO_EXECUTION_CHANGES | List of BLS to execution changes included in the block. |
| DEPOSITS | List of deposits included in the block. |
| ETH1_DATA | Data related to the Ethereum 1.0 chain. |
| EXECUTION_PAYLOAD | The execution payload of the block. |
| GRAFFITI | Graffiti data included in the block. |
| PROPOSER_SLASHINGS | List of proposer slashings included in the block. |
| RANDAO_REVEAL | The RANDAO reveal for the block. |
| SYNC_AGGREGATE | Sync aggregate data included in the block. |
| VOLUNTARY_EXITS | List of voluntary exits included in the block. |
| ETH1_BLOCK_HASH | The hash of the Ethereum 1.0 block. |
| ETH1_BLOCK_NUMBER | The number of the Ethereum 1.0 block. |
| ETH1_BLOCK_TIMESTAMP | The timestamp of the Ethereum 1.0 block. |
| ETH1_DEPOSIT_COUNT | The number of deposits in the Ethereum 1.0 block. |
| PARENT_ROOT | The parent root of the block. |
| PROPOSER_INDEX | The index of the proposer for the block. |
| SLOT | The slot number of the block. |
| STATE_ROOT | The state root of the block. |
| EXECUTION_OPTIMISTIC | Indicates if the block is execution optimistic. |
| FINALIZED | Indicates if the block is finalized. |
| VERSION | The version of the block. |
| SLOT_NUMBER | The slot number of the block. |
| SLOT_TIMESTAMP | The timestamp of the slot. |
| TRANSACTION_COUNT | The number of transactions included in the block. |
| WITHDRAWAL_COUNT | The number of withdrawals included in the block. |
| WITHDRAWALS | List of withdrawals included in the block. |
| EXECUTION_REQUESTS | List of execution requests included in the block. Applicable post-pectra update. |
| _CREATED_AT | The timestamp when the block data was created. |
| _UPDATED_AT | The timestamp when the block data was last updated. |