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

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

<Info>
  * For the flash event, the event log is separated into flash and flash\_paid

  * Columns appended with `_str` are in string format and will retain precision

  * Note that not all columns are applicabel to all events.
</Info>

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