Skip to main content
Schema: hypercore.core Table: dim_perp_markets Type: View

​
What

Reference table of all perpetual futures markets listed on Hyperliquid, including leverage limits, margin configuration, and delisting status. Covers crypto, equity (cash:*), and commodity perpetuals.

​
Key Use Cases

  • Looking up market parameters (max leverage, size precision)
  • Filtering active vs delisted markets
  • Enriching trade data with market metadata
  • Understanding margin mode configuration

​
Important Relationships

  • Joined by core__ez_perp_trades, core__ez_perp_candles, core__ez_perp_funding_rates, core__ez_perp_funding_payments, core__ez_perp_asset_snapshots, core__ez_perp_predicted_fundings, core__ez_perp_l2_book via coin

​
Commonly-used Fields

  • coin: Asset identifier (e.g. BTC, ETH, cash:TSLA)
  • asset_index: Numeric index on the exchange
  • max_leverage: Maximum allowed leverage
  • size_decimals: Decimal precision for order sizes
  • is_delisted: Whether the market has been delisted

​
Columns

Column NameData TypeDescription
COINTEXTRaw asset identifier. Perps use plain ticker (e.g. BTC), spot uses @token_index format (e.g. @2), prelaunch uses xyz:name prefix.
ASSET_INDEXNUMBERNumeric index for the asset on the Hyperliquid exchange.
SIZE_DECIMALSNUMBERDecimal precision for order sizes on this market.
MAX_LEVERAGENUMBERMaximum allowed leverage for this perpetual market.
MARGIN_TABLE_IDNUMBERMargin table reference identifier.
IS_DELISTEDBOOLEANBoolean indicating whether this market or token has been delisted from the exchange.
ONLY_ISOLATEDBOOLEANWhether only isolated margin mode is available for this market.
MARGIN_MODETEXTDefault margin mode for this market.
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was inserted into this table (Snowflake SYSDATE).
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was last modified in this table (Snowflake SYSDATE).
_INVOCATION_IDTEXTdbt invocation identifier for tracking which run produced this record.