Raw
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. |