Skip to main content
stablecoins.registry.catalog is the product-level reference table for all stablecoins tracked by Allium. Each row describes a distinct stablecoin product (e.g. USDC, USDT, DAI) regardless of which chains it is deployed on. Use this table to look up a stablecoin’s peg currency, backing type, and issuer. For the list of per-chain contract addresses, see stablecoins.registry.deployments. This table replaces the product-level metadata previously embedded in crosschain.stablecoin.list. It is the source of truth for resolving which product_id values belong to a stablecoin family — use it instead of the deprecated base_asset column.

​
Sample Query

All product IDs that represent USDT (native + bridged/wrapped variants) Replaces where base_asset = 'usdt' on legacy stablecoin tables: 
select product_id, product_symbol, underlying_product_id, is_native
from stablecoins.registry.catalog
where underlying_product_id = 'usdt'
    or product_id = 'usdt'
Use the result set to filter activity tables: 
select *
from ethereum.stablecoins.transfers
where product_id in (
    select product_id
    from stablecoins.registry.catalog
    where underlying_product_id = 'usdt'
        or product_id = 'usdt'
)
limit 100

​
Table Columns

Unique Key: product_id
Column NameData TypeDescription
product_idVARCHARAllium canonical identifier for this stablecoin (e.g. usdc, usdt, dai)
product_nameVARCHARFull name of the stablecoin (e.g. USD Coin)
product_symbolVARCHARPrimary token symbol (e.g. USDC)
issuer_idVARCHARAllium canonical identifier for the issuer (e.g. circle, tether)
issuer_nameVARCHARHuman-readable name of the issuing entity (e.g. Circle, Tether)
currencyVARCHARISO currency code the stablecoin is pegged to (e.g. usd, eur, jpy)
peg_mechanismVARCHARMechanism used to maintain the peg (e.g. fiat-backed, crypto-collateralized, algorithmic)
stablecoin_typeVARCHARBacking model classification
is_nativeBOOLEANWhether the product has a chain-native issuance (vs. purely bridged/wrapped)
underlying_product_idVARCHARFor DeFi variants and bridged tokens, the product_id of the underlying stablecoin they represent
is_tokenized_depositBOOLEANWhether the product is a tokenized bank deposit (vs. a general-purpose stablecoin)
deployment_countINTEGERNumber of active per-chain deployments in stablecoins.registry.deployments
_updated_atTIMESTAMP_NTZ(9)Timestamp when this catalog entry was last updated
Stablecoins are classified by their underlying peg mechanism:
  • Fiat-backed — Issued by a regulated entity holding equivalent fiat reserves (e.g. USDC, USDT). The most common USD stablecoins.
  • Crypto-collateralized — Backed by over-collateralized crypto assets locked in smart contracts (e.g. DAI, crvUSD).
  • Algorithmic — Supply is managed algorithmically to maintain the peg, without direct asset backing.
The underlying_product_id field captures the base product for bridged and DeFi-wrapped variants. For example, Axelar USDC and Aave aUSDC both have underlying_product_id = 'usdc'.