Snapshots
Frozen quarters
Each quarter the ingestion pipeline freezes the current state of every score into scores_snapshot. Use these views as the official historical record — the dashboard always reflects live momentum, but these don't change once frozen.