Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
Table Details
| Property | Value |
|---|---|
| Table Name | vana.dex.events |
| Table Status | Production-Ready |
| Unique Key | transaction_hash, unique_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| event | VARCHAR(16777216) | Event log name (e.g. mint, burn, swap, sync, flash) |
| project | VARCHAR(16777216) | Name of the project (e.g. uniswap) |
| protocol | VARCHAR(16777216) | Protocol name (e.g. uniswap_v2, uniswap_v3, uniswap_v4) |
| factory_address | VARCHAR(42) | The factory address that deployed the liquidity pool |
| liquidity_pool_address | VARCHAR(42) | The liquidity pool address which emitted the event |
| owner_address | VARCHAR(42) | Owner address |
| sender_address | VARCHAR(42) | Address of the sender of the event log, which can be the Router |
| recipient_address | VARCHAR(42) | Address of the recipient of the event log, which can be the Router |
| token0_address | VARCHAR(42) | Token0 contract address |
| token0_name | VARCHAR(16777216) | Token0 name |
| token0_symbol | VARCHAR(16777216) | Token0 symbol |
| 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 the time of the event |
| token1_address | VARCHAR(42) | Token1 contract address |
| token1_name | VARCHAR(16777216) | Token1 name |
| token1_symbol | VARCHAR(16777216) | Token1 symbol |
| 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 the time of the event |
| usd_amount | FLOAT | USD value of the event |
| liquidity | VARCHAR(16777216) | Liquidity field (Uniswap V3/V4 concentrated liquidity positions) |
| fee | NUMBER(38,0) | Fee denomination of the pool (Uniswap V3/V4) |
| tick_spacing | NUMBER(38,0) | Tick spacing of the pool (Uniswap V3/V4) |
| sqrt_price_x96 | VARCHAR(16777216) | Square-root price in Q64.96 fixed-point representation (Uniswap V3/V4) |
| tick | FLOAT | Current price tick of the pool (Uniswap V3/V4) |
| tick_lower | FLOAT | The lower tick of the position (Uniswap V3/V4) |
| tick_upper | FLOAT | The upper tick of the position (Uniswap V3/V4) |
| price_lower_0_1 | VARCHAR(16777216) | Lower bound price of token0 per token1 |
| price_upper_0_1 | VARCHAR(16777216) | Upper bound price of token0 per token1 |
| price_lower_1_0 | VARCHAR(16777216) | Lower bound price of token1 per token0 |
| price_upper_1_0 | VARCHAR(16777216) | Upper bound price of token1 per token0 |
| transaction_from_address | VARCHAR(42) | The address of the sending party of this transaction |
| transaction_to_address | VARCHAR(42) | The address of the receiving party of this transaction |
| transaction_hash | VARCHAR(66) | Transaction hash of this event |
| transaction_index | NUMBER(38,0) | Transaction index of this event in the block |
| transaction_fees | FLOAT | Fees paid at the transaction level |
| transaction_fees_usd | FLOAT | Fees paid in USD |
| fee_details | VARIANT | Additional fee details of the transaction (gas, gas price, etc.) |
| selector | VARCHAR(16777216) | Call data selector at the transaction level |
| log_index | NUMBER(38,0) | Log index of this event |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of this event |
| block_number | NUMBER(38,0) | Block number of this event |
| block_hash | VARCHAR(66) | Block hash of this event |
| unique_id | VARCHAR(16777216) | Unique ID of each event |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |