Uniswap V4 - Allium Documentation Hub

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.

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

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

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

​Table Columns

Table Columns