Fact Blocks

Schema: monad.core Table: fact_blocks Type: Fact Table

​

What

This table contains block-level data for EVM blockchains, providing a complete record of all blocks produced on the chain. Each row represents one block with its associated metadata, transactions, and gas metrics.

​

Key Use Cases

• Analyzing gas price trends and network congestion over t

​

Columns

Exa… | | BLOB_GAS_USED | TEXT | Gas consumed by blob transactions (EIP-4844, post-Dencun)… | | BLOCK_HASH | TEXT | The unique 32-byte Keccak-256 hash of the block header, p… | | BLOCK_NUMBER | NUMBER | Sequential counter representing the position of a block i… | | BLOCK_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the block was produced by validators/m… | | DIFFICULTY | TEXT | Mining difficulty at block production time. Example: 0 | | EXCESS_BLOB_GAS | TEXT | Excess blob gas above target, affects next block’s blob b… | | EXTRA_DATA | TEXT | Arbitrary data included by block producer (max 32 bytes)… | | FACT_BLOCKS_ID | TEXT | Primary key - unique identifier for each row ensuring dat… | | GAS_LIMIT | TEXT | Maximum gas allowed for all transactions in this block. … | | GAS_USED | TEXT | Total gas consumed by all transactions in the block. Exa… | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the record was first added to the Flip… | | LOGS_BLOOM | TEXT | 2048-bit bloom filter containing all log addresses and to… | | MINER | TEXT | Address that received block rewards. Example: ‘0xea674fd… | | MIX_HASH | TEXT | 256-bit hash used in PoW mining process. Post-merge, cont… | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp of the most recent update to this record. … | | NETWORK | TEXT | Network identifier within the blockchain (e.g., ‘mainnet’… | | NONCE | TEXT | Proof-of-Work nonce value. For PoW chains, this demonstra… | | PARENT_BEACON_BLOCK_ROOT | TEXT | Root hash of the parent beacon chain block (post-merge Et… | | PARENT_HASH | TEXT | Hash of the previous block (block_number - 1). Example: … | | RECEIPTS_ROOT | TEXT | Merkle root of all transaction receipts in the block. Ex… | | SHA3_UNCLES | TEXT | Keccak-256 hash of uncle blocks list. Example: ‘0x1dcc4d… | | SIZE | TEXT | Block size in bytes. Example: 125432 | | STATE_ROOT | TEXT | Merkle root of the entire blockchain state after executin… | | TOTAL_DIFFICULTY | TEXT | Cumulative difficulty from genesis to this block. Exampl… | | TRANSACTIONS_ROOT | TEXT | Merkle root of all transactions in the block. Example: ’… | | TX_COUNT | NUMBER | Number of transactions included in the block. Example: 142 | | UNCLE_BLOCKS | TEXT | Array of uncle block headers (PoW only). Example: [] | | WITHDRAWALS | TEXT | Array of validator withdrawals from beacon chain. Exampl… | | WITHDRAWALS_ROOT | TEXT | Merkle root of all withdrawals in the block. Example: ‘0… |