> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Registry: Catalog

> Product-level stablecoin catalog — one row per stablecoin product with peg, type, and issuer metadata.

`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`](/historical-data/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:

```sql theme={null}
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:

```sql theme={null}
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                                                 |

<Tabs>
  <Tab title="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'`.
  </Tab>
</Tabs>