Stock Market Dashboard
An interactive stock market dashboard for about one hundred equities and ETFs. Daily prices load overnight, and the dashboard is live on this site. An earlier version was a single-stock report in Microsoft Fabric and Power BI.
Problem & Outcome
An early build used Microsoft Fabric and Power BI for AAPL daily bars. The report covered one stock, and it ran on a Fabric trial.
Outcome: a dashboard for about one hundred equities and ETFs, with a nightly refresh. Overview, detail, and compare views are on this site. The database stays private. The site publishes a snapshot of the market data and the dashboard.
The Fabric and Power BI report is the earlier version. The multi-ticker dashboard is what visitors open today.
Dashboard
Interactive preview below (scroll inside the panel for Detail and Compare). For the full-page experience — site header, room for charts, and page scroll — use Open full page.
Two Generations
Two versions. The earlier report was Microsoft Fabric and Power BI, for AAPL. The current dashboard is Python and SQL Server, live on this site, for about one hundred tickers.
| Earlier — Fabric & Power BI | Current — live product | |
|---|---|---|
| Scope | AAPL-focused | ~100 tickers (indices, sectors, mega-caps) |
| Pipeline | Fabric schedule, lakehouse, notebooks | Python ingest and SQL Server upsert |
| Dashboard | Power BI report | Interactive dashboard on this site |
| Public presence | Screenshots and GitHub project | Live product page and project page |
Architecture
The database stays private. This site receives a published snapshot and the dashboard.
flowchart TB A["Massive.com API"] --> B["Nightly Python pipeline"] B --> C["Private SQL Server"] C --> D["Published JSON snapshot"] D --> E["Dashboard on this site"]
Hosting & Operations
The database is a private SQL Server. It is not open to the internet. This site publishes a snapshot and the dashboard.
The dashboard is on Cloudflare Pages, on this domain. The dashboard and the published snapshot ship with the site.
A nightly job loads the new prices, prepares the snapshot, and updates the live dashboard.
Tech Stack
| Layer | Choice | Why |
|---|---|---|
| Ingest | Python and Massive.com API | Reliable daily bars; overnight batch |
| Database | SQL Server with upsert by ticker and date | Re-runs update the same ticker and date. |
| Public data | Published snapshot files | No open database; bounded history on the web |
| Dashboard | HTML, CSS, JavaScript, charts | Interactive filters; static hosting |
| Earlier path | Fabric, lakehouse, Power BI | The first version of this dashboard. |
Takeaways
- About one hundred equities and ETFs, refreshed nightly
- Overview, detail, and compare views on this site
- A private database, with a published snapshot on the site
- An earlier single-stock report in Fabric and Power BI