Transactions

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

Table Columns

Column Name	Description
anchor_mode	Specifies how the transaction is anchored to the Bitcoin chain (on_chain_only, off_chain_only, any).
block_hash	The hash of the block containing the transaction.
block_height	The height of the block containing the transaction.
block_time	Timestamp when the block was mined.
burn_block_height	Height of the burn chain block.
burn_block_time	Timestamp when the corresponding burn block was mined.
canonical	Indicates if the transaction is in the canonical chain.
event_count	The number of events generated by the transaction.
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.
fee_rate	The fee rate for the transaction.
is_unanchored	Indicates if the transaction is unanchored.
microblock_canonical	Indicates if the transaction is in a canonical microblock.
microblock_hash	The hash of the microblock containing the transaction.
microblock_sequence	The sequence number of the microblock.
nonce	The nonce used by the transaction sender.
parent_block_hash	The hash of the parent block.
parent_burn_block_time	Timestamp of the parent burn block.
post_condition_mode	The post condition mode for the transaction (allow, deny).
post_conditions	The post conditions specified in the transaction.
sender_address	The address of the transaction sender.
sponsored	Indicates if the transaction is sponsored.
tx_id	The unique identifier or hash of the transaction.
tx_index	The index of the transaction within the block.
tx_result	The result of the transaction execution.
tx_status	The status of the transaction (success, abort_by_response, abort_by_post_condition).
tx_type	The type of transaction (e.g., token_transfer).
tx_contents	The contents of the transaction.
true_event_count	The true count of events.
_created_at	Timestamp of the entry creation.
_updated_at	Timestamp of the entry update.