Skip to main content

Table Details

PropertyValue
Table Namebeacon_hoodi.raw.blocks
Table StatusBeta 🌱
Clustering Key(s)to_date("slot_timestamp")
Search Optimizationslot_number

Table Columns

Column NameData TypeDescription
attestation_countNUMBER(38,0)The number of attestations included in the block.
attestationsVARIANTList of attestations included in the block.
attester_slashingsVARIANTList of attester slashings included in the block.
blob_kzg_commitmentsVARIANTKZG commitments for blobs included in the block.
bls_to_execution_changesVARIANTList of BLS to execution changes included in the block.
depositsVARIANTList of deposits included in the block.
eth1_dataVARIANTData related to the Ethereum 1.0 chain.
execution_payloadVARIANTThe execution payload of the block.
graffitiVARCHAR(16777216)Graffiti data included in the block.
proposer_slashingsVARIANTList of proposer slashings included in the block.
randao_revealVARCHAR(16777216)The RANDAO reveal for the block.
sync_aggregateVARIANTSync aggregate data included in the block.
voluntary_exitsVARIANTList of voluntary exits included in the block.
eth1_block_hashVARCHAR(16777216)The hash of the Ethereum 1.0 block.
eth1_block_numberVARCHAR(16777216)The number of the Ethereum 1.0 block.
eth1_block_timestampTIMESTAMP_NTZ(9)The timestamp of the Ethereum 1.0 block.
eth1_deposit_countNUMBER(38,0)The number of deposits in the Ethereum 1.0 block.
parent_rootVARCHAR(16777216)The parent root of the block.
proposer_indexNUMBER(38,0)The index of the proposer for the block.
state_rootVARCHAR(16777216)The root of the final state trie of the block.
execution_optimisticBOOLEANIndicates if the block is execution optimistic.
finalizedBOOLEANIndicates if the block is finalized.
versionVARCHAR(16777216)The version of the block.
slot_numberNUMBER(38,0)The slot number of the block.
slot_timestampTIMESTAMP_NTZ(9)The timestamp of the slot.
transaction_countNUMBER(38,0)Number of transactions included in this block.
withdrawal_countNUMBER(38,0)The number of withdrawals included in the block.
withdrawalsVARIANTList of validator withdrawals (from the beacon chain) included in the block
execution_requestsVARIANTList of execution requests included in the block. Applicable post-pectra update.
_created_atTIMESTAMP_NTZ(9)Timestamp when the record was created.
_updated_atTIMESTAMP_NTZ(9)Timestamp when the record was last updated.