from pathlib import Path
import csv

base_candidates = [
    Path(r"C:\Users\Administrator\OneDrive\fx_macro_intraday"),
    Path(r"C:\Users\paul_\OneDrive\fx_macro_intraday"),
]
BASE = next((b for b in base_candidates if b.exists()), None)
uj_p = BASE / "data" / "processed" / "usdjpy_trades_real_costs.csv"

print(f"Path: {uj_p}")
print(f"Exists: {uj_p.exists()}")
print(f"Size: {uj_p.stat().st_size} bytes")
print()

# Raw first 3 lines, repr so we see exact characters/delimiters
with open(uj_p, "rb") as f:
    raw = f.read(600)
print("First 600 raw bytes (repr):")
print(repr(raw))
print()

# Now read with csv and show header + first row keys
with open(uj_p, newline="", encoding="utf-8-sig") as f:   # utf-8-sig handles BOM
    reader = csv.DictReader(f)
    print("Detected fieldnames:", reader.fieldnames)
    for i, row in enumerate(reader):
        print(f"Row {i}: exit_time='{row.get('exit_time')}' pnl_real='{row.get('pnl_real')}'")
        if i >= 2:
            break