Historical Data

Users can fetch historical data using various REST endpoints, mainly:

Alternatively, you can use export to obtain CSVs containing up to 12 months of trades, or up to 3 months of funding payments, for a specific account index.

Historical Trade Events

For interested parties, you can access parquet files containing trade events (global), up to mainnet genesis (June 26th, 2026), using the historicalTrade endpoint. To obtain access, perform an in-app transfer of 300 USDG to 0x4FD058F25bE85E459ec552cA8e4C696FD1D34125. On-chain transfers are not supported; you must transfer from within the exchange directly (L2Transfer).

Historical Trade Events (Requester Pays)

For those that prefer to use their AWS account, and cover costs per each request themselves, --request-payer requester can be used.

Example request for Lighter on Robinhood Chain:

aws s3 ls s3://rh-mainnet-historical-data-292832245117/trade-daily/ --request-payer requester | tail -3
aws s3 cp s3://rh-mainnet-historical-data-292832245117/trade-daily/date=2026-09-23/trades.parquet /tmp/trades.parquet --request-payer requester

Hourly Open Interest (Requester Pays)

Hourly open interest for every perps market is published to the same bucket under open-interest-hourly/, as one Parquet file per UTC day. Each row is the end-of-hour snapshot of one market:

Column	Type	Description
`hour`	timestamp (UTC)	Start of the hour
`symbol`	string	Market symbol, e.g. `BTC`
`open_interest`	double	Open interest in the base asset
`mark_price`	double	Mark price at the snapshot
`open_interest_usd`	double	`open_interest * mark_price`

Data starts at mainnet genesis (June 26th, 2026) and a new day is added every night.

Example request for Lighter on Robinhood Chain:

aws s3 ls s3://rh-mainnet-historical-data-292832245117/open-interest-hourly/ --request-payer requester | tail -3
aws s3 cp s3://rh-mainnet-historical-data-292832245117/open-interest-hourly/date=2026-10-15/oi.parquet /tmp/oi.parquet --request-payer requester