Overview

Allium provides historical data for Lighter.

Data Delivery & Interfaces

We offer the following delivery methods for historical data for Lighter.

Query historical data in the Allium App.

Via Snowflake, Databricks, Google Cloud (Historical Data)

Via Kafka, Pub/Sub (Near Realtime Data)

Historical availability varies by table. See Dataset Completeness (Earliest data available) for the earliest available date per table.

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

⌘I