Trades

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

Coverage:

Currently, we support over 4+ DEX projects on Sui.

Projects
cetus
turbos finance
bluefin
bluemove
flowx (coming soon)
suiswap (coming soon)
kriya (coming soon)

Table Columns

_str columns are numeric fields cast varchar to retain precision when summing.

Unique Key: unique_id

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