The Dunleavy Organization

Data · Analytics · Digital Delivery

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.

Earlier — Fabric & Power BI Single-stock AAPL report with KPIs, trend, volume, and date controls. Click to expand.
Current — live on this site Multi-stock overview: key metrics, sortable table, and date filters. Click to expand.
Role
Sole developer
Timeline
2025–2026
Type
Data product
Status
Live

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.

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.

SQL Server Python Scheduled refresh Cloudflare Pages

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
Want a dashboard like this?