lead-lag-scripts/check_timestamp.py

import sqlite3
from datetime import datetime

conn = sqlite3.connect('data/trading_data_20251104.db')
cursor = conn.cursor()

# 获取最早和最晚的时间戳
cursor.execute('SELECT MIN(timestamp), MAX(timestamp) FROM price_data')
min_ts, max_ts = cursor.fetchone()

print(f'最早时间戳: {min_ts}')
print(f'  UTC: {datetime.utcfromtimestamp(min_ts)}')
print(f'  本地: {datetime.fromtimestamp(min_ts)}')
print()

print(f'最晚时间戳: {max_ts}')
print(f'  UTC: {datetime.utcfromtimestamp(max_ts)}')
print(f'  本地: {datetime.fromtimestamp(max_ts)}')
print()

# 计算时间跨度
span_hours = (max_ts - min_ts) / 3600
print(f'时间跨度: {span_hours:.2f} 小时')

conn.close()