Table Details
| Property | Value |
|---|---|
| Table Name | unichain_sepolia.dex.uniswap_v4_events |
| Table Status | Beta 🌱 |
| Unique Key | block_timestamp, unique_id |
| Clustering Key(s) | block_timestamp::date |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR(16777216) | Name of the project (e.g., uniswap) |
| protocol | VARCHAR(16777216) | DEX protocol or project contract (e.g., uniswap_v4) |
| contract_address | VARCHAR(16777216) | The contract address which emitted the event |
| event_name | VARCHAR(16777216) | Name of the emitted event |
| params | VARIANT | The decoded event parameters and their values |
| hooks | VARCHAR(16777216) | Hook contract address if applicable |
| id | VARCHAR(16777216) | Unique identifier for the position or operation |
| token0_address | VARCHAR(16777216) | Token0 contract address |
| token0_symbol | VARCHAR(16777216) | Token0 symbol |
| token0_name | VARCHAR(16777216) | Token0 name |
| token0_decimals | NUMBER(38,0) | Token0 decimals |
| token0_amount_raw_str | VARCHAR(16777216) | Token0 amount unnormalized, in string format for precision |
| token0_amount_raw | FLOAT | Token0 amount unnormalized |
| token0_amount_str | VARCHAR(16777216) | 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(16777216) | Token1 contract address |
| token1_symbol | VARCHAR(16777216) | Token1 symbol |
| token1_name | VARCHAR(16777216) | Token1 name |
| token1_decimals | NUMBER(38,0) | Token1 decimals |
| token1_amount_raw_str | VARCHAR(16777216) | Token1 amount unnormalized, in string format for precision |
| token1_amount_raw | FLOAT | Token1 amount unnormalized |
| token1_amount_str | VARCHAR(16777216) | 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 |
| liquidity | VARCHAR(16777216) | Liquidity field |
| liquidity_delta | VARCHAR(16777216) | The change in liquidity for the position (positive for additions, negative for removals) |
| sqrt_price_x96 | VARCHAR(16777216) | Square root 96 price |
| transaction_from_address | VARCHAR(16777216) | The sending party address |
| transaction_to_address | VARCHAR(16777216) | The receiving party address |
| transaction_hash | VARCHAR(16777216) | Transaction hash |
| transaction_index | NUMBER(38,0) | Transaction index in the block |
| log_index | NUMBER(38,0) | Log index of this event |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp |
| block_number | NUMBER(38,0) | Block number |
| block_hash | VARCHAR(66) | Block hash |
| unique_id | VARCHAR(16777216) | Unique ID of each event |
| _created_at | TIMESTAMP_NTZ(9) | Entry creation timestamp |
| _updated_at | TIMESTAMP_NTZ(9) | Entry update timestamp |