Fetch Uniswap V3 JIT Liquidity events with 1 line of code.
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.
mint.liquidity_pool_address = burn.liquidity_pool_address
).
mint.transaction_from_address = burn.transaction_from_address
).
burn
event occurring after the mint
event (mint.transaction_index < burn.transaction_index
).
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 |