Metrics (Volume)

The stablecoins.metrics.volume_daily table aggregates stablecoin activity from stablecoins.core.transfers by day, chain and token address, joined to registry metadata so you get product/issuer fields without an extra join. It includes an adjusted volume methodology (organic-activity filtering) alongside raw volume metrics. Adjusted columns are only populated for chains where the organic-activity classification pipeline runs — check has_adjusted_volume before relying on them.

For more on how Allium calculates adjusted volume and filters out non-organic activity (CEX, DeFi, and infrastructure transfers), see the Payments Pipeline overview.

Unique Key: chain, activity_date, token_address

Sample Query

Get the monthly stablecoin transfer metrics for USD currencies in the last 24 months, using adjusted volume where available

select
    date_trunc('month', activity_date) as month,
    sum(adjusted_transfer_tx_count) as num_transactions,
    sum(adjusted_volume_usd / pow(10,9)) as usd_volume_billions
from stablecoins.metrics.volume_daily
where 1=1
    and currency = 'usd' -- limit to USD currencies
    and has_adjusted_volume = true -- only chains with adjusted-volume coverage
    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

Table Columns

Metrics

Column Name	Description
activity_date	The date for which metrics are being calculated. Only includes completed days.
chain	The name of the blockchain.
token_address	The address of the stablecoin.
peg_mechanism	Mechanism used to maintain the stablecoin’s peg.
token_symbol	The token symbol of the stablecoin.
token_name	The name of the stablecoin.
product_id	Internal Allium identifier for the stablecoin product. Join key to `stablecoins.registry.catalog`.
issuer_id	Entity that issues or backs the stablecoin.
is_native	True if this is the issuer’s canonical deployment on this chain.
stablecoin_type	Classification of the stablecoin mechanism.
currency	The ISO currency code (e.g. usd, eur, jpy, xau (gold)) of the stablecoin, lowercased.
has_adjusted_volume	True when this chain has adjusted-volume coverage (organic activity classification pipeline). Adjusted columns are populated only when true; otherwise they are null.
transfer_tx_count	Number of distinct transactions containing at least one stablecoin transfer.
transfer_count	Total number of stablecoin transfer events.
transfer_volume	Total volume of stablecoin transfers (normalized).
transfer_volume_usd	Total volume of stablecoin transfers in USD terms.
max_transfer_volume	Largest single transfer amount within the day (normalized).
max_transfer_volume_usd	Largest single transfer amount within the day in USD terms.
sender_count	Number of distinct sender addresses.
recipient_count	Number of distinct recipient addresses.
adjusted_volume_usd	USD volume where the underlying transfer’s organic activity classification is Real-World Payment, Investment/Trade, or Store as Value. Null when `has_adjusted_volume` is false.
adjusted_transfer_count	Transfer count for the adjusted (classified-intent) volume set. Null when `has_adjusted_volume` is false.
adjusted_transfer_tx_count	Distinct transaction count for the adjusted volume set. Null when `has_adjusted_volume` is false.
_created_at	Timestamp this row was first created.
_updated_at	Timestamp this row was last updated.

Legacy Schema

crosschain.metrics.stablecoin_volume is deprecated in favor of stablecoins.metrics.volume_daily above, which adds registry metadata (issuer, peg mechanism) and a wider set of adjusted-volume columns. It remains queryable, but new work should use the current schema.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)

Sample Query

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

Table Columns

Unique Key: chain, activity_date, token_address

Raw Metrics
Adjusted Metrics

Column Name	Description
chain	The name of the blockchain
token_address	The address of the stablecoin
token_symbol	The token symbol of the stablecoin
currency	The ISO currency code (e.g. usd, eur, jpy, xau (gold)) of the stablecoin in lowercasing
base_asset	The base assets in symbol in lowercasing. (i.e. usdt, usdc, tusd, dai, etc)
activity_date	The date for which metrics are being calculated. Only includes completed days.
transfer_tx_count	The total number of transactions with stablecoin transfers.
transfer_count	The total number of stablecoin transfers.
avg_transfer_count	The average number of stablecoin transfers
transfer_volume	The total volume of stablecoin transfers (normalized)
transfer_volume_usd	The total volume of stablecoin transfers in USD terms
avg_transfer_volume	The average volume of stablecoin transfers (normalized)
avg_transfer_volume_usd	The average volume of stablecoin transfers in USD terms
transfer_volume_is_anomaly	A boolean flag that’s set to true where the transfer_volume is excessively high for a given day, i.e. >1e18

Methodology	Column Name	Description
Single Direction Max Transfer	single_direction_max_transfer_volume	The adjusted total volume of stablecoin transfers (normalized), using the given methodology
Single Direction Max Transfer	single_direction_max_transfer_volume_usd	The adjusted total volume of stablecoin transfers in USD terms, using the given methodology
Single Direction Net Transfer	single_direction_net_transfer_volume	The adjusted total volume of stablecoin transfers (normalized), using the given methodology
Single Direction Net Transfer	single_direction_net_transfer_volume_usd	The adjusted total volume of stablecoin transfers in USD terms, using the given methodology
Entity Adjusted, Single Direction Max Transfer	entity_adjusted_single_direction_max_transfer_tx_count	The adjusted total amount of transactions with stablecoin transfers, using the given methodology
Entity Adjusted, Single Direction Max Transfer	entity_adjusted_single_direction_max_transfer_volume	The adjusted total volume of stablecoin transfers (normalized), using the given methodology
Entity Adjusted, Single Direction Max Transfer	entity_adjusted_single_direction_max_transfer_volume_usd	The adjusted total volume of stablecoin transfers in USD terms, using the given methodology

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Sample Query

Table Columns

Sample Query

Table Columns

​Sample Query

​Table Columns

​Sample Query

​Table Columns

Sample Query

Table Columns

Sample Query

Table Columns