How rpradyrao/stock_market_analysis works
This repository documents a Hive-based stock-analysis project rather than providing executable source. Its documented workflow imports seven years of stock prices and company metadata from MySQL via Sqoop, joins and aggregates them in Hive by company and month, then answers investment, state/industry-growth, and sector-year questions. The data archive and CSV are present, but the README does not establish how those files relate to the MySQL pipeline. Relationships below reflect the README only.
Main entry points: README.md Monthly company aggregate
Components 10
Data sources
- MySQL tables
README.md - Stock data archive
StockPrices.zip - Company CSV
Stockcompanies.csv
Hive data pipeline
- Sqoop import
README.md - Hive source tables
README.md - Monthly company aggregate
README.md
Exploratory analysis
- Investment ranking
README.md - State industry growth
README.md - Sector year comparison
README.md
Other components
- Analyst
Connections 9
- MySQL tables → Sqoop import: supplies tables
README.md - Sqoop import → Hive source tables: imports tables
README.md - Hive source tables → Monthly company aggregate: joins and aggregates
README.md - Analyst → Investment ranking: requests analysis
README.md - Analyst → State industry growth: requests analysis
README.md - Analyst → Sector year comparison: requests analysis
README.md - Monthly company aggregate → Investment ranking: supports ranking
README.md - Monthly company aggregate → State industry growth: supports comparison
README.md - Monthly company aggregate → Sector year comparison: supports comparison
README.md