56,678
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM AikidoFxTick_T WHERE Symbol="CAD_JPY";
Symbol StartTime OpenPrx HighPrx LowPrx LastPrx
CAD_JPY 1.29059e+012 81.4275 81.45 81.39 81.4325
CAD_JPY 1.29059e+012 81.4375 81.46 81.405 81.4375
CAD_JPY 1.29059e+012 81.4375 81.455 81.395 81.4325
CAD_JPY 1.29059e+012 81.425 81.46 81.41 81.4275
CAD_JPY 1.29059e+012 81.4225 81.455 81.405 81.4275
CAD_JPY 1.29059e+012 81.4275 81.445 81.385 81.4075
CAD_JPY 1.29059e+012 81.4025 81.45 81.38 81.4325
CAD_JPY 1.29059e+012 81.4275 81.445 81.395 81.4225
CAD_JPY 1.29059e+012 81.4125 81.43 81.335 81.3525
CAD_JPY 1.29059e+012 81.388 81.411 81.35 81.373
CAD_JPY 1.29059e+012 81.388 81.411 81.35 81.37
CAD_JPY 1.29062e+012 82.578 82.61 82.55 82.5825
CAD_JPY 1.29062e+012 82.5725 82.595 82.53 82.563
CAD_JPY 1.29062e+012 82.5525 82.59 82.52 82.5675
CAD_JPY 1.29062e+012 82.5455 82.571 82.515 82.54
CAD_JPY 1.29062e+012 82.438 82.461 82.375 82.4325
CAD_JPY 1.29062e+012 82.4325 82.47 82.385 82.4425
CAD_JPY 1.29062e+012 82.4275 82.485 82.405 82.4625
SELECT Symbol,FROM_UNIXTIME(StartTime/1000,'%Y%m%d-%H') AS StartTime,OpenPrx,MAX(HighPrx),MIN(LowPrx),LastPrx FROM AikidoFxTick_t WHERE Symbol='CAD_JPY' GROUP BY StartTime;
得出结果类似
Symbol StartTime OpenPrx MAX(HighPrx) MIN(LowPrx) LastPrx
CAD_JPY 20101124-18 81.4275 81.651 81.33 81.4325
CAD_JPY 20101124-21 81.6025 82.196 81.565 81.593
CAD_JPY 20101124-23 82.1625 82.586 81.985 82.233
CAD_JPY 20101125-02 82.5425 82.661 82.375 82.5575
CAD_JPY 20101125-05 82.548 82.761 82.49 82.5725
CAD_JPY 20101125-08 82.668 82.776 82.485 82.668
CAD_JPY 20101125-10 82.56 82.746 82.44 82.563
CAD_JPY 20101125-13 82.6175 82.776 82.59 82.628
CAD_JPY 20101125-16 82.738 82.803 82.582 82.7125
CAD_JPY 20101125-19 82.761 82.848 82.607 82.7725
CAD_JPY 20101125-21 82.76 82.83 82.636 82.7575