Registry

The identity tables behind every stablecoin figure. Every fact and metric joins to one of them, and Coverage introduces each grain.

Tables

Stablecoins
Deployments

One row per stablecoin: dimensions.assets filtered on asset_type = 'stablecoin'.

Column	Type	Description
`asset_id`	`STRING`	Identifier of the asset, for example `usdc`.
`reference_asset_id`	`STRING`	What the asset tracks or wraps. Joins `dimensions.reference_assets`.
`name`	`STRING`	Display name of the asset.
`symbol`	`STRING`	Ticker symbol of the asset.
`asset_type`	`STRING`	What kind of instrument it is: `stablecoin`, `tokenized-stocks`, `tokenized-funds`, `lending-token`, `tokenized-commodities`, `liquid-staking-token`, `tokenized-cryptoasset` or `wrapped_native`.
`description`	`STRING`	Short description of the asset.
`custom_price_fx_peg`	`STRUCT`	A fixed rate the asset is priced at rather than a market quote, in `currency`, `multiplier` and `priority`. Set only where the asset declares one, and `priority` says whether the rate overrides the market price or only fills in where there is none.
`created_at`	`TIMESTAMP`	When the asset entered the registry.
`metrics_verified_at`	`TIMESTAMP`	When the asset’s published metrics were last verified. Null while unverified.
`mica_marker`	`STRING`	Which MiCA category the peg implies: `emt_by_peg` for single-currency stablecoins, `art_by_peg` for other stablecoins, `other_crypto_asset` or `out_of_scope_financial_instrument` for everything else. A marker, not a regulatory ruling.
`mica_authorization_status`	`STRING`	Whether the token is authorized under MiCA according to the official register: `emt_authorized`, `art_authorized`, `not_authorized`, `application_withdrawn`, `out_of_scope_mifid`, `other_crypto_asset` or `not_checked`. A sourced regulatory fact, unlike `mica_marker`, which is read off the peg.
`regulatory_supervised`	`STRING`	What the issuer discloses about its own supervision: `true`, `false` or `unknown`. A disclosure, never an inference.
`regulator`	`STRING`	The authority the issuer names as its supervisor, such as `NYDFS/FinCEN`. Empty where the issuer names none.
`reserves_source`	`STRING`	Where the reserve figure comes from: `attestation` for an issuer-published report, `onchain` where the backing addresses are identified and the balance computed here, `none` where the issuer publishes nothing.
`reserves_attestor`	`STRING`	The firm signing the attestation, filled in where `reserves_source` is `attestation`.
`return_treatment`	`STRING`	How the token treats the income the underlying pays: `total_return`, `price_return`, `price_return_with_distribution` or `not_applicable`. Keyed on the token rather than on what it tracks, so two tokenizations of one share can differ.
`issuer_legal_name`	`STRING`	The issuing entity as a government register spells it, which is routinely not the brand.
`issuer_domicile`	`STRING`	ISO 3166-1 alpha-2 country code of where the issuing entity is registered, such as `US`. Resolved from the issuing project, so it is null when that project has no domicile on file.
`issuer_lei`	`STRING`	Legal Entity Identifier of the issuing entity.
`issuer_cik`	`STRING`	SEC Central Index Key of the issuing entity.
`issuer_regulatory_framework`	`ARRAY<STRING>`	Regimes the issuing entity operates under. An array because an entity can sit under several at once.
`issuer_legal_source_url`	`STRING`	The filing or register the legal fields above were read from, with `issuer_legal_retrieved_at` recording when.
`issuer_legal_retrieved_at`	`STRING`	When `issuer_legal_source_url` was last read.
`use_of_income`	`STRING`	What the issuer says it does with the income the underlying pays, in its own words. `return_treatment` is the coded answer to the same question.
`isin`	`STRING`	International Securities Identification Number of the instrument, where it has one.
`cusip`	`STRING`	CUSIP of the instrument, where it has one.
`peg_currency`	`STRING`	ISO currency code of the peg, set when the asset tracks a national currency. Empty otherwise: a fund strategy, a share or a commodity is not a peg.
`project_relations`	`ARRAY<STRUCT>`	Every project linked to the asset, one element per `(project_id, product_id, relation)`. `relation` is `issuer`, `asset_manager`, `risk_curator` or `manager`. Most assets link to one project; a few link to several, such as an issuer alongside a separate manager.
`issuer_project_id`	`STRING`	The project whose relation is `issuer`, when exactly one project holds that relation. Empty when none do, and empty when more than one does; read `project_relations` for the full set.
`coingecko_id`	`STRING`	Identifier of the same asset in the CoinGecko catalogue, for joining our record to a public one.
`coinmarketcap_id`	`STRING`	Identifier of the same asset in the CoinMarketCap catalogue, for the same purpose.
`yahoo_ticker`	`STRING`	Ticker the underlying trades under on Yahoo Finance, where it is listed.

One row per token contract on one chain, in dimensions.asset_tokens. bridged_status is the classification the supply measures split on.

Column	Type	Description
`asset_token_id`	`STRING`	Identifier of the deployment, formatted `{asset_id}-{token_address}-{chain_id}`.
`asset_id`	`STRING`	Asset the deployment belongs to. Joins `dimensions.assets`.
`token_id`	`STRING`	Key of the deployment in `dimensions.tokens`, formatted `{token_address}-{chain_id}`.
`chain_id`	`STRING`	Chain the contract is deployed on.
`token_address`	`STRING`	Address of the token contract.
`is_bridged`	`BOOL`	Raw registry flag: bridged in rather than issued natively. Always present, so `false` means native or unstated. Filter on `bridged_status` instead.
`bridged_status`	`STRING`	The classification supply measures split on: `native`, `bridged` or `unclassified`.

Sample queries

By peg currency
MiCA candidates
Who issues what
Pegs against deployments
Deployments of one stablecoin

peg_currency holds the ISO code of the national currency the asset tracks, and off_peg on Metrics measures against that currency’s end-of-day rate.

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

mica_marker follows from the peg alone: art_by_peg marks a stablecoin that references something other than a single currency, and emt_by_peg a single-currency one.

select
    asset_id,
    symbol,
    peg_currency,
    reference_asset_id,
    mica_marker
from `dimensions.assets`
where asset_type = 'stablecoin'
  and mica_marker = 'art_by_peg'
order by asset_id

issuer_project_id is the project holding the issuer relation, and it is the row subject of the matrix on Coverage.

select
    assets.issuer_project_id,
    projects.name,
    count(*) as stablecoins
from `dimensions.assets` as assets
join `dimensions.projects` as projects
    on projects.project_id = assets.issuer_project_id
where assets.asset_type = 'stablecoin'
group by assets.issuer_project_id, projects.name
order by stablecoins desc
limit 25

Counting native and bridged deployments apart shows where wrappers concentrate, and so where a careless supply total double counts.

select
    assets.peg_currency,
    assets.mica_marker,
    count(distinct assets.asset_id) as stablecoins,
    countif(deployments.bridged_status = 'native') as native_deployments,
    countif(deployments.bridged_status = 'bridged') as bridged_deployments,
    count(distinct deployments.chain_id) as chains
from `dimensions.assets` as assets
left join `dimensions.asset_tokens` as deployments
    using (asset_id)
where assets.asset_type = 'stablecoin'
group by assets.peg_currency, assets.mica_marker
order by stablecoins desc

bridged_status reads native, bridged or unclassified, and it is the column issuance filters 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

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries