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

# DEX TVL Daily

The `dex.tvl_daily` table contains daily total value locked (TVL) for DEX protocols indexed by Allium.
Each entry corresponds to an asset in a liquidity pool address for each day.

### Table Columns

`_str` columns are numeric fields cast to `varchar` to retain precision.

Unique Key: `date, project, protocol, liquidity_pool_address, token_address`

| Column                   | Data Type         | Description                                                                                                 |
| ------------------------ | ----------------- | ----------------------------------------------------------------------------------------------------------- |
| date                     | DATE              | Date of the balance entry.                                                                                  |
| project                  | VARCHAR           | Name of the project e.g. uniswap, balancer, curve, sushiswap, pancakeswap, fraxswap, etc.                   |
| protocol                 | VARCHAR           | Version of the protocol used e.g. uniswap\_v2, uniswap\_v3, balancer\_v3, curve, fluid, etc.                |
| pool\_name               | VARCHAR           | Name of the liquidity pool.                                                                                 |
| liquidity\_pool\_address | VARCHAR           | Contract address of the liquidity pool holding the asset. For some projects, it might be the vault address. |
| token\_address           | VARCHAR           | Contract address of the token.                                                                              |
| token\_name              | VARCHAR           | Name of the token.                                                                                          |
| token\_symbol            | VARCHAR           | Symbol of the token.                                                                                        |
| token\_decimals          | BIGINT            | Decimals of the token.                                                                                      |
| raw\_balance\_str        | VARCHAR           | Raw balance of the token in string.                                                                         |
| raw\_balance             | FLOAT             | Raw balance of the token, normalized.                                                                       |
| balance\_str             | VARCHAR           | Balance of the token in string.                                                                             |
| balance                  | FLOAT             | Balance of the token, normalized.                                                                           |
| usd\_balance             | FLOAT             | USD balance of the token at the date of the balance entry.                                                  |
| usd\_exchange\_rate      | FLOAT             | USD exchange rate of the token at the date of the balance entry.                                            |
| last\_block\_timestamp   | TIMESTAMP\_NTZ(9) | Timestamp of the last block where the balance of the pool was updated.                                      |
| last\_block\_number      | BIGINT            | Number of the last block where the balance of the pool was updated.                                         |
| \_created\_at            | TIMESTAMP\_NTZ(9) | Timestamp when the record was created.                                                                      |
| \_updated\_at            | TIMESTAMP\_NTZ(9) | Timestamp when the record was last updated.                                                                 |