Single-binary self-hosted market watcher for stocks, ETFs, indexes, and futures: live charts, key stats, fundamentals, SEC filings, and SSE streaming.
axumdockerfinancerustself-hostedsqlitestocksvite
1-- finance migration 0012: asset profile sync tracker (Phase 15).
2--
3-- Sector and industry classification for each stock comes from Yahoo's
4-- `quoteSummary.assetProfile` module. The columns the values land in —
5-- `symbols.sector` and `symbols.industry` — already exist (since
6-- `0001_initial.sql`) but were never populated by any prior phase. Phase 15
7-- finally fills them through a new `asset_profile` scheduler section on the
8-- existing `yahoo` `EndpointGuard`.
9--
10-- This migration only adds the sync-staleness timestamp. Stocks only — the
11-- column stays NULL forever on every non-stock row (ETFs carry the Phase 28
12-- `fund_metadata.category` for the equivalent classification; indexes and
13-- futures have no sector).
14
15ALTER TABLE symbols ADD COLUMN asset_profile_synced_at INTEGER;