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 Name Data Type Description project VARCHAR Name of the project (e.g., uniswap) protocol VARCHAR Protocol Name (e.g., uniswap_v2) 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, which can be the Router recipient_address VARCHAR Address of the recipient of the event log, which can be the Router 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 the time of the event 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 the time of the event usd_amount FLOAT USD value of the event transaction_fees FLOAT Fees paid at the transaction level transaction_fees_usd FLOAT Fees paid in USD fee_details OBJECT Additional fee details of the transaction (gas, gas price, etc.) selector VARCHAR Call data selector at the transaction level transaction_from_address VARCHAR The address of the sending party of this transaction transaction_to_address VARCHAR The address of the receiving party of this transaction transaction_hash VARCHAR Transaction hash of this event transaction_index INTEGER Transaction index of this event in the block log_index INTEGER Log index of this event block_timestamp TIMESTAMP_NTZ(9) Block timestamp of this event block_number INTEGER Block number of this event block_hash VARCHAR Block hash of this event unique_id VARCHAR Unique ID of each event created_at TIMESTAMP_NTZ(9) Timestamp of the entry creation updated_at TIMESTAMP_NTZ(9) Timestamp of the entry update changed_since_full_refresh BOOLEAN Boolean indicator on whether this table was full-refreshed