Skip to main content
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

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

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
Column NameDescription
chainThe name of the blockchain
token_addressThe address of the stablecoin
token_symbolThe token symbol of the stablecoin
currencyThe ISO currency code (e.g. usd, eur, jpy, xau (gold)) of the stablecoin in lowercasing
base_assetThe base assets in symbol in lowercasing. (i.e. usdt, usdc, tusd, dai, etc)
activity_dateThe date for which metrics are being calculated. Only includes completed days.
transfer_tx_countThe total number of transactions with stablecoin transfers.
transfer_countThe total number of stablecoin transfers.
avg_transfer_countThe average number of stablecoin transfers
transfer_volumeThe total volume of stablecoin transfers (normalized)
transfer_volume_usdThe total volume of stablecoin transfers in USD terms
avg_transfer_volumeThe average volume of stablecoin transfers (normalized)
avg_transfer_volume_usdThe average volume of stablecoin transfers in USD terms
transfer_volume_is_anomalyA boolean flag that’s set to true where the transfer_volume is excessively high for a given day, i.e. >1e18