Free Data Tools for Quant Analysts: Prepare Price Data, Parquet and Test Fixtures

Before a backtest or a model there is data preparation: price files from different vendors with different columns, gaps, duplicate timestamps and mixed time zones. Most quant work happens in Python, but quick inspection and conversion do not need a notebook. This guide shows how to prepare time series data with free browser tools, and where code remains the better choice.

Open the Data Profiler

Inspect before you load

Open a vendor file in the data profiler and check:

  • Row count against the expected number of trading days or bars.
  • Duplicate timestamps per symbol, which silently double count in joins.
  • Null prices and zero volume.
  • Obvious outliers such as a price ten times its neighbours, often a split or a bad tick.

Standardise and convert

Rename columns to a common schema (`ts`, `symbol`, `open`, `high`, `low`, `close`, `volume`) and fix date formats with the data transformation tool. For storage and speed, convert to Parquet; see CSV to Parquet and financial API JSON to Parquet.

Quick returns and drawdown with SQL

Run SQL on the file in SQL on your files for a fast sanity check, such as simple returns with a window function:

select ts, close, close / lag(close) over (order by ts) - 1 as ret from prices;

Moving averages and drawdown are covered in SQL for financial analysts. Use it for checks; do your real research in your own code where you control adjustments, calendars and look-ahead.

Synthetic data for testing infrastructure

To test a pipeline, loader or dashboard without licensed data, generate fake bars with the test data generator. See synthetic OHLCV data for trading systems. Synthetic data is for software testing, not for evaluating strategies, because it has no real market structure.

Compare two vendors

Export the same symbol and period from two vendors and use data comparison keyed on symbol and timestamp to see where closes disagree.

Limits

These tools do not adjust for splits and dividends, build calendars or avoid look-ahead bias, and they are not a backtesting engine. Large tick datasets can exceed browser memory. Think of them as a fast front door for data, not the research environment.

Open the Data Profiler

Related tool pages

  • CSV Data Quality Checker: Check a CSV for missing values, duplicates, outliers and wrong types in seconds, and share a report. Free, in your browser.
  • Check a CSV for Duplicates and Blanks: Find duplicate rows, empty cells and odd values in a CSV before you use it. See a report per column. Free, in your browser.
  • CSV Data Profiler: Profile a CSV in seconds: column types, missing values, duplicates, outliers and distributions, with a shareable report. Free, in your browser.
  • Open a Large CSV File Online: Open and explore a CSV too big for Excel: see rows and columns, filter with SQL and export. Works for 500 MB and more, in your browser.
  • CSV Viewer Online: Open a CSV file online and see its rows, column types, blanks and duplicates at a glance. Free, private, no upload.
  • Data Profiler Online: Profile a CSV, Excel, JSON or Parquet file online: rows, types, missing values, duplicates and statistics per column. Free, private, large files too.

Also try

How to use the Data Profiler: step by step

  1. Profile the price file.
  2. Standardise columns and timestamps.
  3. Convert to Parquet.
  4. Sanity-check with SQL, then load into your research code.

When to use the Data Profiler

  • Checking vendor price files
  • Converting OHLCV CSV to Parquet
  • Quick returns and drawdown checks
  • Synthetic bars for testing systems

Example

Input: id,name,age 1,Ada,36 2,Alan,41

Output: age: integer, 0% missing, mean 38.5, min 36, max 41

Frequently asked questions

How do I clean OHLCV price data in a CSV?

Profile it for duplicates, nulls and outliers, standardise column names and timestamps, then convert to Parquet for storage.

Can I convert price history to Parquet for free?

Yes. The data transformation tool converts CSV, JSON and Excel to Parquet in your browser.

Can synthetic data be used for backtesting?

No. It is for testing software. It lacks real market structure, so results would mean nothing.

Does it adjust for splits and dividends?

No. Adjustments, calendars and look-ahead control belong in your own research code.

Tip: Check duplicate timestamps per symbol before any join. Duplicates there quietly inflate every aggregate you compute afterwards.