Block summaries

Schema

Column NameData Type
chain_idLong
block_numberLong
block_timestampLong
hashString
canonical_rlpString
parent_hashString
coinbaseString
gas_limitLong
gas_usedLong
difficultyBigDecimal
nonceBigDecimal
txn_countLong
unclesJSON - Array of uncles' hashes
base_fee_per_gas_gweiBigDecimal
mix_hashString
epochLong - optional
slotLong - optional
proposer_indexLong - optional
proposer_public_keyString - optional
excess_blob_gasBigDecimal - optional
blob_gas_usedBigDecimal - optional

Coverage

Ethereum, Base, Arbitrum

Usage notes

The table contains only one row per block number, reorg'd blocks are removed.

Some columns are optional since they contain fields that were added at a later time in the chain. To properly handle null values, pinot suggests usingSET enableNullHandling=true; before the SQL query. That will enable filtering the null values using theWHERE col IS NULL predicate and ignore null values in aggregation functions.

Here, you can learn more about how Pinot handles null values in queries.