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

> Quant analysts: clean OHLCV CSVs, convert price history to Parquet, run SQL returns and drawdowns, and generate synthetic market data. Free, in your browser.

Page: https://datautility.in/blog/free-data-tools-for-quant-analysts
This is the Markdown copy of the page. The tool itself runs in the browser: your files are processed on your own device and are not uploaded.

Published 2026-11-19 · Analyze & protect · quant analyst free tools, quant data tools, ohlcv csv cleaning, convert price data to parquet, sql returns drawdown, synthetic market data, backtest data preparation, time series csv tools

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 tool: [Data Profiler](https://datautility.in/data-profiler)

## Inspect before you load

Open a vendor file in the [data profiler](https://datautility.in/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](https://datautility.in/data-transformation). For storage and speed, convert to Parquet; see [CSV to Parquet](https://datautility.in/blog/how-to-convert-csv-to-parquet) and [financial API JSON to Parquet](https://datautility.in/blog/financial-api-json-to-parquet).

## Quick returns and drawdown with SQL

Run SQL on the file in [SQL on your files](https://datautility.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](https://datautility.in/blog/sql-for-financial-analysts-returns-moving-average-drawdown). 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](https://datautility.in/test-data-generator). See [synthetic OHLCV data for trading systems](https://datautility.in/blog/synthetic-ohlcv-test-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](https://datautility.in/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.

## 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.

## Related tool pages

- [CSV Data Quality Checker](https://datautility.in/check-csv-data-quality): 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](https://datautility.in/check-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](https://datautility.in/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](https://datautility.in/open-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](https://datautility.in/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](https://datautility.in/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

- [Free data profiling tool for data analysts](https://datautility.in/blog/free-data-profiling-tool-for-data-analysts)
- [Free data tools for business analysts](https://datautility.in/blog/free-data-tools-for-business-analysts)
- [Free data tools for product analysts](https://datautility.in/blog/free-data-tools-for-product-analysts)
- [Synthetic OHLCV test data](https://datautility.in/blog/synthetic-ohlcv-test-data-for-trading-systems)

## More guides

- [Data Profiler: Check Data Quality Before You Use It](https://datautility.in/blog/data-profiler-check-data-quality)
- [Compare Two CSV or Excel Files: Find Added, Removed and Changed Rows](https://datautility.in/blog/compare-two-csv-files-find-differences)
- [Data Masking: Hide Emails, Phones and Names Before Sharing](https://datautility.in/blog/data-masking-hide-emails-phones-pii)
