| marketplace | VARCHAR(16777216) | Name of the NFT marketplace where this trade occurred (e.g. opensea, blur, x2y2, looksrare, rarible). |
| protocol | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| order_match_type | VARCHAR(16777216) | How the order was fulfilled. BUY for a direct purchase at list price; ACCEPT_BID for a seller accepting an existing bid. |
| trade_type | VARCHAR(16777216) | Scope of the trade. SINGLE_TRADE for a single NFT, BUNDLE_TRADE when multiple NFTs are sold together in one transaction. |
| buyer_address | VARCHAR(42) | Address of the buyer in this NFT trade. |
| seller_address | VARCHAR(42) | Address of the seller in this NFT trade. |
| token_standard | VARCHAR(16777216) | Token standard of the NFT. erc721 for non-fungible tokens (unique IDs, balance 0 or 1), erc1155 for semi-fungible tokens (multiple copies per ID). |
| token_address | VARCHAR(42) | Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address. |
| token_id | VARCHAR(16777216) | Identifier for non-fungible tokens (ERC-721) or semi-fungible tokens (ERC-1155). Each unique token_id within a collection represents a distinct asset. |
| token_name | VARCHAR(16777216) | Full name of the token (e.g. “USD Coin”, “Wrapped Ether”). |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the token (e.g. “USDC”, “WETH”). |
| item_quantity | VARCHAR(16777216) | Number of NFT items transferred in this trade. Always 1 for ERC-721; may be greater than 1 for ERC-1155 bundle trades. |
| currency_address | VARCHAR(42) | Contract address of the currency used to pay for the NFT. Native currency (e.g. ETH) is represented as the zero address. |
| currency_symbol | VARCHAR(16777216) | Symbol of the currency used to pay for the NFT (e.g. ETH, WETH, USDC). |
| raw_price | VARCHAR(16777216) | Price paid for the NFT in the currency’s smallest unit (not decimal-adjusted). |
| price | FLOAT | Price per unit of the asset at the time of this event, in USD or in the quote token’s units depending on context. |
| usd_price | FLOAT | USD value of the NFT trade at the time of the transaction. |
| 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. |
| aggregator_name | VARCHAR(16777216) | Name of the aggregator used to route the trade (e.g. gem, blur_aggregator, reservoir). Null or empty if the trade was placed directly on the marketplace. |
| aggregator_address | VARCHAR(42) | Contract address of the aggregator used for the trade. Null if no aggregator was involved. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block_hash | VARCHAR(66) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _helper_nft_tokens__updated_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to the NFT token metadata helper table row referenced by this record. |
| wash_trading_score | NUMBER(15,2) | Wash trading score calculated with behaviours-related to wash trading. |
| wash_trading_level | VARCHAR(16777216) | Wash trading level is divided into five different levels from very low to very high - ‘very low’ if wash_trading_score = 0 ‘low’ if wash_trading_score 4 |
| extra_fields | VARIANT | Protocol-specific fields as a JSON object. Keys: transfer_uuid (transfer identifier, uint128 as varchar, from the event). |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _upstream_created_at | TIMESTAMP_NTZ(9) | Timestamp when the upstream intermediate record feeding this row was first created. |
| _upstream_updated_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to the upstream model that feeds this record. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
| royalty_reg_status | BOOLEAN | Whether the NFT collection has registered royalty enforcement via the Operator Filter Registry (introduced by OpenSea in November 2022). True if the collection opted in; false if not registered or if the trade occurred before block 15907060 (pre-registry). |
| is_opensea_delisted | BOOLEAN | True if the NFT collection has been delisted from OpenSea. |
| token_standard_variant | VARCHAR(16777216) | Specific token standard variant (e.g. erc721, erc1155, cryptopunks). Distinguishes edge cases within the same broad standard. |
| is_sanitized | BOOLEAN | True if this mint passes basic quality filters: not a DeFi protocol mint and not from an OpenSea-delisted collection. Use to filter for organic user-initiated mints. |
