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