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

# Transfers

> Every on-chain stablecoin transfer across supported issuers, enriched with token metadata and USD value.

The Stablecoins Transfers table is the unified record of every on-chain stablecoin movement — every USDC, USDT, DAI, PYUSD, FDUSD, etc. transfer in one schema. Each row captures sender, receiver, raw and normalized amounts, USD value at the time of transfer, and the transaction context. Rows are surfaced raw — applying a heuristic on top (e.g. filtering programmatic bot, arbitrage, and market-making activity) is what turns this into "adjusted" settlement volume.

### Table Columns

Unique Key: `block_timestamp::date`, `unique_id`

| Column Name                | Data Type         | Description                                                                                           |
| -------------------------- | ----------------- | ----------------------------------------------------------------------------------------------------- |
| product\_id                | VARCHAR           | Allium stablecoin product identifier (e.g. usdc, usdt)                                                |
| is\_native                 | BOOLEAN           | Whether the transfer was of a chain-native stablecoin issuance (vs. a bridged/wrapped representation) |
| stablecoin\_type           | VARCHAR           | Backing model of the stablecoin (e.g. fiat-backed, crypto-collateralized, algorithmic)                |
| currency                   | VARCHAR           | The reference currency the stablecoin is pegged to (e.g. USD, EUR)                                    |
| from\_address              | VARCHAR           | Sender of the stablecoin transfer                                                                     |
| to\_address                | VARCHAR           | Recipient of the stablecoin transfer                                                                  |
| token\_address             | VARCHAR           | Contract address of the stablecoin token                                                              |
| token\_name                | VARCHAR           | Name of the stablecoin                                                                                |
| token\_symbol              | VARCHAR           | Symbol of the stablecoin                                                                              |
| raw\_amount\_str           | VARCHAR           | Transfer amount, unnormalized, as string to retain precision                                          |
| raw\_amount                | FLOAT             | Transfer amount, unnormalized                                                                         |
| amount\_str                | VARCHAR           | Transfer amount, normalized, as string to retain precision                                            |
| amount                     | FLOAT             | Transfer amount, normalized by token decimals                                                         |
| usd\_amount                | FLOAT             | Transfer amount valued in USD at the time of transfer                                                 |
| usd\_exchange\_rate        | FLOAT             | Exchange rate used for USD conversion                                                                 |
| transaction\_from\_address | VARCHAR           | The address that initiated the transaction containing the transfer                                    |
| transaction\_to\_address   | VARCHAR           | The transaction's `to` address (often a router or contract)                                           |
| transaction\_hash          | VARCHAR           | Hash of the transaction containing the transfer                                                       |
| transaction\_index         | INTEGER           | Index of the transaction within the block                                                             |
| log\_index                 | INTEGER           | Log index of the transfer event within the transaction                                                |
| block\_timestamp           | TIMESTAMP\_NTZ(9) | Block timestamp of the transfer                                                                       |
| block\_number              | INTEGER           | Block number of the transfer                                                                          |
| block\_hash                | VARCHAR           | Block hash containing the transfer                                                                    |
| unique\_id                 | VARCHAR           | Unique identifier for the transfer event                                                              |
| \_metadata\_updated\_at    | TIMESTAMP\_NTZ(9) | Timestamp when token metadata (name, symbol, etc.) was last updated                                   |