Loading...

[PLUS] Saving Binance API Data to SQLite Database via Python

We are going to go one step farther than in our previous code heavy article which covered how to download data from Binance for any specific period in time. At the end of that article, we saved our historical Open, High, Low, Close, Volume (OHLCV) data to a CSV. One of the great things about the Binance API is in the way they return the actual market quantities for "Taker Order volume", which could be intepreted as "market orders" at the market. (Could be an interesting feature set to run through a machine learning model; Generally, the greater percentage taker order volume represents as a percentage of the total signals increasing fervor to transact immediately)

The code we are going to be using to pull the historical data from Binance is the same as the previous article. Building on that function, we will instead store the data into a SQlite database. Why would we do this? Once in the database, we can execute SQL against it! This is much faster when building an actual application and dealing with multiple CSV files. Of course, there are numerous database(s) and database schemas to follow. But we like to use SQlite when setting up quick solutions for two main reasons: (1) Every Python distribution should already come with the sqlite3 library already included (2) There are easy to use database browser tools for windows that allows visual inspection of data in database.

Of course, we comment every line of code so you know exactly what is intended.
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.