Flipside Docs
Search…
⌃K

Positions

uniswapv3.positions
Positions opened by liquidity providers at a specific tick range (tick_lower, tick_upper). Whenever an event is emitted related to a position a new record is added to this table with the latest state of the position.
Field
Type
Description
block_id
number
The block number that this position's state was recorded
block_timestamp
timestamp
The block timestamp that this position's state was recorded
tx_id
text
The transaction that triggered this position's state to be recorded
blockchain
text
The blockchain this position was created on (Ethereum, will support L2s here shortly)
pool_address
address
the contract address of the pool
pool_name
text
The name of the Pool (format = "{token0}-{token1} {tick_spacing} {fee}")
is_active
boolean
Is the position currently active? When a position is closed this is set to false.
liquidity_adjusted
number
The liquidity of the position, decimal adjusted.
liquidity_provider
address
The address of the LP
nf_position_manager_address
address
The address of the peripheral nf position manager contract, if used.
nf_token_id
number
The id of the NFT associated with the liquidity position
price_lower_0_1
number
Lower bound of the liquidity position represented as token 0 per token 1
price_upper_0_1
number
Upper bound of the liquidity position represented as token 0 per token 1
price_lower_0_1_usd
number
Lower bound of the liquidity position represented as token 0 per token 1, converted to USD
price_upper_0_1_usd
number
Upper bound of the liquidity position represented as token 0 per token 1, converted to USD
price_lower_1_0
number
Lower bound of the liquidity position represented as token 1 per token 0
price_upper_1_0
number
Upper bound of the liquidity position represented as token 1 per token 0
price_lower_1_0_usd
number
Lower bound of the liquidity position represented as token 1 per token 0, converted to USD
price_upper_1_0_usd
number
Upper bound of the liquidity position represented as token 1 per token 0, converted to USD
tick_lower
number
Lower tick of the liquidity position
tick_upper
number
Upper tick of the liquidity position
token_0_address
address
Contract address of token 0
token_0_symbol
text
Symbol of token 0
token_1_address
address
Contract address of token 1
token_1_symbol
text
Symbol of token 1
tokens_owed0_adjusted
number
The uncollected amount of token0 owed to the position as of the last computation.
tokens_owed1_adjusted
number
The uncollected amount of token1 owed to the position as of the last computation
tokens_owed0_usd
number
The uncollected amount of token0 owed to the position as of the last computation, converted to USD.
tokens_owed1_usd
number
The uncollected amount of token1 owed to the position as of the last computation, converted to USD
fee_growth_inside0_last_x128
number
The fee growth of token0 as of the last action on the individual position.
fee_growth_inside1_last_x128
number
The fee growth of token1 as of the last action on the individual position.