Skip to main content
The near.nfts.trades model captures NFT sales from nep-171 compatible tokens. This model provides detailed information about each trade, including marketplace, protocol, and various trade-specific details.
  • Marketplace royalties and fees coverage is nested under the extra_fields segment for purchases involving payout of royalties.

​
Marketplace and Protocol Coverage

Marketplace
apollo42
fewandfar
l2e
mitte
nft_uniqart
paras
tradeport

​
Sample Query

NFT Volume Across Marketplace in the last 90 days. 
select
    date(block_timestamp) as date,
    marketplace,
    sum(usd_price) as usd_volume
from near.nfts.trades
where block_timestamp >= current_timestamp - interval '90 days'
group by all

​
Model Description

NFT trades events NEAR event logs receipt. Broadly, this includes nep-171 compatible tokens.

​
Columns

Column NameDescription
marketplaceThe marketplace of the trade.
protocolThe protocol of the trade.
order_match_typeThe type of order match.
trade_typeThe type of trade.
buyer_addressThe address of the buyer.
seller_addressThe address of the seller.
token_standardThe standard of the token, e.g. nep-171.
token_addressThe contract address of the NFT being traded.
token_idThe ID of the NFT being traded.
token_nameThe name of the NFT being traded.
token_symbolThe symbol of the NFT being traded.
item_quantityThe quantity of the NFT being traded. Defaults to 1.
currency_addressThe contract address of the currency used to pay for the NFT.
currency_nameThe name of the currency used to pay for the NFT.
currency_symbolThe symbol of the currency used to pay for the NFT.
raw_priceThe raw price of the NFT being traded.
priceThe price of the NFT being traded.
usd_priceThe price of the NFT being traded in USD.
agg_feesThe aggregate fees of the trade.
buyer_feesThe fees paid by the buyer.
seller_feesThe fees paid by the seller.
extra_fieldsThe extra fields of the trade.
signer_idThe address of the transaction signer.
receiver_idThe address of the transaction receiver.
transaction_hashThe hash of the transaction.
block_heightThe block height of the transaction.
receipt_idThe ID of the receipt.
unique_idThe unique ID of the trade.
_helper_nft_tokens__updated_atThe timestamp of the last update of the NFT tokens.
_created_atThe timestamp of the entry of the trade in the database.
_updated_atThe timestamp of the last update of the trade in the database.
⌘I