| 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(130) | Address of the buyer in this NFT trade. |
| seller_address | VARCHAR(130) | 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(44) | 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 | NUMBER(38,5) | 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(44) | 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. |
| transaction_hash | VARCHAR(88) | 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. |
| wash_trading_score | NUMBER(15,2) | Wash trading score calculated with behaviours-related to wash trading. |
| wash_trading_level | VARCHAR(16777216) | Wash trading level, bucketed from wash_trading_score: very_low (score 0), low (above 0, up to 2), medium (above 2, below 3), high (3 to 4) and very_high (above 4). |
| 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). |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| _updated_at | TIMESTAMP_NTZ(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). |
| _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 | 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. |
| collection_id | VARCHAR(16777216) | ID of the NFT collection. |
| token_metadata | VARCHAR(44) | Address of the token metadata account. |
| is_cnft | BOOLEAN | Where the trade is for a compressed NFT(cNFT) |
| merkle_tree | VARCHAR(44) | Address of the merkle tree for a cNFT |
| leaf_index | NUMBER(38,0) | Leaf index of the asset for a cNFT |
| asset_id | VARCHAR(44) | Identifier for an asset. On Stellar, this is the issuer:code composite identifier for non-native assets. On other chains, may be a contract address or other unique key. |
| signer | VARCHAR(44) | Primary signing account (fee payer) of the transaction. This is the account that authorized the transaction and paid transaction fees. |
| block_height | NUMBER(38,0) | Number of confirmed blocks between this block and the genesis block (inclusive). Unlike block_slot, this only increments for slots that produced a block. |
| txn_index | NUMBER(38,0) | Zero-based position of this transaction within its slot. |
| instruction_index | NUMBER(38,0) | Zero-based position of this instruction within the transaction’s top-level instructions array. |
| inner_instruction_index | NUMBER(38,0) | Zero-based position of this inner instruction within its parent instruction’s inner instructions array. -1 for top-level instructions that are not inner instructions. |
| outer_program_id | VARCHAR(44) | Program ID of the outermost instruction that invoked this inner instruction on Solana |
| _nft_recipient | VARCHAR(130) | Internal column tracking the final NFT recipient address after all transfer hops in a trade settlement. |
| _sales_proceeds_recipient | VARCHAR(130) | Internal column tracking the address that ultimately received the sales proceeds (may differ from seller if royalties or splits apply). |
| raw_sales_proceeds | VARCHAR(16777216) | Sales proceeds in the payment token’s smallest unit (not decimal-adjusted). |
| sales_proceeds | FLOAT | Sales proceeds decimal-adjusted to the payment token’s human-readable unit. |
| usd_sales_proceeds | FLOAT | USD value of the sales proceeds at the time of the trade. |
| inscription_id | VARCHAR(73) | ID of the inscription. |
| inscription_name | VARCHAR(16777216) | Human-readable name of the inscription (e.g. for Ordinals or similar protocols). |
| inscription_number | VARCHAR(16777216) | Ordinal inscription number assigned at time of inscription. Lower numbers are earlier inscriptions. |
| content_type | VARCHAR(16777216) | MIME type of the inscription content (e.g. text/plain, image/png, application/json). |
| content_tag | VARCHAR(16777216) | High-level content category tag for the inscription (e.g. image, text, brc20, domain). |
| content_length | NUMBER(38,0) | Byte length of the inscription content. |
| content_protocol | VARCHAR(16777216) | Protocol under which this inscription was created (e.g. ordinals, brc20, runes). |
| content_parsed | VARIANT | Parsed content of the inscription as a JSON object, for structured protocols like BRC-20 or domain registrations. |
| is_brc20 | BOOLEAN | True if this inscription follows the BRC-20 fungible token standard. |
| is_token | BOOLEAN | True if this inscription represents a fungible token (BRC-20 or similar). |
| token_tick | VARCHAR(16777216) | Ticker symbol of the BRC-20 token inscribed (e.g. ordi, sats). |
| token_amt | VARCHAR(16777216) | Amount of BRC-20 tokens transferred or minted in this inscription operation. |
| sats_per_token_tick | VARCHAR(16777216) | Price in satoshis per unit of this BRC-20 token at the time of the trade. |
| usd_per_token_tick | FLOAT | USD price per unit of this BRC-20 token at the time of the trade. |
| domain_protocol | VARCHAR(16777216) | Protocol under which this domain name was registered (e.g. ens, .sats, .bitmap). |
| domain_name | VARCHAR(16777216) | The domain name string registered in this inscription. |
| domain_namespace | VARCHAR(16777216) | Top-level namespace of the domain (e.g. .eth, .sats, .bitmap). |
| domain_valid | BOOLEAN | True if this domain registration is valid per the protocol’s rules. |
| domain_meta | VARCHAR(16777216) | JSON metadata attached to this domain registration (resolver, TTL, records). |
| is_domain | BOOLEAN | True if this inscription is a domain name registration. |
| sat_types | VARIANT | Array of satoshi type classifications for the sats in this UTXO (e.g. uncommon, rare, epic). |
| sat_types_amounts | VARIANT | Array of amounts corresponding to each sat type in sat_types. |
| is_rune | BOOLEAN | True if this transaction involves a Runes protocol transfer or etching. |
| rune_id | VARCHAR(16777216) | Canonical identifier for a Rune, formatted as <block_height>:<tx_index> (e.g. 840000:3). |
| rune_symbol | VARCHAR(16777216) | Unicode symbol character assigned to this Rune at etching time. |
| spaced_rune | VARCHAR(16777216) | Human-readable Rune name with spacers inserted at configured positions (e.g. UNCOMMON•GOODS). |
| raw_rune_amount | VARCHAR(16777216) | Amount of Runes transferred, in the Rune’s smallest divisible unit. |
| rune_amount | FLOAT | Rune amount decimal-adjusted by the Rune’s divisibility. |
| sats_per_rune | VARCHAR(16777216) | Price in satoshis per unit of this Rune at the time of trade. |
| usd_per_rune | FLOAT | USD price per unit of this Rune at the time of trade. |
| rune_number | VARCHAR(16777216) | Sequential integer assigned to this Rune in the order it was etched, starting from 0. |
| etching_block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block in which this Rune was etched (created). |
| genesis_fee | NUMBER(38,0) | Fee paid in satoshis to etch (create) this Rune or inscription. |
| satoshi_timestamp | TIMESTAMP_NTZ(9) | Timestamp encoded in the satoshi’s ordinal number, representing when this sat was mined. |