LP Actions

Search…
LP Actions
uniswapv3.lp_actions
Use this table to track increases and decreases to positions by liquidity providers (LPs) over time. Whenever a Pool Burn or Mint event is triggered on a position a record is appended to this table.
Field
Type
Description
block_id
number
The block number that this lp action was recorded
block_timestamp
timestamp
The block timestamp that this lp action was recorded
tx_id
text
The transaction that contained this lp action
blockchain
text
The blockchain this lp action 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}")
action
text
The type of lp action, either INCREASE_LIQUIDITY (mint) or DECREASE_LIQUIDITY (burn)
liquidity_adjusted
number
The amount of liquidity to mint or burn, decimal adjusted.
liquidity_provider
address
The address of the liquidity provider
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
Positions
Next - Our Data
Address Tags & Labels
Last modified 6mo ago
Copy link