Skip to content

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