Skip to main content
The lighter.raw.markets table contains market metadata for Lighter.

​
Table Details

PropertyValue
Clustering Key(s)(none)

​
Table Columns

Column NameDescription
market_idUnique market identifier
symbolMarket symbol (e.g., BTC for perps, ETH/USDC for spots)
market_type’perp’ or ‘spot’
base_asset_idBase asset ID
base_l1_addressL1 contract address of base asset. NULL for perpetuals
quote_asset_idQuote asset ID
base_symbolBase asset symbol
quote_symbolQuote asset symbol
collateral_asset_idCollateral asset ID for perpetuals
collateral_symbolCollateral asset symbol (e.g., USDC). NULL for spots
statusMarket status (e.g., ‘active’)
liquidation_feeLiquidation fee parameter
default_initial_margin_fractionDefault initial margin fraction for perpetuals
maintenance_margin_fractionMaintenance margin fraction for perpetuals
closeout_margin_fractionCloseout margin fraction for perpetuals

​
Sample Query

SELECT
    market_id,
    symbol,
    market_type,
    base_symbol,
    quote_symbol,
    collateral_symbol
FROM lighter.raw.markets
ORDER BY market_id