> ## 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 Liquidity And Price

### Table Details

| Property     | Value                                                    |
| ------------ | -------------------------------------------------------- |
| Table Name   | `arbitrum.dex.uniswap_v3_position_liquidity_and_price`   |
| 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.      |
| source\_sqrt\_price\_x96 | VARCHAR(16777216) | Pool sqrt price (in Q96 fixed-point format) at the time of the snapshot event.                                                                               |
| 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.                   |
| source\_tick             | FLOAT             | Active pool tick at the time of the snapshot event.                                                                                                          |
| tick                     | FLOAT             | 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.            |
| source\_tick\_upper      | VARCHAR(16777216) | Upper tick of the position range at the time of the source event.                                                                                            |
| tick\_upper              | VARCHAR(16777216) | Upper tick boundary for concentrated liquidity position                                                                                                      |
| source\_tick\_lower      | VARCHAR(16777216) | Lower tick of the position range at the time of the source event.                                                                                            |
| tick\_lower              | VARCHAR(16777216) | Lower tick boundary for concentrated liquidity position                                                                                                      |
| source\_liquidity        | VARCHAR(16777216) | Liquidity in the pool at the time of the swap that informed this position snapshot.                                                                          |
| 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.                                                  |
| transaction\_index       | NUMBER(38,0)      | Zero-based position of the transaction within its block. The first transaction in a block has index 0.                                                       |