Creating a stocks database
I just started working on teaching myself sql and after completing the codeacadmey sql lessons, there are links to independant projects. My goal is to work on these independant projects in the coming weeks.
To look ahead (and have a place to find them later outside my pocket list) here’s a list to all five I plan on working on:
- Watching the Stock Market
- Explore a Sample Database
- Education & Census Data
- Home Value Trends
- Analyze Airfare Data
The first project has us working with stock market data. The project asks us to gather data for five different stocks
Before performing SQL work, I need to gather some stock data. Yahoo Finance is a great resource for historical data and allows an export straight to csv.
I’ve downloaded data over the past three months (from April 30, 2019 through today, July 30. 2019). I suggest finding some stocks that interest you! I’ve decided to look at the stocks for
I also saved the data I’m using here. Note that the price I’m using is the adjusted closing price.
For speed, I’m creating the database in the DB Browser GUI. Instructions for that are on the project instruction page. The database is saved along with individual CSVs for each stock.
Stay tuned for my next bit, using some simple sql to work with this data!