Blocks

Stacks blocks contain transactions that are processed and added to the blockchain, linking to previous blocks to form a chain.

Table Columns

Column Name	Description
canonical	Indicates if the block corresponds to the canonical chain tip.
height	The height of the block in the blockchain.
hash	The unique identifier or hash of the block.
block_time	Unix timestamp (in seconds) indicating when this block was mined.
index_block_hash	The hash of the index block.
parent_block_hash	The hash of the parent block.
burn_block_time	Unix timestamp (in seconds) indicating when the corresponding burn block was mined.
burn_block_hash	Hash of the anchor chain block.
burn_block_height	Height of the anchor chain block.
miner_txid	Anchor chain transaction ID.
parent_microblock_hash	The hash of the last streamed block that precedes this block to which this block is to be appended.
parent_microblock_sequence	The sequence number of the last streamed block that precedes this block to which this block is appended.
txs	List of transactions included in the block.
microblocks_accepted	List of microblocks that were accepted in this anchor block. Does not include orphaned microblocks.
microblocks_streamed	List of microblocks streamed/produced by this anchor block's miner.
execution_cost_read_count	Execution cost read count.
execution_cost_read_length	Execution cost read length.
execution_cost_runtime	Execution cost runtime.
execution_cost_write_count	Execution cost write count.
execution_cost_write_length	Execution cost write length.
microblock_tx_count	The count of transactions in microblocks.
_created_at	Timestamp of the entry creation.
_updated_at	Timestamp of the entry update.