| timestamp | TIMESTAMP_NTZ(9) | The unix timestamp for when the block was collated. |
| number | NUMBER(38,0) | The length of the chain, in blocks. |
| hash | VARCHAR(66) | Unique identifier of a block. |
| parent_hash | VARCHAR(66) | Unique identifier of the block preceding this block, also known as the parent block. |
| nonce | VARCHAR(42) | The hash of the generated proof-of-work. null if pending. |
| sha3_uncles | VARCHAR(66) | An array of uncle hashes. |
| logs_bloom | VARCHAR(16777216) | The bloom filter for the logs of the block. |
| transactions_root | VARCHAR(66) | The root of the transaction trie of the block. |
| state_root | VARCHAR(66) | The root of the final state trie of the block. |
| receipts_root | VARCHAR(66) | The root of the receipts trie of the block. |
| miner | VARCHAR(42) | The address of the beneficiary to whom the mining rewards were given. |
| difficulty | NUMBER(38,0) | The integer of the difficulty for this block. |
| total_difficulty | VARCHAR(66) | The integer of the total difficulty of the chain until this block. |
| size | NUMBER(38,0) | The size of the block, in bytes, as determined by the gas_limit. |
| extra_data | VARCHAR(16777216) | The “extra data” field of this block. |
| gas_limit | NUMBER(38,0) | Gas limit of the current block. |
| gas_used | NUMBER(38,0) | Total gas used in the block. |
| transaction_count | NUMBER(38,0) | Number of transactions included in this block. |
| base_fee_per_gas | NUMBER(38,0) | Post London Upgrade (EIP1559), this represents the minimum gas_used required for a transaction to be included in a block. Represented in wei. |
| requests_hash | VARCHAR(16777216) | Hash of execution requests included in the block. Used by some EVM-compatible chains for cross-chain communication and execution requests. |
| withdrawals_root | VARCHAR(16777216) | Root hash of the withdrawals list in the block; part of the block header introduced in Ethereum post-merge for validator withdrawals. |
| mini_block_count | VARCHAR(16777216) | Number of mini blocks included in this EVM block. MegaETH produces mini blocks every ~10ms and aggregates them into EVM blocks every ~1s. |
| withdrawals | VARCHAR(16777216) | List of validator withdrawals (from the beacon chain) included in the block |
| tx_offset | VARCHAR(16777216) | The starting transaction index offset within the EVM block, used to map transactions to their corresponding mini blocks. |
| parent_beacon_block_root | VARCHAR(16777216) | The root of the parent beacon block, linking execution layer blocks to consensus layer blocks. |
| excess_blob_gas | VARCHAR(16777216) | The excess blob gas from the previous block, used to calculate blob gas price. |
| blob_gas_used | VARCHAR(16777216) | Total blob gas used by all blob transactions in the block. Introduced in EIP-4844 (Dencun upgrade) for proto-danksharding. |
| signature | VARCHAR(16777216) | The sequencer’s cryptographic signature for the block, used to verify block authenticity. |
| mini_block_offset | VARCHAR(16777216) | The starting mini block index offset within the EVM block, used to identify the first mini block number in this block. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when the record was created. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when the record was last updated. |
