BASE 44 ORDER: Implement vol_spike_ratio column, partial index, REI/SMA materialized view, and update scan query — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1204] Add generated column vol_spike_ratio using 20-row preceding avg. Create partial index on (symbol, ts) WHERE vol_spike_ratio>=2.5. Build materialized view precomputing REI(14) and SMA(20) for filtered rows, refresh concurrently every 5 min via systemd timer. Update scan query to use view. MERLIN: Understood. I will direct the swarm to add the generated column vol_spike_ratio using a 20-row preceding average, create the partial index on (symbol, ts) where vol_spike_ratio >= 2.5, and build the materialized view precomputing REI(14) and SMA(20) for filtered rows. The view will refresh concurrently every 5 minutes via a systemd timer, and the scan query will be updated to use the view. The swarm will start immediately and report back when each step is complete. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com