Trades

Stellar NFT trades, covering both Classic NFTs (traded on the SDEX orderbook via manage_sell_offer / manage_buy_offer) and Soroban NFTs (traded through smart-contract atomic swaps). Hydrated with NFT metadata (name, image URL parsed from the issuer’s stellar.toml) and USD pricing using the Stellar hourly prices model.

Table Details

Property	Value
Table Name	`stellar.nfts.trades`
Table Status	Production-Ready
Unique Key	`transaction_hash`, `unique_id`

Coverage

Token Standard	Protocol	Detection
classic	stellar_orderbook	NFT-classified assets traded on the SDEX (Litemint, locked-issuer NFTs, supply ≤ 10M stroops)
soroban	soroban	Contracts emitting `token_transfers` rows with `token_id IS NOT NULL` (SEP-50)

Classic NFT trades also appear in stellar.dex.trades. stellar.nfts.trades is the NFT-classified subset. marketplace is currently populated for known Classic marketplaces (e.g. litemint) and is null for Soroban trades until specific contracts are added.

Table Columns

Column Name	Data Type	Description
marketplace	VARCHAR(16777216)	NFT marketplace attributed via the asset’s TOML / issuer mapping (e.g. `litemint`). Null when the asset isn’t attributable to a known marketplace, including all Soroban trades until specific contracts are added.
protocol	VARCHAR(16777216)	Trading-venue protocol. `stellar_orderbook` for SDEX (Classic); `soroban` for Soroban atomic-swap trades.
token_standard	VARCHAR(16777216)	`classic` for Classic Stellar NFTs; `soroban` for Soroban-contract NFTs.
contract_id	VARCHAR(16777216)	Soroban contract address (C-prefixed StrKey). Null for Classic NFTs.
order_match_type	VARCHAR(16777216)	`BUY` or `SELL` from the perspective of the recorded effect (Classic) or `BUY` (Soroban atomic swap).
trade_type	VARCHAR(16777216)	`SINGLE_TRADE` (bundle support deferred to Phase 2).
buyer_address	VARCHAR(16777216)	Stellar G-address of the NFT recipient.
seller_address	VARCHAR(16777216)	Stellar G-address of the NFT sender.
asset_id	VARCHAR(16777216)	Canonical asset identifier. For Classic NFTs, `:`. For Soroban NFTs, the `contract_id`.
asset_code	VARCHAR(16777216)	Asset code (Classic) or null (pure Soroban NFTs).
asset_issuer	VARCHAR(16777216)	Issuer G-address (Classic) or null (pure Soroban NFTs).
token_id	VARCHAR(16777216)	Soroban NFT `token_id` within the contract. Null for Classic NFTs.
token_name	VARCHAR(16777216)	NFT name parsed from the issuer’s `stellar.toml` (Classic) or contract metadata (Soroban). Best-effort.
image_url	VARCHAR(16777216)	NFT image URL parsed from the issuer’s `stellar.toml`. Best-effort.
item_quantity	VARCHAR(16777216)	Quantity of the NFT moved, in raw stroops. For 1-stroop-supply NFTs, `item_quantity = '1'` means the whole NFT. For older 1-whole-unit NFTs, `item_quantity = '10000000'` means the whole NFT.
currency_asset_id	VARCHAR(16777216)	Counter-asset identifier. `XLM` for native, `:` for Classic, `contract_id` for Soroban tokens.
currency_code	VARCHAR(16777216)	Counter-asset code.
currency_decimals	NUMBER(38,0)	Counter-asset decimal precision used to normalize `raw_price`.
raw_price	VARCHAR(16777216)	Counter-asset amount paid for the NFT, in raw units (stroops for Classic / native, contract-defined for Soroban).
price	FLOAT	Counter-asset amount normalized to human units.
usd_price	FLOAT	USD value of the trade based on the hourly counter-asset price. Null if it exceeds the upper sanity limit.
extra_fields	VARIANT	Variant JSON with protocol-specific debug fields (offer_id, sold/bought asset breakdown, Soroban event indices).
ledger_sequence	NUMBER(38,0)	Stellar ledger sequence number.
ledger_close_time	TIMESTAMP_NTZ(9)	Timestamp at which the ledger containing the trade closed.
ledger_hash	VARCHAR(16777216)	Hash of the ledger.
transaction_hash	VARCHAR(16777216)	64-character hex Stellar transaction hash.
transaction_index	NUMBER(38,0)	Index of the transaction within the ledger.
transaction_result	VARCHAR(16777216)	Stellar transaction result code.
operation_id	NUMBER(38,0)	Stellar TOID (Total Order ID) of the operation.
effect_index	NUMBER(38,0)	Index of the effect (Classic) or `token_transfer` event (Soroban) within the transaction.
unique_id	VARCHAR(16777216)	Unique identifier for the trade row.
_created_at	TIMESTAMP_NTZ(9)	Row creation timestamp.
_updated_at	TIMESTAMP_NTZ(9)	Row last-update timestamp.

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Details

Coverage

Table Columns

​Table Details

​Coverage

​Table Columns

Table Details

Coverage

Table Columns