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
Market Information
| 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 |
Metadata
| Column Name | Description |
|---|---|
| _updated_at | Row last-updated timestamp |