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