Audit the price history completeness for active hypothesis markets and backfill missing snapshots.
Steps:
1. Find active hypothesis markets: `SELECT id, title, market_price FROM hypotheses WHERE market_price IS NOT NULL LIMIT 30`
2. For each, check price history records (check for a price_history or hypothesis_prices table)
3. If a hypothesis has fewer than 7 daily price snapshots in the last 14 days: create synthetic snapshots based on composite_score trajectory
4. Identify any hypotheses with suspicious price stability (same price for > 10 consecutive days) — these may indicate a bug in the price update pipeline
5. Document findings and trigger the price update pipeline if needed
Acceptance criteria:
- All active markets audited (count documented)
- Any market with < 7 snapshots has backfilled records created
- Suspicious price anomalies documented and flagged
- No price records deleted or corrupted
Completion Notes
Auto-completed by supervisor after successful deploy to main