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

# Account Balances Daily Agg

> Reference documentation for the Account Balances Daily Agg table in Hubble's Gold data dictionary.

## Table Metadata

| Property | Configuration |
| - | - |
| Natural Key(s) | day, account\_id, contract\_id |
| Partition Field(s) | day (DAY partition) |
| Clustered Field(s) | account\_id, contract\_id |
| Documentation | [dbt docs](http://www.stellar-dbt-docs.com/#!/model/model.stellar_dbt_public.account_balances__daily_agg) |

## Column Details

| Name | Description | Data Type | Domain Values | Required? | Notes |
| - | - | - | - | - | - |
| day | Date by which all metrics are aggregated. Balances are reported as of the end of this day. | DATE | | Yes | |
| account\_id | The address holding the balance. Either a classic account address (base32, starts with `G`) or a Soroban contract address (starts with `C`). | STRING | | Yes | Not limited to classic accounts: contract addresses hold SAC and custom contract token balances and are unioned into this column by the upstream `int_account_balances__contracts` model. |
| asset\_type | The identifier for type of asset code, can be an alphanumeric with 4 characters, 12 characters or the native asset to the network, XLM. | STRING | <ul><li>credit\_alphanum4</li><li>credit\_alphanum12</li><li>native</li></ul> | No | XLM is the native asset to the network. XLM has no asset code or issuer representation and will instead be displayed with an asset type of 'native' |
| asset\_code | The code representation of the asset on the network. | STRING | | No | For classic assets this is the 4 or 12 character asset code. For contract tokens it is resolved via `int_asset_metadata`, which coalesces the asset\_code from SAC transfer events with the SEP-41 `symbol` from contract storage metadata; SEP-41 places no length constraint on `symbol`, so values outside 4/12 characters occur. Null when a contract publishes neither. Asset codes have no guarantees of uniqueness. |
| asset\_issuer | The account address of the original asset issuer that created the asset. | STRING | | No | |
| contract\_id | Soroban contract id of the SAC or contract token the balance is denominated in. | STRING | | Yes | Cluster Field. |
| liquidity\_pool\_balance | The sum of balances across all liquidity pools for a given asset. | FLOAT | | Yes | |
| offer\_balance | The sum of balances across all selling liabilities (SDEX only) for a given asset. | FLOAT | | Yes | |
| trustline\_balance | The sum of trustline balance for a given asset. | FLOAT | | Yes | |
| contract\_balance | The sum of contract balance for a given asset. | FLOAT | | Yes | |