Insert Crypto Price Data into Postgresql Using Sqlalchemy, Python & Pandas

Learn how to insert free minutely crypto price data into PostgreSQL using SQLAlchemy, Python, and Pandas for future crypto algo trading and strategy backtesting purposes.

0:00 Introduction
0:30 Clone Notebook
2:00 Create Ticker List
2:21 Create Active Tickers List
3:52 Create Symbols DataFrame
5:26 Create Minute Bar DataFrame
7:22 Insert DataFrames Into PostgreSQL
11:45 Verify Price Data Insert

#crypto
#algotrading
#python

---
---

[AnalyzingAlpha]

We're almost there! Learn how to import the free minute crypto data into our PostgreSQL database. If you liked this video or have suggested improvements, please let me know in the comments below!

[vadimkovshov]

Thank you for your reply, Leo! I had a chance to go through the rest of your blog on the weekend! I wanted to thank you on behalf of the legions of beginners out there! It’s an enormous amount of good material that cuts to the core of many important issues. Saving time and giving guidance is, probably, the best favor anyone can do to a beginner. I am more of a beginner ‘data_scientist’😅, after spending >20 years working for US hedge funds. A little disappointed that you stopped posting.

[JoelBerman]

I could not do the unzip stuff on my Chromebook in jupyter or in native python, so I had to do thzat part on colab. But so far so good.

[vadimkovshov]

Hi Leo, thanks for the tutorials! I am using MySQL server instead of PostgreSQL. My 'minute_bar' bulk_insert crashes after loosing connection on 1st iteration of 'ticker'. Tried to troubleshoot, able to insert 'minute_bars' for the last 'ticker' only when I remove bulk_insert from the 'ticker' loop. Any idea how I can fix that, or whether this issue came up in the past?