Data Tools for Quant Developers and Finance Teams
Generate synthetic financial data, turn market data APIs into CSV or Parquet, mask customer data and reconcile reports, free and in your browser.
The problem
Quant developers and finance teams need realistic data to test pipelines, reports and trading code, but real customer and market data is sensitive, licensed or slow to move. Files also arrive in the wrong format: JSON from an API, Excel from a colleague, CSV from a vendor.
Typical jobs and the tool for each
Test data: the Data Generator has ready datasets for transactions and orders with up to 500,000 rows, and the Synthetic Data Generator learns the shape of your own file and creates new rows that behave like it. See the guide on synthetic OHLCV data for trading systems.
Market data in a table: API Response to Table calls a GET endpoint over https and returns CSV, Excel, JSON or Parquet. Convert CSV or Excel history to Parquet with the Format Converter.
Sharing safely: Data Masking finds emails, phone numbers, names and card numbers and hides them before a file leaves your team.
Reconciliation: Data Comparison matches two CSV or Excel files by a key, with a tolerance for small numeric differences, and lists added, removed and changed rows.
Quality before a backtest: Data Profiler counts blanks, duplicates and outliers.
- Mock Data Generator
- Synthetic Data Generator: Realistic Data From Your File
- API Response to Table: JSON API to CSV
- CSV to Parquet Converter
- Data Masking and Anonymization
- Data Comparison (CSV and Excel Diff)
- Data Profiler
Limits to know
Synthetic data follows the statistics of a file or the ranges you set. It does not reproduce real market behaviour, so use it to test pipelines and formats, not to judge a strategy. API Response to Table supports GET requests only, and the API must allow calls from a browser. Everything else runs in your browser and files are not uploaded.