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