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.
Table Details
| Property | Value |
|---|---|
| Table Name | stellar_testnet.raw.transactions |
| Table Status | Beta 🌱 |
| Unique Key | ledger_close_time, hash |
| Clustering Key(s) | to_date("ledger_close_time") |
| Search Optimization | hash, ledger_sequence, source_account |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| hash | VARCHAR(16777216) | The hash of the transaction |
| transaction_index | NUMBER(38,0) | The index of the transaction within the ledger |
| source_account | VARCHAR(16777216) | The account that submitted the transaction |
| source_account_muxed | VARCHAR(16777216) | The muxed account address (if applicable) |
| source_account_sequence | NUMBER(38,0) | The sequence number of the source account |
| transaction_result | VARCHAR(16777216) | The result code of the transaction |
| successful | BOOLEAN | Whether the transaction was successful |
| memo_type | VARCHAR(16777216) | The type of memo attached to the transaction |
| memo | VARCHAR(16777216) | The memo text (if applicable) |
| memo_bytes | VARCHAR(16777216) | The memo as bytes (if applicable) |
| transaction_max_fee | NUMBER(38,0) | The maximum fee specified for the transaction |
| inner_transaction_max_fee | NUMBER(38,0) | The maximum fee for inner transactions |
| fee_charged | NUMBER(38,0) | The actual fee charged for the transaction |
| total_non_refundable_resource_fee_charged | NUMBER(38,0) | Total non-refundable resource fees charged |
| total_refundable_resource_fee_charged | NUMBER(38,0) | Total refundable resource fees charged |
| resource_fee_charged | NUMBER(38,0) | Resource fees charged for the transaction |
| inclusion_fee_charged | NUMBER(38,0) | Fee charged for including the transaction in the ledger |
| resource_fee_refund | NUMBER(38,0) | Resource fees refunded |
| fee_account | VARCHAR(16777216) | The account that paid the fee |
| fee_account_muxed | VARCHAR(16777216) | The muxed fee account address (if applicable) |
| fee_account_muxed_id | VARCHAR(16777216) | The muxed ID of the fee account |
| fee_bump_transaction | VARIANT | Whether this is a fee bump transaction |
| envelope_xdr | VARCHAR(16777216) | The transaction envelope in XDR format |
| fee_meta_xdr | VARCHAR(16777216) | The fee metadata in XDR format |
| result_xdr | VARCHAR(16777216) | The transaction result in XDR format |
| result_meta_xdr | VARCHAR(16777216) | The result metadata in XDR format |
| preconditions | VARIANT | Transaction preconditions |
| inner_transaction | VARIANT | Whether this is an inner transaction |
| signatures | VARCHAR(16777216) | Transaction signatures |
| ledger_sequence | NUMBER(38,0) | The sequence number of the ledger containing this transaction |
| ledger_close_time | TIMESTAMP_NTZ(9) | The close time of the ledger containing this transaction |
| ledger_hash | VARCHAR(16777216) | The hash of the ledger containing this transaction |
| operation_count | NUMBER(38,0) | The number of operations in this transaction |
| _extra_fields | VARIANT | Additional fields not explicitly defined |
| transaction_events | VARIANT | List of Soroban transaction-scoped events emitted during transaction execution, as JSON. These are events not tied to a specific operation (e.g. fee events, transaction-level state changes). |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when this record was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when this record was last updated |