Table Details
| Property | Value |
|---|---|
| Table Name | polygon.dex.uniswap_v4_position_holdings_hourly |
| Table Status | Beta 🌱 |
| Unique Key | activity_hour, position |
| Clustering Key(s) | activity_hour::timestamp, position, id |
| Search Optimization | position, id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| id | VARCHAR(16777216) | Unique pool identifier used for grouping related positions |
| position | VARCHAR(16777216) | Synthetic identifier for a position (id + tickLower + tickUpper) |
| activity_hour | TIMESTAMP_NTZ(9) | Hourly timestamp for the observation |
| sqrt_price_x96 | VARCHAR(16777216) | Square root price of the pool in Q64.96 format |
| sqrt_price | VARCHAR(16777216) | Human-readable square root price |
| is_in_range | BOOLEAN | Whether the position is active (in-range) at this hour |
| tick | NUMBER(38,0) | Current pool tick |
| tick_upper | NUMBER(38,0) | Upper tick boundary of the position |
| tick_lower | NUMBER(38,0) | Lower tick boundary of the position |
| liquidity | NUMBER(38,0) | Current liquidity provided by the position |
| token0_address | VARCHAR(16777216) | Token0 contract address |
| token0_name | VARCHAR(16777216) | Token0 name |
| token0_symbol | VARCHAR(16777216) | Token0 symbol |
| amount0_raw | VARCHAR(16777216) | Token0 raw amount (unadjusted for decimals) |
| token0_amount | FLOAT | Token0 amount adjusted for decimals |
| token0_usd_amount | FLOAT | USD value of token0 at the activity hour |
| token1_address | VARCHAR(16777216) | Token1 contract address |
| token1_name | VARCHAR(16777216) | Token1 name |
| token1_symbol | VARCHAR(16777216) | Token1 symbol |
| amount1_raw | VARCHAR(16777216) | Token1 raw amount (unadjusted for decimals) |
| token1_amount | FLOAT | Token1 amount adjusted for decimals |
| token1_usd_amount | FLOAT | USD value of token1 at the activity hour |
| tvl_usd | FLOAT | Total USD value of the position (token0 + token1) at current tick |
| static_pool_fields | VARIANT | Static metadata about the pool (e.g., tick spacing, fee tier) |
| extra_pool_fields | VARIANT | Hourly pool context (e.g., swaps, block metadata) |
| extra_position_fields | VARIANT | Hourly position context (e.g., liquidity change summary, block metadata) |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of last update to the row |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when the row was created |