Events
Uniswap v2
Events
Uniswap v2
Get events emitted by Uniswap V2 protocols.
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
_strare 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 |