Skip to main content
Schema: near.nft Table: ez_nft_sales Type: View

​
Description

This table provides a comprehensive view of all NFT sales on the NEAR Protocol blockchain, combining minting and transfer data with marketplace information, pricing details, and fee structures. The table includes both raw and USD prices, platform fees, royalties, and affiliate information, making it the primary table for NFT marketplace analytics and sales analysis. This easy view eliminates the need for complex joins and calculations, providing ready-to-use data for NFT analytics, reporting, and business intelligence workflows.

​
Key Use Cases

  • NFT marketplace volume analysis and sales performance tracking
  • NFT pricing analysis and market trend identification
  • Platform fee analysis and marketplace economics assessment
  • Royalty tracking and creator revenue analysis
  • Affiliate program analysis and user acquisition tracking
  • Cross-platform NFT sales comparison and performance benchmarking
  • NFT collection performance analysis and market health monitoring

​
Important Relationships

  • Combines data from nft.fact_nft_mints and nft.fact_nft_transfers for comprehensive sales analysis
  • Provides sales data for marketplace analytics and platform comparison
  • Supports nft.dim_nft_contract_metadata with collection context
  • Enables analysis in stats.ez_core_metrics_hourly for NFT metrics
  • Provides foundation for all NFT marketplace analytics and reporting
  • Powers cross-collection analysis and ecosystem mapping

​
Commonly-used Fields

  • price and price_usd: Essential for sales value analysis and market trends
  • block_timestamp: Primary field for time-series analysis and trend detection
  • seller_address and buyer_address: Critical for user behavior analysis and flow tracking
  • platform_name: Important for marketplace comparison and platform analysis
  • token_id and nft_address: Essential for NFT identification and collection analysis
  • platform_fee and royalties: Important for marketplace economics analysis
  • affiliate_id: Useful for affiliate program analysis and user acquisition tracking

​
Columns

Column NameData TypeDescription
RECEIPT_IDTEXTThe identifying hash for a receipt.
BLOCK_IDNUMBERThe height of the chain this block corresponds with.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block began.
TX_HASHTEXTUnique identifier (hash) of this transaction.
SELLER_ADDRESSTEXTThe address the sends the token.
BUYER_ADDRESSTEXTThe receiver of usn token.
PLATFORM_ADDRESSTEXTThe contract address of the NFT marketplace where the sale occurred
PLATFORM_NAMETEXTThe name of the NFT marketplace (e.g., Mintbase, Paras, Apollo42, etc.)
NFT_ADDRESSTEXTThe contract address of the NFT collection
TOKEN_IDTEXTThe identifier of the token being transferred or minted.
PRICEFLOATThe unadjusted price as reported by the source. This should be decimal adjusted to get the real value.
PRICE_USDFLOATThe asset price, in US Dollars.
METHOD_NAMETEXTName of the method(s) approved for use. NULL if permission is FullAccess.
LOGVARIANTLogs (array) for this receipt.
GAS_BURNEDNUMBERUnits of gas (figure is not decimal adjusted, 10^12) attached to the transaction (this is often higher than ‘Gas Used’).
AFFILIATE_IDTEXTAffiliate id
AFFILIATE_AMOUNTFLOATAffiliate amount (currency near)
AFFILIATE_AMOUNT_USDFLOATThe USD value of the affiliate amount at the time of the sale
ROYALTIESOBJECTRoyalties breakdown (currency near)
PLATFORM_FEEFLOATPlatform fee (currency near)
PLATFORM_FEE_USDFLOATThe USD value of the platform fee at the time of the sale
EZ_NFT_SALES_IDTEXTA unique identifier for the record.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe timestamp at which the record was initially created and inserted into this table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe timestamp at which this record was last modified by an internal process.