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.
Marketplace | Protocol | Event Types |
---|---|---|
Tradeport | Tradeport | 8+ unique event types |
- | Orderbyte | 1 known bid event |
⚠️ 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
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. |