Problem
Reddit investing discussions are noisy and fast moving, making it difficult to consistently identify trending tickers and convert them into useful summaries.
Project Case Study
Reddit Street Journal
This project identifies trending stocks from Reddit discussions, fetches live stock price data from Yahoo Finance, generates AI-powered summaries, and publishes content to Twitter and GitHub Pages.
Solution
An automated data workflow detects stock tickers, enriches them with live Yahoo Finance pricing, generates summaries, and publishes results to Twitter and GitHub Pages.
Tech Stack
- Python
- SQL
- Docker
- GCP
- Google Cloud Jobs
- Yahoo Finance
- GitHub Pages
Impact
The project turns unstructured social discussion into a repeatable publishing pipeline with structured outputs and automated distribution.
Pipeline Flow
- Read Reddit discussions and detect trending stock tickers.
- Fetch live price data from Yahoo Finance.
- Generate AI-powered stock summaries.
- Publish output to Twitter and GitHub Pages.
- Run automation with DataFrame ingestion and caching improvements from the migration workflow.