| product_id | VARCHAR(16777216) | Internal Allium identifier for the perpetual market’s RWA product (e.g. hip3_cash_gold). Each perpetual market is its own product. Join key to rwa.registry.perpetual_markets. |
| product_name | VARCHAR(16777216) | Human-readable name of the RWA product. |
| product_symbol | VARCHAR(16777216) | Ticker symbol of the product. Groups deployments of the same product across chains. |
| issuer_id | VARCHAR(16777216) | Internal Allium identifier for the issuer of the perpetual market. For Hyperliquid HIP-3 markets, the market deployer (e.g. dreamcash, felix_markets); for Lighter, the venue. |
| issuer_name | VARCHAR(16777216) | Human-readable name of the RWA issuer. |
| asset_class | VARCHAR(16777216) | V2 taxonomy top-level classification based on primary risk factor. Values: rates (interest rate & sovereign debt), equities (equity securities & derivatives), credit (corporate/private debt & lending), fx (foreign exchange), commodities (physical commodities & environmental instruments), private_funds (pooled alternative investment vehicles), real_estate (real property & real estate securities) |
| asset_type | VARCHAR(16777216) | V2 taxonomy granular classification within asset_class. Examples: government_debt_us, money_market_funds_us, equities_cash, corporate_bonds_investment_grade, private_credit, metals, carbon, private_equity, residential_real_estate. See RWA Classification Framework V2 for complete taxonomy. |
| chain | VARCHAR(16777216) | 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. |
| market_identifier | VARCHAR(16777216) | Venue-specific identifier for a perpetual market, used in place of a token contract address. Hyperliquid HIP-3 uses <deployer>:<symbol> (e.g. cash:GOLD); Lighter and Lighter Robinhood use the market symbol (e.g. WHEAT). |
| name | VARCHAR(16777216) | Name of this token or asset. Short alias for token_name used in tables that preserve the original blockchain field naming convention. |
| symbol | VARCHAR(16777216) | Ticker symbol of this token or asset. Short alias for token_symbol used in tables that preserve the original blockchain field naming convention. |
| underlying_asset | VARCHAR(16777216) | Ticker of the real-world asset this product tracks, with wrapper prefixes/suffixes removed (e.g. xNVDA and bNVDA both resolve to NVDA). Used to join RWA tokens and perpetual markets to their reference price feed. Null when the product is not yet classified. |
| tokenization_structure | VARCHAR(16777216) | Legal/economic structure of the product’s on-chain representation. Perpetual markets are always synthetic_swap: a derivative that tracks the price of the underlying, with no custodied asset. |
| issuance_form | VARCHAR(16777216) | How the product exists on-chain: tokenized (a transferable smart-contract token) or recorded (the chain records a position or register entry, with no transferable token). Perpetual markets are always recorded. |
| platform_id | VARCHAR(16777216) | Unique identifier for the platform |
| platform_name | VARCHAR(16777216) | Human-readable name of the platform |
| is_active | BOOLEAN | True when this deployment or market is actively tracked in the Allium RWA registry; false when deprecated or delisted. |
| _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). |
