Lighter Historical Data Indexer
Lighter trading history - fills, orders, liquidations and funding - in a SQL-queryable ClickHouse warehouse rather than a daily file dump.
- Direct ClickHouse SQL over the trading history
- Fills with price, size, side and fee
- Order lifecycle and liquidation events
- Funding payments per position
- Custom REST endpoints, quoted per scope
- History since
- 2025-01-17 (mainnet genesis)
- Coverage
- fills · orders · liquidations · funding
- Refresh
- continuous updates
- Interfaces
- ClickHouse SQL + custom REST
- Database name
- lighter
- Free trial
- up to 24h, no card
Lighter publishes its own history export. Why use this?
Their export is a file, ours is a database. Lighter regenerates a global historical-trades archive once a day and hands back a presigned download after a one-time on-chain payment. That is fine for a one-off pull and awkward as a foundation: you rebuild your own storage, your own schema and your own refresh loop. Here you connect a SQL client and query.
How far back does it go?
To 17 January 2025, the Lighter mainnet genesis, and forward continuously from there. Anything that reads as all-time on Lighter is measured from that date.
What can I build with it?
Execution-quality and slippage studies, funding-rate research, liquidation post-mortems, market-maker and taker flow analysis, and leaderboard or PnL analytics. Because it is plain SQL, the same warehouse backs notebooks, BI tools and production services.
How is the Lighter indexer priced and provisioned?
It is not on sale yet - the Lighter indexer is in build. Tell us on Telegram which tables you need and roughly how you will query them: that is what decides what gets decoded first. Billing, when it opens, is the same as everything else here: crypto-only, monthly and prepaid.
Get Lighter Historical Data Indexer.
Set up over Telegram with an engineer — endpoint, token, tuning.