Pools 🌱 - Allium Documentation Hub

The dex.pools table contains liquidity pools of DEX protocols indexed by Allium, consolidated into a single table.

Table Details

Property	Value
Table Name	`sui.dex.pools`
Table Status	Beta 🌱
Unique Key	`liquidity_pool_address`

Coverage:

Currently, we support 7 DEX protocols on Sui.

cetus, turbos, momentum, flow_v2, flow_v3, bluemove, bluefin We add new DEX protocols on a case-by-case basis. If you’d like to request support for a specific DEX, please reach out to our team. Your feedback helps inform our roadmap. Unique Key: unique_id

The DEX pools table contains liquidity pool creation events.

Table Columns

Column Name	Data Type	Description
project	VARCHAR(16777216)	The project (decentralized exchange) of the liquidity pool.
protocol	VARCHAR(16777216)	DEX protocol (& version, if applicable) of the contract address.
liquidity_pool_address	VARCHAR(16777216)	The address of the liquidity pool.
transaction_module	VARCHAR(16777216)	The module name where the pool creation event occurred.
package_id	VARCHAR(16777216)	The package ID containing the pool creation logic.
package_event_address	VARCHAR(16777216)	The event address within the package.
coin0_type	VARCHAR(16777216)	The type of the first coin in the pool.
coin0_name	VARCHAR(16777216)	The name of the first coin in the pool.
coin0_symbol	VARCHAR(16777216)	The symbol of the first coin in the pool.
coin0_decimals	NUMBER(38,0)	The decimal places of the first coin in the pool.
coin1_type	VARCHAR(16777216)	The type of the second coin in the pool.
coin1_name	VARCHAR(16777216)	The name of the second coin in the pool.
coin1_symbol	VARCHAR(16777216)	The symbol of the second coin in the pool.
coin1_decimals	NUMBER(38,0)	The decimal places of the second coin in the pool.
coins_array	ARRAY	Array containing the coins in the pool.
tick_spacing	VARCHAR(16777216)	The tick spacing configuration for the pool.
transaction_block_digest	VARCHAR(16777216)	Digest of the transaction block containing this pool creation.
event_seq	NUMBER(38,0)	Sequence number of the event within the transaction.
checkpoint_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the checkpoint containing this pool creation.
checkpoint_sequence	NUMBER(38,0)	Sequence number of the checkpoint.
checkpoint_digest	VARCHAR(16777216)	Digest of the checkpoint.
_created_at	TIMESTAMP_NTZ(9)	Timestamp when the record was created.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when the record was last updated.
date_added	TIMESTAMP_NTZ(9)	Timestamp when the record was added to the dataset.
_changed_since_full_refresh	BOOLEAN	Indicates whether the record has been modified since the last full refresh.