Analyzing
Analyzing
VSCode extension. DuckDB+Parquet OHLCV store, lightweight-charts v5, yfinance/Stooq ingest, Alpaca IEX live feed. Symbols / Sectors / Portfolios trees feed the chart + aggregate panels.
analyzing — VSCode extension data + render pipeline
Two ingest sources land in a DuckDB-over-Parquet store; the VSCode extension drives lightweight-charts v5 panels off the same store. TA-Lib parity validated out-of-band via ta_reference.py.
yfinance / Stooq
Daily-bar ingest via scripts/ingest.py (yfinance multi-symbol fetch, Stooq fallback). Writes canonical OHLCV columns {ts,o,h,l,c,v,adj_c} to data/parquet/ohlcv-equities/<SYM>.parquet in the post-charter flat layout.
Alpaca IEX
Intraday live feed (REST snapshots + WebSocket trades/bars) via the Alpaca IEX SIP. Bar shape matches the canonical OHLCV columns at the client boundary — vendor field names never leak past the adapter.
DuckDB + Parquet
OHLCV-equities + TA-reference parquet store. Read by the extension via DuckDB views (no row-level Python). Today: 17 OHLCV symbols, 17 with TA-Lib reference companions. GICS sector/industry mapping lives at data/parquet/gics-symbols.parquet (present).
analyzing ext
VSCode extension host. Activity-bar trees (Symbols / Sectors / Portfolios) feed two webviews — ChartPanel (single-symbol) and AggregatePanel (multi-symbol roll-up). Webviews bundled via esbuild from src/webview/; extension host code in src/.
lightweight-charts v5
TradingView lightweight-charts v5 in the ChartPanel webview. Honors Layer A tokens; chart-color migration to tokens-chart.css deferred per display-modes-2026-05-07 § 9.
Data coverage — store + per-symbol
KPI strip over the canonical parquet hub plus the per-symbol coverage table. Drives the Phase 2.x DuckDB-backed views.
| Symbol | OHLCV KB | TA-ref | mtime (UTC) |
|---|---|---|---|
AAPL | 32 | yes | 2026-05-24T20:25:08Z |
AMZN | 24 | yes | 2026-05-24T20:25:08Z |
CAT | 32 | yes | 2026-05-24T20:25:08Z |
COST | 23 | yes | 2026-05-24T20:25:08Z |
JPM | 31 | yes | 2026-05-24T20:25:08Z |
KO | 29 | yes | 2026-05-24T20:25:08Z |
MSFT | 32 | yes | 2026-05-24T20:25:08Z |
NEE | 30 | yes | 2026-05-24T20:25:08Z |
NVDA | 33 | yes | 2026-05-24T20:25:08Z |
O | 29 | yes | 2026-05-24T20:25:08Z |
PG | 30 | yes | 2026-05-24T20:25:08Z |
RSP | 23 | yes | 2026-05-24T20:25:08Z |
SPY | 23 | yes | 2026-05-24T20:25:08Z |
TLT | 29 | yes | 2026-05-24T20:25:08Z |
UNH | 31 | yes | 2026-05-24T20:25:08Z |
V | 23 | yes | 2026-05-24T20:25:08Z |
XOM | 30 | yes | 2026-05-24T20:25:08Z |
Metrics
- ohlcvSymbols
- 17
- taRefSymbols
- 17
- gicsMapping
- present
- lastIngestAt
- 2026-05-24T20:25:08.033Z
- storePath
- data/parquet/