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

# Asset Balances Daily Agg

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

## Table Metadata

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

## Column Details

| Name | Description | Data Type | Domain Values | Required? | Notes |
| - | - | - | - | - | - |
| day | Date by which all metrics are aggregated. | DATE | | Yes | |
| 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 | | 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 | |
| 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 | |
| total\_accounts\_with\_liquidity\_pool\_balance | The count of positive liquidity pool balance holders for a given asset. | INTEGER | | Yes | |
| total\_accounts\_with\_offer\_balance | The count of positive offer balance holders for a given asset. | INTEGER | | Yes | |
| total\_accounts\_with\_trustline\_balance | The count of positive trustline balance holders for a given asset. | INTEGER | | Yes | |
| contract\_id | Soroban contract id of the SAC or contract token the balance is denominated in. | STRING | | Yes | |
| contract\_balance | The sum of contract balance for a given asset. | FLOAT | | Yes | Produced with `coalesce(..., 0)` upstream, so never null; 0 means no contract balance. |
| total\_accounts\_with\_contract\_balance | The count of positive contract balance holders for a given asset. | INTEGER | | Yes | Produced with `coalesce(..., 0)` upstream, so never null. |
| total\_accounts\_with\_trustline | The count of accounts holding a trustline for a given asset, including accounts with a zero balance. | INTEGER | | Yes | Produced with `coalesce(..., 0)` upstream, so never null. |