rwa_multichain.prices

rwa_multichain.prices is the cross-chain valuation surface for tokenized RWAs. Grain: one row per (blockchain, token_id, valid_from), with non-overlapping [valid_from, valid_to) windows. This is the table to use for AUM and point-in-time USD joins. Unlike nav_intervals, this view exposes a normalized textual token_id and prices whose basis is one on-chain token unit. It standardizes chain-specific address representation and unit conversions. rwa_multichain.supply.supply_usd is calculated from this table.

Table schema

Column	Type	Description
`blockchain`	`VARCHAR`	Chain for the token deployment
`token_standard`	`VARCHAR`	Native token standard or asset namespace
`token_id`	`VARCHAR`	Normalized textual token identifier. Join key to `tokens`, `balances`, `transfers`, and `supply`
`asset_address`	`VARBINARY`	Binary asset identifier from the NAV tables
`price_usd`	`DOUBLE`	USD price per normalized on-chain token unit
`value_kind`	`VARCHAR`	`accounting_nav`, `redemption_rate`, `tracker_price`, `commodity_reference`, or `par_value`
`valid_from`	`TIMESTAMP WITH TIME ZONE`	Inclusive start of the price window
`valid_to`	`TIMESTAMP WITH TIME ZONE`	Exclusive end. `NULL` only for an open interval
`oracle_address`	`VARBINARY`	Native source identifier bytes
`source_kind`	`VARCHAR`	Source mechanism from the verified oracle registry
`source_table`	`VARCHAR`	Source dataset providing the value
`_updated_at`	`TIMESTAMP WITH TIME ZONE`	Latest refresh timestamp

Point-in-time join

SELECT
  b.day,
  b.blockchain,
  b.token_symbol,
  p.value_kind,
  SUM(b.balance * p.price_usd) AS aum_usd
FROM rwa_multichain.balances AS b
LEFT JOIN rwa_multichain.prices AS p
  ON p.blockchain = b.blockchain
  AND p.token_id = b.token_id
  AND CAST(b.day AS TIMESTAMP) >= p.valid_from
  AND (p.valid_to IS NULL OR CAST(b.day AS TIMESTAMP) < p.valid_to)
WHERE b.day = CURRENT_DATE - INTERVAL '1' DAY
  AND b.balance > 0
GROUP BY 1, 2, 3, 4
ORDER BY 5 DESC NULLS LAST

Use a LEFT JOIN to retain all balance rows while attaching the price in force for each snapshot.

value_kind matters

All values are USD per token unit, but they do not all mean accounting NAV:

Value	Meaning
`accounting_nav`	Issuer or fund accounting net asset value
`redemption_rate`	Units or value redeemable per token
`tracker_price`	Value published by a tracker or oracle
`commodity_reference`	Commodity reference price
`par_value`	Declared or contractual par value

Keep value_kind in reconciliations and methodology notes. It tells downstream users what financial claim the USD number represents.

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

rwa_multichain.prices

Table schema

Point-in-time join

value_kind matters

​Table schema

​Point-in-time join

​value_kind matters

Table schema

Point-in-time join

value_kind matters