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

# TVL Agg

> Reference documentation for the Tvl Agg table in Hubble's Gold data dictionary.

## Table Metadata

| Property | Configuration |
| - | - |
| Natural Key(s) | day, asset\_code, asset\_issuer, asset\_type |
| Partition Field(s) | N/A |
| Clustered Field(s) | N/A |
| Documentation | [dbt docs](http://www.stellar-dbt-docs.com/#!/model/model.stellar_dbt_public.tvl_agg) |

## Column Details

| Name | Description | Data Type | Domain Values | Required? | Notes |
| - | - | - | - | - | - |
| day | The date for the aggregation result. | DATE | | Yes | Natural Key. |
| 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> | Yes | Natural Key. 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 4 or 12 character code representation of the asset on the network. | STRING | | No | Natural Key. Asset codes have no guarantees of uniqueness. The combination of asset code, issuer and type represents a distinct asset. |
| asset\_issuer | The account address of the original asset issuer that created the asset. | STRING | | No | Natural Key. |
| contract\_id | Soroban contract id of the SAC or contract token the asset maps to. | STRING | | No | |
| accounts\_tvl | The total value locked (TVL) denominated in raw asset value (token amounts) for a given date. Aggregated across accounts selling liabilities. | FLOAT | | Yes | |
| trustlines\_tvl | The total value locked (TVL) denominated in raw asset value (token amounts) for a given date. Aggregated across trustlines selling liabilities. | FLOAT | | Yes | |
| liquidity\_pools\_tvl | The total value locked (TVL) denominated in raw asset value (token amounts) for a given date. Aggregated across liquidity pool balances (AMM). | FLOAT | | Yes | |
| total\_tvl | The total value locked (TVL) denominated in raw asset value (token amounts) for a given date. Aggregated across relevant ledger entries (e.g., accounts, trustlines, liquidity pools). | FLOAT | | Yes | |