"""
massive_inplay_count.py -- [2026-10-05] How many $5-15 'stocks in play' per day? (sizing the 5-year
playbook). Massive grouped daily bars (all US stocks per day). In play = open $5-15, day volume >= 500k
AND (volume >= 1.5x its 20-day average OR |gap| >= 2% OR day range >= 5%). Sample of days over 5 years.
"""
import sys, time
from datetime import date, timedelta
import numpy as np
sys.path.insert(0, "/var/www/screener/trade/reports/open_window")
from massive_trial import get, BASE

def grouped(d):
    j = get(f"{BASE}/v2/aggs/grouped/locale/us/market/stocks/{d}", {"adjusted": "false"})
    return {r["T"]: r for r in j.get("results", []) if all(k in r for k in ("o", "h", "l", "c", "v"))}

days, d = [], date(2021, 10, 4)
while d <= date(2026, 10, 2):
    if d.weekday() < 5: days.append(d)
    d += timedelta(days=1)
sample = days[::25]
res = []
for sd in sample:
    i = days.index(sd)
    hist = [grouped(x) for x in days[max(0, i - 21):i]]
    hist = [h for h in hist if h]
    today = grouped(sd)
    if not today or len(hist) < 10: continue
    prev = hist[-1]
    n_price = n_play = 0
    for t, r in today.items():
        if not (5 <= r["o"] <= 15) or r["v"] < 500_000: continue
        n_price += 1
        av = np.mean([h[t]["v"] for h in hist if t in h]) if any(t in h for h in hist) else None
        gap = abs(r["o"] / prev[t]["c"] - 1) * 100 if t in prev else 0
        rng = (r["h"] / r["l"] - 1) * 100 if r["l"] else 0
        if (av and r["v"] >= 1.5 * av) or gap >= 2 or rng >= 5:
            n_play += 1
    res.append((str(sd), n_price, n_play)); print(sd, "price+volume ok:", n_price, " in play:", n_play, flush=True)
p = np.array([r[2] for r in res]); q = np.array([r[1] for r in res])
print(f"\n{len(res)} sample days: $5-15 & >=500k volume median {np.median(q):.0f}; IN PLAY median {np.median(p):.0f} (p10 {np.percentile(p,10):.0f}, p90 {np.percentile(p,90):.0f})")
print(f"5 years ~{len(days)} days -> ~{np.median(p)*len(days):,.0f} stock-days in play")
