Just-in-Time (JIT) Liquidity Events

Fetch Uniswap V3 JIT Liquidity events with 1 line of code.

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.

Each JIT event includes the following sequence of event

  • User A Minting LP

  • User B Swapping

  • User A Burning LP

More on JIT Liquidity on the Uniswap Protocol

Sample Query

Finding the volume of swaps on Uniswap V3 that were caught in between JIT swaps by liquidity pools.

select 
  date_trunc('week', block_timestamp) as date,
  pool_name,
  sum(jit_swap_volume_usd) as jit_swap_volume_usd
from ethereum.dex.jit_liquidity_events
where project = 'uniswap'
group by all 

Methodology

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 first identify the JIT events within the same block must meet the following criteria:

Minting and Burning of LP within the same block.

  • Occur within the same liquidity pool (mint.liquidity_pool_address = burn.liquidity_pool_address).

  • Are initiated by the same user (mint.transaction_from_address = burn.transaction_from_address).

  • Have the burn event occurring after the mint event (mint.transaction_index < burn.transaction_index).

We then identify swaps that occur within the JIT mint + burn event with the following criteria:

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

  • Occur within the same liquidity pool

    swap.liquidity_pool_address = mint.liquidity_pool_address
    swap.liquidity_pool_address = burnt.liquidity_pool_address
  • 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.

Table Columns

Column Name
Description
Example

block_number

Block number in which the JIT event occurred.

16845762

block_timestamp

Timestamp of the block when the JIT event occurred.

2023-03-17 06:29:47.000

project

UniswapV3 dex project

uniswap

signer

Address of the user initiating the transaction.

0xdd8ef55055e01d39cb87571bd38c43ab9b5903a5

liquidity_pool_address

Address of the liquidity pool involved in the JIT event.

0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640

pool_name

Name of the pool.

Uniswap: USDC-WETH 500

jit_action

Description of the JIT action.

mint -> burn

token0_address

Address of token0.

0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48

token0_symbol

Symbol of token0.

USDC

token0_amount_mint

Amount of token0 minted.

2345520.462846

token0_amount_burn

Amount of token0 burned.

2629536.315217

token0_delta

Net change in token0 amount.

284015.852371

token0_delta_usd

Net change in token0 amount in USD.

283192.206399124

token1_address

Address of token1.

0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2

token1_symbol

Symbol of token1.

WETH

token1_amount_mint

Amount of token1 minted.

1234.538399303

token1_amount_burn

Amount of token1 burned.

1068.503695417

token1_delta

Net change in token1 amount.

-166.034703886

token1_price_usd

Price of token1 in USD.

1703.27

token1_delta_usd

Net change in token1 amount in USD.

-282801.930088262

jit_swaps

Details of swaps occurring between mint and burn events.

[{"event": "swap", "sqrt_price_x96": "1915582285665375426460731590612584", "swapper": "0x477ec82595da308c9d11a096766f391422c8a617", "tick": 201874, "transaction_hash": "0xb3506dba6b6f6a28c6b5e0f9d641ac8e20ff2d14784cf29fcd23921209b02c0e", "transaction_index": 1, "usd_amount": 306517.6173650786}]

jit_swap_volume_usd

Total volume in USD of the swaps.

306517.617365079

jit_swap_count

Number of swaps between mint and burn events.

1

liquidity_mint

Liquidity provided during the mint event.

215578968583683921381

tick_lower_mint

Lower tick boundary for the mint event.

201870

tick_upper_mint

Upper tick boundary for the mint event.

201880

liquidity_burn

Liquidity removed during the burn event.

215578968583683921381

tick_lower_burn

Lower tick boundary for the burn event.

201870

tick_upper_burn

Upper tick boundary for the burn event.

201880

transaction_hash_mint

Transaction hash for the mint event.

0x7a4cd6098168f3ada3e93b67c3ccee07f38c2f564b385d6ef00e8fa7a86eae64

transaction_index_mint

Transaction index for the mint event.

0

log_index_mint

Log index for the mint event.

4

txn_fees_mint

Transaction fees for the mint event.

0.007637103865

txn_fees_usd_mint

Transaction fees in USD for the mint event.

13.0080499

transaction_hash_burn

Transaction hash for the burn event.

0x375394dc79f55b166041ccc0bb2560cfc58a1499a095bdce23470c21f7891de6

transaction_index_burn

Transaction index for the burn event.

2

log_index_burn

Log index for the burn event.

24

txn_fees_burn

Transaction fees for the burn event.

0.003859862509

txn_fees_usd_burn

Transaction fees in USD for the burn event.

6.574388015

Last updated