Blocks - Allium Documentation Hub

All blocks, starting from genesis.

Table Details

Property	Value
Table Name	`near.raw.blocks`
Table Status	Production-Ready
Unique Key	`timestamp`, `height`
Clustering Key(s)	`to_date("timestamp")`

Blocks are the fundamental units of data storage in the NEAR blockchain, containing a set of transactions and the state of the network at a specific point in time. Each block includes a hash, height, timestamp, and links to predecessor and successor blocks, ensuring the chain’s integrity and chronological order.

Table Columns

Column Name	Data Type	Description
timestamp	TIMESTAMP_NTZ(9)	The unix timestamp for when the block was collated
height	NUMBER(38,0)	The block height or index
hash	VARCHAR(16777216)	The block hash
approvals	VARIANT	An array of signatures, encoded in the standard ed25519 signature type
block_body_hash	VARCHAR(16777216)	Hash of the NEAR block body (transactions and receipts), distinct from the full block hash.
block_merkle_root	VARCHAR(16777216)	The merkle root of the block
block_ordinal	NUMBER(38,0)	The ordinal number of the block
challenges_result	VARIANT	An array of challenges outcome
challenges_root	VARCHAR(16777216)	The root challenges incurred
chunk_headers_root	VARCHAR(16777216)	The root of the headers trie of the block
chunk_mask	VARIANT	A boolean value
chunk_receipts_root	VARCHAR(16777216)	The root of the receipts trie of the block
chunk_tx_root	VARCHAR(16777216)	The root of the transaction trie of the block
chunks_included	NUMBER(38,0)	The chunks included in the queried block
epoch_id	VARCHAR(16777216)	The corresponding epoch id
epoch_sync_data_hash	VARCHAR(16777216)	The epoch sync data hash
gas_price	VARCHAR(16777216)	Integer of the gasPrice used for each paid gas encoded as a hexadecimal
last_ds_final_block	VARCHAR(16777216)	The last ds final block
last_final_block	VARCHAR(16777216)	The address of the last final block
latest_protocol_version	NUMBER(38,0)	The version of the latest protocol
next_bp_hash	VARCHAR(16777216)	The hash of the next bp node
next_epoch_id	VARCHAR(16777216)	The id next to the current epoch number
outcome_root	VARCHAR(16777216)	The root of the outcome trie of the block
prev_hash	VARCHAR(16777216)	The hash of the previous block
prev_height	NUMBER(38,0)	The height of the previous block
prev_state_root	VARCHAR(16777216)	The previous root state of the corresponding block
random_value	VARCHAR(16777216)	The random value generated to make the result deterministic
rent_paid	VARCHAR(16777216)	The number of tokens paid as rent
signature	VARCHAR(16777216)	The standard ed25519 signature type
total_supply	VARCHAR(16777216)	The total number of tokens supplied
validator_proposals	VARIANT	The validator proposals
validator_reward	VARCHAR(16777216)	The reward sent to the validators
author	VARCHAR(16777216)	The author name
_created_at	TIMESTAMP_NTZ(9)	Timestamp of the entry creation
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of the entry update
account_change_count	NUMBER(38,0)	Number of account state changes in this NEAR block.
balance_change_count	NUMBER(38,0)	Number of balance change records in this NEAR block.
balance_snapshot_count	NUMBER(38,0)	Number of balance snapshot records associated with this block.