> ## 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          | `casper.dex.pool_balance_changes_daily`                 |
| Table Status        | Production-Ready                                        |
| Unique Key          | `block_date`, `liquidity_pool_address`, `token_address` |
| Clustering Key(s)   | `block_date::date`                                      |
| Search Optimization | `liquidity_pool_address`, `token_address`               |

### Table Columns

| Column Name              | Data Type         | Description                                                           |
| ------------------------ | ----------------- | --------------------------------------------------------------------- |
| block\_date              | DATE              | Calendar date (UTC) of the pool balance snapshot.                     |
| project                  | VARCHAR(16777216) | Name of the DEX protocol's project (e.g., Casperswap).                |
| protocol                 | VARCHAR(16777216) | Specific protocol variant or version identifier.                      |
| liquidity\_pool\_address | VARCHAR(16777216) | Address of the liquidity pool contract.                               |
| token\_address           | VARCHAR(16777216) | Address of the token whose pool balance is recorded.                  |
| raw\_balance\_str        | VARCHAR(16777216) | End-of-day raw pool balance in the token's smallest unit as a string. |
| raw\_balance             | FLOAT             | End-of-day raw pool balance in the token's smallest unit.             |
| block\_timestamp         | TIMESTAMP\_NTZ(9) | Timestamp of the last block reflected in the daily snapshot.          |
| block\_number            | NUMBER(38,0)      | Height of the last block reflected in 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.         |