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 NameDescription
ATTESTATION_COUNTThe number of attestations included in the block.
ATTESTATIONSList of attestations included in the block.
ATTESTER_SLASHINGSList of attester slashings included in the block.
BLOB_KZG_COMMITMENTSKZG commitments for blobs included in the block.
BLS_TO_EXECUTION_CHANGESList of BLS to execution changes included in the block.
DEPOSITSList of deposits included in the block.
ETH1_DATAData related to the Ethereum 1.0 chain.
EXECUTION_PAYLOADThe execution payload of the block.
GRAFFITIGraffiti data included in the block.
PROPOSER_SLASHINGSList of proposer slashings included in the block.
RANDAO_REVEALThe RANDAO reveal for the block.
SYNC_AGGREGATESync aggregate data included in the block.
VOLUNTARY_EXITSList of voluntary exits included in the block.
ETH1_BLOCK_HASHThe hash of the Ethereum 1.0 block.
ETH1_BLOCK_NUMBERThe number of the Ethereum 1.0 block.
ETH1_BLOCK_TIMESTAMPThe timestamp of the Ethereum 1.0 block.
ETH1_DEPOSIT_COUNTThe number of deposits in the Ethereum 1.0 block.
PARENT_ROOTThe parent root of the block.
PROPOSER_INDEXThe index of the proposer for the block.
SLOTThe slot number of the block.
STATE_ROOTThe state root of the block.
EXECUTION_OPTIMISTICIndicates if the block is execution optimistic.
FINALIZEDIndicates if the block is finalized.
VERSIONThe version of the block.
SLOT_NUMBERThe slot number of the block.
SLOT_TIMESTAMPThe timestamp of the slot.
TRANSACTION_COUNTThe number of transactions included in the block.
WITHDRAWAL_COUNTThe number of withdrawals included in the block.
WITHDRAWALSList of withdrawals included in the block.
EXECUTION_REQUESTSList of execution requests included in the block. Applicable post-pectra update.
_CREATED_ATThe timestamp when the block data was created.
_UPDATED_ATThe timestamp when the block data was last updated.