Registry: Catalog

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 Name	Data Type	Description
product_id	VARCHAR	Allium canonical identifier for this stablecoin (e.g. usdc, usdt, dai)
product_name	VARCHAR	Full name of the stablecoin (e.g. USD Coin)
product_symbol	VARCHAR	Primary token symbol (e.g. USDC)
issuer_id	VARCHAR	Allium canonical identifier for the issuer (e.g. circle, tether)
issuer_name	VARCHAR	Human-readable name of the issuing entity (e.g. Circle, Tether)
currency	VARCHAR	ISO currency code the stablecoin is pegged to (e.g. usd, eur, jpy)
peg_mechanism	VARCHAR	Mechanism used to maintain the peg (e.g. fiat-backed, crypto-collateralized, algorithmic)
stablecoin_type	VARCHAR	Backing model classification
is_native	BOOLEAN	Whether the product has a chain-native issuance (vs. purely bridged/wrapped)
underlying_product_id	VARCHAR	For DeFi variants and bridged tokens, the `product_id` of the underlying stablecoin they represent
is_tokenized_deposit	BOOLEAN	Whether the product is a tokenized bank deposit (vs. a general-purpose stablecoin)
deployment_count	INTEGER	Number of active per-chain deployments in `stablecoins.registry.deployments`
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when this catalog entry was last updated

Peg Mechanisms

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'.

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