perpetualMarketID | string | Eq, IsOneOf | | The series key of the perpetual-market-funding-rates timeseries model, the exchange and contract symbol joined with an underscore (binance_BTCUSDT). The same id as perpetual-markets where that model covers the contract. (primary key) |
name | string | Eq, IsOneOf, Contains | default | The display name of the market, the exchange name followed by the contract symbol. |
exchangeSlug | string | Eq, IsOneOf | yes | The exchange’s slug, shared by every market on that exchange (gate-io, crypto-com). |
exchange | string | Eq, IsOneOf | yes | The exchange’s short name as used in the id (binance, bybit, okx, hyperliquid). |
exchangeSub | string | Eq, IsOneOf | yes | The venue within the exchange, where one exchange hosts several: ‘main’ on every centralized venue and on core Hyperliquid, the HIP-3 builder code (xyz, para) on a builder market. |
symbol | string | Eq, IsOneOf, Contains | yes | The exchange-native contract symbol. |
baseAsset | string | Eq, IsOneOf | yes | The ticker of the asset the contract tracks, parsed from the contract symbol with contract-size prefixes such as 1000 and k removed (1000PEPEUSDT and kPEPE both read PEPE). Set on every contract. To identify the asset, use baseAssetID, which matches perpetual-markets. |
baseAssetID | string | Eq, IsOneOf | | The unique identifier of the asset the contract tracks, the same as perpetual-markets for the same contract. Null, along with the other resolved base asset columns, where perpetual-markets has no asset for the contract. |
baseAssetName | string | Eq, IsOneOf, Contains | yes | The name of the asset the contract tracks. |
baseAssetSlug | string | Eq, IsOneOf | yes | The URL slug of the asset the contract tracks. |
baseAssetSymbol | string | Eq, IsOneOf, Contains | yes | The ticker symbol of the asset the contract tracks, as the asset record holds it. It can differ in case and spelling from baseAsset. |
baseAssetSerialID | int64 | Eq, IsOneOf | | The numeric serial identifier of the base asset, used by market data services. Join on it to reach the spot markets for the same asset. |
exchangeID | string | Eq, IsOneOf | | The unique identifier of the exchange. |
exchangeName | string | Eq, IsOneOf, Contains | | The display name of the exchange. |
exchangeSerialID | int64 | Eq, IsOneOf | | The numeric serial identifier of the exchange, used by market data services. |
intervalHours | int64 | Eq, IsOneOf | | Hours between the contract’s latest two settlements (1, 2, 4, 8 or 24). Null where neither neighbouring gap is one of those. |