Registry: Deployments

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 Name	Data Type	Description
product_id	VARCHAR	Allium canonical identifier for the underlying stablecoin product (e.g. usdc, usdt, dai)
product_name	VARCHAR	Canonical product name (e.g. USD Coin)
product_symbol	VARCHAR	Canonical product symbol (e.g. USDC)
issuer_id	VARCHAR	Allium canonical identifier for the issuer (e.g. circle, tether)
is_native	BOOLEAN	True if this is a chain-native issuance by the issuer; false for bridged or DeFi-wrapped variants
is_verified	BOOLEAN	True if this deployment has been manually verified by Allium
stablecoin_type	VARCHAR	Backing model classification
currency	VARCHAR	ISO currency code the stablecoin is pegged to (e.g. usd, eur, jpy, xau)
peg_mechanism	VARCHAR	Mechanism used to maintain the peg (e.g. fiat-backed, crypto-collateralized)
chain	VARCHAR	Blockchain where this token is deployed, in lower case
address	VARCHAR	Contract address of the stablecoin on this chain
decimals	BIGINT	Token decimals used for normalization. May be null for some chains.
symbol	VARCHAR	Token symbol as reported by the contract
name	VARCHAR	Token name as reported by the contract
token_type	VARCHAR	Token standard (e.g. erc20, trc20, spl)
status	VARCHAR	Deployment status (e.g. active, deprecated)
is_active	BOOLEAN	True if this deployment is actively tracked and included in core models
status_reason	VARCHAR	Reason for the current status, if applicable
status_source_reference	VARCHAR	Source reference for the status (e.g. issuer announcement URL)
_created_at	TIMESTAMP_NTZ(9)	Timestamp when this deployment was first added to the registry
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when this deployment was last updated

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