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
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
Last updated