Stock Data Analysis Project This project collects historical stock data from Yahoo Finance using Python and stores it in a MySQL database for analysis. It leverages SQL queries to analyze and extract key financial metrics such as average prices, daily returns, trading volumes, and stock price trends over time. The data analysis includes comparing the first and last dates for each stock, identifying trends, and calculating maximum daily returns. This project demonstrates practical experience in data collection, storage, and analysis with MySQL.

Features:

Fetch stock data using Python and Yahoo Finance API.

Store data in MySQL database (using MySQL Workbench).

Perform analysis on stock prices, volumes, and daily returns.

Generate insights on price trends, average prices, and volume changes.