Stablecoin Transfers

The assets.stablecoin_transfers table records every on-chain movement of a token in assets.stablecoin_list. Each row captures sender, receiver, raw and normalized amounts, USD value at the time of transfer, and the transaction context. Prefer the stablecoins.transfers model for the current stablecoins schema. This table is the assets-schema counterpart for the same events.

Table Columns

Column Name	Data Type	Description
from_address	VARCHAR	Address that sent the stablecoin. The account whose balance decreased.
to_address	VARCHAR	Address that received the stablecoin. The account whose balance increased.
token_address	VARCHAR	Contract address of the stablecoin token.
token_name	VARCHAR	Full name of the token (e.g. “USD Coin”).
token_symbol	VARCHAR	Ticker symbol of the token (e.g. “USDC”).
raw_amount_str	VARCHAR	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	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.
transaction_from_address	VARCHAR	Address of the account that signed and submitted the transaction. May differ from `from_address` when a contract routes tokens on a user’s behalf.
transaction_to_address	VARCHAR	Address the transaction was sent to (the top-level `to` field). May be a router or contract rather than the token recipient.
transaction_hash	VARCHAR	Hash of the transaction that produced this record.
transaction_index	INTEGER	Zero-based position of the transaction within its block.
log_index	INTEGER	Zero-based position of this event log within its transaction.
block_timestamp	TIMESTAMP_NTZ(9)	Timestamp (UTC) of the block that contains this record.
block_number	INTEGER	Sequential number of the block that contains this record.
block_hash	VARCHAR	Cryptographic hash of the block header that contains this record.
unique_id	VARCHAR	Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record. Stable across full refreshes.
currency	VARCHAR	Fiat currency this stablecoin is pegged to, as an ISO 4217 code in lowercase (e.g. `usd`, `eur`).
base_asset	VARCHAR	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.
_metadata_updated_at	TIMESTAMP_NTZ(9)	Timestamp when token metadata (name, symbol, etc.) was last updated.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns