Trades - Allium Documentation Hub

The DEX trades table contains successful swaps made on decentralized exchanges (DEX), consolidated into a single table.

Table Details

Property	Value
Table Name	`sui.dex.trades`
Table Status	Production-Ready
Unique Key	`checkpoint_timestamp`, `unique_id`
Clustering Key(s)	`checkpoint_timestamp::date`
Search Optimization	`checkpoint_digest`, `project`, `sender_address`

Coverage:

Currently, we support 9 DEX protocols and over 25+ DEX projects on Sui.

Projects	Protocols
cetus, cetus_adapter, daos_sui, movescription, suiai, suiemoji, suipump, moonbags	cetus_protocol
bluefin	bluefin
turbos	turbos
momentum, flowx, kriya, steamm, aftermath, volo, haedal, deepbook, afsui, obric, alphafi, metastable, scallop, suilend, hawal	cetus_aggregator
flowx	flowx_v3
flowx	flowx_v2
bluemove, move_pump	bluemove
deepbook	deepbook
momentum	momentum
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 us prioritize our roadmap.
`_str` columns are numeric fields cast `varchar` to retain precision when summing.
Unique Key: `unique_id`

Table Columns

Column Name	Data Type	Description
project	VARCHAR(134217728)	The project (decentralized exchange) of the liquidity pool that the swap occurred from.
protocol	VARCHAR(134217728)	DEX protocol (& version, if applicable) of the contract address facilitating the swap.
liquidity_pool_address	VARCHAR(134217728)	The aaddress of the liquidity pool holding the asset
sender_address	VARCHAR(134217728)	The address of the sender emitted on the swap event logs.
to_address	VARCHAR(134217728)	Address of the recipient emitted on the swap event logs.
coin_sold_type	VARCHAR(134217728)	Type of the coin sold.
coin_sold_name	VARCHAR(134217728)	Name of the coin sold.
coin_sold_symbol	VARCHAR(134217728)	Symbol of the coin sold.
coin_sold_decimals	NUMBER(38,0)	Coin decimals of the coin sold.
coin_sold_amount_raw_str	VARCHAR(134217728)	Raw amount of coins sold (unnormalized) in string.
coin_sold_amount_raw	FLOAT	Raw amount of coins sold (unnormalized).
coin_sold_amount_str	VARCHAR(134217728)	Amount of coins sold in string.
coin_sold_amount	FLOAT	Amount of coins sold.
usd_sold_amount	FLOAT	Amount of coin sold in USD value.
coin_bought_type	VARCHAR(134217728)	Type of the coin bought.
coin_bought_name	VARCHAR(134217728)	Name of the coin bought.
coin_bought_symbol	VARCHAR(134217728)	Symbol of the coin bought.
coin_bought_decimals	NUMBER(38,0)	Coin decimals of the coin bought.
coin_bought_amount_raw_str	VARCHAR(134217728)	Raw amount of coins bought (unnormalized) in string.
coin_bought_amount_raw	FLOAT	Raw amount of coins bought (unnormalized).
coin_bought_amount_str	VARCHAR(134217728)	Amount of coins bought in string.
coin_bought_amount	FLOAT	Amount of coins bought.
usd_bought_amount	FLOAT	Amount of coin bought in USD value.
usd_amount	FLOAT	USD value of the swap. This field preferentially selects the USD value of Native Assets and Stablecoin (USDT/USDC) tokens.
transaction_block_digest	VARCHAR(134217728)	Digest of the transaction block containing this swap.
event_seq	NUMBER(38,0)	Sequence number of the event within the transaction.
checkpoint_timestamp	TIMESTAMP_NTZ(9)	Timestamp of the checkpoint containing this swap.
checkpoint_sequence	NUMBER(38,0)	Sequence number of the checkpoint.
checkpoint_digest	VARCHAR(134217728)	Digest of the checkpoint.
unique_id	VARCHAR(134217728)	Unique ID of each trade.
_created_at	TIMESTAMP_NTZ(9)	Timestamp when the record was created.
_updated_at	TIMESTAMP_NTZ(9)	Timestamp when the record was last updated.
_changed_since_full_refresh	BOOLEAN	Boolean indicating if the record has changed since the last full refresh.