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.

Last updated