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.token_transfers |
| Table Status | Beta 🌱 |
| Unique Key | ledger_close_time, unique_id |
| Clustering Key(s) | to_date("ledger_close_time") |
| Search Optimization | from_address, to_address, transaction_hash, contract_id, asset_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| event_type | VARCHAR(16777216) | Type of transfer event (transfer, mint, burn, clawback, fee, etc.). |
| event_stage | VARCHAR(16777216) | Stage of the transfer event lifecycle (e.g. pre/post execution). |
| event_index | NUMBER(38,0) | Position of the event within its transaction. |
| from_address | VARCHAR(16777216) | Source address of the transfer (sender). |
| from_muxed_id | VARCHAR(16777216) | Muxed account memo id for the sender, if any. |
| to_address | VARCHAR(16777216) | Destination address of the transfer (recipient). |
| to_muxed_id | VARCHAR(16777216) | Muxed account memo id for the recipient, if any. |
| contract_id | VARCHAR(16777216) | Soroban contract address (C…) for SAC/Soroban token transfers, null for native. |
| asset_id | VARCHAR(16777216) | Unique identifier of the asset (asset code:issuer, or contract id). |
| asset_code | VARCHAR(16777216) | Code of the credit asset, null for native XLM. |
| asset_issuer | VARCHAR(16777216) | Address of the asset’s issuer account, null for native XLM. |
| token_id | NUMBER(38,0) | Contract address (C…) for Soroban tokens, null otherwise. |
| amount_str | VARCHAR(16777216) | Transfer amount as a string (preserves precision). |
| amount | NUMBER(38,0) | Transfer amount as a numeric value (smallest unit of the asset). |
| ledger_sequence | NUMBER(38,0) | Sequence of the ledger containing the transfer. |
| ledger_close_time | TIMESTAMP_NTZ(9) | Time the containing ledger was closed (Unix timestamp). |
| ledger_hash | VARCHAR(16777216) | Hash of the containing ledger. |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced the transfer. |
| transaction_index | NUMBER(38,0) | Position of the transaction within its ledger. |
| transaction_result | VARCHAR(16777216) | Result code of the parent transaction, as JSON. |
| transaction_successful | BOOLEAN | True if the parent transaction succeeded. |
| operation_index | NUMBER(38,0) | Position of the operation that produced the transfer. |
| unique_id | VARCHAR(16777216) | A synthetic primary key for this transfer row. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |