Uniswap v2

Get events emitted by Uniswap V2 protocols.

The dex.uniswap_v2_events table contains swap, sync, mint, and burn events of liquidity pools for projects utilizing the Uniswap v2 protocol. This table is used to track key events such as liquidity addition and removal and sync events which tells the pool balances after each event.

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

  • Note that not all columns are applicabel to all events.

Table Columns

Unique Key: unique_id

Column Name
Data Type
Description

project

VARCHAR

Name of the project (e.g., uniswap)

protocol

VARCHAR

Protocol Name (e.g., uniswap_v2)

factory_address

VARCHAR

The factory address that deployed the liquidity pool

liquidity_pool_address

VARCHAR

The liquidity pool address which emitted the event

owner_address

VARCHAR

Owner address

sender_address

VARCHAR

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

recipient_address

VARCHAR

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

token0_address

VARCHAR

Token0 contract address

token0_name

VARCHAR

Token0 name

token0_symbol

VARCHAR

Token0 symbol

token0_decimals

INTEGER

Token0 decimals

token0_amount_raw_str

VARCHAR

Token0 amount unnormalized, in string format for precision

token0_amount_raw

FLOAT

Token0 amount unnormalized

token0_amount_str

VARCHAR

Token0 amount normalized, in string format for precision

token0_amount

FLOAT

Token0 amount normalized

token0_amount_usd

FLOAT

Token0 USD amount

token0_price_usd

FLOAT

Token0 hourly USD price at the time of the event

token1_address

VARCHAR

Token1 contract address

token1_name

VARCHAR

Token1 name

token1_symbol

VARCHAR

Token1 symbol

token1_decimals

INTEGER

Token1 decimals

token1_amount_raw_str

VARCHAR

Token1 amount unnormalized, in string format for precision

token1_amount_raw

FLOAT

Token1 amount unnormalized

token1_amount_str

VARCHAR

Token1 amount normalized, in string format for precision

token1_amount

FLOAT

Token1 amount normalized

token1_amount_usd

FLOAT

Token1 USD amount

token1_price_usd

FLOAT

Token1 hourly USD price at the time of the event

usd_amount

FLOAT

USD value of the event

transaction_fees

FLOAT

Fees paid at the transaction level

transaction_fees_usd

FLOAT

Fees paid in USD

fee_details

OBJECT

Additional fee details of the transaction (gas, gas price, etc.)

selector

VARCHAR

Call data selector at the transaction level

transaction_from_address

VARCHAR

The address of the sending party of this transaction

transaction_to_address

VARCHAR

The address of the receiving party of this transaction

transaction_hash

VARCHAR

Transaction hash of this event

transaction_index

INTEGER

Transaction index of this event in the block

log_index

INTEGER

Log index of this event

block_timestamp

TIMESTAMP_NTZ(9)

Block timestamp of this event

block_number

INTEGER

Block number of this event

block_hash

VARCHAR

Block hash of this event

unique_id

VARCHAR

Unique ID of each event

created_at

TIMESTAMP_NTZ(9)

Timestamp of the entry creation

updated_at

TIMESTAMP_NTZ(9)

Timestamp of the entry update

changed_since_full_refresh

BOOLEAN

Boolean indicator on whether this table was full-refreshed

Last updated