📚 stock_data 表字段说明 (Data Dictionary)
timestamp : 时间戳 (YYYY-MM-DD HH:MM:SS)
code : 股票代码 (例: '600330')
name : 股票名称 (例: '天通股份')
price : 股价 (元, 精确到分)
dark_funds : 暗盘净流入 (元)
light_funds : 明盘净流入 (元)
net_inflow : 主力净流入 (元)
total_inflow : 总净流入 (元)
常用示例 (点击直接填入工作区):
1. 查询某只股票最近10分钟的总流入: SELECT timestamp, name, price, total_inflow FROM stock_data WHERE code = '600330' ORDER BY timestamp DESC LIMIT 10;
= CURRENT_DATE GROUP BY code, name ORDER BY total DESC LIMIT 5;'">2. 聚合分析今日总流入排名前5的主力异动股: SELECT code, name, sum(total_inflow) as total FROM stock_data WHERE timestamp >= CURRENT_DATE GROUP BY code, name ORDER BY total DESC LIMIT 5;