lighter_robinhood.raw.market_stats table contains market statistics including prices, open interest, and funding.
Table Columns
Unique key:funding_timestamp, market_id
| Column Name | Data Type | Description |
|---|---|---|
market_id | NUMBER(38,0) | Market identifier. |
symbol | VARCHAR | Market symbol (e.g., BTC, ETH). |
index_price | VARCHAR | Oracle/index price at snapshot time. |
mark_price | VARCHAR | Mark price for PnL, liquidations, funding. |
open_interest | VARCHAR | Open interest in USD at snapshot time. |
open_interest_limit | VARCHAR | Maximum OI allowed. |
funding_clamp_small | VARCHAR | Funding rate lower clamp parameter. |
funding_clamp_big | VARCHAR | Funding rate upper clamp parameter. |
last_trade_price | VARCHAR | Last traded price at snapshot time. |
current_funding_rate | VARCHAR | Live funding rate at snapshot time. |
funding_rate | VARCHAR | Last settled funding rate. |
funding_timestamp | TIMESTAMP_NTZ(9) | Snapshot timestamp (hourly). |
daily_base_token_volume | VARCHAR | Rolling 24h volume in base token units. |
daily_quote_token_volume | VARCHAR | Rolling 24h volume in quote token / USD. |
daily_price_low | VARCHAR | Rolling 24h price low. |
daily_price_high | VARCHAR | Rolling 24h price high. |
daily_price_change | VARCHAR | Rolling 24h price change percentage. |
_created_at | TIMESTAMP_NTZ(9) | Timestamp when the row was first recorded. |
_updated_at | TIMESTAMP_NTZ(9) | Timestamp when the row was last updated. |
Sample Query
SELECT
market_id,
symbol,
funding_timestamp,
mark_price,
open_interest,
funding_rate
FROM lighter_robinhood.raw.market_stats
WHERE funding_timestamp >= CURRENT_DATE - 1
ORDER BY funding_timestamp DESC
LIMIT 100;