Skip to main content
The dex.uniswap_v2_events table contains swap, sync, mint, and burn events of liquidity pools for projects utilizing the Uniswap v2 protocol. This table is used to track key events such as liquidity addition and removal and sync events which tells the pool balances after each event.
  • 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)
protocolVARCHARProtocol Name (e.g., uniswap_v2)
factory_addressVARCHARThe factory address that deployed the liquidity pool
liquidity_pool_addressVARCHARThe liquidity pool address which emitted the event
owner_addressVARCHAROwner address
sender_addressVARCHARAddress of the sender of the event log, which can be the Router
recipient_addressVARCHARAddress of the recipient of the event log, which can be the Router
token0_addressVARCHARToken0 contract address
token0_nameVARCHARToken0 name
token0_symbolVARCHARToken0 symbol
token0_decimalsINTEGERToken0 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 the time of the event
token1_addressVARCHARToken1 contract address
token1_nameVARCHARToken1 name
token1_symbolVARCHARToken1 symbol
token1_decimalsINTEGERToken1 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 the time of the event
usd_amountFLOATUSD value of the event
transaction_feesFLOATFees paid at the transaction level
transaction_fees_usdFLOATFees paid in USD
fee_detailsOBJECTAdditional fee details of the transaction (gas, gas price, etc.)
selectorVARCHARCall data selector at the transaction level
transaction_from_addressVARCHARThe address of the sending party of this transaction
transaction_to_addressVARCHARThe address of the receiving party of this transaction
transaction_hashVARCHARTransaction hash of this event
transaction_indexINTEGERTransaction index of this event in the block
log_indexINTEGERLog index of this event
block_timestampTIMESTAMP_NTZ(9)Block timestamp of this event
block_numberINTEGERBlock number of this event
block_hashVARCHARBlock hash of this event
unique_idVARCHARUnique ID of each event
created_atTIMESTAMP_NTZ(9)Timestamp of the entry creation
updated_atTIMESTAMP_NTZ(9)Timestamp of the entry update
changed_since_full_refreshBOOLEANBoolean indicator on whether this table was full-refreshed