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