rwa_multichain.balances - Dune Docs

rwa_multichain.balances is the cross-chain holder snapshot table. Grain: one row per holder per token per chain per day, keyed on (blockchain, day, address, token_id). Use it to measure holder counts, concentration, and AUM.

Table schema

Column	Type	Description
`blockchain`	`VARCHAR`	Chain for the native balance source
`day`	`DATE`	Balance snapshot date
`address`	`VARCHAR`	Normalized holder address. 0x-hex on EVM, base58 on Solana, native form elsewhere
`token_symbol`	`VARCHAR`	RWA token symbol where available
`token_address`	`VARCHAR`	Normalized native token identifier as `VARCHAR`
`token_id`	`VARCHAR`	Normalized cross-chain token identifier for joining to `rwa_multichain.tokens`
`token_standard`	`VARCHAR`	Native token standard or asset namespace
`currency`	`VARCHAR`	Token metadata currency where available
`balance_raw`	`DOUBLE`	Raw token balance in the source token’s native precision
`balance`	`DOUBLE`	Token balance adjusted for decimals
`balance_usd`	`DOUBLE`	USD value of the balance using curated RWA prices
`last_updated`	`TIMESTAMP`	UTC timestamp when the balance last changed

USD valuation

balance_usd applies Dune’s curated RWA price for the snapshot date. If you need the price type and provenance explicitly, join prices on the normalized cross-chain key:

SELECT
  b.day,
  b.token_symbol,
  p.value_kind,
  SUM(b.balance * p.price_usd) AS aum_usd
FROM rwa_multichain.balances AS b
INNER 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 '30' day
GROUP BY 1, 2, 3

Zero balances are retained

Rows persist after a holder empties a position, so balance = 0 rows appear in the snapshot. Filter balance > 0 when counting holders, or you will count every address that ever held the asset.

Example query

-- Holder concentration for a single asset
WITH latest AS (
  SELECT address, balance
  FROM rwa_multichain.balances
  WHERE day = current_date - INTERVAL '1' day
    AND token_symbol = 'BUIDL'
    AND balance > 0
)
SELECT
  COUNT(*) AS holders,
  SUM(balance) AS total_balance,
  MAX(balance) / SUM(balance) AS top_holder_share
FROM latest

Top holders across all chains:

SELECT
  address,
  COUNT(DISTINCT token_id) AS assets_held,
  SUM(balance_usd) AS portfolio_usd
FROM rwa_multichain.balances
WHERE day = current_date - INTERVAL '1' day
  AND balance > 0
  AND balance_usd IS NOT NULL
GROUP BY 1
ORDER BY 3 DESC
LIMIT 50