import pandas as pd
from pathlib import Path

# Check USDJPY CSV is intact
uj_csv = Path(r"C:\Users\Administrator\OneDrive\fx_macro_intraday\data\raw\prices\USDJPY\USDJPY_15M_2003_2026.csv")
print(f"USDJPY CSV size: {uj_csv.stat().st_size:,} bytes")

df = pd.read_csv(uj_csv)
print(f"Rows: {len(df):,}")
print(f"Columns: {list(df.columns)}")
print(f"Last 3 rows:")
print(df.tail(3).to_string())