Blocks

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.

Table Details

Property	Value
Table Name	`imx-zkevm.raw.blocks`
Table Status	Production-Ready
Unique Key	`timestamp`, `number`
Clustering Key(s)	`to_date("timestamp")`
Search Optimization	`number`, `hash`, `miner`

Table Columns

Column Name	Data Type	Description
timestamp	TIMESTAMP_NTZ(9)	The unix timestamp for when the block was collated.
number	NUMBER(38,0)	The length of the chain, in blocks.
hash	VARCHAR(66)	Unique identifier of a block.
parent_hash	VARCHAR(66)	Unique identifier of the block preceding this block, also known as the parent block.
nonce	VARCHAR(42)	The hash of the generated proof-of-work. null if pending.
sha3_uncles	VARCHAR(66)	An array of uncle hashes.
logs_bloom	VARCHAR(16777216)	The bloom filter for the logs of the block.
transactions_root	VARCHAR(66)	The root of the transaction trie of the block.
state_root	VARCHAR(66)	The root of the final state trie of the block.
receipts_root	VARCHAR(66)	The root of the receipts trie of the block.
miner	VARCHAR(42)	The address of the beneficiary to whom the mining rewards were given.
difficulty	NUMBER(38,0)	The integer of the difficulty for this block.
total_difficulty	VARCHAR(66)	The integer of the total difficulty of the chain until this block.
size	NUMBER(38,0)	The size of the block, in bytes, as determined by the gas_limit.
extra_data	VARCHAR(16777216)	The “extra data” field of this block.
gas_limit	NUMBER(38,0)	Gas limit of the current block.
gas_used	NUMBER(38,0)	Total gas used in the block.
transaction_count	NUMBER(38,0)	Number of transactions included in this block.
base_fee_per_gas	NUMBER(38,0)	Post London Upgrade (EIP1559), this represents the minimum gas_used required for a transaction to be included in a block. Represented in wei.
_created_at	TIMESTAMP_NTZ(9)	Timestamp when the record was created.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when the record was last updated.

EVM Raw Blocks

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Table Columns

​Table Details

​Table Columns

​Related Docs

Table Details

Table Columns

Related Docs