Parquet Market Data to JSON for Apps and APIs

Parquet is built for pipelines, not for web pages. When an app needs the prices, JSON is the simplest hand-over.

Open the Parquet to JSON converter, drop the file and download the result. Types are kept: numbers stay numbers and text stays text.

JSON is a list of records, each with named fields. Numbers and true/false stay as such when type detection is on, but ids and codes with leading zeros should stay text. Choose pretty JSON to read it, or compact JSON to save space.

A Parquet file can hold far more rows than a JSON file should. Take a sample with the SQL tool and a LIMIT, or filter to a symbol and date range, and convert only that.

Everything runs in your browser and nothing is uploaded.

Open the Parquet to JSON converter

Related tool pages

JSON, CSV, Parquet and Excel Converter: Convert between JSON, CSV, Parquet and Excel online for free, one file or a whole folder. It runs in your browser, so nothing is uploaded.
JSON to CSV Converter: Convert JSON to CSV in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.
CSV to JSON Converter: Convert CSV to JSON in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.
CSV to Parquet Converter: Convert CSV to Parquet in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.
JSON to Parquet Converter: Convert JSON to Parquet in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded.
Parquet to CSV Converter: Convert Parquet to CSV in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.

How to use the Parquet to JSON converter: step by step

Open the Parquet to JSON converter.
Drop the file.
Check the size of the result.
Download JSON.

When to use the Parquet to JSON converter

Give an app a sample of prices
Inspect a Parquet file as readable text
Make test fixtures
Share a small extract

Example

Input: A Parquet file with the columns id, name and age.

Output: [{"id":1,"name":"Ada","age":36},{"id":2,"name":"Alan","age":41}]

Frequently asked questions

How do I convert Parquet to JSON?

Drop your Parquet file (or paste the data), check the options, click Convert and download the JSON result.

How big can a file be?

It depends on your device. A few hundred MB usually works.

Which conversions does the Format Converter support?

Any direction between JSON, CSV, Parquet and Excel (.xlsx), for one file or a whole folder. Nested JSON is flattened into columns such as address.city. For Excel, the first sheet is read; old .xls files are not supported.

Why did my number or date change after converting?

Types are detected from the values. Turn off "Detect types" to keep everything as text, which also keeps leading zeros in IDs and phone numbers.

Tip: Query a sample with LIMIT first. Do not convert millions of rows to JSON.