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-- 0010_quarter_horizon.sql
2-- The four picker horizons are day / week / month / quarter (PLAN.md Phase 30,
3-- reworked 2026-05-23). The original `year` horizon was dropped: its score was
4-- a pass-through of today's standing, so every historical backtest year
5-- produced an identical top-5. Quarter (~one earnings cycle, 60-day trailing
6-- momentum gated on SMA200) replaces it.
7--
8-- The `picks` snapshot table stores horizons as text; clear any snapshot rows
9-- with the retired key so /backtest never surfaces stale `year` slates.
10-- Today's daily_close scheduler tick will write a fresh `quarter` snapshot.
11
12DELETE FROM picks WHERE horizon = 'year';