id | string | Eq, IsOneOf | | The series key of the perpetual-markets timeseries model, the exchange and contract symbol joined with an underscore (binance_BTCUSDT). (primary key) |
name | string | Eq, IsOneOf, Contains | default | The display name of the market, the exchange name followed by the contract symbol. |
slug | string | Eq, IsOneOf | yes | The exchange’s slug, shared by every market on that exchange (gate-io, crypto-com). (identifier 1) |
exchange | string | Eq, IsOneOf | yes | The exchange’s short name as used in the id (binance, bybit, okx). |
symbol | string | Eq, IsOneOf, Contains | yes | The exchange-native contract symbol. |
symbolNormalized | string | Eq, IsOneOf, Contains | | The normalized contract symbol, where the exchange provides one. |
baseAssetID | string | Eq, IsOneOf | | The unique identifier of the asset the contract tracks. Null, along with the other base asset columns, where the contract’s ticker matches no asset. |
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. |
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. |
quoteAssetSerialID | int64 | Eq, IsOneOf | | The numeric serial identifier of the quote currency, used by market data services. |
settleAssetSerialID | int64 | Eq, IsOneOf | | The numeric serial identifier of the settlement currency, used by market data services. It is what distinguishes an exchange’s linear and inverse perpetuals on the same pair. |
exchangeSerialID | int64 | Eq, IsOneOf | | The numeric serial identifier of the exchange, used by market data services. |
quoteCurrency | string | Eq, IsOneOf | yes | The currency the contract is quoted in. |
settleCurrency | string | Eq, IsOneOf | | The currency the contract settles in. |
contractType | string | Eq, IsOneOf | | The contract type as reported by the exchange (perpetual or tradfi_perpetual). |
marginType | string | Eq, IsOneOf | | The margin type of the contract, linear or inverse. |
exchangeID | string | Eq, IsOneOf | | The unique identifier of the exchange. |
exchangeName | string | Eq, IsOneOf, Contains | | The display name of the exchange. |