How To Build an INTRADAY Stock Price Database with Python & SQL [beginner friendly]

Hi all, happy to be back! In this warm up video I am going over how to build an Intraday Stock Price Database with Python and update it while also doing quality checks like only importing new datapoints.

Get the Notebook/Source code by becoming a Tier-3 Channel member or get other perks like Discord to exchange with like minded people here:

Useful PREREQUISITES:
Python & SQL playlist:

A similar video with more details (parameters etc.):

sqlalchemy for other DBMS:

Disclaimer: This video is not an investment advice and is for informational and educational purposes only.

#SQL #Python #stocks

[anilmm]

Really love your videos. This one is another one of those game changing ones.. Awaiting next one😊

[gustavozambrana]

Another informative video, which shows the power of Python in Finance!!! A few enhancements that should be taken into account for production systems are: a set of securities, stock splits, rename of securities ( consider META and FB as a recent example), and securities that have different trading max dates. I suggest as a follow up to this video.

[nullhakunamatatabyte]

dude u are doing great job everytime thx for everything

[pietraderdetective]

I press like even before I watched the video. Now that I've watched it, I would give several more likes if I could!

This is my favorite video topic from your channel. Great content Sir!

[kadourkadouri]

Nice job as usual! Can you make a similar video for options (e.g. SPY). That would be great too

[stocktraderlog]

Thanks for sharing this video.
For Windows, you need to change the DB path for example.
engine =

[philipfiguerres]

Good video. Much thanks. Btw, sqlalchemy has a version 2.09 and some of the comands are different. Can you update this video with version 2.09? On another note, can u do trading strategy based on order flow (order book) and show how to back test. Strategy would be to buy at support and sell at resistance. This can be done for crypto, stocjs, etc. Much thanks again.

[yank]

Love your videos, new subscriber here. I'm curious as I'm so new to python. How can I schedule this to run 2x a day Mon thru Friday

[tessalittle]

yup brilliant video this whole series on SQL awesome - it is exactly what I have been looking for. My challenge is to take the 1 min data and then analyse multiple times frame with a customised indicator and K% rso stochastics. and some time frames will always be use - like 1 month - 1Week etc what would your suggestion be to manage the data efficiently - resample into a SQL with 1 week TF etc??

[asuras]

So how can I update the database and make sure to create no duplicates? ChatGPT isn't really helpful here.

[rajeevmenon]

Was wondering why no videos have not come after the dashboard. I missed you.

[fudgenuggets]

How about this for a study... correlate a stock with its biggest input cost. For example correlate an airline with the price of jet fuel. Tesla with the cost of lithium. Fluor with the cost of copper, etc.