Transfers

stablecoins.core.transfers is the unified record of every on-chain stablecoin movement across all chains Allium supports. Each row captures sender, receiver, raw and normalized amounts, USD value at the time of transfer, and transaction context. This table replaces crosschain.stablecoin.transfers. Key additions in the new schema: product_id (canonical stablecoin identifier), is_native (distinguishes chain-native issuance from bridged representations), stablecoin_type (backing model), and usd_exchange_rate. For single-chain workloads, use <chain>.stablecoins.transfers instead — identical schema without the chain column. For background on how Allium maps on-chain events to the transfer schema:

Token Transfers

Sample Queries

All USDT-family transfers on Ethereum (replaces base_asset = 'usdt') The legacy base_asset column grouped tokens by ticker and is removed. Filter by product_id via the catalog to include native USDT and bridged or DeFi-wrapped variants:

select *
from ethereum.stablecoins.transfers
where product_id in (
    select product_id
    from stablecoins.registry.catalog
    where underlying_product_id = 'usdt'
        or product_id = 'usdt'
)
limit 100

On stablecoins.core.transfers, add a chain filter instead of using the per-chain table. Weekly unique senders and total volume of USD stablecoins across all chains, last 6 months

select
    date_trunc('week', block_timestamp) as week,
    chain,
    token_symbol,
    count(distinct from_address) as unique_senders,
    sum(amount) as transfer_volume
from stablecoins.core.transfers
where block_timestamp > current_timestamp - interval '6 months'
    and currency = 'usd'
group by all
order by 1 desc

Table Columns

Unique Key: block_timestamp::date, unique_id

Column Name	Data Type	Description
chain	VARCHAR	Blockchain of the transfer (e.g. ethereum, solana)
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_hash	VARCHAR	Hash of the transaction containing the transfer
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the transfer
unique_id	VARCHAR	Unique identifier for the transfer event
_created_at	TIMESTAMP_NTZ(9)	Timestamp when the row was first created
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when the row was last updated
_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

Token Transfers

Sample Queries

Table Columns

Token Transfers

​Sample Queries

​Table Columns

Sample Queries

Table Columns