Registry

The identity tables behind every real-world asset figure. Every metric joins to one of them, and Coverage introduces each grain.

Tables

Assets
Deployments
Reference assets

One row per real-world asset: dimensions.assets filtered on the three tokenized-* asset_type values: stocks, funds and commodities.

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 chain an asset is issued on, in dimensions.asset_tokens. bridged_status says whether the supply was minted there or bridged in.

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`.

One row per thing a real-world asset stands for, in dimensions.reference_assets, classified in type. Some references are broad categories, such as etf and fund_strategy, and an asset pointing at one stands for the category while its own name says which instrument it wraps.

Column	Type	Description
`reference_asset_id`	`STRING`	Identifier of the thing being tracked.
`linked_asset_id`	`STRING`	Its own tokenized asset in `dimensions.assets`, where one exists.
`name`	`STRING`	Display name.
`symbol`	`STRING`	Ticker symbol.
`type`	`STRING`	What kind of thing it is: `stock`, `crypto`, `fiat`, `pendle_pt`, `etf`, `commodity`, `fund_strategy`, `bond` or `other`.
`currency_code`	`STRING`	ISO currency code, filled in only on the `fiat` rows.
`unit`	`STRING`	The physical unit a commodity is quoted in, for example `troy ounce` or `barrel`. Empty on everything else.
`aliases`	`ARRAY<STRING>`	Other names it is known by.
`yahoo_ticker`	`STRING`	Ticker the reference trades under on Yahoo Finance, where it is listed.

Sample queries

asset_type is the column that separates the three tokenized-* types, the real-world assets, from stablecoins and the rest of the asset registry, and it is the filter every query on this page starts from.

select
    asset_type,
    count(*) as assets
from `dimensions.assets`
where asset_type in (
    'tokenized-stocks', 'tokenized-funds',
    'tokenized-commodities'
)
group by asset_type
order by assets desc

reference_asset_id is the join between a wrapper and the thing it tracks, and several issuers can point at the same one. Each token’s name says who issued it.

select
    assets.asset_id,
    assets.name,
    assets.symbol
from `dimensions.assets` as assets
join `dimensions.reference_assets` as reference_assets
    using (reference_asset_id)
where reference_assets.reference_asset_id = 'nvda'
  and assets.asset_type = 'tokenized-stocks'
order by assets.asset_id

A having clause on the token count keeps the result to references more than one issuer has wrapped. type says what kind of thing the reference is, from an equity to a fund strategy.

select
    reference_assets.reference_asset_id,
    reference_assets.name,
    reference_assets.type,
    count(*) as instruments
from `dimensions.assets` as assets
join `dimensions.reference_assets` as reference_assets
    using (reference_asset_id)
where assets.asset_type in (
    'tokenized-stocks', 'tokenized-funds',
    'tokenized-commodities'
)
group by 1, 2, 3
having count(*) > 1
order by instruments desc

issuer_project_id is the project holding the issuer relation, so count(distinct ...) on it counts issuers where count(*) counts tokens. Where a reference asset has more tokens than issuers, one issuer runs two wrappers on the same share.

select
    reference_assets.symbol as reference_asset,
    reference_assets.type,
    count(distinct assets.issuer_project_id) as issuers,
    count(*) as tokens,
    string_agg(distinct assets.issuer_project_id order by assets.issuer_project_id) as issuer_list
from `dimensions.assets` as assets
join `dimensions.reference_assets` as reference_assets
    using (reference_asset_id)
where assets.asset_type = 'tokenized-stocks'
group by reference_asset, reference_assets.type
order by issuers desc
limit 20

return_treatment says what the token does with the income the underlying pays. It is keyed on the token, so the same share tokenized by two issuers reads total_return on one row and price_return_with_distribution on the next.

select
    assets.symbol as wrapper,
    projects.name as issuer,
    assets.return_treatment,
    assets.issuer_domicile
from `dimensions.assets` as assets
join `dimensions.reference_assets` as reference_assets
    using (reference_asset_id)
left join `dimensions.projects` as projects
    on projects.project_id = assets.issuer_project_id
where reference_assets.symbol = 'NVDA'
  and assets.asset_type = 'tokenized-stocks'
order by assets.return_treatment, issuer

Reading treatments as one on every row makes the treatment a property of the issuer, held constant across every share it wraps. string_agg names which one the issuer settled on.

select
    projects.name as issuer,
    count(*) as tokens,
    count(distinct assets.return_treatment) as treatments,
    string_agg(distinct assets.return_treatment order by assets.return_treatment) as treatment
from `dimensions.assets` as assets
join `dimensions.projects` as projects
    on projects.project_id = assets.issuer_project_id
where assets.asset_type = 'tokenized-stocks'
  and assets.return_treatment is not null
group by issuer
order by tokens desc

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries