Documentation Index
Fetch the complete documentation index at: https://docs.allium.so/llms.txt
Use this file to discover all available pages before exploring further.
The lighter.assets.perpetual_market_stats_latest table provides the most recent snapshot for each market. One row per market.
Table Details
| Property | Value |
|---|
| Clustering Key(s) | to_date("funding_timestamp") (base table) |
Table Columns
| Column Name | Description |
|---|
| market_id | Market identifier |
| funding_timestamp | Funding timestamp of the latest snapshot |
| symbol | Market symbol (e.g., BTC, ETH) |
| market_type | ’perp’ or ‘spot’ |
| base_symbol | Base asset symbol |
| quote_symbol | Quote asset symbol |
| collateral_symbol | Collateral asset symbol. NULL for spots |
| base_l1_address | L1 contract address of the base asset. NULL for perpetuals |
Prices
| Column Name | Description |
|---|
| index_price | Latest oracle/index price |
| mark_price | Latest mark price |
| last_trade_price | Latest traded price |
Open Interest & Funding
| Column Name | Description |
|---|
| open_interest | Current open interest in USD |
| current_funding_rate | Current live funding rate estimate |
| funding_rate | Last settled funding rate |
Rolling 24h Metrics
| Column Name | Description |
|---|
| daily_base_token_volume | Rolling 24h volume in base units |
| daily_quote_token_volume | Rolling 24h volume in quote/USD |
| daily_price_low | Rolling 24h price low |
| daily_price_high | Rolling 24h price high |
| daily_price_change | Rolling 24h price change percentage |
| Column Name | Description |
|---|
| _updated_at | Row last-updated timestamp |
Sample Query
SELECT
symbol,
mark_price,
open_interest,
current_funding_rate,
daily_quote_token_volume
FROM lighter.assets.perpetual_market_stats_latest
ORDER BY open_interest DESC
