Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
| Property | Value |
|---|---|
| Table Name | near.nfts.trades |
| Table Status | Production-Ready |
| Unique Key | block_timestamp, unique_id |
| Clustering Key(s) | block_timestamp::date |
| Search Optimization | buyer_address, seller_address, token_address |
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.
extra_fields segment for purchases involving payout of royalties.| Marketplace |
|---|
| apollo42 |
| fewandfar |
| l2e |
| mitte |
| nft_uniqart |
| paras |
| tradeport |
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
| Column Name | Data Type | Description |
|---|---|---|
| marketplace | VARCHAR(134217728) | The marketplace of the trade. |
| protocol | VARCHAR(134217728) | The protocol of the trade. |
| order_match_type | VARCHAR(134217728) | The type of order match. |
| trade_type | VARCHAR(134217728) | The type of trade. |
| buyer_address | VARCHAR(134217728) | The address of the buyer. |
| seller_address | VARCHAR(134217728) | The address of the seller. |
| token_standard | VARCHAR(134217728) | The standard of the token, e.g. nep-171. |
| token_address | VARCHAR(134217728) | The contract address of the NFT being traded. |
| token_name | VARCHAR(134217728) | The name of the NFT being traded. |
| token_symbol | VARCHAR(134217728) | The symbol of the NFT being traded. |
| token_id | VARCHAR(134217728) | The ID of the NFT being traded. |
| item_quantity | NUMBER(38,0) | The quantity of the NFT being traded. Defaults to 1. |
| currency_address | VARCHAR(134217728) | The contract address of the currency used to pay for the NFT. |
| currency_name | VARCHAR(134217728) | The name of the currency used to pay for the NFT. |
| currency_symbol | VARCHAR(134217728) | The symbol of the currency used to pay for the NFT. |
| raw_price | VARCHAR(134217728) | The raw price of the NFT being traded. |
| price | FLOAT | The price of the NFT being traded. |
| usd_price | FLOAT | The price of the NFT being traded in USD. |
| agg_fees | VARIANT | The aggregate fees of the trade. |
| buyer_fees | VARIANT | The fees paid by the buyer. |
| seller_fees | VARIANT | The fees paid by the seller. |
| extra_fields | VARIANT | The extra fields of the trade. |
| signer_id | VARCHAR(134217728) | The address of the transaction signer. |
| receiver_id | VARCHAR(134217728) | The address of the transaction receiver. |
| transaction_hash | VARCHAR(134217728) | The hash of the transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_height | NUMBER(38,0) | The block height of the transaction. |
| receipt_id | VARCHAR(134217728) | The ID of the receipt. |
| unique_id | VARCHAR(134217728) | The unique ID of the trade. |
| _helper_nft_tokens__updated_at | TIMESTAMP_NTZ(9) | The timestamp of the last update of the NFT tokens. |
| _created_at | TIMESTAMP_NTZ(9) | The timestamp of the entry of the trade in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | The timestamp of the last update of the trade in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
Was this page helpful?