Skip to main content
Schema: flow.core_evm Table: fact_blocks Type: Base Table

​
Description

A comprehensive fact table containing block-level data for EVM-compatible blockchains. This table serves as the foundation for blockchain analysis, providing detailed information about each block including metadata, gas usage, mining information, and blockchain state. The table supports analysis of blockchain performance, gas economics, and network health across multiple EVM chains. Each record represents a single block with complete header information and aggregated transaction data.

​
Key Use Cases

  • Blockchain Performance Analysis: Monitoring block production rates, gas usage patterns, and network efficiency
  • Gas Economics: Analyzing gas prices, fee structures, and economic incentives across different EVM chains
  • Network Health Monitoring: Tracking block difficulty, mining rewards, and network security metrics
  • Cross-Chain Comparison: Comparing performance and characteristics across different EVM-compatible blockchains
  • Mining Analysis: Understanding validator/miner behavior and reward distribution patterns
  • Blockchain State Tracking: Monitoring blockchain progression and state changes over time

​
Important Relationships

  • core_evm__fact_transactions: Links to transaction data within each block
  • core_evm__fact_event_logs: May link to event logs emitted in blocks
  • core_evm__fact_traces: May link to execution traces for block analysis
  • core__fact_blocks: May provide comparison data with native Flow blocks
  • price__ez_prices_hourly: May link to native token prices for economic analysis

​
Commonly-used Fields

  • BLOCK_NUMBER: Essential for block identification and chronological analysis
  • BLOCK_TIMESTAMP: Critical for time-series analysis and temporal data aggregation
  • GAS_USED/GAS_LIMIT: Key for gas economics and network efficiency analysis
  • TX_COUNT: Important for transaction volume and network activity analysis
  • MINER: Critical for mining analysis and validator behavior studies
  • BASE_FEE_PER_GAS: Essential for EIP-1559 fee mechanism analysis

​
Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERAlso known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block.
BLOCK_HASHTEXTThe hash of the block header for a given block.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
NETWORKTEXTThe network on the blockchain used by a transaction.
TX_COUNTNUMBERTotal number of transactions within a block.
SIZENUMBERBlock size, which is determined by a given block’s gas limit.
MINERTEXTThe address of the beneficiary to whom the mining rewards were given
MIX_HASHTEXTA string of a 256-bit hash encoded as a hexadecimal
EXTRA_DATATEXTAny data included by the miner for a given block.
PARENT_HASHTEXTThe hash of the block from which a given block is generated. Also known as the parent block.
GAS_USEDNUMBERTotal gas used in the block.
GAS_LIMITNUMBERTotal gas limit provided by all transactions in the block.
BASE_FEE_PER_GASNUMBERA string of the base fee encoded in hexadecimal format. Please note that this response field will not be included in a block requested before the EIP-1559 upgrade
DIFFICULTYNUMBERThe effort required to mine the block.
TOTAL_DIFFICULTYNUMBERTotal difficulty of the chain at a given block.
SHA3_UNCLESTEXTThe mechanism which Ethereum Javascript RLP encodes an empty string.
UNCLE_BLOCKSVARIANTUncle blocks occur when two blocks are mined and broadcasted at the same time, with the same block number. The block validated across the most nodes will be added to the primary chain, and the other one becomes an uncle block. Miners do receive rewards for uncle blocks.
NONCENUMBERBlock nonce is a value used during mining to demonstrate proof of work for a given block.
RECEIPTS_ROOTTEXTThe root of the state trie.
STATE_ROOTTEXTThe root of the final state trie of the block
TRANSACTIONS_ROOTTEXTThe root of the transaction trie of the block
LOGS_BLOOMTEXTThe bloom filter for the logs of the block.
FACT_BLOCKS_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp at which the row was last modified.