Skip to main content
stablecoins.registry.deployments is the per-chain reference table for all stablecoin token addresses tracked by Allium. Each row maps a (chain, address) pair to its canonical product_id and captures deployment-level metadata: decimals, native/bridged status, and active/inactive status. Use this table to enumerate all stablecoins on a given chain, or to resolve a contract address to its canonical product. Join to stablecoins.registry.catalog on product_id for product-level metadata. This table replaces crosschain.stablecoin.list. Note the column rename: address (not token_address).

​
Sample Query

All active, native USD stablecoin deployments on Ethereum 
select
    address,
    product_id,
    name,
    symbol
from stablecoins.registry.deployments
where chain = 'ethereum'
    and currency = 'usd'
    and is_native = true
    and is_active = true
order by product_id

​
Table Columns

Unique Key: chain, address
Column NameData TypeDescription
product_idVARCHARAllium canonical identifier for the underlying stablecoin product (e.g. usdc, usdt, dai)
product_nameVARCHARCanonical product name (e.g. USD Coin)
product_symbolVARCHARCanonical product symbol (e.g. USDC)
issuer_idVARCHARAllium canonical identifier for the issuer (e.g. circle, tether)
is_nativeBOOLEANTrue if this is a chain-native issuance by the issuer; false for bridged or DeFi-wrapped variants
is_verifiedBOOLEANTrue if this deployment has been manually verified by Allium
stablecoin_typeVARCHARBacking model classification
currencyVARCHARISO currency code the stablecoin is pegged to (e.g. usd, eur, jpy, xau)
peg_mechanismVARCHARMechanism used to maintain the peg (e.g. fiat-backed, crypto-collateralized)
chainVARCHARBlockchain where this token is deployed, in lower case
addressVARCHARContract address of the stablecoin on this chain
decimalsBIGINTToken decimals used for normalization. May be null for some chains.
symbolVARCHARToken symbol as reported by the contract
nameVARCHARToken name as reported by the contract
token_typeVARCHARToken standard (e.g. erc20, trc20, spl)
statusVARCHARDeployment status (e.g. active, deprecated)
is_activeBOOLEANTrue if this deployment is actively tracked and included in core models
status_reasonVARCHARReason for the current status, if applicable
status_source_referenceVARCHARSource reference for the status (e.g. issuer announcement URL)
_created_atTIMESTAMP_NTZ(9)Timestamp when this deployment was first added to the registry
_updated_atTIMESTAMP_NTZ(9)Timestamp when this deployment was last updated