> ## 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
> Raw stablecoin transfers across all supported chains, and the legacy crosschain.stablecoin.transfers table it replaces.
`stablecoins.core.transfers` contains raw, unfiltered stablecoin transfers across all supported chains, joined to registry metadata (`product_id`, `is_native`, `stablecoin_type`) so you don't need a separate join to `stablecoins.registry.deployments` for basic product identification.
*A short primer on Allium's transfer schema and how it maps to the on-chain data can be found here:*
### Sample Query
**Get the weekly unique addresses of USD stablecoins, showing the distribution of transfer activity across different stablecoins in the last 6 months**
```sql theme={null}
select
date_trunc('week', block_timestamp) as date,
chain,
token_symbol,
count(distinct from_address) as senders,
sum(amount) as daily_volume
from stablecoins.core.transfers
where 1=1
and block_timestamp > current_timestamp - interval '2 months'
and currency = 'usd' -- iso currency code
group by all
```
### Table Columns
| Column Name | Description |
| ----------------------- | -------------------------------------------------------------------------------------------------- |
| chain | Blockchain where the transfer occurred. |
| product\_id | Internal Allium identifier for the stablecoin product. Join key to `stablecoins.registry.catalog`. |
| is\_native | True if this is the issuer's canonical deployment on this chain, false if bridged/wrapped. |
| stablecoin\_type | Classification of the stablecoin mechanism (e.g. fiat\_backed, crypto\_backed, yield\_bearing). |
| currency | The ISO currency code (e.g. usd, eur, jpy, xau (gold)) of the stablecoin, lowercased. |
| from\_address | Address where the token is being transferred from. |
| to\_address | Address where the token is being transferred to. |
| token\_address | Token address of the asset transferred. |
| token\_name | Name of the asset transferred. |
| token\_symbol | Symbol of the asset transferred. |
| raw\_amount\_str | Amount of tokens moved (unnormalized), as a string to preserve full precision. |
| raw\_amount | Amount of tokens moved (unnormalized). |
| amount\_str | Amount of token moved, normalized, as a string to preserve full precision. |
| amount | Amount of token moved, normalized. |
| usd\_amount | USD value of the amount of tokens transferred. |
| usd\_exchange\_rate | USD exchange rate applied to compute `usd_amount`. |
| transaction\_hash | Transaction hash that this transfer belongs to. |
| block\_timestamp | The time when the block that contains this transaction was included on the blockchain. |
| unique\_id | Unique id generated for each transfer. |
| \_created\_at | Timestamp this transfer row was first created. |
| \_updated\_at | Timestamp this transfer row was last updated. |
| \_metadata\_updated\_at | Timestamp the joined registry metadata (product/issuer) for this row was last updated. |
*For non-EVM compatible chains such as Solana, the underlying columns mapping for certain columns are annotated accordingly.*
`crosschain.stablecoin.transfers` is deprecated in favor of `stablecoins.core.transfers` above. It remains queryable, but new work should use the current schema.
The legacy transfers table contains all on-chain transfers of stablecoins found in the (also-deprecated) `crosschain.stablecoin.list`. This table allows users to aggregate stablecoin activity across multiple chains while also fetching granular transfer details.
For single-chain workloads, use `.stablecoins.transfers` instead — identical schema without the `chain` column.
*For background on how Allium maps on-chain events to the transfer schema:*
```sql theme={null}
select
date_trunc('week', block_timestamp) as date,
chain,
token_symbol,
count(distinct from_address) as senders,
sum(amount) as daily_volume
from crosschain.stablecoin.transfers
where 1=1
and block_timestamp > current_timestamp - interval '6 months'
and currency = 'usd' -- iso currency code
group by all
order by 1 desc
```
### Table Columns
Blockchains Supported: ethereum, bsc, optimism, polygon, base, avalanche, solana, arbitrum, scroll, celo, blast, tron, ton^, polygon\_zkevm
^ ton transfers are currently in beta.
| Column Name | Description | Example |
| -------------------------- | -------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------- |
| chain | Blockchain of the transfer. | ethereum |
| token\_type | Token Standard. (E.g. erc20, trc20, spl) | erc20 |
| from\_address | Address where the token is being transferred from. **Sender address (not token account) for Solana.** | 0x8ebad4aa179cb14c8939ef8d3785859a7cf45673 |
| to\_address | Address where the token is being transferred to. **Recipient address (not token account) for Solana.** | 0x61da7961439f671ddc02b18ce0575cc585c3dcd9 |
| token\_address | Token address of the asset transferred. **Token mint for Solana.** | 0xdac17f958d2ee523a2206206994597c13d831ec7 |
| token\_name | Name of the asset transferred. | Tether USD |
| token\_symbol | Symbol of the asset transferred. | USDT |
| raw\_amount | Amount of tokens moved (unnormalized). | 1993200000 |
| amount | Amount of token moved, normalized. | 1993.2 |
| usd\_amount | USD value of the amount of tokens transferred. | 1995.1932 |
| transaction\_from\_address | The address of the sending party of this transaction. **Signer address for Solana.** | 0x8ebad4aa179cb14c8939ef8d3785859a7cf45673 |
| transaction\_to\_address | The address of the receiving party of this transaction (could be a contract address). **Null for Solana** | 0x4f391c202a906eed9e2b63fdd387f28e952782e2 |
| transaction\_hash | Transaction hash that this transfer belongs to. | 0xeb63929f60bf8a6013fcdbe6af3a6687652ecbebb53f08da08f91f24d9980e19 |
| block\_timestamp | The time when the block that contains this transaction was included on the blockchain. | 2020-05-04 04:34:53 |
| block\_number | The block number that the corresponding transaction of this transfer belongs to. **Block Height for Solana.** | 9997570 |
| block\_hash | The block hash that the corresponding transaction of this transfer belongs to. | 0x31ba5abf842755faebb7dbdd2f7a6d3d017351807b735c8eb19f4002ff9c2a5c |
| unique\_id | Unique id generated for each transfer. | txn-0xeb63929f60bf8a6013fcdbe6af3a6687652ecbebb53f08da08f91f24d9980e19\_log\_index-89 |
| currency | The **ISO currency code** (e.g. usd, eur, jpy, xau (gold)) of the stablecoin in **lowercasing**. | usd |
| base\_asset | The base assets in symbol in **lowercasing**. (i.e. usdt, usdc, tusd, dai, etc). | usdt |
| is\_bridge | When **TRUE**, this means that the stablecoin is a bridged entity from Wormhole and/or bridges based on their token names. | FALSE |
*For non-EVM compatible chains such as Solana, the underlying columns mapping for certain columns are annotated accordingly.*