--- title: "Hyperliquid and Lighter Parquet exports" description: "Bring Hyperliquid and Lighter history into your notebooks, backtests and warehouse as Parquet. Keep the research tools and models you already use." canonical_url: "https://0xarchive.io/exports" markdown_url: "https://0xarchive.io/exports.md" route: "/exports" robots: "index, follow" generated_from: "prerendered_html" --- # Bring market history to your research stack. Bring market history into the research stack you already use. Download Hyperliquid and Lighter Parquet selections for notebooks, backtests and warehouse queries. [Browse the Data Catalog](https://0xarchive.io/data/catalog) Parquet exports are purchased separately from API plans. ![BTC](https://0xarchive.io/markets/hyperliquid/BTC.svg) ## BTC trade history · Parquet Hyperliquid core **hyperliquid-btc-trades-20260810.parquet** 14 source trade rows · 5,105 bytes 10 Aug 2026 · 00:00:00.511 to 00:00:14.524 UTC ### SQL result | Direction | BTC size | | --- | --- | | Direction Close Long | BTC size 0.00018 | | Direction Close Short | BTC size 0.00195 | | Direction Long > Short | BTC size 0.00016 | | Direction Open Long | BTC size 0.07003 | | Direction Open Short | BTC size 0.15444 | 10 Aug 2026 · 00:00:00.511 to 00:00:14.524 UTC ## From Parquet to a research result Download the BTC trade file, group trade size by direction with SQL and use the result in your research. The file and query use the same selection. ### SQL ``` SELECT direction, SUM(CAST(size AS DECIMAL(38, 8))) AS btc_size FROM read_parquet('hyperliquid-btc-trades-20260810.parquet') GROUP BY direction; ``` ![BTC](https://0xarchive.io/markets/hyperliquid/BTC.svg) ## BTC trade history · Parquet Hyperliquid core **hyperliquid-btc-trades-20260810.parquet** 14 source trade rows · 5,105 bytes 10 Aug 2026 · 00:00:00.511 to 00:00:14.524 UTC ### SQL result | Direction | BTC size | | --- | --- | | Direction Close Long | BTC size 0.00018 | | Direction Close Short | BTC size 0.00195 | | Direction Long > Short | BTC size 0.00016 | | Direction Open Long | BTC size 0.07003 | | Direction Open Short | BTC size 0.15444 | 10 Aug 2026 · 00:00:00.511 to 00:00:14.524 UTC ## Keep your research stack Query Parquet with DuckDB, pandas or Polars, or load it into your warehouse. Join market history with your signals and execution data. ![BTC](https://0xarchive.io/markets/hyperliquid/BTC.svg) ## BTC trade history · Parquet Hyperliquid core **hyperliquid-btc-trades-20260810.parquet** 14 source trade rows · 5,105 bytes 10 Aug 2026 · 00:00:00.511 to 00:00:14.524 UTC | timestamp | price | size | side | direction | crossed | | --- | --- | --- | --- | --- | --- | | 10 Aug 2026 00:00:00.511 UTC | 64,866 | 0.00195 | B | Close Short | false | | 10 Aug 2026 00:00:02.457 UTC | 64,851 | 0.00304 | A | Open Short | true | | 10 Aug 2026 00:00:02.457 UTC | 64,856 | 0.00016 | A | Long > Short | true | | 10 Aug 2026 00:00:03.728 UTC | 64,852 | 0.00091 | B | Open Long | true | | 10 Aug 2026 00:00:08.205 UTC | 64,834 | 0.00018 | A | Close Long | true | | 10 Aug 2026 00:00:10.082 UTC | 64,837 | 0.00019 | B | Open Long | true | | 10 Aug 2026 00:00:10.690 UTC | 64,838 | 0.06862 | B | Open Long | true | | 10 Aug 2026 00:00:10.690 UTC | 64,837 | 0.00031 | B | Open Long | true | | 10 Aug 2026 00:00:14.524 UTC | 64,839 | 0.03068 | A | Open Short | true | | 10 Aug 2026 00:00:14.524 UTC | 64,839 | 0.01 | A | Open Short | true | | 10 Aug 2026 00:00:14.524 UTC | 64,839 | 0.01 | A | Open Short | true | | 10 Aug 2026 00:00:14.524 UTC | 64,839 | 0.08072 | A | Open Short | true | | 10 Aug 2026 00:00:14.524 UTC | 64,839 | 0.01 | A | Open Short | true | | 10 Aug 2026 00:00:14.524 UTC | 64,839 | 0.01 | A | Open Short | true | 10 Aug 2026 · 00:00:00.511 to 00:00:14.524 UTC ## Choose the history your work needs Select markets, data types and dates in the Data Catalog. Parquet exports are purchased separately from API plans. ## Choose the history your research needs. Select markets, data types and dates in the Data Catalog. [Browse the Data Catalog](https://0xarchive.io/data/catalog) [Parquet exports docs](https://docs.0xarchive.io/data-catalog) [Compare data types](https://0xarchive.io/data-types) [Explore trade history](https://0xarchive.io/data-types/trades) [Explore Hyperliquid L4 books](https://0xarchive.io/data-types/l4-order-books) [Browse the Data Catalog](https://0xarchive.io/data/catalog) [REST market data API](https://0xarchive.io/rest-api) [Hyperliquid Backtesting Data: Reproducible Workflow](https://0xarchive.io/resources/market-data-guides/hyperliquid-historical-data-api-for-backtesting) [Hyperliquid market data](https://0xarchive.io/hyperliquid) [Lighter market data](https://0xarchive.io/lighter)