| index | NUMBER(38,0) | Unique market index identifier. |
| market_name | VARCHAR(16777216) | Name of the perpetual market. |
| base_symbol | VARCHAR(16777216) | The base token symbol (e.g., BTC, ETH). |
| quote_symbol | VARCHAR(16777216) | The quote/collateral token symbol (e.g., USDC). |
| dex_name | VARCHAR(16777216) | The HIP-3 DEX name if this is a permissionless perpetual. Empty for native perps. |
| dex_full_name | VARCHAR(16777216) | The full name of the HIP-3 DEX. |
| dex_deployer | VARCHAR(16777216) | The address of the HIP-3 DEX deployer. |
| dex_fee_recipient | VARCHAR(16777216) | The address that receives trading fees for HIP-3 DEX trades. |
| is_hip3 | BOOLEAN | Whether this is a HIP-3 permissionless perpetual market (true) or native (false). |
| max_leverage | NUMBER(38,0) | Maximum leverage allowed for the market. |
| sz_decimals | NUMBER(38,0) | Number of decimals for size/quantity. |
| margin_mode | VARCHAR(16777216) | Margin mode for the market. |
| only_isolated | BOOLEAN | Whether the market only supports isolated margin. |
| is_delisted | BOOLEAN | Whether the market has been delisted. |
| margin_table_id | NUMBER(38,0) | Margin table identifier. |
| collateral_token_index | NUMBER(38,0) | Index of the collateral token in the tokens table. |
| api_category | VARCHAR(16777216) | HIP-3 deployer-supplied category for the market (lowercased). NULL when the deployer has not supplied a category — includes native main-dex perps and HIP-3 venues that have not yet annotated their markets. |
| category | VARCHAR(16777216) | Asset class for the perpetual market. Possible values: crypto, fx, bonds, commodities, preipo, indices, stocks, others. Always populated for HIP-3 and native main-dex markets; new values may appear as deployers introduce new markets. |
| description | VARCHAR(16777216) | Long-form description of the underlying asset for HIP-3 perpetual markets, supplied by the deployer. NULL for native main-dex perpetuals. |
| keywords | ARRAY | Search keywords for HIP-3 perpetual markets, supplied by the deployer. Stored as an array. NULL for native main-dex perpetuals. |
| display_name | VARCHAR(16777216) | Human-readable display name for HIP-3 perpetual markets, supplied by the deployer. NULL for native main-dex perpetuals. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp when the record was first created. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp when the record was last updated. |
