| chain | VARCHAR(9) | Slug identifying the blockchain this record belongs to (e.g. ethereum, base, avalanche, solana). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| marketplace | VARCHAR(16777216) | Name of the NFT marketplace where this trade occurred (e.g. opensea, blur, x2y2, looksrare, rarible). |
| protocol | VARCHAR(16777216) | NFT marketplace contract or protocol used to settle this trade (e.g. seaport, x2y2, blur, opensea). Identifies the settlement mechanism, not the collection. |
| 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_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”). |
| 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. |
| 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(16777216) | Contract address of the aggregator used for the trade. Null if no aggregator was involved. |
| extra_fields | VARIANT | JSON object containing additional fields from the onchain event that are not part of the standard schema (e.g. nonce, fee metadata, protocol-specific parameters). |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. Can be null for rows that no transaction creates, such as beacon chain withdrawals or block rewards. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block in which this event was confirmed. |
| 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. |
| _updated_at | TIMESTAMP_LTZ(9) | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |
| _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. |
| _changed_since_full_refresh | BOOLEAN | Flag indicating whether this row was created or modified after the last full refresh of the model. Useful for identifying recently added or updated records in incremental processing. Same concept as _change_since_full_refresh — the column name varies by model generation. |