import json

def get_bars(file, start, end):
    try:
        with open(file, 'r') as f:
            data = json.load(f)
            return [b for b in data if start <= b['time'] <= end]
    except Exception as e:
        return []

timestamps = [
    "2026-07-05T23:15:00Z",
    "2026-07-06T03:30:00Z",
    "2026-07-06T07:00:00Z"
]

files = {
    'H4': '/home/aryy/.hermes/profiles/finance/backtests/xauusd_2026/hybrid/data/ohlcv_H4.json',
    'H1': '/home/aryy/.hermes/profiles/finance/backtests/xauusd_2026/hybrid/data/ohlcv_H1.json',
    'M30': '/home/aryy/.hermes/profiles/finance/backtests/xauusd_2026/hybrid/data/ohlcv_M30.json',
    'M15': '/home/aryy/.hermes/profiles/finance/backtests/xauusd_2026/hybrid/data/ohlcv_M15.json',
    'M5': '/home/aryy/.hermes/profiles/finance/backtests/xauusd_2026/hybrid/data/ohlcv_M5.json'
}

data_out = {}
for i, ts in enumerate(timestamps):
    start = ts[:11] + "00:00:00Z" if ts.endswith("T23:15:00Z") else ts[:10] + "T00:00:00Z"
    end = ts[:10] + "T23:59:59Z"
    
    if ts == "2026-07-05T23:15:00Z":
        start = "2026-07-03T00:00:00Z"
        end = "2026-07-06T23:59:59Z"
        
    data_out[ts] = {}
    for tf, file in files.items():
        bars = get_bars(file, start, end)
        data_out[ts][tf] = bars

with open('/home/aryy/.hermes/profiles/finance/backtests/xauusd_2026/hybrid/reviews/data_748_751.json', 'w') as f:
    json.dump(data_out, f, indent=2)

print("Data saved to data_748_751.json")