Stablecoins

Our crosschain.stablecoin schemas allow users to investigate onchain stablecoin activity across multiple blockchains.

The stablecoin vertical supports currencies aside from usd (e.g. cny, jpy, try, eur, cad, etc.)

​

Chain Coverage

We are currently working on expanding stablecoin coverage for more chains and add on a case by case basis. Please reach out to us if you have any questions or would like to request coverage for a specific chain.

​

Stablecoins List

The stablecoin list includes a list of curated stablecoins with various denominations. This list is used to identify the list of stablecoins to be included in the crosschain.stablecoin.transfers table.

Unique Key: chain, address

​

Stablecoin Transfers

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:

​

Sample Query

Overview of transfer volume of usd stablecoins on blockchains indexed by Allium 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 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.

For non-EVM compatible chains such as Solana, the underlying columns mapping for certain columns are annotated accordingly.

​

Stablecoin Metrics

The crosschain.metrics.stablecoin_volume table aggregates stablecoin activity from crosschain.stablecoin.transfers by day, chain and token address.

It includes adjusted activity metrics using the following methodologies:

• Single Direction Max Transfer - only the largest stablecoin amount transferred within a single transaction is counted

• Single Direction Net Transfer - the largest net stablecoin amount transferred per token, to a single address, for each transaction, is counted

• Entity Adjusted, Single Direction Max Transfer - in addition, to applying the Single Direction Max Transfer logic, this methodology also uses labels & heuristics to remove bot related activity (e.g. if an address does more than 1,000 transactions and $10m in transfer volume in a rolling 30-day window), or intra-exchange volume (i.e. when transfers are made between two CEX/DEX addresses)

​

Table Columns

Unique Key: chain, activity_date, token_address

​

Sample Queries

1) Get the monthly stablecoin transfer metrics for all USD currencies in the last 24 months, excluding anomalies and using the Entity Adjusted, Single Direction Max Transfer methodology

select 
    date_trunc('month', activity_date) as month,
    sum(entity_adjusted_single_direction_max_transfer_tx_count) as num_transactions,
    sum(entity_adjusted_single_direction_max_transfer_volume_usd/pow(10,9)) as usd_volume_billions
from crosschain.metrics.stablecoin_volume
where 1=1
    and currency = 'usd' -- limit to USD currencies
    and transfer_volume_is_anomaly = false -- exclude high volume days, where total raw volume is >1e18
    and activity_date >= current_date - interval '24 months'
    and activity_date < date_trunc('month', current_date) -- exclude incomplete months
group by all
order by 1 desc