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 NameDescription

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.

Last updated