Uniswap v4

Get events emitted by Uniswap V4 protocols.

This is currently only available on Unichain Sepolia.

The dex.uniswap_v4_events table contains the following events emitted by UniswapV4 PoolManger:

• OperatorSet, OwnershipTransferred, ProtocolFeeControllerUpdated, Transfer, ProtocolFeeUpdated, Initialize, Swap, ModifyLiquidity, Donate

• 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
project	VARCHAR	Name of the project (e.g., uniswap)
protocol	VARCHAR	DEX protocol or project contract (e.g., uniswap_v4)
contract_address	VARCHAR	The contract address which emitted the event
event_name	VARCHAR	Name of the emitted event
params	VARIANT	The decoded event parameters and their values
hooks	VARCHAR	Hook contract address if applicable
id	VARCHAR	Unique identifier for the position or operation
token0_address	VARCHAR	Token0 contract address
token0_symbol	VARCHAR	Token0 symbol
token0_name	VARCHAR	Token0 name
token0_decimals	BIGINT	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_symbol	VARCHAR	Token1 symbol
token1_name	VARCHAR	Token1 name
token1_decimals	BIGINT	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
liquidity	VARCHAR	Liquidity field
sqrt_price_x96	VARCHAR	Square root 96 price
transaction_from_address	VARCHAR	The sending party address
transaction_to_address	VARCHAR	The receiving party address
transaction_hash	VARCHAR	Transaction hash
transaction_index	BIGINT	Transaction index in the block
log_index	BIGINT	Log index of this event
block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp
block_number	BIGINT	Block number
block_hash	VARCHAR	Block hash
unique_id	VARCHAR	Unique ID of each event
_created_at	TIMESTAMP_NTZ(9)	Entry creation timestamp
_updated_at	TIMESTAMP_NTZ(9)	Entry update timestamp