import pandas as pd
from pathlib import Path

proj = Path(r"C:\Users\paul_\OneDrive\fx_macro_intraday")
df = pd.read_csv(proj / "data" / "processed" / "trades" / "trades_real_costs.csv")
df["entry_time"] = pd.to_datetime(df["entry_time"])

recent = df[df["entry_time"] >= "2024-01-01"]
print(f"Trades since 2024: {len(recent)}")
print(f"Active days: {recent['entry_time'].dt.normalize().nunique()}")
print()
print("Recent active days with most trades:")
print(recent.groupby(recent["entry_time"].dt.normalize()).size().sort_values(ascending=False).head(10))
print()
print("Average trades per active day, 2024+:")
days = recent.groupby(recent["entry_time"].dt.normalize()).size()
print(f"  Mean:   {days.mean():.2f}")
print(f"  Median: {days.median():.0f}")
print(f"  Distribution of trades-per-day:")
print(days.value_counts().sort_index())