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

# Liquidity Events

### Table Details

| Property     | Value                           |
| ------------ | ------------------------------- |
| Table Name   | `casper.dex.liquidity_events`   |
| Table Status | Production-Ready                |
| Unique Key   | `transaction_hash`, `unique_id` |

### Table Columns

| Column Name              | Data Type         | Description                                                                |
| ------------------------ | ----------------- | -------------------------------------------------------------------------- |
| project                  | VARCHAR(16777216) | Name of the DEX protocol's project (e.g., Casperswap).                     |
| protocol                 | VARCHAR(16777216) | Specific protocol variant or version identifier.                           |
| liquidity\_pool\_address | VARCHAR(16777216) | Address of the liquidity pool contract.                                    |
| event\_type              | VARCHAR(16777216) | Type of liquidity event (e.g., Mint/Add or Burn/Remove).                   |
| sender\_address          | VARCHAR(16777216) | Address that initiated the liquidity event.                                |
| to\_address              | VARCHAR(16777216) | Address that received LP tokens (on add) or underlying tokens (on remove). |
| token0\_address          | VARCHAR(16777216) | Address of token0 (the first token in the pool by sort order).             |
| token0\_name             | VARCHAR(16777216) | Human-readable name of token0.                                             |
| token0\_symbol           | VARCHAR(16777216) | Ticker symbol of token0.                                                   |
| token0\_decimals         | NUMBER(38,0)      | Decimals of token0.                                                        |
| token0\_amount\_raw      | VARCHAR(16777216) | Raw amount of token0 in its smallest unit (no decimal adjustment).         |
| token0\_amount           | FLOAT             | Human-readable amount of token0 adjusted for token decimals.               |
| usd\_amount0             | FLOAT             | USD value of the token0 amount at the time of the event.                   |
| token1\_address          | VARCHAR(16777216) | Address of token1 (the second token in the pool by sort order).            |
| token1\_name             | VARCHAR(16777216) | Human-readable name of token1.                                             |
| token1\_symbol           | VARCHAR(16777216) | Ticker symbol of token1.                                                   |
| token1\_decimals         | NUMBER(38,0)      | Decimals of token1.                                                        |
| token1\_amount\_raw      | VARCHAR(16777216) | Raw amount of token1 in its smallest unit (no decimal adjustment).         |
| token1\_amount           | FLOAT             | Human-readable amount of token1 adjusted for token decimals.               |
| usd\_amount1             | FLOAT             | USD value of the token1 amount at the time of the event.                   |
| usd\_amount              | FLOAT             | Total USD value of the liquidity event (sum of both sides).                |
| transaction\_hash        | VARCHAR(16777216) | Hash of the transaction this event belongs to.                             |
| log\_index               | NUMBER(38,0)      | Index of the event within the transaction.                                 |
| block\_timestamp         | TIMESTAMP\_NTZ(9) | Timestamp of the block this event was included in.                         |
| block\_number            | NUMBER(38,0)      | Height of the block this event was included in.                            |
| block\_hash              | VARCHAR(16777216) | Hash of the block this event was included in.                              |
| unique\_id               | VARCHAR(16777216) | Unique identifier for the row, used for deduplication.                     |