> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Transactions

### Table Details

| Property          | Value                        |
| ----------------- | ---------------------------- |
| Table Name        | `stacks.raw.transactions`    |
| Table Status      | Production-Ready             |
| Unique Key        | `tx_id`                      |
| Clustering Key(s) | `to_date("burn_block_time")` |

### Table Columns

| Column Name                    | Data Type         | Description                                                                                              |
| ------------------------------ | ----------------- | -------------------------------------------------------------------------------------------------------- |
| anchor\_mode                   | VARCHAR(16777216) | Specifies how the transaction is anchored to the Bitcoin chain (on\_chain\_only, off\_chain\_only, any). |
| block\_hash                    | VARCHAR(16777216) | The hash of the block containing the transaction.                                                        |
| block\_height                  | NUMBER(38,0)      | The height of the block containing the transaction.                                                      |
| miner\_block\_time             | TIMESTAMP\_NTZ(9) | The timestamp set by the miner when producing the block.                                                 |
| burn\_block\_height            | NUMBER(38,0)      | Height of the burn chain block.                                                                          |
| burn\_block\_time              | TIMESTAMP\_NTZ(9) | Timestamp when the corresponding burn block was mined.                                                   |
| canonical                      | BOOLEAN           | Indicates if the transaction is in the canonical chain.                                                  |
| event\_count                   | NUMBER(38,0)      | The number of events generated by the transaction.                                                       |
| execution\_cost\_read\_count   | NUMBER(38,0)      | Execution cost read count.                                                                               |
| execution\_cost\_read\_length  | NUMBER(38,0)      | Execution cost read length.                                                                              |
| execution\_cost\_runtime       | NUMBER(38,0)      | Execution cost runtime.                                                                                  |
| execution\_cost\_write\_count  | NUMBER(38,0)      | Execution cost write count.                                                                              |
| execution\_cost\_write\_length | NUMBER(38,0)      | Execution cost write length.                                                                             |
| fee\_rate                      | NUMBER(38,0)      | The fee rate for the transaction.                                                                        |
| is\_unanchored                 | BOOLEAN           | Indicates if the transaction is unanchored.                                                              |
| microblock\_canonical          | BOOLEAN           | Indicates if the transaction is in a canonical microblock.                                               |
| microblock\_hash               | VARCHAR(16777216) | The hash of the microblock containing the transaction.                                                   |
| microblock\_sequence           | NUMBER(38,0)      | The sequence number of the microblock.                                                                   |
| nonce                          | NUMBER(38,0)      | The nonce used by the transaction sender.                                                                |
| parent\_block\_hash            | VARCHAR(16777216) | The hash of the parent block.                                                                            |
| parent\_burn\_block\_time      | TIMESTAMP\_NTZ(9) | Timestamp of the parent burn block.                                                                      |
| post\_condition\_mode          | VARCHAR(16777216) | The post condition mode for the transaction (allow, deny).                                               |
| post\_conditions               | VARIANT           | The post conditions specified in the transaction.                                                        |
| sender\_address                | VARCHAR(16777216) | The address of the transaction sender.                                                                   |
| sponsored                      | BOOLEAN           | Indicates if the transaction is sponsored.                                                               |
| tx\_id                         | VARCHAR(16777216) | The unique identifier or hash of the transaction.                                                        |
| tx\_index                      | NUMBER(38,0)      | The index of the transaction within the block.                                                           |
| tx\_result                     | VARIANT           | The result of the transaction execution.                                                                 |
| tx\_status                     | VARCHAR(16777216) | The status of the transaction (success, abort\_by\_response, abort\_by\_post\_condition).                |
| tx\_type                       | VARCHAR(16777216) | The type of transaction (e.g., token\_transfer).                                                         |
| tx\_contents                   | VARIANT           | The contents of the transaction.                                                                         |
| \_created\_at                  | TIMESTAMP\_NTZ(9) | Timestamp of the entry creation.                                                                         |
| \_updated\_at                  | TIMESTAMP\_NTZ(9) | Timestamp of the entry update.                                                                           |
| true\_event\_count             | NUMBER(38,0)      | The true count of events.                                                                                |