Uniswap v3

Events Included

polygon.dex.uniswap_v3_protocol_liquidity_pool_events contains swap, mint, burn, collect, and flash events emitted by Uniswap v3 protocol pools.

Projects Included

This table includes forks of Uniswap v3 under the project segment.

Signed Token Amounts

token0_amount and token1_amount in this table is multiplied by -1* accordingly. This is to facilitate the calculation of pool TVL changes from events.

TVL Calculation

The 3 main events that contribute to pool balance changes are mint, swap & collect. This is because collect event is emitted during LP-burn and includes the LP burned amount. Users can also collect fees without burning LP (which decreases pool balance without burn event emitted).

Column Names

Column Name	Description
event	Liquidity pool event: mint or burn
project	Name of the project.
liquidity_pool_factory_address	Address of the liquidity pool factory.
liquidity_pool_address	Address of the liquidity pool.
pool_name	Name of the pool.
fee	The fee amount to enable, denominated in hundredths of a bip (i.e. 1e-6).
tick_spacing	The spacing between ticks to be enforced for all pools created with the given fee amount.
sender_address	Address of the sender of the pool event, which can be the Router.
to_address	Address of the recipient of the pool event.
token0_address	Address of token0 in this LP.
token0_name	Name of the token0 in this LP.
token0_symbol	Symbol of token0 in this LP.
token0_amount_raw	How much token0 was required for the minted liquidity, unormalized.
token0_amount_raw_str	How much token0 was required for the minted liquidity, unormalized & in string.
token0_amount	How much token0 was required for the minted liquidity, normalized.
token0_amount_usd	Amount of token0 in USD value.
token1_address	Address of token1 in this LP.
token1_name	Name of the token1 in this LP.
token1_symbol	Symbol of token1 in this LP.
token1_amount_raw	How much token1 was required for the minted liquidity, unormalized.
token1_amount_raw_str	How much token1 was required for the minted liquidity, unormalized & in string.
token1_amount	How much token1 was required for the minted liquidity, normalized.
token1_amount_usd	Amount of token1 in USD value.
usd_amount	Total sum of LP in USD value: token0_amount_usd + token1_amount_usd
liquidity_amount_raw	The amount of unnormalized amount of liquidity minted to the position range.
liquidity_amount	The amount of liquidity minted to the position range.
sqrt_price_x96	The initial sqrt price of the pool, as a Q64.96.
tick_lower	The lower tick of the position.
tick_upper	The upper tick of the position.
price_lower_0_1	Lower bound price of token0 per token1.
price_upper_0_1	Upper bound price of token0 per token1. The tick_lower is used to calculate the price_upper_0_1, where price_upper_0_1 = pow(1.0001, -1 * (tick_lower)) * pow(10,(token1_decimals - token0_decimals))
price_lower_1_0	Lower bound price of token1 per token0. Where price_lower_1_0 = pow(1.0001, (tick_lower)) * pow(10,(token0_decimals - token1_decimals))
price_upper_1_0	Upper bound price of token1 per token0.
token0_price_usd	USD price of token0.
token1_price_usd	USD price of token1.
transaction_from_address	Transaction sender address. I.e. the address of the transaction initiator. (from_address in the raw.transactions field for the transaction_hash of this swap).
transaction_to_address	Transaction receiver. (to_address in the raw.transactions field for the transaction_hash of this swap).
transaction_hash	Transaction hash the pool event.
log_index	Log index of the pool event transaction.
block_timestamp	Block timestamp of the pool event.
block_number	Block number of the pool event.
block_hash	Block hash of the pool event.
unique_id	Unique ID of each event.