Table: t_blocks

Table Documentation: `t_blocks`

Summary:
The t_blocks table contains detailed information about each block on the Beacon Chain, including the slot number, proposer index, various roots, and flags indicating the block's canonical status.

Description:
In Beacon Chain blocks are proposed by one randomly selected validator called proposer.
This table is crucial for analyzing the Beacon Chain's block production, including the proposers' behavior, block inclusion, and the Ethereum 1 (Eth1) data votes. Each row represents a block and includes metadata such as the proposer's validator index, the block's root, and its relation to the Eth1 chain.

Schema Overview

Column Name	Data Type	Nullable	Description
`f_slot`	INT64	YES	The slot number for which the block was proposed.
`f_proposer_index`	INT64	YES	The index of the validator that proposed the block.
`f_root`	STRING	YES	The root of the block.
`f_graffiti`	STRING	YES	Arbitrary data proposers can include in their proposed blocks. Often used for validator identification or messages.
`f_randao_reveal`	STRING	YES	The RANDAO reveal value, contributing to the randomness of the protocol.
`f_body_root`	STRING	YES	The root of the block body.
`f_parent_root`	STRING	YES	The root of the parent block.
`f_state_root`	STRING	YES	The state root after processing the block.
`f_canonical`	BOOL	YES	Indicates if the block is part of the canonical chain.
`f_eth1_block_hash`	STRING	YES	The hash of the Eth1 block voted on in the Eth1 data vote.
`f_eth1_deposit_count`	INT64	YES	The number of deposits from the Eth1 chain included up to this block.
`f_eth1_deposit_root`	STRING	YES	The root of the Eth1 deposit tree.

Example SQL Query

SELECT * 
FROM raw_beacon_chain.t_blocks
LIMIT 3;

Sample Query Result

f_slot	f_proposer_index	f_root	f_graffiti	f_randao_reveal	f_body_root	f_parent_root	f_state_root	f_canonical	f_eth1_block_hash	f_eth1_deposit_count	f_eth1_deposit_root
5765961	418482	\x634ccad1d978c47755cd7dacc7d168dc7853c560e3b48fcedf3002dbd72...	\x336335356230623061363265313739303763326132636435333532...	\x98198e81488e85e5e74dd342c960de3260ce8f790d70c83dc557aa6d...	\x7c04ee7872fe01447432e970513641da765d2df71fa634308001fad...	\x550e17e0892bb0ab496d2eb936418825982b027f9059f9415c37a9c...	\x36780a892d08a887dd099db7edf027936d526b566289876b7801d...	true	\x25cb7c6d3f3d7c49ba6baa35af5276985e08373046c2165bf...	528653	\x59554a60285987aa59a163c282e96e8bb67cfa60ba687937b7...
5766707	490013	\xdde59363dd4dfbd807c23af1bae9e84ef0468d625f40aff5aa6131ef7...	\x56616c69646174696e675f66726f6d5f444170704e6f64650000...	\x8447acd6e9cbdab0a4d932c1244b2a3354963d6aa46c2412e7115cf...	\x89a07df8fc140a0793ebf19fabc31e543c54e88cf619e24e3296a0...	\xcaf0ac7f998b041f9d0576704d76967954f2a88fe6ae702297ee1d...	\xca0f2ee75019e03497579bf38ea5169f29aaa40422acb1b3bf02...	true	\xb0c3c8a7eee7505a35e96ae54210018c42ff9806c0f7e6ef8a...	529386	\xcdd7cbac01bdd3c343798f276a7784de17b75915b30dedb...
5767522	325099	\x185be1ccb7da3d77d396af87603f45149e18aca80910a94981fdd3...	\x56616c69646174696e675f46726f6d5f5468655f536f7574685...	\xac26bbb622dab3a3b05bf5beab686bd39b5b0153604b1cf7ea714...	\x9a0aff1112b48cf4991e05216d05947abdbca8b980392337c5148...	\x9cbb0dcd8dccfe86a4188132078cd958a9d30b0c70ef9f7f89e6...	\xda0817a2e17a50ebcc1c746993a2011ddc0391925066c1af0d1d...	true	\x26b5b4e0e42550980058f27f0f7d10ff372001e9199dfdbd39...	529386	\x261f4db6b1ca78743cb1400ba7dca2fff6e5965e63b251b...

Note: The sample result set is a truncated representation of the actual query result. It showcases the detailed information available for each block, such as the slot number, proposer index, various cryptographic roots, and the block's canonical status, among others.

Table Documentation: t_blocks

Schema Overview

Example SQL Query

Sample Query Result

Table Documentation: `t_blocks`