NFTs
Trades
The DEX trades table contains successful swaps made on decentralized exchanges (DEX), consolidated into a single table.
Active Marketplaces
Currently, two major marketplaces are active:- Tradeport
- Bluemove
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.
Table Columns
_str columns are numeric fields cast varchar to retain precision when summing.
Unique Key: unique_id
| Column Name | Description |
|---|---|
| marketplace | Marketplace where this trade occurred. e.g. tradeport |
| protocol | Protocol that was used for this trade e.g. orderbyte |
| package_id | Package ID of the protocol that was used for this trade. |
| event_type | Event type of the protocol that was used for this trade. |
| order_match_type | Type of sales. Registered as ‘BUY’ for direct purchase and ‘ACCEPT_BID’ for bids accepeted. |
| trade_type | Type of trade. SINGLE_TRADE for single token sale or BUNDLE_TRADE when more than 1 token is sold in a transaction |
| buyer_address | Address of the buyer. |
| seller_address | Address of the seller. |
| nft_id | object_id of the NFT. |
| nft_name | Name of the NFT collection. |
| collection_id | ID of the NFT collection. |
| nft_extra_fields | Extra fields of the NFT. |
| coin_type | Type of the currency used in the trade. |
| raw_price | The price of the NFT in the currency used to purchase (not divided by the number of decimals). |
| price | ’raw_price’ divided by the number of decimals of the currency |
| usd_price | The USD price of the NFTs in this trade. |
| extra_fields | Extra fields of the trade. |
| transaction_block_digest | The block digest of the transaction that contains the trade. |
| checkpoint_timestamp | The timestamp of the checkpoint that contains the trade. |
| checkpoint_sequence | The sequence of the checkpoint that contains the trade. |
| checkpoint_digest | The digest of the checkpoint that contains the trade. |
| unique_id | Unique ID of each trade. |
| _created_at | The timestamp of the creation of the trade. |
| _updated_at | The timestamp of the last update of the trade. |
| _helper_nft_tokens__updated_at | The timestamp of the last update of the NFT metadata. |
| _changed_since_full_refresh | Whether the trade has changed since the last full refresh. |