Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

The Uniswap v2 LP events table contains swap, sync, mint, and burn events of liquidity for projects utilizing Uniswap v2 protocol.
ethereum.dex.uniswap_v2_protocol_liquidity_pool_events is deprecated and replaced with ethereum.dex.uniswap_v2_events

Column Names

Column NameDescriptionExample
projectName of the project.uniswap
protocolProtocol Name.uniswap_v2
factory_addressThe factory address that deployed the liquidity pool.0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f
liquidity_pool_addressThe liquidity pool address which emitted the event.0x20c2601f8c3357a9d55743a7a5efd4a73721b635
owner_addressOwner address.
sender_addressAddress of the sender of the event log, which can be the Router.
recipient_addressAddress of the recipient of the event log, which can be the Router.
token0_addressToken0 contract address.0x4c1fffa890fe6e8194f6e14aba7aadf4042b6ac5
token0_nameToken0 name.FAMILY
token0_symbolToken0 symbol.FAMILY
token0_decimalsToken0 decimals.18
token0_amount_raw_strToken0 amount unnormalized, in string format for precision.137236948882768125807312793371
token0_amount_rawToken0 amount unnormalized.1.37E+29
token0_amount_strToken0 amount normalized, in string format for precision.137236948883
token0_amountToken0 amount normalized.137236948883
token0_amount_usdToken0 usd amount.
token0_price_usdToken0 hourly USD price at the time of the event.
token1_addressToken1 contract address.0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2
token1_nameToken1 name.Wrapped Ether
token1_symbolToken1 symbol.WETH
token1_decimalsToken1 decimals.18
token1_amount_raw_strToken1 amount unnormalized, in string format for precision.4672111890830594287
token1_amount_rawToken1 amount unnormalized.4.67E+18
token1_amount_strToken1 amount normalized, in string format for precision.4.672111891
token1_amountToken1 amount normalized.4.672111891
token1_amount_usdToken1 usd amount.8488.246162
token1_price_usdToken1 hourly USD price at the time of the event.1816.79
usd_amountUSD value of the event.8488.24616
transaction_feesFees paid at the transaction level.0.008600647975
transaction_fees_usdFees paid in USD.15.62557123
fee_detailsAdditional fee details of the transaction, including max priority fee, gas price and gas used for the transaction.{ "gas": 214154, "gas\_price": 60990582449, "max\_fee\_per\_gas": 85000000000, "max\_priority\_fee\_per\_gas": 2000000000, "receipt\_effective\_gas\_price": 60990582449, "receipt\_gas\_used": 141016 }
selectorCall data selector at the transaction level.0x3593564c
transaction_from_addressThe address of the sending party of this transaction.0x8f64c199659612133a354ca289f355709e16eb47
transaction_to_addressThe address of the receiving party of this transaction (could be a contract address).0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b
transaction_hashTransaction hash of this trade.0xcd60d3b5885fc734e3154db0412d4da6a2d10907f1e14762813f7e6932c50957
transaction_indexTransaction index of this trade in the block.3
log_indexLog index of this trade.31
block_timestampBlock timestamp of this trade.2023-05-16 20:02:23
block_numberBlock number of this trade.17274496
block_hashBlock hash of this trade.0xac8e84d77b973380602f0d7ef3352ae99bef719d4762f7373feb91f2d9e8b2b0
unique_idUnique ID of each trade.event-sync_txn-0xcd60d3b5885fc734e3154db0412d4da6a2d10907f1e14762813f7e6932c50957_log_index-31
_created_atTimestamp of the entry creation.2024-05-28 05:51:11
_updated_atTimestamp of the entry update.2024-05-28 05:51:11
_changed_since_full_refreshBoolean indicator on whether this table was full-refreshed.TRUE