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

# Token Transfers

### Table Details

| Property            | Value                                                                       |
| ------------------- | --------------------------------------------------------------------------- |
| Table Name          | `stellar.raw.token_transfers`                                               |
| Table Status        | Production-Ready                                                            |
| 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 token-transfer event (e.g. transfer, mint, burn, clawback).                  |
| event\_stage            | VARCHAR(16777216) | Stage at which the event was emitted (e.g. during\_tx, after\_tx).                   |
| event\_index            | NUMBER(38,0)      | Index of this event within its transaction.                                          |
| from\_address           | VARCHAR(16777216) | Address whose balance decreased in this transfer.                                    |
| from\_muxed\_id         | VARCHAR(16777216) | 64-bit sub-account id of the sender's multiplexed account, if used.                  |
| to\_address             | VARCHAR(16777216) | Address whose balance increased in this transfer.                                    |
| to\_muxed\_id           | VARCHAR(16777216) | 64-bit sub-account id of the recipient's multiplexed account, if used.               |
| contract\_id            | VARCHAR(16777216) | Soroban contract address of the token, for contract-based assets.                    |
| asset\_id               | VARCHAR(16777216) | Composite `code:issuer` identifier of the asset for non-native assets.               |
| asset\_code             | VARCHAR(16777216) | Asset code for a classic asset.                                                      |
| asset\_issuer           | VARCHAR(16777216) | Issuer G-address for a classic asset.                                                |
| token\_id               | NUMBER(38,0)      | Identifier of the Soroban token for contract-based assets.                           |
| amount\_str             | VARCHAR(16777216) | Transfer amount in the token's smallest unit, stored as a string for full precision. |
| amount                  | NUMBER(38,0)      | Transfer amount in the token's smallest unit (stroops for classic assets).           |
| ledger\_sequence        | NUMBER(38,0)      | Sequence number of the ledger containing this transfer.                              |
| ledger\_close\_time     | TIMESTAMP\_NTZ(9) | Time when the ledger containing this transfer closed and was finalized.              |
| ledger\_hash            | VARCHAR(16777216) | Hash of the ledger containing this transfer.                                         |
| transaction\_hash       | VARCHAR(16777216) | Hash of the transaction that produced this transfer.                                 |
| transaction\_index      | NUMBER(38,0)      | Position of the transaction within its ledger.                                       |
| transaction\_result     | VARCHAR(16777216) | Result code of the transaction that produced this transfer.                          |
| transaction\_successful | BOOLEAN           | True if the transaction that produced this transfer executed successfully.           |
| operation\_index        | NUMBER(38,0)      | Index of the operation within the transaction that produced this transfer.           |
| unique\_id              | VARCHAR(16777216) | Deterministic unique identifier for this 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.                        |
