from database import TradeDB
db = TradeDB()
try:
    sql = "SELECT source, COUNT(*) as cnt FROM ws_orderbook WHERE DATE(recv_ts) = '2026-08-10' GROUP BY source"
    rows = db.conn.execute(sql).fetchall()
    print("ws_orderbook today:", [dict(r) for r in rows])
except Exception as e:
    print(f"Could not count ws_orderbook: {e}")
finally:
    db.close()