Flipside Docs
Search
⌃K

Position Collected Fees

uniswapv3.position_collected_fees
These are legacy Polygon tables. See Polygon 2.0 for up-to-date Polygon models.
Fees collected by a Liquidity Provider (LP) on their position. In V3 fees are accrued and collected in each token within the pair. When a pool Collect event is emitted a new record is appended to this table. If a Burn event is emitted in the same transaction as the Collect event the amount of the burn is subtracted from the Collect event token1 and token0 amounts. This allows us to arrive solely at the swap fees collected.
Field
Type
Description
block_id
number
The block number that this Collect was recorded
block_timestamp
timestamp
The block timestamp that this Collect was recorded
tx_id
text
The transaction that contained this Collect
blockchain
text
The blockchain this Collect occurred 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}")
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
amount0_adjusted
number
The amount of token0 collected for swap fees
amount1_adjusted
number
The amount of token1 collected for swap fees
amount0_adjusted_usd
number
The amount of token0 collected for swap fees, converted to USD
amount1_adjusted_usd
number
The amount of token1 collected for swap fees, converted to USD
tick_lower
number
Lower tick of the liquidity position
tick_upper
number
Upper tick of the liquidity position
price_lower
number
Lower bound of the liquidity position represented as token 1 per token 0
price_upper
number
Upper bound of the liquidity position represented as token 1 per token 0
price_lower_usd
number
Lower bound of the liquidity position represented as token 1 per token 0, converted to USD
price_upper_usd
number
Upper bound of the liquidity position represented as token 1 per token 0, converted to USD