Skip to main content
stablecoins.core.supply_daily contains one row per (chain, token_address, date) with end-of-day supply figures: total supply, circulating supply (excluding bridge-locked, issuer-held, and burned tokens), and adjusted circulating supply (a more conservative figure using additional heuristics). For a detailed explanation of how circulating and non-circulating supply are defined, see the Supply Distribution Methodology.

Sample Query

Daily circulating USDT supply across all chains, last 90 days
select
    date,
    chain,
    token_symbol,
    circulating_supply,
    circulating_supply_usd
from stablecoins.core.supply_daily
where date >= current_date - 90 and product_id = 'usdt'
order by date desc, circulating_supply_usd desc nulls last

Table Columns

Unique Key: date, chain, token_address
Column NameData TypeDescription
is_verifiedBOOLEANWhether this deployment has been manually verified by Allium
is_nativeBOOLEANWhether this is a chain-native issuance (vs. bridged/wrapped)
stablecoin_typeVARCHARBacking model classification
product_idVARCHARAllium stablecoin product identifier (e.g. usdc, usdt)
issuer_idVARCHARAllium canonical identifier for the issuer
currencyVARCHARISO currency code the stablecoin is pegged to (e.g. usd, eur)
peg_mechanismVARCHARMechanism used to maintain the peg
dateTIMESTAMP_NTZ(9)The UTC date of this daily supply snapshot
chainVARCHARBlockchain of the supply measurement
token_addressVARCHARContract address of the stablecoin token
token_nameVARCHARName of the stablecoin
token_symbolVARCHARSymbol of the stablecoin
total_supplyFLOATTotal on-chain supply as reported by the token contract
total_supply_usdFLOATTotal supply in USD terms (null if > $500B to suppress anomalous values)
circulating_supplyFLOATTotal supply minus bridge-locked, pre-minted, collateral-locked, and burned supply
circulating_supply_usdFLOATCirculating supply in USD terms (null if > $500B)
adjusted_circulating_supplyFLOATMore conservative circulating supply estimate using additional heuristics
adjusted_circulating_supply_usdFLOATAdjusted circulating supply in USD terms (null if > $500B)
price_usdFLOATUSD price of the token used for supply valuations
_metadataOBJECTMetadata object with price_source, supply_source, and integration_status fields
unique_idVARCHARUnique identifier for the (date, chain, token) row
_created_atTIMESTAMP_NTZ(9)Timestamp when the row was first created
_updated_atTIMESTAMP_NTZ(9)Timestamp when the row was last updated