Skip to main content
The lighter.raw.market_stats table contains hourly snapshots of perpetual market statistics.

​
Table Details

PropertyValue
Clustering Key(s)to_date("funding_timestamp")

​
Table Columns

Column NameDescription
market_idMarket identifier
symbolMarket symbol (e.g., BTC, ETH)
index_priceOracle/index price at snapshot time
mark_priceMark price for PnL, liquidations, funding
last_trade_priceLast traded price at snapshot time
open_interestOpen interest in USD at snapshot time
open_interest_limitMaximum OI allowed
current_funding_rateLive funding rate at snapshot time
funding_rateLast settled funding rate
funding_timestampSnapshot timestamp (hourly)
funding_clamp_smallFunding rate lower clamp parameter
funding_clamp_bigFunding rate upper clamp parameter
daily_base_token_volumeRolling 24h volume in base token units
daily_quote_token_volumeRolling 24h volume in quote token / USD
daily_price_lowRolling 24h price low
daily_price_highRolling 24h price high
daily_price_changeRolling 24h price change percentage

​
Sample Query

SELECT
    market_id,
    symbol,
    funding_timestamp,
    mark_price,
    open_interest,
    funding_rate
FROM lighter.raw.market_stats
WHERE funding_timestamp >= CURRENT_DATE - 1
ORDER BY funding_timestamp DESC
LIMIT 100