rwa_multichain.tokens

rwa_multichain.tokens is the identity table for every tokenized RWA Dune tracks. Grain: one row per token per chain, keyed on (blockchain, token_standard, token_id). Native identifiers are already stored in token_id; there are no separate contract_address / token_mint_address columns on this view.

Why token_id exists

Each chain identifies a token differently: EVM uses a contract address, Solana a mint address, Aptos an asset type, Sui a coin type, and XRPL and Stellar their own asset identifiers. This table normalizes all of those into a single VARCHAR token_id. Join on (blockchain, token_id) and one query works across all 20 chains — that key resolves every row in balances, transfers, and supply.

Table schema

Column	Type	Description
`blockchain`	`VARCHAR`	Chain for the native token identifier
`token_standard`	`VARCHAR`	Native token standard or asset namespace. One of `erc20`, `spl`, `aptos_asset`, `sui_coin`, `xrpl_asset`, `stellar_asset`
`token_id`	`VARCHAR`	Normalized token identifier for cross-chain joins. Use this as the join key
`currency`	`VARCHAR`	Native currency code from the canonical token-list model
`balance_semantics`	`VARCHAR`	Balance behavior for the token: `standard` or `indexed`

token_standard here uses coarse namespaces. The transfers table uses finer-grained values (bep20, spl_token, spl_token_2022, classic, soroban, issued), so do not join the two tables on token_standard — use (blockchain, token_id).

balance_semantics = 'indexed' identifies rebasing or indexed-share tokens. The curated balances table applies the correct semantics for each token.

Asset class and issuer

This table is an identity registry, not a classification table. It does not carry asset_class or issuer. Those live in tokens_reference_data (token grain) and product_reference_data (product grain). Join tokens_reference_data on (blockchain, token_id) whenever you need to slice by asset class or attribute activity to an issuer.

Example query

-- Token coverage by chain and standard
SELECT
  blockchain,
  token_standard,
  COUNT(DISTINCT token_id) AS tokens
FROM rwa_multichain.tokens
GROUP BY 1, 2
ORDER BY 3 DESC

Resolve holder balances to the registry:

SELECT
  t.blockchain,
  t.token_standard,
  b.token_symbol,
  COUNT(DISTINCT b.address) AS holders
FROM rwa_multichain.balances AS b
INNER JOIN rwa_multichain.tokens AS t
  ON t.blockchain = b.blockchain
  AND t.token_id = b.token_id
WHERE b.day = CURRENT_DATE - INTERVAL '1' DAY
  AND b.balance > 0
GROUP BY 1, 2, 3
ORDER BY 4 DESC
LIMIT 50

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

rwa_multichain.tokens

Why token_id exists

Table schema

Asset class and issuer

Example query

​Why token_id exists

​Table schema

​Asset class and issuer

​Example query

Why token_id exists

Table schema

Asset class and issuer

Example query