near.core Table: fact_blocks Type: View
Description
This table contains all finalized blocks on the NEAR Protocol blockchain, providing comprehensive block-level metadata including block height, timestamp, author (validator), cryptographic hashes, and protocol-specific header fields. Each record represents a unique block, capturing the full context of NEAR’s sharded architecture, including chunk and epoch data, validator proposals, and protocol versioning. The table is sourced from the final, canonical chain state and is foundational for all temporal, transactional, and consensus analytics on NEAR. It exposes both raw and parsed header fields, supporting deep analysis of block production, validator behavior, and protocol evolution.Key Use Cases
- Block production analysis and validator performance tracking
- Network activity monitoring and chain growth analysis
- Temporal alignment for transactions, receipts, and logs
- Consensus and protocol upgrade tracking
- Sharding and chunk distribution analysis
- Economic analysis of total supply, gas price, and validator rewards
- Cross-referencing with transaction, receipt, and event tables for full blockchain context
Important Relationships
- Links to
core.fact_transactionsandcore.fact_receiptsthroughblock_idfor temporal and execution context - Provides block context for
core.fact_logs,core.fact_token_transfers, and all downstream analytics tables - Supports
stats.ez_core_metrics_hourlyfor aggregated block and network metrics - Enables sharding and chunk analysis via chunk-related fields and relationships to chunk-level tables
- Serves as the temporal backbone for all gold layer models in the NEAR analytics suite
Commonly-used Fields
block_id: Essential for unique block identification and joining with all transactional tablesblock_timestamp: Primary field for time-series analysis and trend detectionblock_hash: Critical for block verification and chain integrityblock_author: Important for validator analysis and block production trackingtx_count: Key for network activity and throughput analysisheader,chunks, and chunk-related fields: Support sharding, chunk distribution, and protocol-level analyticstotal_supply,gas_price,validator_proposals,validator_reward: Important for economic and protocol analysisinserted_timestamp,modified_timestamp: Useful for data freshness and ETL monitoring
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_ID | NUMBER | The height of the chain this block corresponds with. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| BLOCK_HASH | TEXT | Unique identifier (hash) of this block. |
| BLOCK_AUTHOR | TEXT | The block_author taken from block headers. Validators of the blockchain. |
| HEADER | OBJECT | A json column containing header information from the object: block or chunk. |
| BLOCK_CHALLENGES_RESULT | ARRAY | The block_challenges_result taken from block headers. |
| BLOCK_CHALLENGES_ROOT | TEXT | The block_challenges_root taken from block headers. |
| CHUNK_HEADERS_ROOT | TEXT | The chunk_headers_root taken from block headers. |
| CHUNK_TX_ROOT | TEXT | The chunk_tx_root taken from block headers. |
| CHUNK_MASK | ARRAY | The chunk_mask taken from block headers. |
| CHUNK_RECEIPTS_ROOT | TEXT | The chunk_receipts_root taken from block headers. |
| CHUNKS | ARRAY | The chunks taken from block headers. Chunk is an aggregation of transactions which are executed within a particular shard. |
| CHUNKS_INCLUDED | NUMBER | The chunks_included taken from block headers. |
| EPOCH_ID | TEXT | The epoch_id taken from block headers. |
| EPOCH_SYNC_DATA_HASH | TEXT | The epoch_sync_data_hash taken from block headers, if available. |
| GAS_PRICE | FLOAT | The gas_price taken from block headers, number is not decimal adjusted. |
| LAST_DS_FINAL_BLOCK | TEXT | The last_ds_final_block taken from block headers. |
| LAST_FINAL_BLOCK | TEXT | The last_final_block taken from block headers. |
| LATEST_PROTOCOL_VERSION | NUMBER | The latest_protocol_version taken from block headers. |
| NEXT_BP_HASH | TEXT | The next_bp_hash taken from block headers. |
| NEXT_EPOCH_ID | TEXT | The next_epoch_id taken from block headers. |
| OUTCOME_ROOT | TEXT | The outcome_root taken from block headers. |
| PREV_HASH | TEXT | The prev_hash taken from block headers. |
| PREV_HEIGHT | NUMBER | The prev_height taken from block headers. |
| PREV_STATE_ROOT | TEXT | The prev_state_root taken from block headers. |
| RANDOM_VALUE | TEXT | The random_value taken from block headers. |
| RENT_PAID | FLOAT | The rent_paid taken from block headers. |
| SIGNATURE | TEXT | The signature taken from block headers. |
| TOTAL_SUPPLY | FLOAT | The total_supply taken from block headers. |
| VALIDATOR_PROPOSALS | ARRAY | The validator_proposals taken from block headers. |
| VALIDATOR_REWARD | FLOAT | The validator_reward taken from block headers. |
| FACT_BLOCKS_ID | TEXT | A unique identifier for the record. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which the record was initially created and inserted into this table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which this record was last modified by an internal process. |