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

# TVL Daily

### Table Details

| Property     | Value                    |
| ------------ | ------------------------ |
| Table Name   | `hyperevm.dex.tvl_daily` |
| Table Status | Production-Ready         |

### Table Columns

| Column Name              | Data Type         | Description                                                                                                 |
| ------------------------ | ----------------- | ----------------------------------------------------------------------------------------------------------- |
| date                     | TIMESTAMP\_NTZ(9) | Date of the balance entry.                                                                                  |
| project                  | VARCHAR(16777216) | Name of the project e.g. uniswap, balancer, curve, sushiswap, pancakeswap, fraxswap, etc.                   |
| protocol                 | VARCHAR(16777216) | Version of the protocol used e.g. uniswap\_v2, uniswap\_v3, balancer\_v3, curve, fluid, etc.                |
| pool\_name               | VARCHAR(16777216) | Name of the liquidity pool.                                                                                 |
| liquidity\_pool\_address | VARCHAR(16777216) | Contract address of the liquidity pool holding the asset. For some projects, it might be the vault address. |
| token\_address           | VARCHAR(16777216) | Contract address of the token.                                                                              |
| token\_name              | VARCHAR(16777216) | Name of the token.                                                                                          |
| token\_symbol            | VARCHAR(16777216) | Symbol of the token.                                                                                        |
| token\_decimals          | NUMBER(38,0)      | Decimals of the token.                                                                                      |
| raw\_balance\_str        | VARCHAR(16777216) | Raw balance of the token in string.                                                                         |
| raw\_balance             | FLOAT             | Raw balance of the token, normalized.                                                                       |
| balance\_str             | VARCHAR(16777216) | 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      | NUMBER(38,0)      | 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.                                                                 |

### Related Docs

* [EVM DEX TVL Daily](/historical-data/supported-blockchains/evm/core-schemas/dex/tvl-daily)