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

Table Columns

Column NameDescription
canonicalIndicates if the block corresponds to the canonical chain tip.
heightThe height of the block in the blockchain.
hashThe unique identifier or hash of the block.
block_timeUnix timestamp (in seconds) indicating when this block was mined.
index_block_hashThe hash of the index block.
parent_block_hashThe hash of the parent block.
burn_block_timeUnix timestamp (in seconds) indicating when the corresponding burn block was mined.
burn_block_hashHash of the anchor chain block.
burn_block_heightHeight of the anchor chain block.
miner_txidAnchor chain transaction ID.
parent_microblock_hashThe hash of the last streamed block that precedes this block to which this block is to be appended.
parent_microblock_sequenceThe sequence number of the last streamed block that precedes this block to which this block is appended.
txsList of transactions included in the block.
microblocks_acceptedList of microblocks that were accepted in this anchor block. Does not include orphaned microblocks.
microblocks_streamedList of microblocks streamed/produced by this anchor block’s miner.
execution_cost_read_countExecution cost read count.
execution_cost_read_lengthExecution cost read length.
execution_cost_runtimeExecution cost runtime.
execution_cost_write_countExecution cost write count.
execution_cost_write_lengthExecution cost write length.
microblock_tx_countThe count of transactions in microblocks.
_created_atTimestamp of the entry creation.
_updated_atTimestamp of the entry update.