Events
Uniswap v3
Events
Uniswap v3
Get events emitted by Uniswap V3 protocols.
The dex.uniswap_v3_events table contains swap, sync, mint, collect, burn, initialize, flash, flash_paid events from liquidity pool untilising Uniswap v3 protocol.
- For the flash event, the event log is separated into flash and flash_paid
- 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 |
|---|---|---|
| event | VARCHAR | Event log name (e.g. mint, burn, swap, swap, flash, flash_paid) |
| project | VARCHAR | Name of the project (e.g., uniswap) |
| protocol | VARCHAR | DEX protocol or project contract (e.g., uniswap_v3) |
| 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 |
| recipient_address | VARCHAR | Address of the recipient of the event log |
| 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 event time |
| 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 event time |
| usd_amount | FLOAT | USD value of the event |
| liquidity | FLOAT | Liquidity field |
| fee | INTEGER | Fee denomination of the pool address |
| tick_spacing | INTEGER | Tick spacing of the pool address |
| sqrt_price_x96 | FLOAT | Square root 96 price |
| tick | INTEGER | Price tick |
| tick_lower | INTEGER | The lower tick of the position |
| tick_upper | INTEGER | The upper tick of the position |
| price_lower_0_1 | FLOAT | Lower bound price of token0 per token1 |
| price_upper_0_1 | FLOAT | Upper bound price of token0 per token1 |
| price_lower_1_0 | FLOAT | Lower bound price of token1 per token0 |
| price_upper_1_0 | FLOAT | Upper bound price of token1 per token0 |
| transaction_from_address | VARCHAR | The sending party address |
| transaction_to_address | VARCHAR | The receiving party address |
| transaction_hash | VARCHAR | Transaction hash |
| transaction_index | INTEGER | Transaction index in the block |
| transaction_fees | FLOAT | Fees paid at the transaction level |
| transaction_fees_usd | FLOAT | Fees paid in USD |
| fee_details | OBJECT | Additional fee details (gas, gas price, etc.) |
| selector | VARCHAR | Call data selector at transaction level |
| log_index | INTEGER | Log index of this trade |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp |
| block_number | INTEGER | Block number |
| block_hash | VARCHAR | Block hash |
| unique_id | VARCHAR | Unique ID of each trade |
| created_at | TIMESTAMP_NTZ(9) | Entry creation timestamp |
| updated_at | TIMESTAMP_NTZ(9) | Entry update timestamp |