Uniswap V3 - Allium Documentation Hub

The dex.uniswap_v3_events table contains swap, sync, mint, collect, burn, initialize, flash, flash_paid events from liquidity pool untilising Uniswap v3 protocol.

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
Note that not all columns are applicabel to all events.

Table Columns

Unique Key: unique_id

Column Name	Data Type	Description
event	VARCHAR	Event log name (e.g. mint, burn, swap, swap, flash, flash_paid)
project	VARCHAR	Name of the project (e.g., uniswap)
protocol	VARCHAR	DEX protocol or project contract (e.g., uniswap_v3)
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
recipient_address	VARCHAR	Address of the recipient of the event log
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 event time
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 event time
usd_amount	FLOAT	USD value of the event
liquidity	FLOAT	Liquidity field
fee	INTEGER	Fee denomination of the pool address
tick_spacing	INTEGER	Tick spacing of the pool address
sqrt_price_x96	FLOAT	Square root 96 price
tick	INTEGER	Price tick
tick_lower	INTEGER	The lower tick of the position
tick_upper	INTEGER	The upper tick of the position
price_lower_0_1	FLOAT	Lower bound price of token0 per token1
price_upper_0_1	FLOAT	Upper bound price of token0 per token1
price_lower_1_0	FLOAT	Lower bound price of token1 per token0
price_upper_1_0	FLOAT	Upper bound price of token1 per token0
transaction_from_address	VARCHAR	The sending party address
transaction_to_address	VARCHAR	The receiving party address
transaction_hash	VARCHAR	Transaction hash
transaction_index	INTEGER	Transaction index 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 (gas, gas price, etc.)
selector	VARCHAR	Call data selector at transaction level
log_index	INTEGER	Log index of this trade
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp
block_number	INTEGER	Block number
block_hash	VARCHAR	Block hash
unique_id	VARCHAR	Unique ID of each trade
created_at	TIMESTAMP_NTZ(9)	Entry creation timestamp
updated_at	TIMESTAMP_NTZ(9)	Entry update timestamp

​Table Columns

Table Columns