> ## 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 | `celestia.raw.transactions` |
| Table Status | Production-Ready |
| Unique Key | `block_timestamp`, `hash` |
| Clustering Key(s) | `to_date("block_timestamp")` |
| Search Optimization | `block_height`, `hash` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| block\_height | NUMBER(38,0) | The sequential number of the block in the blockchain. |
| block\_timestamp | TIMESTAMP\_NTZ(9) | The timestamp when the block was created. |
| block\_hash | VARCHAR(16777216) | The hash of the block containing the transaction. |
| hash | VARCHAR(16777216) | The hash of the transaction. |
| transaction\_index | NUMBER(38,0) | The index of the transaction within the block. |
| code | NUMBER(38,0) | The code returned after the transaction execution (e.g., 0 for success). |
| codespace | VARCHAR(16777216) | The namespace for the error codes. |
| gas\_used | VARCHAR(16777216) | The amount of gas used for the transaction. |
| gas\_wanted | VARCHAR(16777216) | The amount of gas requested for the transaction. |
| tx\_acc\_seq | VARCHAR(16777216) | The sequence number of the account used in the transaction. |
| tx\_fee\_payer | VARCHAR(16777216) | The address of the account paying the transaction fee. |
| tx\_fee\_raw | VARCHAR(16777216) | The raw fee data for the transaction, containing both amount and denomination. |
| fee\_amount | VARCHAR(16777216) | The fee amount for the transaction. |
| fee\_denom | VARCHAR(16777216) | The denomination of the fee amount. |
| event\_count | NUMBER(38,0) | The number of events associated with the transaction. |
| log | VARCHAR(16777216) | The log of the transaction execution in string format. Use `try_parse_json` to fetch the log details. |
| info | VARCHAR(16777216) | Additional information about the transaction. |
| tx | VARCHAR(16777216) | The transaction details in a serialized format. |
| data | VARCHAR(16777216) | The data returned from the transaction execution. |
| \_created\_at | TIMESTAMP\_NTZ(9) | The timestamp when the entry was created. |
| \_updated\_at | TIMESTAMP\_NTZ(9) | The timestamp when the entry was updated. |

### Related Docs

* [COSMOS Raw Transactions](/historical-data/supported-blockchains/cosmos-ecosystem/core-schemas/raw/transactions)