Transfers

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:

Token Transfers

Sample Query

Get the weekly unique addresses of USD stablecoins, showing the distribution of transfer activity across different stablecoins in the last 6 months

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. native, bridged, 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.

Legacy Schema

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 <chain>.stablecoins.transfers instead — identical schema without the chain column.For background on how Allium maps on-chain events to the transfer schema:

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.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Token Transfers

Sample Query

Table Columns

Table Columns

Token Transfers

​Sample Query

​Table Columns

​Table Columns

Sample Query

Table Columns

Table Columns