Skip to main content
Schema: aptos.nft Table: ez_nft_mints Type: View

​
What

​
Description

This table provides enriched NFT mint data for Aptos, combining raw on-chain mint events with token metadata (symbols, decimals) and price information. It includes decimal-adjusted prices, token symbols, and USD values, making it suitable for analytics and reporting.

​
Key Use Cases

  • Analyzing NFT minting activity and project launches in USD
  • Building dashboards for NFT mint volume, user activity, and project trends
  • Comparing mint activity across projects and tokens
  • Supporting NFT research, monitoring, and reporting
  • Powering downstream models for NFT aggregations and analytics

​
Important Relationships

  • Sources raw mint data from nft.fact_nft_mints
  • Joins token metadata from core.dim_tokens for symbol/decimals
  • Joins price data from price.ez_prices_hourly for USD values
  • Can be related to NFT sales data in nft.ez_nft_sales for lifecycle analysis

​
Commonly-used Fields

  • tx_hash, event_index: Unique identifiers for each mint event
  • nft_address, tokenid: NFT contract and token identifiers
  • nft_from_address, nft_to_address: Addresses involved in the mint
  • block_timestamp: Time of the mint event
  • project_name: Name of the NFT project
  • total_price, total_price_usd: Decimal-adjusted and USD value of mint price

​
Columns

Column NameData TypeDescription
BLOCK_TIMESTAMPTIMESTAMP_NTZThe block timestamp at which the NFT event occurred.
BLOCK_NUMBERNUMBERThe block number at which the NFT event occurred.
VERSIONNUMBERVERSION column
TX_HASHTEXTThe transaction hash for the NFT event. This is not necessarily unique in this table as a transaction may contain multiple NFT events.
EVENT_INDEXNUMBERThe event number within a transaction
EVENT_TYPETEXTThe type of NFT event in this transaction, either sale, bid_won or redeem.
NFT_FROM_ADDRESSTEXTThe account address that sent or originated the NFT in a mint or transfer event. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Used for tracking NFT creators, senders, and transferors. Enables user-level analytics, provenance, and ownership history. Supports linking to address labels and user profiles.
NFT_TO_ADDRESSTEXTThe account address that received the NFT in a mint or transfer event. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Used for tracking NFT recipients, buyers, and new owners. Enables user-level analytics, ownership history, and transfer analysis. Supports linking to address labels and user profiles.
NFT_ADDRESSTEXTThe contract address of the NFT.
TOKEN_VERSIONTEXTThe version of the NFT token.
PROJECT_NAMETEXTThe name of the NFT project. This field, along with metadata, will be filled in over time.
TOKENIDTEXTThe token ID for this NFT contract.
NFT_COUNTNUMBERThe number of NFTs minted in this event. Data type: Integer Example: 1 10 Business Context: Used for quantifying NFT minting activity and project launches. Enables project-level analytics, trend analysis, and reporting. Supports dashboards and user-facing NFT discovery tools.
TOTAL_PRICEFLOATThe price of the NFT event (mint or sale), in decimal-adjusted units of the transaction currency. Data type: Decimal Example: 1.0 (for 1 unit of the transaction currency) 0.25 (for 0.25 units of the transaction currency) Business Context: Used for financial analysis, reporting, and cross-project comparisons. Enables value-based analytics and aggregation of NFT volumes in native currency terms. Supports dashboards and business intelligence for NFT marketplaces.
TOTAL_PRICE_USDFLOATThe price of the NFT event (mint or sale), converted to USD at the time of the transaction. Data type: Decimal Example: 100.00 (for $100 sale) 0.50 (for $0.50 mint) Business Context: Used for financial analysis, reporting, and cross-project comparisons. Enables value-based analytics and aggregation of NFT volumes in USD terms. Supports dashboards and business intelligence for NFT marketplaces.
CURRENCY_ADDRESSTEXTThe contract address of the currency used for the NFT event (mint or sale). Data type: String Example: 0x1::aptos_coin::AptosCoin 0xabcdef1234567890abcdef1234567890abcdef1234567890abcdef1234567890 Business Context: Used for identifying the payment currency for NFT events. Enables currency-level analytics, filtering, and reporting. Supports joining with token metadata and price information.
EZ_NFT_MINTS_IDTEXTThe unique primary key identifier for each row in the table, ensuring data integrity and uniqueness. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Essential for data integrity and unique row identification. Critical for join operations and data relationship management. Enables precise data retrieval and referential integrity maintenance.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp when the row was inserted into the table, representing when the data was first recorded. Data type: Timestamp Example: 2024-01-15 14:30:25.123456 Business Context: Essential for data lineage tracking and insertion timing analysis. Critical for understanding data freshness and processing delays. Enables data quality analysis and processing performance monitoring.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe UTC timestamp when the row was last modified, representing when the data was most recently updated. Data type: Timestamp Example: 2024-01-15 14:30:25.123456 Business Context: Essential for data freshness analysis and update tracking. Critical for understanding data modification patterns and change frequency. Enables data quality monitoring and update performance analysis.