Business Request: Provide the business with data on the American stock market. (NASDAQ & Dow Jones)
Requested Outcome: Historical data of the US Stock Market from the start of each market till 2023. Include my stock data from ETrade and Fidelity (Bonus pts.)
A1 | Create a Tableau of this data set with the same title
Comparison of personal stock data vs. stock market (Graph of overall trend)
Top stock in each market category
Top 10 stocks
A2 | Obtain personal Stock Market data from accounts inception till 2023
- My Solution: Download stock market data for time frame 0 till now. Create sql select script for A2. Use Tableau to visualize the data via A1.
Tags: Project Money/Stocks Related
[Dataset Used] (URL)
[SQL Scripts] (URL)