Skip to main content

Table Details

PropertyValue
Table Namestacks.raw.blocks
Table StatusProduction-Ready
Unique Keyheight
Clustering Key(s)to_date("burn_block_time")

Table Columns

Column NameData TypeDescription
canonicalBOOLEANIndicates if the block corresponds to the canonical chain tip.
heightNUMBER(38,0)The height of the block in the blockchain.
hashVARCHAR(16777216)The unique identifier or hash of the block.
miner_block_timeTIMESTAMP_NTZ(9)The timestamp set by the miner when producing the block.
index_block_hashVARCHAR(16777216)The hash of the index block.
parent_block_hashVARCHAR(16777216)The hash of the parent block.
burn_block_timeTIMESTAMP_NTZ(9)Unix timestamp (in seconds) indicating when the corresponding burn block was mined.
burn_block_hashVARCHAR(16777216)Hash of the anchor chain block.
burn_block_heightNUMBER(38,0)Height of the anchor chain block.
miner_txidVARCHAR(16777216)Anchor chain transaction ID.
parent_microblock_hashVARCHAR(16777216)The hash of the last streamed block that precedes this block to which this block is to be appended.
parent_microblock_sequenceNUMBER(38,0)The sequence number of the last streamed block that precedes this block to which this block is appended.
txsVARIANTList of transactions included in the block.
microblocks_acceptedVARIANTList of microblocks that were accepted in this anchor block. Does not include orphaned microblocks.
microblocks_streamedVARIANTList of microblocks streamed/produced by this anchor block’s miner.
execution_cost_read_countNUMBER(38,0)Execution cost read count.
execution_cost_read_lengthNUMBER(38,0)Execution cost read length.
execution_cost_runtimeNUMBER(38,0)Execution cost runtime.
execution_cost_write_countNUMBER(38,0)Execution cost write count.
execution_cost_write_lengthNUMBER(38,0)Execution cost write length.
microblock_tx_countVARIANTThe count of transactions in microblocks.
_created_atTIMESTAMP_NTZ(9)Timestamp of the entry creation.
_updated_atTIMESTAMP_NTZ(9)Timestamp of the entry update.