Blocks are the building blocks of blockchains and rollups.

A block contains transactions which will alter the state of an EVM system incrementally. Transaction within a block can only be executed one after the other, not in parallel.

Several columns may only be applicable for specific EVM-compatible blockchains. The list of columns present in the table is not exhaustive.

​
Table Columns

Unique Key: number

Column NameData TypeDescription
timestampTIMESTAMP_NTZ(9)The unix timestamp for when the block was collated.
numberBIGINTThe length of the chain, in blocks.
hashVARCHARUnique identifier of a block.
parent_hashVARCHARUnique identifier of the block preceding this block, also known as the parent block.
nonceVARCHARThe hash of the generated proof-of-work. null if pending
sha3_unclesVARCHARAn array of uncle hashes.
logs_bloomVARCHARThe bloom filter for the logs of the block.
transactions_rootVARCHARThe root of the transaction trie of the block.
state_rootVARCHARThe root of the final state trie of the block.
receipts_rootVARCHARThe root of the receipts trie of the block.
minerVARCHARThe address of the beneficiary to whom the mining rewards were given.
difficultyBIGINTThe integer of the difficulty for this block.
total_difficultyVARCHARThe integer of the total difficulty of the chain until this block.
sizeBIGINTThe size of the block, in bytes, as determined by the gas_limit.
extra_dataVARCHARThe “extra data” field of this block.
gas_limitBIGINTGas limit of the current block.
gas_usedBIGINTTotal gas used in the block.
transaction_countBIGINTNumber of transactions included in this block.
base_fee_per_gasBIGINTPost London Upgrade (EIP1559), this represents the minimum gas_used required for a transaction to be included in a block. Represented in wei.
send_rootVARCHARThe root hash of send operations.
created_atTIMESTAMP_NTZ(9)Timestamp when the record was created.
updated_atTIMESTAMP_NTZ(9)Timestamp when the record was last updated.