Data Delivery & Interfaces
We offer the following delivery methods for historical data for Lighter.Explorer
Via the Allium App or Explorer APIs (Historical Data)
Datashares
Via Snowflake, Databricks, Google Cloud (Historical Data)
Datastreams
Via Kafka, Pub/Sub (Near Realtime Data)
Historical Data CaveatsLighter data is not fully backfilled. Raw (and derived DEX/Assets) data is available from the dates we started ingesting. See Dataset Completeness (Earliest data available) for the minimum timestamp per table.
Data Schemas
| Table Name | Description |
|---|---|
lighter.metrics.overview | Daily metrics including volume, fees, open interest, and liquidations |
lighter.dex.trades | All trades including voluntary trades, liquidations, and deleverages |
lighter.dex.liquidations | Liquidation events only |
lighter.dex.order_books | Flattened order book updates with bid/ask levels |
lighter.assets.perpetual_market_stats | Hourly perpetual market snapshots with prices, OI, and funding |
lighter.assets.perpetual_market_stats_latest | Latest snapshot per market |
lighter.raw.trades | Raw trade data |
lighter.raw.markets | Market metadata |
lighter.raw.order_books | Raw order book snapshots |
lighter.raw.market_stats | Hourly market stats |
lighter.raw.public_pool_data | Public pool data |
lighter.raw.public_pool_info | Public pool info |
lighter.raw.l1_mapping | Account-to-wallet address mapping |