openbb-stack

A self-hosted financial data lake for personal market research.

● Private alpha ● Single user ● Non-commercial

What this is

A FastAPI service running on a single VPS that pulls daily market data from multiple providers, stores it as Parquet files locally, and exposes it as widgets in OpenBB Workspace.

I wanted one consistent locally-owned dataset to look at equities, FX, commodities, FRED macro, and computed cross-asset indicators in a single place. Existing tools either charge per-symbol, lock data into proprietary formats, or both.

It serves exactly one user: me. Not a SaaS. No signups. No public API. No team. No customers.

Architecture

Python 3.11 FastAPI Pandas DuckDB Plotly Pydantic pytest (492) OpenBB Platform 4.7 APScheduler Caddy systemd SQLite

Data sources

Equities + ETFs + indices + crypto + FX + commoditiesFMP Ultimate
Macro economic series (yields, CPI, M2, payrolls, credit spreads)FRED CSV
ETF fund flows (weekly)ICI
US margin debtFRED Z.1 BOGZ1FL663067003Q
Synthetic indicators (10 ratios + spreads)computed locally

Why TradingView Advanced Charts

The current chart layer uses Plotly inside OpenBB Workspace dashboards. For the deeper "look at one symbol with full toolset" workflow, I need TradingView Advanced Charts (formerly Charting Library) — specifically because:

Multi-pane resizable charts. Drag dividers between price + indicator panes, the way every TradingView user expects. Plotly subplots can't do this.
Drawing tools. Trendlines, Fibonacci retracements, channels, rectangles — for marking up multi-year price patterns I want to remember.
Drawing → alert. When I draw a trendline, I want price-cross detection. Plan: integrate via subscribe('drawing_event_added') → POST to local FastAPI → SQLite alerts row → cron-based notifications. The backend endpoint is already built.
Layout persistence. Restore drawings/indicators across sessions via charts_storage_url REST endpoints. The five REST endpoints are already implemented locally, dormant pending license.

This is purely for personal analysis on data I own. No public chart deployment, no white-labeling, no resale, no embedding in any product, no derivative SaaS.

Project status

Started: April 2026
Users: 1
Hosting: A single VPS in Singapore
Public access: None
Pricing: Free for me, n/a for others
Repository: github.com/WenZhun/openbb-stack
Test suite: 492 unit + integration tests, all passing