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

# Uniswap v4 Position Holdings Hourly 🌱

### Table Details

| Property            | Value                                              |
| ------------------- | -------------------------------------------------- |
| Table Name          | `ethereum.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                                       |

### Related Docs

* [EVM DEX Uniswap v4 Position Holdings Hourly](/historical-data/supported-blockchains/evm/core-schemas/dex/position-holdings/uniswap-v4-position-holdings-hourly)