Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Get events emitted by Sui DEX protocols.
dex.events table contains pool creation, add/remove liquidity events of liquidity pools. This table is used to track key events such as liquidity addition and removal events.
Currently, we support 7 DEX protocols on Sui.
| Property | Value |
|---|---|
| Table Name | sui.dex.events |
| Table Status | Beta 🌱 |
| Unique Key | checkpoint_timestamp, unique_id |
| Clustering Key(s) | checkpoint_timestamp::date |
_str are in string format and will retain precision.unique_id
| Column Name | Data Type | Description |
|---|---|---|
| event | VARCHAR(134217728) | Type of event (e.g., pool_created, add_liquidity, remove_liquidity) |
| project | VARCHAR(134217728) | Name of the project (e.g., cetus, bluemove, bluefin) |
| package_id | VARCHAR(134217728) | The package ID that contains the DEX protocol implementation |
| liquidity_pool_address | VARCHAR(134217728) | The liquidity pool address which emitted the event |
| sender | VARCHAR(134217728) | Address of the sender of the event |
| coin0_type | VARCHAR(134217728) | Coin0 address |
| coin0_name | VARCHAR(134217728) | Coin0 name |
| coin0_symbol | VARCHAR(134217728) | Coin0 symbol |
| coin0_decimals | NUMBER(38,0) | Coin0 decimals |
| coin0_amount_raw_str | VARCHAR(134217728) | Coin0 amount unnormalized, in string format for precision |
| coin0_amount_raw | FLOAT | Coin0 amount unnormalized |
| coin0_amount_str | VARCHAR(134217728) | Coin0 amount normalized, in string format for precision |
| coin0_amount | FLOAT | Coin0 amount normalized |
| coin0_amount_usd | FLOAT | Coin0 USD amount |
| coin0_price_usd | FLOAT | Coin0 hourly USD price at the time of the event |
| coin1_type | VARCHAR(134217728) | Coin1 address |
| coin1_name | VARCHAR(134217728) | Coin1 name |
| coin1_symbol | VARCHAR(134217728) | Coin1 symbol |
| coin1_decimals | NUMBER(38,0) | Coin1 decimals |
| coin1_amount_raw_str | VARCHAR(134217728) | Coin1 amount unnormalized, in string format for precision |
| coin1_amount_raw | FLOAT | Coin1 amount unnormalized |
| coin1_amount_str | VARCHAR(134217728) | Coin1 amount normalized, in string format for precision |
| coin1_amount | FLOAT | Coin1 amount normalized |
| coin1_amount_usd | FLOAT | Coin1 USD amount |
| coin1_price_usd | FLOAT | Coin1 hourly USD price at the time of the event |
| usd_amount | FLOAT | USD value of the event |
| position_id | VARCHAR(134217728) | Unique identifier for the liquidity position |
| liquidity | VARCHAR(134217728) | Liquidity amount in the position |
| tick_lower | FLOAT | Lower tick boundary for concentrated liquidity |
| tick_upper | FLOAT | Upper tick boundary for concentrated liquidity |
| tick_spacing | VARCHAR(134217728) | Tick spacing for the pool |
| gas_fees_mist | VARCHAR(134217728) | Gas fees paid in MIST (Sui’s native token) |
| gas_fees_sui_amount | VARCHAR(134217728) | Gas fees in SUI amount |
| gas_fees_amount_usd | VARCHAR(134217728) | Gas fees in USD |
| transaction_block_digest | VARCHAR(134217728) | Transaction block digest |
| event_seq | NUMBER(38,0) | Event sequence number |
| checkpoint_timestamp | TIMESTAMP_NTZ(9) | Checkpoint timestamp of this event |
| checkpoint_sequence | NUMBER(38,0) | Checkpoint sequence number |
| checkpoint_digest | VARCHAR(134217728) | Checkpoint digest |
| unique_id | VARCHAR(134217728) | Unique ID of each event |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of the entry creation |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of the entry update |
| _changed_since_full_refresh | BOOLEAN | Boolean indicator on whether this table was full-refreshed |
Was this page helpful?