Events
Uniswap V2
Get events emitted by Uniswap V2 protocols.
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 Name | Description | Example |
|---|---|---|
| project | Name of the project. | uniswap |
| protocol | Protocol Name. | uniswap_v2 |
| factory_address | The factory address that deployed the liquidity pool. | 0x5c69bee701ef814a2b6a3edd4b1652cb9cc5aa6f |
| liquidity_pool_address | The liquidity pool address which emitted the event. | 0x20c2601f8c3357a9d55743a7a5efd4a73721b635 |
| owner_address | Owner address. | |
| sender_address | Address of the sender of the event log, which can be the Router. | |
| recipient_address | Address of the recipient of the event log, which can be the Router. | |
| token0_address | Token0 contract address. | 0x4c1fffa890fe6e8194f6e14aba7aadf4042b6ac5 |
| token0_name | Token0 name. | FAMILY |
| token0_symbol | Token0 symbol. | FAMILY |
| token0_decimals | Token0 decimals. | 18 |
| token0_amount_raw_str | Token0 amount unnormalized, in string format for precision. | 137236948882768125807312793371 |
| token0_amount_raw | Token0 amount unnormalized. | 1.37E+29 |
| token0_amount_str | Token0 amount normalized, in string format for precision. | 137236948883 |
| token0_amount | Token0 amount normalized. | 137236948883 |
| token0_amount_usd | Token0 usd amount. | |
| token0_price_usd | Token0 hourly USD price at the time of the event. | |
| token1_address | Token1 contract address. | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 |
| token1_name | Token1 name. | Wrapped Ether |
| token1_symbol | Token1 symbol. | WETH |
| token1_decimals | Token1 decimals. | 18 |
| token1_amount_raw_str | Token1 amount unnormalized, in string format for precision. | 4672111890830594287 |
| token1_amount_raw | Token1 amount unnormalized. | 4.67E+18 |
| token1_amount_str | Token1 amount normalized, in string format for precision. | 4.672111891 |
| token1_amount | Token1 amount normalized. | 4.672111891 |
| token1_amount_usd | Token1 usd amount. | 8488.246162 |
| token1_price_usd | Token1 hourly USD price at the time of the event. | 1816.79 |
| usd_amount | USD value of the event. | 8488.24616 |
| transaction_fees | Fees paid at the transaction level. | 0.008600647975 |
| transaction_fees_usd | Fees paid in USD. | 15.62557123 |
| fee_details | Additional 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 } |
| selector | Call data selector at the transaction level. | 0x3593564c |
| transaction_from_address | The address of the sending party of this transaction. | 0x8f64c199659612133a354ca289f355709e16eb47 |
| transaction_to_address | The address of the receiving party of this transaction (could be a contract address). | 0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b |
| transaction_hash | Transaction hash of this trade. | 0xcd60d3b5885fc734e3154db0412d4da6a2d10907f1e14762813f7e6932c50957 |
| transaction_index | Transaction index of this trade in the block. | 3 |
| log_index | Log index of this trade. | 31 |
| block_timestamp | Block timestamp of this trade. | 2023-05-16 20:02:23 |
| block_number | Block number of this trade. | 17274496 |
| block_hash | Block hash of this trade. | 0xac8e84d77b973380602f0d7ef3352ae99bef719d4762f7373feb91f2d9e8b2b0 |
| unique_id | Unique ID of each trade. | event-sync_txn-0xcd60d3b5885fc734e3154db0412d4da6a2d10907f1e14762813f7e6932c50957_log_index-31 |
| _created_at | Timestamp of the entry creation. | 2024-05-28 05:51:11 |
| _updated_at | Timestamp of the entry update. | 2024-05-28 05:51:11 |
| _changed_since_full_refresh | Boolean indicator on whether this table was full-refreshed. | TRUE |