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

Uniswap V4 liquidity positions minted via the position manager — one row per position NFT with its pool, tick range, and mint transaction.

### Table Columns

| Column Name              | Data Type         | Description                                                                   |
| ------------------------ | ----------------- | ----------------------------------------------------------------------------- |
| id                       | VARCHAR(16777216) | Uniswap V4 pool identifier (pool ID including hooks) the position belongs to. |
| position                 | VARCHAR(16777216) | Identifier (token ID) of the position NFT.                                    |
| token0\_address          | VARCHAR(42)       | Contract address of the pool's first token.                                   |
| token1\_address          | VARCHAR(42)       | 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.                           |
| mint\_transaction\_hash  | VARCHAR(66)       | 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(66)       | Hash of the block that contains the mint.                                     |
| \_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.                 |