Blocks

eth.blocks

Purpose: TODO (describe what this table powers and its grain).

Columns

• number — UInt64
• hash — FixedString(66)
• timestamp — DateTime
• transaction_count — UInt32
• gas_limit — UInt64
• gas_used — UInt64
• base_fee_per_gas — UInt256
• miner — FixedString(42)
• blob_gas_used — UInt64
• excess_blob_gas — UInt64

Modeling notes

• Engine: MergeTree
• Partition key: toYYYYMM(timestamp)
• Sorting (ORDER BY): number, timestamp