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

# Pool Balance Changes Daily

### Table Details

| Property            | Value                                                   |
| ------------------- | ------------------------------------------------------- |
| Table Name          | `hyperevm.dex.pool_balance_changes_daily`               |
| Table Status        | Production-Ready                                        |
| Unique Key          | `block_date`, `liquidity_pool_address`, `token_address` |
| Clustering Key(s)   | `block_date::date, project`                             |
| Search Optimization | `liquidity_pool_address`, `token_address`               |

### Table Columns

| Column Name              | Data Type         | Description                                                              |
| ------------------------ | ----------------- | ------------------------------------------------------------------------ |
| block\_date              | TIMESTAMP\_NTZ(9) | The date of the daily pool balance snapshot.                             |
| project                  | VARCHAR(16777216) | The project or platform name (e.g., uniswap, sushiswap).                 |
| protocol                 | VARCHAR(16777216) | The specific protocol or version used (e.g., uniswap\_v3).               |
| pool\_name               | VARCHAR(16777216) | The display name of the liquidity pool.                                  |
| liquidity\_pool\_address | VARCHAR(16777216) | The address of the liquidity pool.                                       |
| token\_address           | VARCHAR(16777216) | The contract address of the token in the pool.                           |
| raw\_balance\_str        | VARCHAR(16777216) | The raw token balance in the pool as string to retain precision.         |
| raw\_balance             | FLOAT             | The raw token balance in the pool (unnormalized).                        |
| balance\_str             | VARCHAR(16777216) | The token balance normalized by decimals, in string to retain precision. |
| balance                  | FLOAT             | The token balance in the pool, normalized by token decimals.             |
| usd\_balance             | FLOAT             | The USD value of the token balance in the pool.                          |
| usd\_exchange\_rate      | FLOAT             | The USD exchange rate of the token at the time of the snapshot.          |
| block\_timestamp         | TIMESTAMP\_NTZ(9) | The timestamp of the block used for the daily snapshot.                  |
| block\_number            | NUMBER(38,0)      | The block number used for the daily snapshot.                            |
| \_created\_at            | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                 |
| \_updated\_at            | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.            |