rwa_multichain.balances_enriched

Daily RWA holder balances with entity attribution — CEX, lending protocol, custodian, and treasury labels.

rwa_multichain.balances_enriched extends balances with entity attribution, so you can tell how much of an asset sits with centralized exchanges, lending protocols, and custodians versus unattributed wallets. Grain: one row per holder per token per chain per day, same as balances.

What it answers

Raw balances tell you an address holds 40% of an asset. They do not tell you whether that address is a custodian holding on behalf of thousands of end investors, an exchange omnibus wallet, or a single whale — three very different market-structure readings of the same number. The label columns resolve that:

• How much of supply sits with CEXs, protocols, or custodians versus unknown wallets
• Who the labeled top holders are
• What an asset’s DeFi exposure is, via labeled lending-protocol holdings
• How much of outstanding supply is circulating versus issuer, bridge, or distributor inventory

Table schema

Column	Type	Description
blockchain	VARCHAR	Chain for the native balance source
day	DATE	Balance snapshot date
address	VARCHAR	Normalized holder address
token_symbol	VARCHAR	RWA token symbol
token_address	VARCHAR	Normalized native token identifier
token_id	VARCHAR	Normalized cross-chain token identifier
token_standard	VARCHAR	Native token standard or asset namespace, including tip20 for Tempo
token_product_id	VARCHAR	`blockchain	token_standard	token_id. Join key to tokens_reference_data`
currency	VARCHAR	Token metadata currency where available
balance_raw	DOUBLE	Raw token balance in native precision
balance	DOUBLE	Decimals-adjusted balance
balance_usd	DOUBLE	USD value using curated RWA prices
address_label	VARCHAR	Label value. NULL for unlabeled addresses
address_category	VARCHAR	Top-level holder classification. Unlabeled rows use unidentified or unidentified_smart_contract
address_subcategory	VARCHAR	Finer classification, or the top-level / unidentified fallback
address_label_source	VARCHAR	Exact RWA label source. NULL for unidentified holders
address_label_method	VARCHAR	RWA label extraction method. NULL for unidentified holders
is_smart_contract	BOOLEAN	Whether the holder is a deployed EVM smart contract. NULL on Robinhood and non-EVM chains
is_circulating	BOOLEAN	false for xStocks system wallets holding xStocks, bridge lockboxes, issuer inventory, and custodian distributor omnibus. CEX, DEX, lending, and unidentified wallets stay true. supply.circulating_supply sums this flag.
last_updated	TIMESTAMP	UTC timestamp when the balance last changed

Holder attribution

Known entities carry their resolved label and category. Other rows are preserved with address_category = 'unidentified'; supported EVM contracts use unidentified_smart_contract. address_category and address_subcategory are non-null, so no COALESCE(..., 'unlabeled') is needed.

token_product_id is the exact join key to tokens_reference_data. Do not join the two tables on product_id: one product may have many chain deployments.

Tempo smart-contract classification uses tempo.creation_traces. More specific entity and protocol labels retain precedence over the generic unidentified_smart_contract classification.

Table schema notes

Because one row per holder per day is preserved, zero balances persist after a holder exits. Filter balance > 0 when counting holders.

Example query

-- Supply attribution by holder type
SELECT
  address_category AS holder_type,
  COUNT(DISTINCT address) AS holders,
  SUM(balance_usd) AS balance_usd
FROM rwa_multichain.balances_enriched
WHERE day = CURRENT_DATE - INTERVAL '1' DAY
  AND balance > 0
GROUP BY 1
ORDER BY 3 DESC NULLS LAST

Labeled top holders for one asset:

SELECT
  address,
  address_label,
  address_category,
  is_smart_contract,
  balance,
  balance_usd
FROM rwa_multichain.balances_enriched
WHERE day = CURRENT_DATE - INTERVAL '1' DAY
  AND token_symbol = 'BUIDL'
  AND balance > 0
ORDER BY balance DESC
LIMIT 25

CEX-held share of an asset over time:

SELECT
  day,
  SUM(CASE WHEN address_category = 'cex' THEN balance ELSE 0 END) / SUM(balance) AS cex_share
FROM rwa_multichain.balances_enriched
WHERE day >= CURRENT_DATE - INTERVAL '90' DAY
  AND token_symbol = 'BUIDL'
  AND balance > 0
GROUP BY 1
ORDER BY 1 DESC