Skip to main content
The stablecoin transfers table contains all on-chain transfers of stablecoins found in the stablecoin list. This table allows users to aggregate stablecoin activity across multiple chains while also fetching granular transfer details. 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

https://app.allium.so/s/JwoAc4wM

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

​
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 NameDescriptionExample
chainBlockchain of the transfer.ethereum
token_typeToken Standard. (E.g. erc20, trc20, spl)erc20
from_addressAddress where the token is being transferred from. Sender address (not token account) for Solana.0x8ebad4aa179cb14c8939ef8d3785859a7cf45673
to_addressAddress where the token is being transferred to. Recipient address (not token account) for Solana.0x61da7961439f671ddc02b18ce0575cc585c3dcd9
token_addressToken address of the asset transferred. Token mint for Solana.0xdac17f958d2ee523a2206206994597c13d831ec7
token_nameName of the asset transferred.Tether USD
token_symbolSymbol of the asset transferred.USDT
raw_amountAmount of tokens moved (unnormalized).1993200000
amountAmount of token moved, normalized.1993.2
usd_amountUSD value of the amount of tokens transferred.1995.1932
transaction_from_addressThe address of the sending party of this transaction. Signer address for Solana.0x8ebad4aa179cb14c8939ef8d3785859a7cf45673
transaction_to_addressThe address of the receiving party of this transaction (could be a contract address). Null for Solana0x4f391c202a906eed9e2b63fdd387f28e952782e2
transaction_hashTransaction hash that this transfer belongs to.0xeb63929f60bf8a6013fcdbe6af3a6687652ecbebb53f08da08f91f24d9980e19
block_timestampThe time when the block that contains this transaction was included on the blockchain.2020-05-04 04:34:53
block_numberThe block number that the corresponding transaction of this transfer belongs to. Block Height for Solana.9997570
block_hashThe block hash that the corresponding transaction of this transfer belongs to.0x31ba5abf842755faebb7dbdd2f7a6d3d017351807b735c8eb19f4002ff9c2a5c
unique_idUnique id generated for each transfer.txn-0xeb63929f60bf8a6013fcdbe6af3a6687652ecbebb53f08da08f91f24d9980e19_log_index-89
currencyThe ISO currency code (e.g. usd, eur, jpy, xau (gold)) of the stablecoin in lowercasing.usd
base_assetThe base assets in symbol in lowercasing. (i.e. usdt, usdc, tusd, dai, etc).usdt
is_bridgeWhen 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.