Skip to main content

Overview

  • Dataset ID: 0101
  • Table: blockdb0101_blocks_v1
  • Description: Holds information about each mined block
  • Primary Key: block_number

Columns

ColumnTypeDescription
block_numberBIGINTSequential number of the block in the blockchain
block_hashBYTEAKeccak-256 hash of the current block (32 bytes)
parent_block_hashBYTEAKeccak-256 hash of the previous block (32 bytes)
receipt_rootBYTEAHashed txs receipts with logs used for verification, no need to import by Data Engines
minerBYTEAFee-recipient / coinbase address for the block (20-byte 0x address).
gas_limitBIGINTMaximum cumulative gas allowed for all transactions in the block.
extra_dataBYTEAArbitrary ≤32-byte payload the block producer embeds in the header.
sizeBIGINTTotal block size in bytes, including header, transactions, and receipts.
timestamp_utcTIMESTAMPTZUTC timestamp when the block was mined
_tracing_idBYTEATracing ID of the genesis block record.
_computed_receipt_rootBYTEARecomputed receipts root (BlockDB integrity check).
_computed_receipt_timestamp_utcTIMESTAMPTZUTC timestamp when receipts root was (re)computed.
_created_atTIMESTAMPTZRecord creation timestamp.
_updated_atTIMESTAMPTZRecord last update timestamp.

Use Cases

  • Chain reconstruction and blockchain state verification
  • Block production and mining analytics
  • Gas market analysis and block space utilization
  • Chain reorganization detection and handling
  • Foundation for transaction and log indexing
  • Block-level time series analysis and chain health monitoring