Stacks transactions represent individual actions on the blockchain, such as transferring tokens or interacting with smart contracts.

Table Columns

Column NameDescription
anchor_modeSpecifies how the transaction is anchored to the Bitcoin chain (on_chain_only, off_chain_only, any).
block_hashThe hash of the block containing the transaction.
block_heightThe height of the block containing the transaction.
block_timeTimestamp when the block was mined.
burn_block_heightHeight of the burn chain block.
burn_block_timeTimestamp when the corresponding burn block was mined.
canonicalIndicates if the transaction is in the canonical chain.
event_countThe number of events generated by the transaction.
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.
fee_rateThe fee rate for the transaction.
is_unanchoredIndicates if the transaction is unanchored.
microblock_canonicalIndicates if the transaction is in a canonical microblock.
microblock_hashThe hash of the microblock containing the transaction.
microblock_sequenceThe sequence number of the microblock.
nonceThe nonce used by the transaction sender.
parent_block_hashThe hash of the parent block.
parent_burn_block_timeTimestamp of the parent burn block.
post_condition_modeThe post condition mode for the transaction (allow, deny).
post_conditionsThe post conditions specified in the transaction.
sender_addressThe address of the transaction sender.
sponsoredIndicates if the transaction is sponsored.
tx_idThe unique identifier or hash of the transaction.
tx_indexThe index of the transaction within the block.
tx_resultThe result of the transaction execution.
tx_statusThe status of the transaction (success, abort_by_response, abort_by_post_condition).
tx_typeThe type of transaction (e.g., token_transfer).
tx_contentsThe contents of the transaction.
true_event_countThe true count of events.
_created_atTimestamp of the entry creation.
_updated_atTimestamp of the entry update.