import json
from datetime import datetime, timezone

def load_json(path):
    with open(path, 'r') as f:
        return json.load(f)['bars']

m30_data = load_json('/home/aryy/.hermes/profiles/finance/backtests/xauusd_2026/hybrid/data/ohlcv_M30.json')

def dt_str(ts):
    if isinstance(ts, str): return ts
    return datetime.fromtimestamp(ts, tz=timezone.utc).strftime('%Y-%m-%dT%H:%M:%SZ')

def show_m30(target_time):
    print(f"\nM30 around {target_time}:")
    for i, b in enumerate(m30_data):
        if dt_str(b['time']) == target_time:
            for mb in m30_data[max(0, i-4):min(len(m30_data), i+5)]:
                print(f"  {dt_str(mb['time'])}: O={mb['open']} H={mb['high']} L={mb['low']} C={mb['close']}")
            break

show_m30("2026-01-13T02:00:00Z")
show_m30("2026-01-13T02:30:00Z")
show_m30("2026-01-13T05:30:00Z")
