TVL Agg
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 |
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 |
| 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 |