Flipside Docs
Search…
What is Flipside?
Our Data
Data Updates
Data Model Overview
Tables
AAVE Tables
Algorand Tables
Astroport Tables
Compound Tables
Ethereum Tables
Ethereum_Core Tables
Ethereum_Sushi Tables
FLOW Tables
Osmosis Tables
Polygon Tables
Solana Tables
Terra Tables
Terraswap Tables
THORChain Tables
Uniswap V3 Tables
Pools
Pool Stats
Positions
LP Actions
Data Tutorials
Flipside App
Getting Started with the Flipside App
Parameterized Queries
Query Editor Shortcuts
Powered By GitBook
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
Previous
Positions
Next - Our Data
Data Tutorials
Last modified 2mo ago
Copy link