> ## 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 V3 Position Holdings

### Table Details

| Property     | Value                                                    |
| ------------ | -------------------------------------------------------- |
| Table Name   | `arbitrum.dex.uniswap_v3_position_holdings`              |
| Table Status | Production-Ready                                         |
| Unique Key   | `transaction_hash`, `token_id`, `liquidity_pool_address` |

### Table Columns

| Column Name              | Data Type         | Description                                                                                                                                                  |
| ------------------------ | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| liquidity\_pool\_address | VARCHAR(42)       | Contract address of the liquidity pool where this trade was executed. Null when the routing path is not emitted by the event (common for aggregator trades). |
| token\_id                | VARCHAR(16777216) | Identifier for non-fungible tokens (ERC-721) or semi-fungible tokens (ERC-1155). Each unique token\_id within a collection represents a distinct asset.      |
| amount0\_raw             | VARCHAR(16777216) | Computed token0 amount in the position (raw, not decimal-adjusted)                                                                                           |
| amount1\_raw             | VARCHAR(16777216) | Computed token1 amount in the position (raw, not decimal-adjusted)                                                                                           |
| sqrt\_price\_x96         | VARCHAR(16777216) | Square root of the current spot price of the pool, stored as a Q64.96 fixed-point number (multiplied by 2^96). Used in Uniswap V3/V4 math.                   |
| tick                     | VARCHAR(16777216) | Current price tick of the AMM pool. In Uniswap V3/V4, the price is represented as `1.0001^tick`. Only meaningful for concentrated liquidity AMMs.            |
| liquidity                | VARCHAR(16777216) | Current active liquidity of the pool or position. In Uniswap V3/V4, this is the liquidity available within the current tick range.                           |
| block\_timestamp         | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                                                      |
| block\_number            | NUMBER(38,0)      | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block.                                |
| block\_hash              | VARCHAR(66)       | Cryptographic hash of the block header that contains this record. Uniquely identifies a block.                                                               |
| transaction\_hash        | VARCHAR(66)       | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                                                  |