rwa_multichain.product_reference_data

rwa_multichain.product_reference_data is the product catalog behind tokenized RWAs. Grain: one row per product_id. deployments is an array of (chain, token_address) pairs from the product token registry — empty (never null) when the product has no registered on-chain identity yet. This is the inverse of tokens_reference_data: that table is token grain with product fields attached; this table is product grain with chain deployments nested. Join the two on product_id.

Table schema

Product identity

Column	Type	Description
`product_id`	`VARCHAR`	Stable lowercase product identifier. Unique. Join key to `tokens_reference_data`
`product_name`	`VARCHAR`	Official name as used by the issuer or platform
`issuer_id` / `issuer_name`	`VARCHAR`	Legal issuing entity
`platform_id` / `platform_name`	`VARCHAR`	Tokenization or distribution platform
`deployments`	`ARRAY(ROW("chain" VARCHAR, "token_address" VARCHAR))`	`(chain, token_address)` pairs. Empty array when none are registered

Asset classification

Column	Type	Description
`asset_class`	`VARCHAR`	Product asset class. Same vocabulary as Hyperliquid markets
`asset_type`	`VARCHAR`	Product subtype
`underlying_asset`	`VARCHAR`	What backs the token
`underlying_ticker` / `underlying_exchange`	`VARCHAR`	Independent market ticker and venue
`denomination_currency`	`VARCHAR`	ISO 4217 currency of account, not the investment currency

Mechanics and legal structure

Column	Type	Description
`transfer_restriction`	`VARCHAR`	`NONE`, `ALLOWLIST`, `PLATFORM_INTERNAL`, `NON_TRANSFERABLE`
`acquisition_access`	`VARCHAR`	`PERMISSIONLESS`, `KYC_ONBOARDING`, `PLATFORM_ACCOUNT_ONLY`
`transfer_model`	`VARCHAR`	Free-text detail behind the two columns above
`product_status`	`VARCHAR`	Lifecycle state
`issuance_date`	`VARCHAR`	Product issuance date where known
`jurisdiction_country` / `jurisdiction_iso2`	`VARCHAR`	Domicile of the issuing legal entity
`legal_wrapper_type`	`VARCHAR`	Legal form through which holders obtain exposure
`asset_manager_entity`	`VARCHAR`	Portfolio manager when distinct from the issuer
`custodian_entity`	`VARCHAR`	Institution holding the underlying
`transfer_agent_entity`	`VARCHAR`	Appointed transfer agent for this product
`regulatory_framework` / `regulator`	`VARCHAR`	Offering regime and supervising authority
`issuer_entity` / `issuer_lei` / `issuer_cik`	`VARCHAR`	Exact legal registrant and identifiers
`eligible_investors`	`VARCHAR`	Investor class permitted to hold the product
`redemption_mechanism`	`VARCHAR`	`INSTANT_ONCHAIN`, `T_PLUS_N_OFFCHAIN`, `SECONDARY_MARKET_ONLY`
`last_updated`	`DATE`	Date another cell on this row last changed

Blank versus NOT_APPLICABLE

Blank means the value is unknown or not yet verified.
NOT_APPLICABLE means the field has been shown not to apply — a basket product has no single underlying_ticker, a non-SEC issuer has no issuer_cik.

No other placeholder appears. WHERE custodian_entity <> '' gives products with a known custodian; WHERE custodian_entity = 'NOT_APPLICABLE' gives products that genuinely have none.

asset_class values

Shared with rwa_hyperliquid.markets:

Value	Meaning
`credit`	Credit-sector debt: corporates, agencies, securitizations, private lending
`fixed_income`	Sovereign debt whose stated maturity exceeds one year
`cash_equivalent`	Debt maturing in one year or less — T-bills and money-market instruments
`equities`	Public or private company shares, or equity funds
`multi_asset`	Allocation spanning more than one asset class
`commodities`	Physical or commodity-linked goods
`real_estate`	Property or property-backed interests
`fx`	Currency exposure itself, not the currency a product is priced in
`other`	Exposure that does not fit the preceding classes

cash_equivalent is a maturity test, not a credit-quality test. A 20-year Treasury is fixed_income. fx is the currency pair or index; denomination is denomination_currency.

Selected asset_type values

asset_type is validated independently of asset_class. Common pairings:

Parent class	Values
`credit`	`corporate_bonds_high_yield`, `corporate_bonds_investment_grade`, `credit_fund`, `private_credit`, `private_credit_fund`, `private_credit_senior_secured_loans`, `securitized_products`
`equities`	`equities_cash`, `equities_exchange_traded_funds`, `equities_fund`, `equities_index`, `equities_index_fund`, `equities_preferred`, `equities_synthetic`, `private_equity`, `venture_capital_fund_interest`
`commodities`	`agriculture`, `carbon_credits`, `energy`, `gemstones`, `metals`
`cash_equivalent`	`government_debt_us`, `government_debt_non_us`, `money_market_fund`
`fixed_income`	`government_debt_us`, `government_debt_non_us`, `fixed_income_diversified`
`real_estate`	`residential_real_estate`
`fx`	`cash_fx`
`other`	`crypto_hedge_fund`, `fine_art`, `hedge_fund`, `insurance_linked_securities`

energy and fixed_income_diversified can appear under more than one parent. Filter on the pair when that matters.

legal_wrapper_type values

DIRECT_TOKENIZED_EQUITY, LEDGER_BASED_SECURITY, SPECIAL_PURPOSE_VEHICLE, REGISTERED_FUND, UNREGISTERED_FUND, ETF_PASSTHROUGH_WRAPPER, STRUCTURED_NOTE, STRUCTURED_CREDIT_TRANCHE, DERIVATIVE_CONTRACT, CUSTODIAL_RECEIPT, WRAPPED_RWA_TOKEN, DEFI_VAULT_SHARE, OTHER.

eligible_investors values

UNRESTRICTED, US_RETAIL, US_ACCREDITED, US_QUALIFIED_PURCHASER, PROFESSIONAL_QUALIFIED, NON_US_PERSON, INSTITUTIONAL_ONLY. PROFESSIONAL_QUALIFIED is jurisdiction-neutral (MiFID II, Swiss CISA, UK FCA, and similar tests). Which regime supplies the test is a regulatory_framework fact.

Issuer, platform, and asset manager

issuer_name is the legal entity that issues the product. Attribute AUM here for asset-manager rankings.
platform_name is the venue that brought it onchain. Ondo Global Markets is the platform for tokenized iShares ETFs whose issuer is BlackRock.
asset_manager_entity runs the underlying portfolio when that is a third party.

Example queries

Issuer league table for tokenized money market funds:

SELECT
  p.issuer_name,
  p.platform_name,
  p.custodian_entity,
  COUNT(DISTINCT p.product_id) AS products,
  SUM(s.supply_usd) AS aum_usd
FROM rwa_multichain.supply AS s
INNER JOIN rwa_multichain.tokens_reference_data AS r
  ON r.blockchain = s.blockchain
  AND r.token_id = s.token_id
INNER JOIN rwa_multichain.product_reference_data AS p
  ON p.product_id = r.product_id
WHERE s.day = CURRENT_DATE - INTERVAL '1' DAY
  AND p.asset_type = 'money_market_fund'
GROUP BY 1, 2, 3
ORDER BY 5 DESC NULLS LAST
LIMIT 25

Products a US retail investor can hold, by legal wrapper:

SELECT
  legal_wrapper_type,
  regulator,
  jurisdiction_iso2,
  COUNT(*) AS products
FROM rwa_multichain.product_reference_data
WHERE eligible_investors = 'US_RETAIL'
  AND legal_wrapper_type <> ''
GROUP BY 1, 2, 3
ORDER BY 4 DESC

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

rwa_multichain.product_reference_data

Table schema

Blank versus NOT_APPLICABLE

asset_class values

Selected asset_type values

legal_wrapper_type values

eligible_investors values

Issuer, platform, and asset manager

Example queries

​Table schema

​Blank versus NOT_APPLICABLE

​asset_class values

​Selected asset_type values

​legal_wrapper_type values

​eligible_investors values

​Issuer, platform, and asset manager

​Example queries

Table schema

Blank versus NOT_APPLICABLE

asset_class values

Selected asset_type values

legal_wrapper_type values

eligible_investors values

Issuer, platform, and asset manager

Example queries