binance_pandas_dataframe 0.2

binance_pandas_dataframe.

Overview

binance_pandas_dataframe collects the historical data from https://data.binance.vision and builds Pandas dataframes from them for use in Python.

The code was forked from https://github.com/binance/binance-public-data, and the logic to build the Pandas dataframe was added.

If you want to process data in a tool other than Python, such as R, Julia, or excel, you can use pandas_dataframe_convert to convert the dataframes produced by binance_pandas_dataframe to 'pkl', 'ftr', 'json', 'xlsx', 'csv', 'md', 'latex', or 'parquet'.

Status

Currently only klines work.

Installing

Installing from PyPi

pip install binance_pandas_dataframes

Installing from your git clone.

Flit is used to build the python package for installation with pip. Flit will call pip as required.

This is the best way to do it. In windows, do this from an adminstrator powershell for the symlink permissions.

flit install --symlink

or you can install it this way, you will have to uninstall with pip and reinstall with flit for every change in a source file. flit install

Running the scripts

The scripts are installed in your python Scripts folder which should be in your path.

export STORE_DIRECTORY=<your desired path>

This will configure the default storing directory of the downloaded data. This can be overwritten
by setting an argument(example given below).

download_kline
download_trade
download_aggTrade

Downloads all monthly and daily(for past 35 days) klines/trades/aggTrades of all intervals(applicable to klines only) and symbols.

download_kline --help

This will show the arguments that can be parsed to the scripts which can be used to configure download options.

Running with arguments

Argument	Explanation
-h	show help messages
-a	All binance symbols. It might work for you
-s	Single symbol or multiple symbols separated by space
-y	Single year or multiple years separated by space
-m	Single month or multiple months separated by space
-d	single date or multiple dates separated by space
-startDate	Starting date to download in [YYYY-MM-DD] format
-endDate	Ending date to download in [YYYY-MM-DD] format
-folder	Directory to store the downloaded data
-c	1 to download checksum file, default 0
-i	single kline interval or multiple intervals separated by space
-t	Trading type: spot, um (USD-M Futures), cm (COIN-M Futures)

e.g download ETHUSDT BTCUSDT BNBBUSD kline of 1 week interval from year 2020, month of Feb and Dec with CHECKSUM file:
download_kline -s ETHUSDT BTCUSDT BNBBUSD -i 1w -y 2020 -m 02 12 -c 1

eg. download ETHUSDT kline from 2020-01-01 to 2021-02-02 to directory /Users/bob/Binance:
download_kline -s ETHUSDT -startDate 2020-01-01 -endDate 2021-02-02 -folder '/Users/bob/Binance'