| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| has_block_reward | BOOLEAN | Boolean flag indicating that there is a block reward. This is only applicable for pre-merge. |
| block_reward | VARCHAR(16777216) | Amount of block rewards to the miner in ETH. |
| has_uncle_reward | BOOLEAN | Boolean flag indicating that there is a uncle reward. This is only applicable for pre-merge. |
| uncles_reward | VARCHAR(16777216) | Amount of block uncle rewards in ETH. Note that it is possible to have more than one uncles rewards recipient. |
| uncles_reward_transactions | VARIANT | The trace level transfers to the uncles reward recipient wrapped in JSON. There can be more than one uncles reward recipient. |
| base_fee_burnt | VARCHAR(16777216) | The amount of base fees burnt in the block. |
| builder_priority_fee_reward | VARCHAR(16777216) | Priority fee (tips) sent to the block builder (miner) recipient address in the block. |
| builder_direct_reward | VARCHAR(16777216) | Array of direct ETH transactions to the block producer in the block, which are assuemd to be builder’s direct rewards. |
| builder_address | VARCHAR(42) | The address of the block builder (miner). |
| builder_direct_transactions | VARIANT | Direct amount of ETH transfers rewarded to the block builder (miner) in the block. |
| has_mev_reward | BOOLEAN | Amount of MEV reward awarded in ETH. |
| proposer_mev_reward | VARCHAR(16777216) | ETH value of MEV rewards paid to the block proposer (validator), extracted from MEV-boost relay data or direct payment transactions to the fee recipient address. |
| proposer_fee_recipient | VARCHAR(42) | Block proposer fee recipient address. This is the address that receives the MEV reward from the block builder. |
| proposer_payout_transaction | VARCHAR(66) | Proposer’s MEV reward payout transaction. |
| l1_gas_used | VARCHAR(16777216) | L1 gas used. |
| l1_gas_limit | VARCHAR(16777216) | L1 gas limit of the block. |
| l1_extra_data | VARCHAR(16777216) | L1 extra data. |
| l1_block_hash | VARCHAR(66) | L1 block hash. |
| slot_number | NUMBER(38,0) | Beacon Chain slot number. |
| epoch | NUMBER(38,0) | Epoch number. On Sui, epochs are ~24 hour periods used for validator rotation and staking rewards. On Solana, epochs are voting periods. On Cosmos, epoch is a governance/staking cycle. |
| proposer_index | NUMBER(38,0) | The index of validator in validator registry. |
| pubkey | VARCHAR(16777216) | The validator’s BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive. |
| graffiti | VARCHAR(16777216) | 32 byte field of arbitrary data. This field may contain any data included by the block proposer. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
