Uniswap v3

Get events emitted by Uniswap V3 protocols.

The Uniswap v3 LP events table contains swap, sync, mint, and burn events of liquidity for projects utilizing Uniswap v3 protocol.

polygon.dex.uniswap_v3_protocol_liquidity_pool_events is deprecated and replaced with polygon.dex.uniswap_v3_events

  • For the flash event, the event log is separated into flash and flash_paid

  • Columns appended with _str are in string format and will retain precision

Column Names

Column NameDescriptionExample

event

Event log name. Note that flash event is spearated into flash and flash_paid

swap

project

Name of the project.

uniswap

protocol

DEX protocol or project contract which executed the aggregator trade.

uniswap_v3

factory_address

The factory address that deployed the liquidity pool.

0x1f98431c8ad98523631ae4a59f267346ea31f984

liquidity_pool_address

The liquidity pool address which emitted the event.

0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640

owner_address

Owner address.

sender_address

Address of the sender of the event log, which can be the Router.

0x03f911aedc25c770e701b8f563e8102cfacd62c0

recipient_address

Address of the recipient of the event log, which can be the Router.

0xf3de3c0d654fda23dad170f0f320a92172509127

token0_address

Token0 contract address.

0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48

token0_name

Token0 name.

USD Coin

token0_symbol

Token0 symbol.

USDC

token0_decimals

Token0 decimals.

6

token0_amount_raw_str

Token0 amount unnormalized, in string format for precision.

5036814217

token0_amount_raw

Token0 amount unnormalized.

5036814217

token0_amount_str

Token0 amount normalized, in string format for precision.

5036.814217

token0_amount

Token0 amount normalized.

5036.814217

token0_amount_usd

Token0 usd amount.

5039.836306

token0_price_usd

Token0 hourly USD price at the time of the event.

1.0006

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.

-1.46499E+18

token1_amount_raw

Token1 amount unnormalized.

-1.46E+18

token1_amount_str

Token1 amount normalized, in string format for precision.

-1.46498585

token1_amount

Token1 amount normalized.

-1.46498585

token1_amount_usd

Token1 usd amount.

5043.667935

token1_price_usd

Token1 hourly USD price at the time of the event.

3442.81

usd_amount

USD value of the event.

5039.836306

liquidity

Liquidity field

4628976692693695648

fee

Fee denomination of the pool address.

500

tick_spacing

Tick spacing of the pool address.

10

sqrt_price_x96

Square root 96 price.

1351521332041867599613703477231485

tick

Price tick.

194897

tick_lower

The lower tick of the position.

tick_upper

The upper tick of the position.

price_lower_0_1

Lower bound price of token0 per token1.

price_upper_0_1

Upper bound price of token0 per token1. The tick_lower is used to calculate the price_upper_0_1, where price_upper_0_1 = pow(1.0001, -1 * (tick_lower)) * pow(10,(token1_decimals - token0_decimals))

price_lower_1_0

Lower bound price of token1 per token0. Where price_lower_1_0 = pow(1.0001, (tick_lower)) * pow(10,(token0_decimals - token1_decimals))

price_upper_1_0

Upper bound price of token1 per token0.

transaction_from_address

The address of the sending party of this transaction.

0x91e0859484e4e6e9ff7afa6c6db0a636f83924e1

transaction_to_address

The address of the receiving party of this transaction (could be a contract address).

0xf3de3c0d654fda23dad170f0f320a92172509127

transaction_hash

Transaction hash of this trade.

0xba4e6ad60d4047b64483edb7a60da522ab77c926e42ca3f7faa4acedbf90d438

transaction_index

Transaction index of this trade in the block.

3

transaction_fees

Fees paid at the transaction level.

0.01013343787

transaction_fees_usd

Fees paid in USD.

34.88750123

fee_details

Additional fee details of the transaction, including max priority fee, gas price and gas used for the transaction.

{ "gas": 519926, "gas_price": 27512591954, "max_fee_per_gas": 38787955200, "max_priority_fee_per_gas": 13988113, "receipt_effective_gas_price": 27512591954, "receipt_gas_used": 368320 }

selector

Call data selector at the transaction level.

0xb80c2f09

log_index

Log index of this trade.

34

block_timestamp

Block timestamp of this trade.

2024-03-17 07:17:11

block_number

Block number of this trade.

19453026

block_hash

Block hash of this trade.

0xde8f8cad5c9d3671bcd4f5c8015ccfeb1773840ad80516768ab165e366a28404

unique_id

Unique ID of each trade.

event-swap_txn-0xba4e6ad60d4047b64483edb7a60da522ab77c926e42ca3f7faa4acedbf90d438_log_index-34

_created_at

Timestamp of the entry creation.

2024-05-28 05:45:36

_updated_at

Timestamp of the entry update.

2024-05-28 05:45:36

_changed_since_full_refresh

Boolean indicator on whether this table was full-refreshed.

TRUE

Last updated