"""mark_table.py DAY SYM FROM TO [STEP] -- minute indicators for studying the user's marks (old-score library: bars/flow/ref)."""
import gzip, json, sys
sys.path.insert(0, "/var/www/screener/trade/reports/playbook"); sys.path.insert(0, "/var/www/screener/trade")
import v2_bar_replay as R
day, s, f0, f1 = sys.argv[1], sys.argv[2], sys.argv[3], sys.argv[4]; step = int(sys.argv[5]) if len(sys.argv) > 5 else 1
tm = lambda x: (int(x.split(":")[0]) - 9) * 60 + int(x.split(":")[1]) - 30
d = json.load(gzip.open(R.OW / "bars" / f"bars_{day}.json.gz", "rt")); ref = R.REF.load(day, s) or {}
b = [x for x in R.bars_of(d["symbols"][s]["bars"]) if 0 <= R.minute(x["t"]) < 390]; M = [R.minute(x["t"]) for x in b]
fl = json.loads((R.OW / "flow" / day / f"{s}.json").read_text()); vpm = ref.get("vol_per_min") or []
print({k: ref.get(k) for k in ("prev_close", "prev_high", "prev_low", "atr14")}, "open", b[0]["o"])
def bs(m, n):
    B = sum(fl["buy"][max(0, m - n + 1):m + 1]); S = sum(fl["sell"][max(0, m - n + 1):m + 1]); return B / (B + S) if B + S else float("nan")
pv = cv = 0; hi = 0; lo = 1e9
print(" time    open   high    low  close     vol vol/norm bs1  bs5 bs15   VWAP vsVWAP vsOpen dayLow dayHigh")
for i, x in enumerate(b):
    m = M[i]; pv += (x["h"] + x["l"] + x["c"]) / 3 * x["v"]; cv += x["v"]; hi = max(hi, x["h"]); lo = min(lo, x["l"])
    if tm(f0) <= m <= tm(f1) and (m - tm(f0)) % step == 0:
        nv = x["v"] / vpm[m] if len(vpm) > m and vpm[m] else 0
        print(f"{9 + (30 + m) // 60:2}:{(30 + m) % 60:02d} {x['o']:7.3f} {x['h']:7.3f} {x['l']:7.3f} {x['c']:7.3f} {x['v']:8.0f} {nv:5.1f}x {bs(m,1):.2f} {bs(m,5):.2f} {bs(m,15):.2f} {pv/cv:7.3f} {(x['c']/(pv/cv)-1)*100:+5.1f}% {(x['c']/b[0]['o']-1)*100:+5.1f}% {lo:7.3f} {hi:7.3f}")
