lighter_robinhood.assets.perpetual_market_stats_latest table contains the latest perpetual market snapshot for each market.
Table Columns
Unique key:market_id
| Column Name | Data Type | Description |
|---|---|---|
market_id | NUMBER(38,0) | Market identifier. |
funding_timestamp | TIMESTAMP_NTZ(9) | Funding timestamp of the latest snapshot. |
symbol | VARCHAR | Market symbol (e.g., BTC, ETH). |
market_type | VARCHAR | ’perp’ or ‘spot’. |
base_symbol | VARCHAR | Base asset symbol. |
quote_symbol | VARCHAR | Quote asset symbol. |
collateral_symbol | VARCHAR | Collateral asset symbol. NULL for spots. |
base_l1_address | VARCHAR | L1 contract address of the base asset, when applicable. |
index_price | FLOAT | Latest oracle/index price. |
mark_price | FLOAT | Latest mark price. |
last_trade_price | FLOAT | Latest traded price. |
open_interest | FLOAT | Current open interest in USD. |
open_interest_limit | NUMBER(38,0) | Maximum allowed open interest. The value 72057594037927936 indicates no configured limit. |
current_funding_rate | FLOAT | Current live funding rate estimate. |
funding_rate | FLOAT | Last settled funding rate. |
funding_clamp_small | FLOAT | Funding rate lower clamp parameter. |
funding_clamp_big | FLOAT | Funding rate upper clamp parameter. |
daily_base_token_volume | FLOAT | Rolling 24h volume in base units. |
daily_quote_token_volume | FLOAT | Rolling 24h volume in quote/USD. |
daily_price_low | FLOAT | Rolling 24h price low. |
daily_price_high | FLOAT | Rolling 24h price high. |
daily_price_change | FLOAT | Rolling 24h price change percentage. |
_updated_at | TIMESTAMP_NTZ(9) | Timestamp when the row was last updated. |
Sample Query
SELECT
symbol,
mark_price,
open_interest,
current_funding_rate,
daily_quote_token_volume
FROM lighter_robinhood.assets.perpetual_market_stats_latest
ORDER BY open_interest DESC
LIMIT 100;