Registry

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

dimensions.assets: one row per stablecoin. USDC is one row.
dimensions.asset_tokens: one row per contract that issues it. USDC is one row per chain it is deployed on.

Every column is documented at Assets ▸ Registry.

Sample queries

By peg currency
MiCA candidates
Deployments of one stablecoin

Count stablecoins by peg currency. peg_currency carries the ISO code of the fiat currency the asset pegs to.

select
    peg_currency,
    count(*) as assets
from `dimensions.assets`
where asset_type = 'stablecoin'
group by peg_currency
order by assets desc

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.

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

List every deployment of one stablecoin. bridged_status reads native, bridged or unclassified, and it is the column to filter issuance on.

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

Overview

Core entities

Market verticals

Chain verticals

Sample queries

​Sample queries

Sample queries