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

# Stablecoin Transfers

### Table Details

| Property | Value |
| - | - |
| Table Name | `starknet.assets.stablecoin_transfers` |
| Table Status | Production-Ready |
| Unique Key | `block_timestamp`, `unique_id` |
| Clustering Key(s) | `block_timestamp::date, token_address` |
| Search Optimization | `from_address`, `to_address`, `transaction_hash`, `token_address` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| currency | VARCHAR(16777216) | Fiat currency this stablecoin is pegged to, as an ISO 4217 code in lowercase (e.g. `usd`, `eur`). |
| base\_asset | VARCHAR(16777216) | Canonical name of the stablecoin (e.g. `USDC`, `USDT`, `DAI`). |
| is\_bridge | BOOLEAN | True if this token is a bridged representation. False if it is the canonical deployment by the issuer. |
| from\_address | VARCHAR(66) | Address that sent the stablecoin. The account whose balance decreased. |
| to\_address | VARCHAR(66) | Address that received the stablecoin. The account whose balance increased. |
| token\_address | VARCHAR(66) | Contract address of the stablecoin token. |
| token\_name | VARCHAR(16777216) | Full name of the token (e.g. "USD Coin"). |
| token\_symbol | VARCHAR(16777216) | Ticker symbol of the token (e.g. "USDC"). |
| raw\_amount\_str | VARCHAR(16777216) | Token amount in the smallest unit as a string, to preserve full precision. |
| raw\_amount | FLOAT | Token amount in the smallest indivisible unit (not decimal-adjusted). |
| amount\_str | VARCHAR(16777216) | Normalized token amount stored as a string to preserve full precision. |
| amount | FLOAT | Token amount normalized by the token's decimal precision. |
| usd\_amount | FLOAT | USD value of the token amount at the time of the event. |
| usd\_exchange\_rate | FLOAT | Exchange rate used for USD conversion. |
| sender\_address | VARCHAR(66) | Address that initiated the bridge transfer on the source chain. |
| transaction\_hash | VARCHAR(66) | Hash of the transaction that produced this record. |
| transaction\_index | NUMBER(38,0) | Zero-based position of the transaction within its block. |
| event\_index | NUMBER(38,0) | Zero-based index of this event within its transaction. The specific semantics depend on the chain — on Aptos this is the `event_index` within the transaction; on Cosmos this is within the message. |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block\_number | NUMBER(38,0) | Sequential number of the block that contains this record. |
| block\_hash | VARCHAR(66) | Cryptographic hash of the block header that contains this record. |
| unique\_id | VARCHAR(16777216) | Allium's deterministic unique identifier for this row. Generated from the fields that uniquely identify the record. Stable across full refreshes. |
| \_tokens\_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the token metadata was last updated. |
| \_metadata\_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp when token metadata (name, symbol, etc.) was last updated. |
| \_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. |
| \_changed\_since\_full\_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |

### Related Docs

* [EVM Assets Stablecoin Transfers](/historical-data/supported-blockchains/evm/core-schemas/assets/stablecoin-transfers)