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

# Events

### Table Details

| Property          | Value                          |
| ----------------- | ------------------------------ |
| Table Name        | `ethereum.dex.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\_name                     | VARCHAR(16777216) | Name of the DEX event that produced this record (e.g. Swap, Mint, Burn).         |
| project                         | VARCHAR(16777216) | Name of the project (e.g. uniswap)                                               |
| protocol                        | VARCHAR(16777216) | Protocol name (e.g. uniswap\_v2, uniswap\_v3, uniswap\_v4)                       |
| liquidity\_pool\_address        | VARCHAR(42)       | The liquidity pool address which emitted the event                               |
| sender                          | VARCHAR(42)       | Address recorded as the sender in the event log (often a router or pool caller). |
| recipient                       | VARCHAR(42)       | Address recorded as the recipient in the event log.                              |
| token0\_address                 | VARCHAR(42)       | Token0 contract address                                                          |
| token0\_symbol                  | VARCHAR(16777216) | Token0 symbol                                                                    |
| token0\_amount\_raw\_str        | VARCHAR(16777216) | Token0 amount unnormalized, in string format for precision                       |
| 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                                                                |
| token1\_address                 | VARCHAR(42)       | Token1 contract address                                                          |
| token1\_symbol                  | VARCHAR(16777216) | Token1 symbol                                                                    |
| token1\_amount\_raw\_str        | VARCHAR(16777216) | Token1 amount unnormalized, in string format for precision                       |
| 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                                                                |
| usd\_amount                     | FLOAT             | USD value of the event                                                           |
| liquidity                       | VARCHAR(16777216) | Liquidity field (Uniswap V3/V4 concentrated liquidity positions)                 |
| id                              | VARIANT           | Pool identifier for Uniswap V4-style events (pool ID including hooks).           |
| liquidity\_details              | VARIANT           | Structured liquidity attributes of the event (protocol-specific).                |
| event\_details                  | VARIANT           | Structured event payload with protocol-specific fields.                          |
| 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                                     |
| 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.            |

### Related Docs

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