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