The Uniswap v4 LP events table contains Swap, Initialize, OwnershipTransferred, Transfer, ModifyLiquidity, OperatorSet liquidity events for projects utilizing Uniswap v4 protocol.

Column Names

Column NameDescriptionExample
projectName of the projectuniswap
protocolDEX protocol or project contractuniswap_v4
contract_addressThe contract address which emitted the event0x1f98431c8ad98523631ae4a59f267346ea31f984
event_nameName of the emitted eventswap
paramsThe decoded event parameters and their values{"id": "0x4f88...", "liquidityDelta": "555103547015", ...}
hooksHook contract address if applicable0xf8c3f4243c4d8c02831a718a7978fd869f094300
idUnique identifier for the position or operation0x21c67e77068de97969ba93d4aab21826d33ca12bb9f565d8496e8fda8a82ca27
token0_addressToken0 contract address0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
token0_symbolToken0 symbolUSD Coin
token0_nameToken0 nameUSDC
token0_decimalsToken0 decimals18
token0_amount_raw_strToken0 amount unnormalized, in string format for precision137236948882768125807312793371
token0_amount_rawToken0 amount unnormalized1.37E+29
token0_amount_strToken0 amount normalized, in string format for precision137236948883
token0_amountToken0 amount normalized137236948883
token0_amount_usdToken0 USD amount137236.948883
token0_price_usdToken0 hourly USD price at event time1.00
token1_addressToken1 contract address0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2
token1_symbolToken1 symbolWETH
token1_nameToken1 nameWrapped Ether
token1_decimalsToken1 decimals18
token1_amount_raw_strToken1 amount unnormalized, in string format for precision4672111890830594287
token1_amount_rawToken1 amount unnormalized4.67E+18
token1_amount_strToken1 amount normalized, in string format for precision4.672111891
token1_amountToken1 amount normalized4.672111891
token1_amount_usdToken1 USD amount8488.246162
token1_price_usdToken1 hourly USD price at event time1816.79
liquidityLiquidity field4628976692693695648
liquidity_deltaLiquidty delta field16550714
sqrt_price_x96Square root 96 price1351521332041867599613703477231485
transaction_from_addressThe sending party address0x8f64c199659612133a354ca289f355709e16eb47
transaction_to_addressThe receiving party address0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b
transaction_hashTransaction hash0xcd60d3b5885fc734e3154db0412d4da6a2d10907f1e14762813f7e6932c50957
transaction_indexTransaction index in the block3
log_indexLog index of this event31
block_timestampBlock timestamp2023-05-16 20:02:23
block_numberBlock number17274496
block_hashBlock hash0xac8e84d77b973380602f0d7ef3352ae99bef719d4762f7373feb91f2d9e8b2b0
unique_idUnique ID of each eventevent-sync_txn-0xcd60d3b5885fc734e3154db0412d4da6a2d10907f1e14762813f7e6932c50957_log_index-31
_created_atEntry creation timestamp2024-05-28 05:51:11
_updated_atEntry update timestamp2024-05-28 05:51:11
_changed_since_full_refreshBoolean indicator on whether this table was full-refreshedTRUE