| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The block timestamp at which the NFT event occurred. |
| BLOCK_NUMBER | NUMBER | The block number at which the NFT event occurred. |
| VERSION | NUMBER | VERSION column |
| TX_HASH | TEXT | The transaction hash for the NFT event. This is not necessarily unique in this table as a transaction may contain multiple NFT events. |
| EVENT_INDEX | NUMBER | The event number within a transaction |
| EVENT_TYPE | TEXT | The type of NFT event in this transaction, either sale, bid_won or redeem. |
| BUYER_ADDRESS | TEXT | The address of the buyer of the NFT in the transaction. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Used for tracking NFT buyers and purchase activity. Enables user-level analytics, purchase reporting, and marketplace analysis. Supports linking to address labels and user profiles. |
| SELLER_ADDRESS | TEXT | SELLER_ADDRESS column |
| NFT_ADDRESS | TEXT | The contract address of the NFT. |
| TOKEN_VERSION | TEXT | The version of the NFT token. |
| PLATFORM_ADDRESS | TEXT | The contract address of the NFT marketplace or platform where the event occurred. Data type: String Example: 0x1::marketplace::Marketplace 0xabcdef1234567890abcdef1234567890abcdef1234567890abcdef1234567890 Business Context: Used for identifying NFT marketplaces and platforms. Enables platform-level analytics, filtering, and reporting. Supports joining with metadata and project information. |
| PROJECT_NAME | TEXT | The name of the NFT project. This field, along with metadata, will be filled in over time. |
| TOKENID | TEXT | The token ID for this NFT contract. |
| PLATFORM_NAME | TEXT | The name of the NFT marketplace or platform where the event occurred. Data type: String Example: bluemove topaz souffl3 Business Context: Used for grouping and filtering NFT events by platform. Enables platform-level analytics, trend analysis, and reporting. Supports dashboards and user-facing NFT discovery tools. |
| PLATFORM_EXCHANGE_VERSION | TEXT | The version or identifier of the NFT marketplace or platform where the event occurred. Data type: String Example: v1 v2 2023-01-01 Business Context: Used for tracking platform upgrades, changes, and event context. Enables version-level analytics, trend analysis, and reporting. Supports dashboards and user-facing NFT discovery tools. |
| TOTAL_PRICE_RAW | NUMBER | The non-decimal adjusted amount of the NFT event in the currency in which the transaction occurred. Data type: Integer Example: 100000000 (for 1 NFT at 1 unit with 8 decimals) 500000000000000000 (for 0.5 NFT at 18 decimals) Business Context: Used for reconstructing the exact on-chain value of NFT sales or mints. Enables technical audits, protocol analytics, and downstream decimal adjustment. Supports accurate calculation of NFT volumes and value flows. |
| PLATFORM_FEE_RAW | NUMBER | The non-decimal adjusted amount of platform fees paid for this NFT event in the transaction’s currency. Data type: Integer Example: 100000000 (for 1 unit with 8 decimals) 500000000000000000 (for 0.5 unit at 18 decimals) Business Context: Used for reconstructing the exact on-chain value of platform fees. Enables technical audits, protocol analytics, and downstream decimal adjustment. Supports accurate calculation of platform fee volumes and value flows. |
| CREATOR_FEE_RAW | NUMBER | The non-decimal adjusted amount of creator royalty fees paid for this NFT event in the transaction’s currency. Data type: Integer Example: 100000000 (for 1 unit with 8 decimals) 500000000000000000 (for 0.5 unit at 18 decimals) Business Context: Used for reconstructing the exact on-chain value of creator fees. Enables technical audits, protocol analytics, and downstream decimal adjustment. Supports accurate calculation of creator fee volumes and value flows. |
| TOTAL_FEES_RAW | NUMBER | The non-decimal adjusted total amount of fees paid relating to the NFT purchase in the transaction currency. This includes royalty payments to creators and platform fees. Does not include gas fee. Data type: Integer Example: 100000000 (for 1 unit with 8 decimals) 500000000000000000 (for 0.5 unit at 18 decimals) Business Context: Used for reconstructing the exact on-chain value of NFT fees. Enables technical audits, protocol analytics, and downstream decimal adjustment. Supports accurate calcu… |
| AGGREGATOR_NAME | TEXT | The name of the NFT aggregator or routing service involved in the event, if applicable. Data type: String Example: Gem Genie None Business Context: Used for grouping and filtering NFT events by aggregator. Enables aggregator-level analytics, trend analysis, and reporting. Supports dashboards and user-facing NFT discovery tools. |
| CURRENCY_ADDRESS | TEXT | The 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. |
| FACT_NFT_SALES_ID | TEXT | The 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_TIMESTAMP | TIMESTAMP_NTZ | The 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_TIMESTAMP | TIMESTAMP_NTZ | The 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. |
