NFT Trades

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 Name	Description
marketplace	The marketplace of the trade.
protocol	The protocol of the trade.
order_match_type	The type of order match.
trade_type	The type of trade.
buyer_address	The address of the buyer.
seller_address	The address of the seller.
token_standard	The standard of the token, e.g. nep-171.
token_address	The contract address of the NFT being traded.
token_id	The ID of the NFT being traded.
token_name	The name of the NFT being traded.
token_symbol	The symbol of the NFT being traded.
item_quantity	The quantity of the NFT being traded. Defaults to 1.
currency_address	The contract address of the currency used to pay for the NFT.
currency_name	The name of the currency used to pay for the NFT.
currency_symbol	The symbol of the currency used to pay for the NFT.
raw_price	The raw price of the NFT being traded.
price	The price of the NFT being traded.
usd_price	The price of the NFT being traded in USD.
agg_fees	The aggregate fees of the trade.
buyer_fees	The fees paid by the buyer.
seller_fees	The fees paid by the seller.
extra_fields	The extra fields of the trade.
signer_id	The address of the transaction signer.
receiver_id	The address of the transaction receiver.
transaction_hash	The hash of the transaction.
block_height	The block height of the transaction.
receipt_id	The ID of the receipt.
unique_id	The unique ID of the trade.
_helper_nft_tokens__updated_at	The timestamp of the last update of the NFT tokens.
_created_at	The timestamp of the entry of the trade in the database.
_updated_at	The timestamp of the last update of the trade in the database.

NFTs Transfers

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Marketplace and Protocol Coverage

Sample Query

Model Description

Columns

​Marketplace and Protocol Coverage

​Sample Query

​Model Description

​Columns

Marketplace and Protocol Coverage

Sample Query

Model Description

Columns