import csv
from pathlib import Path

base = Path(r"C:\Users\Administrator\OneDrive\fx_macro_intraday\data\processed")
for fname in ["monthly_pnl_validated.csv", "monthly_pnl_final.csv", "monthly_pnl_v2.csv"]:
    p = base / fname
    print("=" * 70)
    print(f"FILE: {fname}")
    print("=" * 70)
    if not p.exists():
        print("  (not found)")
        continue
    try:
        with open(p, newline="", encoding="utf-8") as f:
            rows = list(csv.reader(f))
        print(f"  Rows: {len(rows)}")
        # print header + first 20 rows
        for r in rows[:20]:
            print("  " + " | ".join(r))
        if len(rows) > 20:
            print(f"  ... ({len(rows)-20} more rows)")
    except Exception as e:
        print(f"  Error reading: {e}")
    print()