> ## 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 | `bsc.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 UTC date this daily pool balance snapshot covers |
| project | VARCHAR(134217728) | Name of the project (e.g. uniswap) |
| protocol | VARCHAR(134217728) | Protocol name (e.g. uniswap\_v2, uniswap\_v3) |
| pool\_name | VARCHAR(134217728) | Human-readable pool name (typically `token0/token1`) |
| liquidity\_pool\_address | VARCHAR(134217728) | Contract address of the liquidity pool |
| token\_address | VARCHAR(134217728) | Contract address of the token held in the pool |
| raw\_balance\_str | VARCHAR(134217728) | Pool's token reserve, unnormalized, as string for precision |
| raw\_balance | FLOAT | Pool's token reserve, unnormalized |
| balance\_str | VARCHAR(134217728) | Pool's token reserve, normalized, as string for precision |
| balance | FLOAT | Pool's token reserve, normalized by token decimals |
| usd\_balance | FLOAT | USD value of the pool's reserve of this token |
| usd\_exchange\_rate | FLOAT | Exchange rate used for USD conversion |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Block timestamp at which the balance was captured |
| block\_number | NUMBER(38,0) | Block number at which the balance was captured |
| \_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. |

### Related Docs

* [EVM DEX Pool Balance Changes Daily](/historical-data/supported-blockchains/evm/core-schemas/dex/pool-balance-changes-daily)