> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Balances (Holdings)

> Track RWA token balances and holdings across different blockchains.

## 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

<Tabs>
  <Tab title="Balances Daily">
    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                                   |
  </Tab>

  <Tab title="Balances Latest">
    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.)                                                   |
    | `rwa_class`         | **(Deprecated — removed March 15, 2026)** Classification of the RWA token. Use `asset_class` and `asset_type` instead. |
    | `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                                                                            |
  </Tab>
</Tabs>