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

<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)                                                            |
    | `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                                                                              |
  </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.)                                 |
    | `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>

<Accordion title="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.
</Accordion>