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

# Registry

> Metadata on every stablecoin: identity, peg currency, MiCA classification and per-chain deployments.

Stablecoin identity lives in two registry tables. Both filter with `asset_type = 'stablecoin'`.

* [`dimensions.assets`](/docs/catalog/assets/registry): one row per stablecoin. USDC is one row.
* [`dimensions.asset_tokens`](/docs/catalog/assets/registry): one row per contract that issues it. USDC is one row per chain it is deployed on.

Every column is documented at [Assets ▸ Registry](/docs/catalog/assets/registry).

## Sample queries

<Tabs>
  <Tab title="By peg currency">
    **Count stablecoins by peg currency.** `peg_currency` carries the ISO code of the fiat currency the asset pegs to.

    ```sql theme={null}
    select
        peg_currency,
        count(*) as assets
    from `dimensions.assets`
    where asset_type = 'stablecoin'
    group by peg_currency
    order by assets desc
    ```
  </Tab>

  <Tab title="MiCA candidates">
    **Find stablecoins referencing something other than a single currency.** `mica_indicator` narrows which assets would have to be assessed under MiCA. It is derived from the peg alone and is not a regulatory determination.

    ```sql theme={null}
    select
        asset_id,
        symbol,
        peg_currency,
        reference_asset_id,
        mica_indicator
    from `dimensions.assets`
    where asset_type = 'stablecoin'
      and mica_indicator = 'asset_referenced_token_candidate'
    order by asset_id
    ```
  </Tab>

  <Tab title="Deployments of one stablecoin">
    **List every deployment of one stablecoin.** `bridged_status` reads `native`, `bridged` or `unclassified`, and it is the column to filter issuance on.

    ```sql theme={null}
    select
        deployments.asset_token_id,
        deployments.chain_id,
        deployments.token_address,
        deployments.bridged_status
    from `dimensions.asset_tokens` as deployments
    join `dimensions.assets` as assets
        using (asset_id)
    where assets.asset_type = 'stablecoin'
      and assets.asset_id = 'usdc'
    order by deployments.chain_id
    ```
  </Tab>
</Tabs>