import json

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'
}

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

for ts in timestamps:
    print(f"\n--- {ts} ---")
    for tf, file in files.items():
        with open(file, 'r') as f:
            data = json.load(f)
            if isinstance(data, dict):
                bars = data.get('data', data.get('bars', []))
            else:
                bars = data
        
        target_idx = -1
        for i, b in enumerate(bars):
            if isinstance(b, dict) and 'time' in b:
                # Handle potential timestamp format issues (int vs str)
                b_time = b['time']
                if isinstance(b_time, int):
                    import datetime
                    b_time = datetime.datetime.utcfromtimestamp(b_time).strftime('%Y-%m-%dT%H:%M:%SZ')
                    b['time'] = b_time
                if b_time <= ts:
                    target_idx = i
                
        if target_idx != -1:
            start_idx = max(0, target_idx - 6)
            context_bars = bars[start_idx:target_idx+5]
            print(f"\n{tf} Context:")
            for b in context_bars:
                flag = "-->" if b['time'] == bars[target_idx]['time'] else "   "
                print(f"{flag} {b['time']} | O: {b['open']} | H: {b['high']} | L: {b['low']} | C: {b['close']}")
        else:
            print(f"{tf} Context: No bars found before/at {ts}")