Skip to main content
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 NameData TypeDescription
projectVARCHARName of the project (e.g., uniswap)
protocolVARCHARDEX protocol or project contract (e.g., uniswap_v4)
contract_addressVARCHARThe contract address which emitted the event
event_nameVARCHARName of the emitted event
paramsVARIANTThe decoded event parameters and their values
hooksVARCHARHook contract address if applicable
idVARCHARUnique identifier for the position or operation
token0_addressVARCHARToken0 contract address
token0_symbolVARCHARToken0 symbol
token0_nameVARCHARToken0 name
token0_decimalsBIGINTToken0 decimals
token0_amount_raw_strVARCHARToken0 amount unnormalized, in string format for precision
token0_amount_rawFLOATToken0 amount unnormalized
token0_amount_strVARCHARToken0 amount normalized, in string format for precision
token0_amountFLOATToken0 amount normalized
token0_amount_usdFLOATToken0 USD amount
token0_price_usdFLOATToken0 hourly USD price at event time
token1_addressVARCHARToken1 contract address
token1_symbolVARCHARToken1 symbol
token1_nameVARCHARToken1 name
token1_decimalsBIGINTToken1 decimals
token1_amount_raw_strVARCHARToken1 amount unnormalized, in string format for precision
token1_amount_rawFLOATToken1 amount unnormalized
token1_amount_strVARCHARToken1 amount normalized, in string format for precision
token1_amountFLOATToken1 amount normalized
token1_amount_usdFLOATToken1 USD amount
token1_price_usdFLOATToken1 hourly USD price at event time
liquidityVARCHARLiquidity field
sqrt_price_x96VARCHARSquare root 96 price
transaction_from_addressVARCHARThe sending party address
transaction_to_addressVARCHARThe receiving party address
transaction_hashVARCHARTransaction hash
transaction_indexBIGINTTransaction index in the block
log_indexBIGINTLog index of this event
block_timestampTIMESTAMP_NTZ(9)Block timestamp
block_numberBIGINTBlock number
block_hashVARCHARBlock hash
unique_idVARCHARUnique ID of each event
_created_atTIMESTAMP_NTZ(9)Entry creation timestamp
_updated_atTIMESTAMP_NTZ(9)Entry update timestamp
⌘I