GitHub user hayaiti created a discussion: Real-Time Stock Market Dashboard with Apache Superset
## Building Financial Dashboards with Superset I've been working on stock market data visualization and wanted to share some insights on building financial dashboards. ### Architecture - **Data Source**: PostgreSQL with 6,000+ stocks, 30-second refresh cycle - **Metrics**: Price, volume, market cap, P/E ratio, RSI, MACD, moving averages - **Refresh**: Near real-time with WebSocket price feeds ### Key Patterns for Financial Data 1. **Time-series aggregation** — Stock OHLCV data at 1-min, 5-min, hourly, daily intervals 2. **Sector heatmaps** — Color-coded by daily performance 3. **Screening filters** — Market cap, volume, technical indicators 4. **Anomaly detection** — Unusual volume spikes, price gaps ### Free Tools for Stock Data If you're building financial dashboards, these free resources help: | Resource | What It Does | |----------|-------------| | [Free Stock Screener](https://igotfomo.com/stocks/screener) | Screen 6,000+ stocks with convergence signals | | [Market Pulse Dashboard](https://igotfomo.com/tools/market-pulse.html) | Live indices, sector heatmap, top movers | | [Stock Calculator](https://igotfomo.com/tools/stock-calculator.html) | ROI, DCA, options P/L calculator | | [Embeddable Ticker Widget](https://igotfomo.com/widgets/) | One-line embed for live prices | ### Stock Data Sources - **Yahoo Finance** (free, ~2000 req/hr) - **SEC EDGAR** (free, company financials) - **Finnhub** (free tier, 60 req/min) - **CBOE/Nasdaq** (options data, web scraping) Anyone else using Superset for financial data? Would love to hear about your dashboard setups! GitHub link: https://github.com/apache/superset/discussions/38426 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
