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 Name | Description |
|---|---|
crosschain.rwa.balances_daily | Daily historical balances for RWA token holders across different blockchains. |
crosschain.rwa.balances_latest | Latest balances for RWA token holders (most recent within last 7 days). |
Table Columns
- Balances Daily
- Balances Latest
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 Name | Description |
|---|---|
date | The date of the balance snapshot |
chain | The blockchain network (ethereum, solana, aptos, sui, stellar, etc.) |
address | The wallet address holding the tokens |
token_account | The token account address (applicable for Solana only, null for other chains) |
token_address | The contract/asset address of the RWA token |
token_name | The name of the RWA token |
token_symbol | The symbol of the RWA token |
token_decimals | The number of decimals for the token |
raw_balance_str | The raw balance as a string (not adjusted for decimals) |
raw_balance | The raw balance as a float (not adjusted for decimals) |
balance_str | The balance as a string (adjusted for decimals) |
balance | The balance as a float (adjusted for decimals) |
usd_balance | The USD value of the balance (balance * usd_exchange_rate) |
usd_exchange_rate | The USD exchange rate for the token on this date |
_created_at | Timestamp when this record was created |
_updated_at | Timestamp when this record was last updated |