Skip to main content

Overview

The balances tables provide information about RWA token holdings across different wallet addresses. This includes both historical daily snapshots and the latest balance state for each holder.

Tables

Table NameDescription
crosschain.rwa.balances_dailyDaily historical balances for RWA token holders across different blockchains.
crosschain.rwa.balances_latestLatest balances for RWA token holders (most recent within last 7 days).

Table Columns

Daily historical balances for RWA token holders across different blockchains. This model forward-fills balances to provide a complete daily time series for each holder.Unique key: date, chain, address, token_address
Column NameDescription
dateThe date of the balance snapshot
chainThe blockchain network (ethereum, solana, aptos, sui, stellar, etc.)
addressThe wallet address holding the tokens
token_accountThe token account address (applicable for Solana only, null for other chains)
token_addressThe contract/asset address of the RWA token
token_nameThe name of the RWA token
token_symbolThe symbol of the RWA token
token_decimalsThe number of decimals for the token
raw_balance_strThe raw balance as a string (not adjusted for decimals)
raw_balanceThe raw balance as a float (not adjusted for decimals)
balance_strThe balance as a string (adjusted for decimals)
balanceThe balance as a float (adjusted for decimals)
usd_balanceThe USD value of the balance (balance * usd_exchange_rate)
usd_exchange_rateThe USD exchange rate for the token on this date
_created_atTimestamp when this record was created
_updated_atTimestamp when this record was last updated