GitHub user hayaiti created a discussion: Stock Market Dashboard: Visualizing
6,000+ Stocks with 12 Signal Types
## Financial Data Visualization at Scale
Sharing patterns from building a stock market analytics dashboard that
visualizes data for 6,000+ stocks across 12 different signal types.
### Dashboard Components
**1. Convergence Heatmap**
- Rows: 6,137 stocks
- Columns: 12 signal types (technical, options, insider, dark pool, etc.)
- Color: Green (bullish) → Red (bearish), intensity = strength
- Filterable by sector, market cap, score threshold
**2. Sector Rotation Chart**
- 11 GICS sectors + ETF category
- Performance comparison: 1D, 1W, 1M, 3M
- Volume-weighted sector strength
**3. Signal Distribution**
- Distribution of convergence scores (0-100) across universe
- Current: 4 STRONG BUY, 92 BUY, 93 HOLD, 63 AVOID, 19 SELL
**4. Real-Time Movers**
- Top gainers/losers with signal context
- Options unusual activity highlights
- Insider buying clusters
### Data Schema
```sql
-- Core stock data
SELECT s.symbol, s.name, s.price, s.change_percent,
s.sector, s.market_cap, s.pe_ratio,
cr.score, cr.signal_count, cr.top_signals
FROM stocks s
JOIN convergence_rankings cr ON s.symbol = cr.symbol
WHERE cr.score >= 70
ORDER BY cr.score DESC;
```
### Signal Types Visualized
| Signal | Source | Coverage | Avg IC |
|--------|--------|----------|--------|
| RSI | OHLCV computation | 100% | 0.12 |
| MACD | OHLCV computation | 100% | 0.08 |
| Options Flow | 5-source engine | 100% | 0.15 |
| Insider Trading | SEC EDGAR | 94% | 0.18 |
| Dark Pool | FINRA | 85% | 0.11 |
| Short Interest | Yahoo + FINRA | 75% | 0.09 |
| Earnings | Finnhub + SEC | 80% | 0.14 |
### Live Demo
- **Screener**:
[igotfomo.com/stocks/screener](https://igotfomo.com/stocks/screener)
- **Dashboard**:
[igotfomo.com/tools/market-pulse.html](https://igotfomo.com/tools/market-pulse.html)
- **Calculator**:
[igotfomo.com/tools/stock-calculator.html](https://igotfomo.com/tools/stock-calculator.html)
- **Widget**: [igotfomo.com/widgets/](https://igotfomo.com/widgets/)
Curious about others' approaches to financial data visualization!
GitHub link: https://github.com/apache/superset/discussions/38423
----
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]
