hyperliquid.raw.perpetual_markets table contains perpetual markets metadata including HIP-3 permissionless perpetual DEXes. Spot tokens are in hyperliquid.raw.tokens.
Table Columns
| Column Name | Description |
|---|---|
| index | Unique market index identifier. |
| market_name | Name of the perpetual market. |
| base_symbol | The base token symbol (e.g., BTC, ETH). |
| quote_symbol | The quote/collateral token symbol (e.g., USDC). |
| dex_name | The HIP-3 DEX name if this is a permissionless perpetual. Empty for native perps. |
| dex_full_name | The full name of the HIP-3 DEX. |
| dex_deployer | The address of the HIP-3 DEX deployer. |
| dex_fee_recipient | The address that receives trading fees for HIP-3 DEX trades. |
| is_hip3 | Whether this is a HIP-3 permissionless perpetual market (true) or native (false). |
| max_leverage | Maximum leverage allowed for the market. |
| sz_decimals | Number of decimals for size/quantity. |
| margin_mode | Margin mode for the market. |
| only_isolated | Whether the market only supports isolated margin. |
| is_delisted | Whether the market has been delisted. |
| margin_table_id | Margin table identifier. |
| collateral_token_index | Index of the collateral token in the tokens table. |
| _created_at | Timestamp when the record was first created. |
| _updated_at | Timestamp when the record was last updated. |