import pandas as pd
from pathlib import Path

proj = Path(r"C:\Users\paul_\OneDrive\fx_macro_intraday")
# Find existing trade CSV and look at year-by-year counts
csv = proj / "data" / "processed" / "trades" / "trades_real_costs.csv"
df = pd.read_csv(csv)
df["entry_time"] = pd.to_datetime(df["entry_time"])
df["year"] = df["entry_time"].dt.year

print(f"Total trades: {len(df)}")
print(f"Date range: {df['entry_time'].min()} to {df['entry_time'].max()}")
print()
print("Year-by-year trade counts:")
print(df.groupby("year").size().to_string())