Balances (Holdings) - Allium Documentation Hub

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
`rwa.core.balances_daily`	Daily historical balances for RWA token holders across different blockchains.
`rwa.core.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)
`holder_rank`	Rank of this holder by `balance`, among all holders of the same `token_address` on the same `date` (1 = largest balance)
`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

Latest balances for RWA token holders across different blockchains. Shows the most recent balance for each holder-token combination within the last 7 days.Unique key: chain, address, token_address

Column Name	Description
`chain`	The blockchain network (ethereum, solana, aptos, sui, stellar, etc.)
`asset_class`	Top-level V2 classification (rates, equities, credit, fx, commodities, private_funds, real_estate)
`asset_type`	Granular V2 sub-classification within the asset class
`product_id`	Unique identifier for the RWA product
`issuer_id`	Unique identifier for the token issuer
`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
`block_date`	The date of the block when this balance was last updated
`block_timestamp`	The timestamp of the block when this balance was last updated
`block_number`	The block number when this balance was last updated
`_created_at`	Timestamp when this record was created
`_updated_at`	Timestamp when this record was last updated

Legacy Schema

crosschain.rwa.balances_daily is deprecated in favor of rwa.core.balances_daily above, and crosschain.rwa.balances_latest is deprecated in favor of rwa.core.balances_latest above. Both remain queryable, but new work should use the current schema.

⌘I