The Just-in-Time (JIT) liquidity events table contains DEX events from Uniswap V3 protocol for each JIT event.

JIT liquidity refers to the practice where liquidity is added and removed within the same block to capture trading fees and/or exploit arbitrage opportunities. We use the dex.uniswap_v3_events table to construct this table. This table contains all log events emitted from UniswapV3 protocol liquidity pools. We identify JIT events within the same block with the following criteria:

Minting and Burning of LP within the same block.

1. Occur within the same liquidity pool (mint.liquidity_pool_address = burn.liquidity_pool_address).
2. Are initiated by the same user (mint.transaction_from_address = burn.transaction_from_address).
3. Have the burn event occurring after the mint event (mint.transaction_index < burn.transaction_index).

Swaps that occur within the JIT mint + burn event.

The JIT swap event should be performed within the same block as the burn-mint event.

a. Occur within the same liquidity pool:

• swap.liquidity_pool_address = mint.liquidity_pool_address
• swap.liquidity_pool_address = burnt.liquidity_pool_address

b. Occur between the mint and burn JIT:

• swap.transaction_index > mint_transaction_index
• swap.transaction_index < burn_transaction_index

Exclusion of Outliers: This model excludes liquidity provision from rebalancing contracts by Popsicle Finance.