Overview

These schemas capture enriched DEX events from Uniswap V2, V3, and V4 liquidity pools.

Each event table includes comprehensive token metadata, USD price data, and normalized fields to simplify querying and analysis. This enriched format eliminates the need for additional joins when exploring the data.

Available Event Tables

• Uniswap V2 Events: Contains swap, Sync, Mint, Burn events from Uniswap V2 Liquidity Pools

• Uniswap V3 Events: Contains swap, Sync, Mint, Collect, Burn, Initialize, Flash events from Uniswap V3 Liquidity Pools

• Uniswap V4 Events: Contains OperatorSet, OwnershipTransferred, ProtocolFeeControllerUpdated, Transfer, ProtocolFeeUpdated, Initialize, Swap, ModifyLiquidity, and Donate events from Uniswap V4 PoolManager

For pool creation events, please use the dex.pools table.

Coming Soon

We’re actively working on expanding our DEX pool event coverage to include other major protocols such as:

• Curve Finance

• Algebra

• PancakeSwap

• And more!

If you’d like to request support for a specific DEX protocol, please reach out to our team.

Key Features

• All tables include enriched token information (name, symbol, decimals)

• USD prices are included where applicable

• High-precision values are available with _str suffix columns

• Each event has a unique identifier for easy querying

For specific details about each protocol’s events and schema, please refer to their respective documentation files.

Table Columns

Unique Key: unique_id

Column Name	Data Type	Description
event	VARCHAR	Event log name (e.g. mint, burn, swap, sync, flash)
project	VARCHAR	Name of the project (e.g. uniswap)
protocol	VARCHAR	Protocol name (e.g. uniswap_v2, uniswap_v3, uniswap_v4)
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
liquidity	VARCHAR	Liquidity field (Uniswap V3/V4 concentrated liquidity positions)
fee	INTEGER	Fee denomination of the pool (Uniswap V3/V4)
tick_spacing	INTEGER	Tick spacing of the pool (Uniswap V3/V4)
sqrt_price_x96	VARCHAR	Square-root price in Q64.96 fixed-point representation (Uniswap V3/V4)
tick	FLOAT	Current price tick of the pool (Uniswap V3/V4)
tick_lower	FLOAT	The lower tick of the position (Uniswap V3/V4)
tick_upper	FLOAT	The upper tick of the position (Uniswap V3/V4)
price_lower_0_1	VARCHAR	Lower bound price of token0 per token1
price_upper_0_1	VARCHAR	Upper bound price of token0 per token1
price_lower_1_0	VARCHAR	Lower bound price of token1 per token0
price_upper_1_0	VARCHAR	Upper bound price of token1 per token0
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
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
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