How to download Binance Trade Print History for Any Date to CSV

[PLUS] How to download Binance Trade Print History for Any Date to CSV

April 23, 2023, 1:48 a.m.by CryptoDataDownload

Trade Print Data

Often times it can be hard to wrangle and manage Binance trade print data due to the sheer size of the data on any given day; the volumes are just huge! Some days have file sizes that reach up to 150mb (while zipped!) This can be hard to load into memory at once or analyze, and it is certainly too large to load into one Excel file. You may wonder, "Can anyone use this script to access the data?" ---> One of the best parts of this Python script is that we use a Binance data repository that allows all users, even those from now "restricted locations" (ie. USA).

What the Script Does

Basically we are going to allow the user to pass two basic parameters: the symbol and the date. We will then generate the corresponding data URL location in a string, and access programmatically. Once we download the data, we will split the data into equal sized Excel files in the same directory where the script was executed. (This process is called reading the data in "chunks"). Due to the chunking size, the largest each individual CSV file will be is ~25mb. Depending on how large the zipped file is, there could be just a few resulting excel files or up to 20-25! Each line is commented so you know exactly how to modify. Feel free to use to your purpose.

Bonus Idea

Just as an additional thought if you were looking to analyze data over a short time window, it may be useful to combine this script with an additional function that would load the Excel files into a SQLite database!

This is a premium post. Create Plus+ Account to view the live, working codebase for this article.

Notice: Information contained herein is not and should not be construed as an offer, solicitation, or recommendation to buy or sell securities. The information has been obtained from sources we believe to be reliable; however no guarantee is made or implied with respect to its accuracy, timeliness, or completeness. Author does not own the any crypto currency discussed. The information and content are subject to change without notice. CryptoDataDownload and its affiliates do not provide investment, tax, legal or accounting advice.

This material has been prepared for informational purposes only and is the opinion of the author, and is not intended to provide, and should not be relied on for, investment, tax, legal, accounting advice. You should consult your own investment, tax, legal and accounting advisors before engaging in any transaction. All content published by CryptoDataDownload is not an endorsement whatsoever. CryptoDataDownload was not compensated to submit this article. Please also visit our Privacy policy; disclaimer; and terms and conditions page for further information.

About

CryptoDataDownload - Free market data and risk analytics tools for cryptocurrency research and analysis. Premium content & analytical offerings also available. Trusted by academics worldwide.

Navigation

Contacts

E-mail

support@cryptodatadownload.com
Have feedback or questions? Our team is here to help. Contact us for any inquiries or to report any inaccuracies.