Trades 🌱

NFT trades across all marketplaces aggregated into a single table.

Table Details

Property	Value
Table Name	`sui.nfts.trades`
Table Status	Beta 🌱
Unique Key	`checkpoint_timestamp`, `unique_id`
Clustering Key(s)	`checkpoint_timestamp::date`
Search Optimization	`checkpoint_digest`, `protocol`, `buyer_address`, `seller_address`

Active Marketplaces

Currently, two major marketplaces are active:

Tradeport
Bluemove Both support buy and bid flows, but their event formats are non-standardized and vary even within the same platform.

Buy Events

These represent finalized NFT purchases.

Marketplace	Protocol	Event Source
Tradeport	Tradeport	Custom buy events
Bluemove	Bluemove	Custom buy events
-	Orderbyte	Protocol-level buy events (WIP marketplace attribution)

Events are explicitly named as buy, so detection is straightforward. Attribution to marketplaces via Orderbyte remains a work in progress.

Bid Events

These are settled bids, i.e. when a bid was accepted.

Marketplace	Protocol	Event Types
Tradeport	Tradeport	8+ unique event types
-	Orderbyte	1 known bid event

Aggregator Trades (WIP)

Sui has no native aggregator standard. Current state:

Tradeport acts as an aggregator, routing trades through other marketplaces like Bluemove.
- The Bluemove trade event is still emitted, despite aggregation.
- Aggregator trades are not explicitly marked in logs.
Attribution requires:
- Combining balance changes
- Tracing commission recipients in the transaction block digest
- Possibly recognizing aggregator contracts via known patterns

Work in progress — Allium attribution heuristics are under development. _str columns are numeric fields cast varchar to retain precision when summing. Unique Key: unique_id

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

💡 Events are explicitly named as buy, so detection is straightforward. Attribution to marketplaces via Orderbyte remains a work in progress.

⚠️ Work in progress — Allium attribution heuristics are under development.

Table Columns

Column Name	Data Type	Description
marketplace	VARCHAR(134217728)	Marketplace where this trade occurred. e.g. tradeport
protocol	VARCHAR(134217728)	Protocol that was used for this trade e.g. orderbyte
package_id	VARCHAR(134217728)	Package ID of the protocol that was used for this trade.
event_type	VARCHAR(134217728)	Event type of the protocol that was used for this trade.
order_match_type	VARCHAR(134217728)	Type of sales. Registered as ‘BUY’ for direct purchase and ‘ACCEPT_BID’ for bids accepeted.
trade_type	VARCHAR(134217728)	Type of trade. SINGLE_TRADE for single token sale or BUNDLE_TRADE when more than 1 token is sold in a transaction
buyer_address	VARCHAR(134217728)	Address of the buyer.
seller_address	VARCHAR(134217728)	Address of the seller.
nft_id	VARCHAR(134217728)	object_id of the NFT.
nft_name	VARCHAR(134217728)	Name of the NFT collection.
collection_id	VARCHAR(134217728)	ID of the NFT collection.
nft_extra_fields	VARIANT	Extra fields of the NFT.
coin_type	VARCHAR(134217728)	Type of the currency used in the trade.
raw_price	VARCHAR(134217728)	The price of the NFT in the currency used to purchase (not divided by the number of decimals).
price	FLOAT	’raw_price’ divided by the number of decimals of the currency
usd_price	FLOAT	The USD price of the NFTs in this trade.
extra_fields	VARIANT	Extra fields of the trade.
transaction_block_digest	VARCHAR(134217728)	The block digest of the transaction that contains the trade.
checkpoint_timestamp	TIMESTAMP_NTZ(9)	The timestamp of the checkpoint that contains the trade.
checkpoint_sequence	NUMBER(38,0)	The sequence of the checkpoint that contains the trade.
checkpoint_digest	VARCHAR(134217728)	The digest of the checkpoint that contains the trade.
unique_id	VARCHAR(134217728)	Unique ID of each trade.
_created_at	TIMESTAMP_NTZ(9)	The timestamp of the creation of the trade.
_updated_at	TIMESTAMP_NTZ(9)	The timestamp of the last update of the trade.
_helper_nft_tokens__updated_at	TIMESTAMP_NTZ(9)	The timestamp of the last update of the NFT metadata.
_changed_since_full_refresh	BOOLEAN	Whether the trade has changed since the last full refresh.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Active Marketplaces

Buy Events

Bid Events

Aggregator Trades (WIP)

Table Columns

​Table Details

​Active Marketplaces

​Buy Events

​Bid Events

​Aggregator Trades (WIP)

​Table Columns

Table Details

Active Marketplaces

Buy Events

Bid Events

Aggregator Trades (WIP)

Table Columns