> ## 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 Positions 🌱

### Table Details

| Property            | Value                                           |
| ------------------- | ----------------------------------------------- |
| Table Name          | `polygon.dex.uniswap_v4_positions`              |
| Table Status        | Beta 🌱                                         |
| Unique Key          | `position`                                      |
| Clustering Key(s)   | `mint_block_timestamp::timestamp, position, id` |
| Search Optimization | `position`, `id`                                |

### Table Columns

| Column Name              | Data Type          | Description                                                                   |
| ------------------------ | ------------------ | ----------------------------------------------------------------------------- |
| id                       | VARCHAR(134217728) | Uniswap V4 pool identifier (pool ID including hooks) the position belongs to. |
| token0\_address          | VARCHAR(134217728) | Contract address of the pool's first token.                                   |
| token1\_address          | VARCHAR(134217728) | Contract address of the pool's second token.                                  |
| tick\_lower              | NUMBER(38,0)       | Lower tick bound of the position's liquidity range.                           |
| tick\_upper              | NUMBER(38,0)       | Upper tick bound of the position's liquidity range.                           |
| position                 | VARCHAR(134217728) | Identifier (token ID) of the position NFT.                                    |
| mint\_transaction\_hash  | VARCHAR(134217728) | Hash of the transaction that minted the position.                             |
| mint\_transaction\_index | NUMBER(38,0)       | Zero-based position of the mint transaction within its block.                 |
| mint\_block\_timestamp   | TIMESTAMP\_NTZ(9)  | Timestamp (UTC) of the block that contains the mint.                          |
| mint\_block\_number      | NUMBER(38,0)       | Number of the block that contains the mint.                                   |
| mint\_block\_hash        | VARCHAR(134217728) | Hash of the block that contains the mint.                                     |
| \_updated\_at            | TIMESTAMP\_NTZ(9)  | Timestamp of when the entry was last updated in the database.                 |
| \_created\_at            | TIMESTAMP\_NTZ(9)  | Timestamp of when the entry was created in the database.                      |

### Related Docs

* [EVM DEX Uniswap V4 Positions](/historical-data/supported-blockchains/evm/core-schemas/dex/position-manager/uniswap-v4-positions)