> ## 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.

# Uniswap v3 Events

### Table Details

| Property | Value |
| - | - |
| Table Name | `polygon.dex.uniswap_v3_events` |
| Table Status | Production-Ready |
| Unique Key | `block_timestamp`, `unique_id` |
| Clustering Key(s) | `block_timestamp::date` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| event | VARCHAR(134217728) | Event log name (e.g. mint, burn, swap, swap, flash, flash\_paid) |
| project | VARCHAR(134217728) | Name of the project (e.g., uniswap) |
| protocol | VARCHAR(134217728) | DEX protocol or project contract (e.g., uniswap\_v3) |
| 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 |
| recipient\_address | VARCHAR(42) | Address of the recipient of the event log |
| token0\_address | VARCHAR(42) | Token0 contract address |
| token0\_name | VARCHAR(134217728) | Token0 name |
| token0\_symbol | VARCHAR(134217728) | Token0 symbol |
| token0\_decimals | NUMBER(38,0) | Token0 decimals |
| token0\_amount\_raw\_str | VARCHAR(134217728) | Token0 amount unnormalized, in string format for precision |
| token0\_amount\_raw | FLOAT | Token0 amount unnormalized |
| token0\_amount\_str | VARCHAR(134217728) | 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(42) | Token1 contract address |
| token1\_name | VARCHAR(134217728) | Token1 name |
| token1\_symbol | VARCHAR(134217728) | Token1 symbol |
| token1\_decimals | NUMBER(38,0) | Token1 decimals |
| token1\_amount\_raw\_str | VARCHAR(134217728) | Token1 amount unnormalized, in string format for precision |
| token1\_amount\_raw | FLOAT | Token1 amount unnormalized |
| token1\_amount\_str | VARCHAR(134217728) | 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 | VARCHAR(134217728) | Liquidity field |
| fee | NUMBER(38,0) | Fee denomination of the pool address |
| tick\_spacing | NUMBER(38,0) | Tick spacing of the pool address |
| sqrt\_price\_x96 | VARCHAR(134217728) | Square root 96 price |
| tick | FLOAT | Price tick |
| tick\_lower | FLOAT | The lower tick of the position |
| tick\_upper | FLOAT | The upper tick of the position |
| price\_lower\_0\_1 | VARCHAR(134217728) | Lower bound price of token0 per token1 |
| price\_upper\_0\_1 | VARCHAR(134217728) | Upper bound price of token0 per token1 |
| price\_lower\_1\_0 | VARCHAR(134217728) | Lower bound price of token1 per token0 |
| price\_upper\_1\_0 | VARCHAR(134217728) | Upper bound price of token1 per token0 |
| transaction\_from\_address | VARCHAR(42) | The sending party address |
| transaction\_to\_address | VARCHAR(42) | The receiving party address |
| transaction\_hash | VARCHAR(66) | Transaction hash |
| transaction\_index | NUMBER(38,0) | Transaction index 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 (gas, gas price, etc.) |
| selector | VARCHAR(134217728) | Call data selector at transaction level |
| log\_index | NUMBER(38,0) | Log index of this trade |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Block timestamp |
| block\_number | NUMBER(38,0) | Block number |
| block\_hash | VARCHAR(66) | Block hash |
| unique\_id | VARCHAR(134217728) | Unique ID of each trade |
| \_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. |

### Related Docs

* [EVM DEX Uniswap v3 Events](/historical-data/supported-blockchains/evm/core-schemas/dex/events/uniswap-v3-events)