Market Lab

Market Lab is an interactive Python application for manipulating Binance crypto-market data. It stores downloaded OHLCV data in SQLite, calculates various technical indicators, marks events such as a cross between two series, plots series, and produces simple quantile-based statistics vizualised by a heatmap or a simple graph. It is intended for research and experimentation; it does not place orders or provide trading advice.

What it does

• Creates a SQLite database for a Binance USDT market and timeframe.
• Downloads historical candles from Binance's public REST API and updates an existing database.
• Calculates built-in or user-defined indicators and stores them as columns in the SQLite table candles.
• Calculates events and stores their status values as columns in SQLite table status.
• Plots one or more series, with positive and negative event markers when selected.
• Produces one- and two-variable quantile statistics (classic two dimensional graph or heatmap).

The built-in indicator catalogue includes moving averages, VWEMA, correlation, ATR, relative changes, returns, RSI, Bollinger bands, Savitzky-Golay filtering, and other formulas. The event catalogue includes crossings, extrema, over/under comparisons, and peak detection (full list here).

Requirements

• Python 3.11 or over
• Internet access to Binance for downloads and updates
• A desktop environment capable of displaying Matplotlib windows

Runtime dependencies are declared in pyproject.toml: matplotlib, numpy, questionary, requests, rich, scipy, and websocket-client.

Install and run

You can install Market Lab directly with pip:

python -m pip install the-marketlab-project

Then open a Python terminal and run:

from market_lab import main
main()

Or clone the github repo:

https://github.com/Cla1tra2algo/Market-Lab.git

Then lunch this file:

````run_marketlab.py```

This is the supported way to launch the packaged application after installation.

At launch, choose Create a database or Open a database. When creating one, enter a base symbol such as BTC (Market Lab appends USDT) and choose a supported Binance timeframe. Then use the main menu:

1. Download Data — retrieve all available history or a selected date range.
2. Calculate Indicators — choose a formula, its input columns, arguments, and window.
3. Calculate Events — choose a rule and the columns it should inspect.
4. Plot or Calculate Statistics — explore saved data.
5. Update Data — download newer candles and attempt to extend saved calculations.

Download data before calculating an indicator or event. A window must contain no more candles than are available.

Download data before calculating an indicator or event. A window must contain no more candles than are available.

Data model

Each database has these main tables:

The downloaded candle fields on BINANCE are open_time, open, high, low, close, volume, close_time, quote_asset_vol, number_of_trades, taker_buy_base_asset_volume, and taker_buy_quote_asset_volume.

Indicator output begins at the final candle of its first window; earlier rows are left empty. Calculating a column with the same name will ask you to replace the existing column or rename the indicator you are triying to calculate, so use clear, unique names when preserving experiments matters.

Custom indicators and events

Market Lab can import Python modules that define indicator_dict and/or event_dict. Custom Python is executed during import, so only load code you have reviewed and trust.

Use Settings → Manage Custom Indicators and Events → Create custom_indicators.py to generate a starter module, edit it, then use Register custom module to validate, register, and load it. The complete, code-aligned extension contract and working examples are in How to create your own indicators and events.

Project layout

Notes and limitations

• Because the market data come from BINANCE, availability, symbols, and historical coverage are controlled by Binance.
• The application is interactive rather than a stable programmatic API.
• SQLite files and generated custom modules are created next to the project files. Back up databases before replacing columns or registering untrusted changes.
• This project is for analysis, not a recommendation to buy or sell any asset.

Verification

The repository includes a lightweight custom-module smoke test:

python test_smoke.py