when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

[ Date: 2021-05-09 17:08:50 - Database: acaweb_fx - User: postgres ]

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

[ Date: 2021-05-09 17:08:50 - Database: acaweb_fx - User: postgres ]

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

[ Date: 2021-05-09 17:08:51 - Database: acaweb_fx - User: postgres ]

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, averagequality DESC LIMIT 50;

[ Date: 2021-05-09 17:08:50 - Database: acaweb_fx - User: postgres ]

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

[ Date: 2021-05-09 17:08:51 - Database: acaweb_fx - User: postgres ]

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

[ Date: 2021-05-09 17:08:55 - Database: acaweb_fx - User: postgres ]

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

[ Date: 2021-05-09 17:08:54 - Database: acaweb_fx - User: postgres ]

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, PatternQuality DESC LIMIT 50;

[ Date: 2021-05-09 17:08:53 - Database: acaweb_fx - User: postgres ]

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

[ Date: 2021-05-09 17:08:50 - Database: acaweb_fx - User: postgres ]

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

[ Date: 2021-05-09 17:08:49 - Database: acaweb_fx - User: postgres ]

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, qtp DESC LIMIT 50;

[ Date: 2021-05-09 17:08:51 - Database: acaweb_fx - User: postgres ]

when 1440 then 1 when 240 then 3 when 60 then 4 when 30 then 5 when 15 then 5 end)) ORDER BY relevant DESC, age asc, PatternEndTime DESC, averagequality DESC LIMIT 50;

[ Date: 2021-05-09 17:08:54 - Database: acaweb_fx - User: postgres ]

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM fibonacci_results fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_fibonacci_results rar ON rar.resultuid = fr.resultuid WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR s.symbol in ($7)) AND ($8 = 0 OR fr.pattern in ($9)) AND ($10 = 0 OR fr.patternlengthbars <= $11) AND ($12 = 0 OR ($13 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($14 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $15 OR relevant = 1) AND ($16 = 0 OR age <= $17) ORDER BY identified DESC, length DESC;

[ Date: 2021-05-09 17:06:39 - Database: acaweb_fx - User: postgres ]

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM fibonacci_results fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_fibonacci_results rar ON rar.resultuid = fr.resultuid WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR s.symbol in ($7)) AND ($8 = 0 OR fr.pattern in ($9)) AND ($10 = 0 OR fr.patternlengthbars <= $11) AND ($12 = 0 OR ($13 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($14 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $15 OR relevant = 1) AND ($16 = 0 OR age <= $17) ORDER BY identified DESC, length DESC;

[ Date: 2021-05-09 17:11:37 - Database: acaweb_fx - User: postgres ]

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM fibonacci_results fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_fibonacci_results rar ON rar.resultuid = fr.resultuid WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR s.symbol in ($7)) AND ($8 = 0 OR fr.pattern in ($9)) AND ($10 = 0 OR fr.patternlengthbars <= $11) AND ($12 = 0 OR ($13 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($14 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $15 OR relevant = 1) AND ($16 = 0 OR age <= $17) ORDER BY identified DESC, length DESC;

[ Date: 2021-05-09 17:16:18 - Database: acaweb_fx - User: postgres ]

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM fibonacci_results fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_fibonacci_results rar ON rar.resultuid = fr.resultuid WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR s.symbol in ($7)) AND ($8 = 0 OR fr.pattern in ($9)) AND ($10 = 0 OR fr.patternlengthbars <= $11) AND ($12 = 0 OR ($13 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($14 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $15 OR relevant = 1) AND ($16 = 0 OR age <= $17) ORDER BY identified DESC, length DESC;

[ Date: 2021-05-09 17:21:17 - Database: acaweb_fx - User: postgres ]

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM fibonacci_results fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_fibonacci_results rar ON rar.resultuid = fr.resultuid WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR s.symbol in ($7)) AND ($8 = 0 OR fr.pattern in ($9)) AND ($10 = 0 OR fr.patternlengthbars <= $11) AND ($12 = 0 OR ($13 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($14 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $15 OR relevant = 1) AND ($16 = 0 OR age <= $17) ORDER BY identified DESC, length DESC;

[ Date: 2021-05-09 17:26:20 - Database: acaweb_fx - User: postgres ]

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM fibonacci_results fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_fibonacci_results rar ON rar.resultuid = fr.resultuid WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR s.symbol in ($7)) AND ($8 = 0 OR fr.pattern in ($9)) AND ($10 = 0 OR fr.patternlengthbars <= $11) AND ($12 = 0 OR ($13 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($14 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $15 OR relevant = 1) AND ($16 = 0 OR age <= $17) ORDER BY identified DESC, length DESC;

[ Date: 2021-05-09 17:31:10 - Database: acaweb_fx - User: postgres ]

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM fibonacci_results fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_fibonacci_results rar ON rar.resultuid = fr.resultuid WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR s.symbol in ($7)) AND ($8 = 0 OR fr.pattern in ($9)) AND ($10 = 0 OR fr.patternlengthbars <= $11) AND ($12 = 0 OR ($13 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($14 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $15 OR relevant = 1) AND ($16 = 0 OR age <= $17) ORDER BY identified DESC, length DESC;

[ Date: 2021-05-09 17:36:10 - Database: acaweb_fx - User: postgres ]

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), results AS ( SELECT DISTINCT ON (s.symbolid) fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, s.symbol AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, fr.pattern AS pattern_name, fr.timed AS timed, fr.patternendtime AS identified, dtt.timezone AS timezone, fr.patternlengthbars AS length, g.basegroupname, CASE WHEN rar.age IS NOT NULL THEN rar.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN rar.relevant IS NOT NULL THEN rar.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM fibonacci_results fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $1 AND bsl.symbolid = fr.symbolid INNER JOIN symbols s ON fr.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on fr.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON fr.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN relevance_fibonacci_results rar ON rar.resultuid = fr.resultuid WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($2 = 0 OR s.timegranularity in ($3)) AND ($4 = 0 OR s.exchange in ($5)) AND ($6 = 0 OR s.symbol in ($7)) AND ($8 = 0 OR fr.pattern in ($9)) AND ($10 = 0 OR fr.patternlengthbars <= $11) AND ($12 = 0 OR ($13 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($14 = 2 AND fr.timed < cast('1970-01-01' as timestamp))) ORDER BY symbolid, identified DESC, patternlengthbars DESC ) SELECT * from results WHERE (FALSE = $15 OR relevant = 1) AND ($16 = 0 OR age <= $17) ORDER BY identified DESC, length DESC;

[ Date: 2021-05-09 17:41:23 - Database: acaweb_fx - User: postgres ]

insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1035, '2021-05-09 00:00:00', 0.000463090122479943, 0.00132269230769231, 0.000883856410196918, 0.00185807692307693, 0.00117259962673344, 0.00237826923076924, 0.00357277104801561, 0.00410480769230767, 0.00350154671318486, 0.0104592307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1035); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1050, '2021-05-09 00:00:00', 0.000631126465444595, 0.00120115384615382, 0.000819079126449076, 0.00161884615384616, 0.00101159632036924, 0.00212634615384615, 0.00339445700313816, 0.00383711538461536, 0.00347443551585667, 0.0103869230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1050); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1065, '2021-05-09 00:00:00', 0.000380245922448174, 0.000979807692307706, 0.000573375866788419, 0.00142173076923077, 0.000720286721756309, 0.00183980769230768, 0.00342550565048992, 0.00353480769230766, 0.00346989705012434, 0.0102715384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1065); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1080, '2021-05-09 00:00:00', 0.000530996342157469, 0.00103134615384617, 0.000617683669352385, 0.00140634615384614, 0.000823806105828301, 0.00186249999999998, 0.00342805255883771, 0.00350711538461536, 0.00347942500223154, 0.0102871153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1080); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1095, '2021-05-09 00:00:00', 0.000500705387044516, 0.000938269230769203, 0.000574155567232982, 0.00124615384615381, 0.00103989476168723, 0.00181634615384609, 0.00345194032950477, 0.00340596153846151, 0.00347524244311985, 0.0103509615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1095); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1110, '2021-05-09 00:00:00', 0.000418391425121756, 0.00084576923076922, 0.000778389659192937, 0.00126269230769229, 0.00114634610158337, 0.00178923076923075, 0.00346342898673465, 0.0033178846153846, 0.00348305690229365, 0.0103342307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1110); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1125, '2021-05-09 00:00:00', 0.000673239956079215, 0.000919038461538427, 0.000883171492189004, 0.00131826923076917, 0.00161592541954708, 0.00169019230769227, 0.00348868371143924, 0.00318403846153845, 0.0035042077399343, 0.0102832692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1125); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1140, '2021-05-09 00:00:00', 0.000558949873905031, 0.00086980769230766, 0.000786386599971904, 0.00106326923076924, 0.00135661320375977, 0.00150576923076922, 0.00313924606945926, 0.00306826923076922, 0.00351165731747629, 0.0102763461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1140); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1155, '2021-05-09 00:00:00', 0.00037048326028829, 0.000660384615384612, 0.000912516554117464, 0.00105730769230768, 0.00276692214452197, 0.0019769230769231, 0.00309969036294817, 0.00307288461538462, 0.00351564956794836, 0.0103167307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1155); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1170, '2021-05-09 00:00:00', 0.000735047041927361, 0.000786923076923048, 0.00113326492252048, 0.00114423076923077, 0.00300890138397081, 0.00206346153846155, 0.00302938275637388, 0.00295673076923077, 0.0035104538168163, 0.01035 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1170); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1185, '2021-05-09 00:00:00', 0.000919823917095821, 0.00091403846153848, 0.0025288910308975, 0.00163461538461542, 0.00294644615792287, 0.00201980769230772, 0.00283631872056287, 0.00284826923076924, 0.00354725276148265, 0.0103980769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1185); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1200, '2021-05-09 00:00:00', 0.00213289330397793, 0.0011996153846154, 0.00244109301653677, 0.00152634615384614, 0.00255151318602542, 0.00193153846153848, 0.00242375129626657, 0.0026271153846154, 0.003440201028339, 0.0103436538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1200); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1215, '2021-05-09 00:00:00', 0.00101853063471166, 0.000849423076923056, 0.00115324760501012, 0.00111403846153847, 0.0011984248636632, 0.00165807692307691, 0.0013453936369931, 0.00242096153846153, 0.00343034224015848, 0.0103732692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1215); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1230, '2021-05-09 00:00:00', 0.000712054449084861, 0.000761538461538463, 0.000766532150964025, 0.00112346153846155, 0.000976806807133081, 0.00159653846153847, 0.00137570369405848, 0.00239942307692307, 0.00341045833260892, 0.0103409615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1230); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1245, '2021-05-09 00:00:00', 0.0005916420760509, 0.000897115384615386, 0.000770735437997103, 0.00131134615384614, 0.00081161835005981, 0.00151288461538462, 0.00121687267837871, 0.00232865384615383, 0.00334727264408594, 0.0103930769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1245); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1260, '2021-05-09 00:00:00', 0.000629729398539249, 0.000963653846153831, 0.000720166567271342, 0.00114326923076923, 0.000727162054734795, 0.00136442307692308, 0.00116976278002784, 0.00225519230769229, 0.00325068087542382, 0.0103980769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1260); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1275, '2021-05-09 00:00:00', 0.000535342880778295, 0.000690000000000037, 0.000516932408913021, 0.000833653846153868, 0.00092787061846754, 0.00129326923076924, 0.00106392909321281, 0.00215134615384615, 0.00328701111018224, 0.0103609615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1275); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1290, '2021-05-09 00:00:00', 0.000277571404534756, 0.000533269230769223, 0.00045669262512785, 0.000848076923076919, 0.000729229625120797, 0.00114038461538461, 0.000864205215123204, 0.00219557692307693, 0.00321065514522169, 0.0102973076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1290); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1305, '2021-05-09 00:00:00', 0.000468548823496539, 0.000705000000000033, 0.000741064333343473, 0.000987115384615378, 0.000752822790466752, 0.00115807692307692, 0.000944696797105615, 0.00238903846153847, 0.00321491801546382, 0.0102903846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1305); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1320, '2021-05-09 00:00:00', 0.000452391933547035, 0.000682307692307662, 0.000444229670328284, 0.000784999999999984, 0.000734081844106038, 0.00121192307692307, 0.00103021971144325, 0.0024794230769231, 0.00320869566119223, 0.0102746153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1320); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1335, '2021-05-09 00:00:00', 0.000288462035897003, 0.000477115384615402, 0.000660811534868615, 0.000838269230769223, 0.000720024999565991, 0.00128500000000001, 0.00100229054976782, 0.00249788461538464, 0.0032352846028655, 0.0102773076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1335); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1350, '2021-05-09 00:00:00', 0.000599497385636196, 0.000626346153846166, 0.000678534421778639, 0.000945192307692317, 0.000666172996704665, 0.0012073076923077, 0.000972369034092275, 0.00264346153846155, 0.00323319563875458, 0.0102790384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1350); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1365, '2021-05-09 00:00:00', 0.00037004142179783, 0.000710576923076924, 0.000475460788644492, 0.00102019230769231, 0.00046171923703281, 0.00112557692307692, 0.00102849920533982, 0.00279884615384617, 0.00333611870868853, 0.0102990384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1365); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1380, '2021-05-09 00:00:00', 0.000392337374442744, 0.000718846153846149, 0.000377865106170887, 0.000789038461538455, 0.000463485001002051, 0.00106211538461539, 0.00115479588606022, 0.00278846153846154, 0.00337769247586847, 0.0103276923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1380); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1395, '2021-05-09 00:00:00', 0.000202623181907091, 0.00047192307692306, 0.000270684389024439, 0.000685961538461523, 0.00068936060118166, 0.00115403846153845, 0.00111787925933957, 0.00284903846153846, 0.00338669566664346, 0.0103165384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1395); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1410, '2021-05-09 00:00:00', 0.000278511220599843, 0.000487499999999974, 0.000326333241664693, 0.000744230769230768, 0.000733804443662253, 0.00124019230769229, 0.00109807105346677, 0.00297096153846154, 0.00338669566664346, 0.0103165384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1410); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 1, 1425, '2021-05-09 00:00:00', 0.000242776567111546, 0.000567692307692303, 0.000686146093436736, 0.000992692307692303, 0.00073244377573669, 0.00130673076923076, 0.00111007123818531, 0.00304807692307692, 0.00339564986416444, 0.010305 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 1 and fromtime = 1425); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 0, '2021-05-09 00:00:00', 0.000680997458483921, 0.000833461538461524, 0.000719994337584579, 0.00104461538461538, 0.000721555291340538, 0.00127596153846153, 0.00124950828790309, 0.0031901923076923, 0.00341551804832906, 0.0102865384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 0); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 15, '2021-05-09 00:00:00', 0.000418084321638615, 0.000592499999999987, 0.000479225376559376, 0.000794807692307673, 0.000489679526283833, 0.0011609615384615, 0.00126725209986626, 0.00313173076923075, 0.00342115983481986, 0.0102688461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 15); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 30, '2021-05-09 00:00:00', 0.000250882749200008, 0.000508076923076929, 0.000292582204096311, 0.000727115384615374, 0.000417059486625856, 0.00122384615384617, 0.00110580741472538, 0.00310903846153844, 0.0033368512622162, 0.0102528846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 30); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 45, '2021-05-09 00:00:00', 0.000216367653632562, 0.000505192307692312, 0.000349531774719376, 0.000847307692307666, 0.000637280671169463, 0.00140442307692307, 0.00109840135581745, 0.00308846153846152, 0.00335626133574938, 0.0102519230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 45); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 60, '2021-05-09 00:00:00', 0.000311911229975145, 0.000718846153846123, 0.000434174947014904, 0.000991730769230767, 0.000755481405360955, 0.00151192307692307, 0.00111084827254465, 0.00311173076923075, 0.00339584540850458, 0.0102640384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 60); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 75, '2021-05-09 00:00:00', 0.000406566675390989, 0.000647307692307706, 0.000573124231397852, 0.00103576923076924, 0.000664204671884972, 0.00146961538461539, 0.00109743589264317, 0.00305653846153846, 0.00341921637446136, 0.0102261538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 75); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 90, '2021-05-09 00:00:00', 0.00026722361710459, 0.000637692307692326, 0.000432086396275272, 0.000955576923076949, 0.000565353837466842, 0.0014951923076923, 0.00106066387048576, 0.00290038461538461, 0.00349718744685804, 0.0102240384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 90); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 105, '2021-05-09 00:00:00', 0.000297313613235879, 0.000689230769230758, 0.000399982307300999, 0.00107461538461537, 0.000673540930170824, 0.00161076923076923, 0.000988077484504422, 0.00286634615384616, 0.00348207005187342, 0.0102296153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 105); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 120, '2021-05-09 00:00:00', 0.000307240134097063, 0.000837500000000021, 0.000420887203965104, 0.00119596153846153, 0.00054361072044673, 0.00164384615384615, 0.000977649713107114, 0.00287519230769231, 0.00343945082825732, 0.01024 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 120); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 135, '2021-05-09 00:00:00', 0.000344584755678748, 0.000825576923076909, 0.000490889146188992, 0.00118692307692308, 0.000561146251332572, 0.00161134615384615, 0.00102983196911699, 0.00274673076923078, 0.00337908114501787, 0.0104157692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 135); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 150, '2021-05-09 00:00:00', 0.000346360916697266, 0.000793269230769235, 0.000480258303896463, 0.00109096153846154, 0.000555421946326859, 0.00161653846153847, 0.00098257724300002, 0.00263903846153847, 0.003722652362951, 0.0106788461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 150); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 165, '2021-05-09 00:00:00', 0.000250315570061824, 0.000716730769230751, 0.000499813349777067, 0.00116576923076922, 0.000614045976730121, 0.0015526923076923, 0.000913670134887086, 0.00261865384615384, 0.00361500161187325, 0.0106805769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 165); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 180, '2021-05-09 00:00:00', 0.000403065608326226, 0.000843269230769238, 0.000450293750276937, 0.00114230769230769, 0.00074818706525531, 0.00162173076923076, 0.000873666896565192, 0.0026003846153846, 0.00362324641935722, 0.0106538461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 180); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 195, '2021-05-09 00:00:00', 0.000241229861654458, 0.000739615384615422, 0.000335836498680757, 0.00103807692307694, 0.000687075211424342, 0.00146788461538465, 0.000789395874168252, 0.0025046153846154, 0.00365158718388849, 0.0105698076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 195); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 210, '2021-05-09 00:00:00', 0.000259365794553966, 0.000673846153846145, 0.000560599816131003, 0.00101692307692307, 0.000583095222465003, 0.00129403846153848, 0.000735842296022313, 0.00238826923076924, 0.00364999622760609, 0.0105923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 210); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 225, '2021-05-09 00:00:00', 0.000541528747727554, 0.00073923076923077, 0.00055286846397812, 0.000946538461538454, 0.000524011340159147, 0.00123826923076921, 0.000790427172726621, 0.00241365384615386, 0.00362062533910292, 0.0106146153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 225); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 240, '2021-05-09 00:00:00', 0.000278660808428172, 0.000620384615384606, 0.00029772476964729, 0.000824038461538454, 0.000354812680807117, 0.00113096153846153, 0.000802043543801629, 0.00248461538461541, 0.00358143276013734, 0.0106411538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 240); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 255, '2021-05-09 00:00:00', 0.000232149818999582, 0.000558461538461559, 0.000304724655032447, 0.000783653846153847, 0.000353414607246773, 0.00107826923076922, 0.000855167842275178, 0.00271403846153849, 0.00358340961397642, 0.0106576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 255); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 270, '2021-05-09 00:00:00', 0.00025488036409266, 0.000589999999999988, 0.000282534953589802, 0.000814999999999985, 0.000408697979517312, 0.00106903846153845, 0.000903423403589869, 0.0029346153846154, 0.00361362243675026, 0.0106913461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 270); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 285, '2021-05-09 00:00:00', 0.000208743862185216, 0.000559999999999988, 0.000307386314194094, 0.000772115384615379, 0.000436036872117677, 0.00115307692307694, 0.00108078788924489, 0.00323269230769229, 0.00360242078864502, 0.0107084615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 285); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 300, '2021-05-09 00:00:00', 0.000241415377752472, 0.000554230769230736, 0.000320614314186893, 0.00078153846153844, 0.000600611227129346, 0.00121038461538461, 0.00138002069382479, 0.00359134615384614, 0.00360666646108824, 0.0107001923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 300); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 315, '2021-05-09 00:00:00', 0.000192904220953145, 0.000490961538461535, 0.000289599989375257, 0.000813076923076946, 0.000537529999162829, 0.00121750000000002, 0.00136012555981482, 0.00397653846153846, 0.00361060293281632, 0.0106934615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 315); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 330, '2021-05-09 00:00:00', 0.000229068011398708, 0.000603076923076954, 0.000423085234184091, 0.00085865384615386, 0.000409707634971392, 0.0012071153846154, 0.00124058877151133, 0.00429750000000001, 0.0036066331198971, 0.0107026923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 330); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 345, '2021-05-09 00:00:00', 0.000245950276400624, 0.000561538461538451, 0.000391991218504475, 0.000838653846153883, 0.000443578498819998, 0.00116826923076922, 0.00126036424832724, 0.00447596153846153, 0.00362893724642101, 0.0107365384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 345); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 360, '2021-05-09 00:00:00', 0.000308374210734537, 0.000620576923076958, 0.000267642413564199, 0.000792307692307673, 0.000504292230602638, 0.00124442307692307, 0.00134295065491566, 0.00454269230769231, 0.00363701602119949, 0.0107534615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 360); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 375, '2021-05-09 00:00:00', 0.000184521001514744, 0.000539999999999985, 0.000358556346821728, 0.0008555769230769, 0.000483201343604895, 0.00132153846153843, 0.00131109214603115, 0.00463615384615383, 0.00359885407509755, 0.0107894230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 375); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 390, '2021-05-09 00:00:00', 0.000338855993919785, 0.000634230769230757, 0.000449527957545889, 0.000934230769230749, 0.000616678478750371, 0.00140288461538459, 0.00153022367646037, 0.00494249999999998, 0.0035793039987384, 0.0108063461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 390); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 405, '2021-05-09 00:00:00', 0.000360980555623803, 0.000655192307692313, 0.000451179991373103, 0.000995769230769212, 0.000618755481716239, 0.00146211538461538, 0.00172324015023575, 0.00514115384615382, 0.00351198105939351, 0.0107898076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 405); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 420, '2021-05-09 00:00:00', 0.000343985297091923, 0.000803269230769207, 0.000580621682734607, 0.00112346153846151, 0.000639719048910141, 0.0017176923076923, 0.00175056746843372, 0.00522269230769227, 0.00348271934534808, 0.0107959615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 420); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 435, '2021-05-09 00:00:00', 0.000416881462583981, 0.000701923076923055, 0.000423397612725364, 0.00106346153846155, 0.000786727325453592, 0.00196673076923078, 0.00187761006027915, 0.00541653846153843, 0.00347330080205252, 0.0108076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 435); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 450, '2021-05-09 00:00:00', 0.000407943812118986, 0.000818076923076945, 0.00059828241337505, 0.00134038461538464, 0.000910011010077102, 0.00218096153846157, 0.0020577644423014, 0.00557749999999999, 0.00346723836570484, 0.0108267307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 450); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 465, '2021-05-09 00:00:00', 0.000406599784327778, 0.000884230769230746, 0.000664743472788879, 0.00158673076923077, 0.000914387310632738, 0.00252192307692306, 0.00210648443000325, 0.0055705769230769, 0.00344739904186422, 0.0108519230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 465); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 480, '2021-05-09 00:00:00', 0.000606634600448686, 0.00130153846153848, 0.000751521354423046, 0.00177288461538464, 0.00116141273389852, 0.00292653846153846, 0.00211435525724655, 0.00552307692307691, 0.00344146031727591, 0.0108763461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 480); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 495, '2021-05-09 00:00:00', 0.000444975885258453, 0.00114346153846154, 0.000648535154138796, 0.00185961538461535, 0.000992416262695021, 0.00310403846153845, 0.00210473372151004, 0.00540596153846151, 0.00351784103371112, 0.0109934615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 495); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 510, '2021-05-09 00:00:00', 0.000574459880101409, 0.00144192307692306, 0.000963693216425543, 0.00218115384615384, 0.00110811308781394, 0.00324384615384615, 0.00223669956890469, 0.00554980769230768, 0.00366167668614342, 0.0111330769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 510); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 525, '2021-05-09 00:00:00', 0.000662290315147724, 0.0014076923076923, 0.000840553686566181, 0.00232249999999999, 0.00100025189135231, 0.00318038461538461, 0.00214099786224876, 0.00569461538461538, 0.0037634682296234, 0.0112413461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 525); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 540, '2021-05-09 00:00:00', 0.000785753068473412, 0.00192673076923075, 0.00101402861816693, 0.00250096153846151, 0.00100810118539759, 0.00315999999999999, 0.00221685733901359, 0.00584769230769231, 0.00380573527213054, 0.0112501923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 540); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 555, '2021-05-09 00:00:00', 0.000669281618315778, 0.00150173076923075, 0.000926568192517192, 0.00213115384615385, 0.000977580628191537, 0.00281326923076923, 0.00209747952222516, 0.0057421153846154, 0.00382797729275476, 0.0111969230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 555); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 570, '2021-05-09 00:00:00', 0.000786091695571279, 0.00143307692307692, 0.000914843681477019, 0.00201519230769232, 0.00107127172808052, 0.00294134615384615, 0.00200557718528953, 0.00566038461538462, 0.00384452075636924, 0.0111446153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 570); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 585, '2021-05-09 00:00:00', 0.000575190938197575, 0.00146115384615386, 0.000725691500464311, 0.00206307692307695, 0.00123999776674735, 0.00303769230769232, 0.00215219187019974, 0.00566461538461539, 0.00396975488489579, 0.0112103846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 585); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 600, '2021-05-09 00:00:00', 0.000414728085153874, 0.00141076923076926, 0.000910091204220754, 0.00209500000000003, 0.00130015627758891, 0.0030221153846154, 0.00198191286775795, 0.00562384615384617, 0.00382863916876682, 0.0111332692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 600); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 615, '2021-05-09 00:00:00', 0.000763536911605856, 0.00142115384615384, 0.000897724923604937, 0.00205403846153844, 0.00155767020307201, 0.00304230769230771, 0.00185542232389284, 0.00544500000000001, 0.0037233115791436, 0.0110636538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 615); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 630, '2021-05-09 00:00:00', 0.000743507203420663, 0.00148480769230769, 0.00093106120182212, 0.00214480769230768, 0.00138795556623622, 0.00311442307692308, 0.00215157953606179, 0.00543749999999999, 0.00369493551520709, 0.0109923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 630); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 645, '2021-05-09 00:00:00', 0.000621042300058159, 0.00143846153846152, 0.00134765238898555, 0.00208019230769233, 0.00128429609574211, 0.00278269230769232, 0.00198300452887487, 0.00538980769230769, 0.00362010340375053, 0.0110605769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 645); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 660, '2021-05-09 00:00:00', 0.000995201429166651, 0.00157826923076925, 0.00103357802727298, 0.00223653846153847, 0.00140929268947771, 0.00273326923076925, 0.00196397571659745, 0.00536884615384617, 0.00362777726502269, 0.0109982692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 660); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 675, '2021-05-09 00:00:00', 0.000813340405601903, 0.00150615384615382, 0.000763275154540267, 0.0018301923076923, 0.00121627130386908, 0.00262326923076924, 0.00200993705412343, 0.0054348076923077, 0.00367869753288602, 0.0109965384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 675); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 690, '2021-05-09 00:00:00', 0.000293184439192507, 0.00116365384615381, 0.00117051009590496, 0.00174173076923075, 0.00125054414310179, 0.0026455769230769, 0.00188395582179134, 0.00517846153846153, 0.00352084812771892, 0.0108365384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 690); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 705, '2021-05-09 00:00:00', 0.000925294215163685, 0.00123923076923077, 0.000904322887366771, 0.00181173076923078, 0.00106394297490332, 0.00272557692307694, 0.00190519840477007, 0.0052148076923077, 0.00353175997202531, 0.0108175 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 705); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 720, '2021-05-09 00:00:00', 0.000682706041031966, 0.00133846153846154, 0.00088164385361401, 0.00193826923076924, 0.00107159485742588, 0.00278846153846156, 0.00209581759335476, 0.00525576923076926, 0.00356705894799369, 0.0108434615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 720); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 735, '2021-05-09 00:00:00', 0.000548178697702994, 0.00130173076923078, 0.000527761783383348, 0.00178750000000003, 0.000851756398002672, 0.00252519230769233, 0.00214258543497191, 0.00521288461538462, 0.00349459609749334, 0.0107517307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 735); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 750, '2021-05-09 00:00:00', 0.000423740350468752, 0.00128173076923079, 0.000817768916014827, 0.00186500000000002, 0.000837137154464355, 0.00245384615384617, 0.00206873874619296, 0.00523500000000001, 0.00343561355510195, 0.0106375 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 750); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 765, '2021-05-09 00:00:00', 0.000602246723016948, 0.00134865384615386, 0.000646679566353007, 0.0017373076923077, 0.000897023989903055, 0.00232903846153847, 0.00210466508389924, 0.00516865384615385, 0.00356573844439638, 0.0106905769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 765); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 780, '2021-05-09 00:00:00', 0.000418284638089378, 0.00126096153846154, 0.000679018890640156, 0.00174442307692305, 0.000737807484792196, 0.00232673076923075, 0.00227442611527528, 0.00542307692307692, 0.00358874025465549, 0.0107011538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 780); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 795, '2021-05-09 00:00:00', 0.000599972948108122, 0.00119846153846153, 0.000657930116700501, 0.00163596153846154, 0.000718290090315975, 0.00231557692307692, 0.00274476239689062, 0.00596384615384615, 0.00362672227521471, 0.0107326923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 795); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 810, '2021-05-09 00:00:00', 0.000462781265826525, 0.00115250000000002, 0.000630450632484386, 0.00171000000000001, 0.00172985087174052, 0.00256403846153847, 0.00273805790942862, 0.00603134615384618, 0.00367659562429911, 0.0106742307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 810); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 825, '2021-05-09 00:00:00', 0.00056437661321005, 0.00122980769230769, 0.000600933152560373, 0.00180557692307692, 0.00167411404813225, 0.00286038461538461, 0.00274532450793093, 0.00600942307692309, 0.00371277383346489, 0.0106434615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 825); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 840, '2021-05-09 00:00:00', 0.000429974417843681, 0.001315, 0.00175196471030491, 0.00211288461538461, 0.0016331729853264, 0.00297500000000001, 0.00273273185377113, 0.00596423076923078, 0.00375597118445571, 0.0105915384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 840); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 855, '2021-05-09 00:00:00', 0.00182848583848453, 0.00157769230769232, 0.00178150382671927, 0.00219673076923079, 0.00177523966962643, 0.00303673076923078, 0.00274351299221666, 0.00607346153846156, 0.0038016509419745, 0.0106082692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 855); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 870, '2021-05-09 00:00:00', 0.0005622133799683, 0.00139326923076923, 0.000580859177955685, 0.00195423076923074, 0.00103552820041084, 0.00270442307692306, 0.002441289641846, 0.00587134615384617, 0.00388000624503863, 0.0106376923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 870); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 885, '2021-05-09 00:00:00', 0.000567141415006323, 0.00151423076923077, 0.0010191204352472, 0.00211769230769232, 0.00111365800578369, 0.00290807692307693, 0.00232714556914689, 0.00575250000000002, 0.00385395978682469, 0.0106459615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 885); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 900, '2021-05-09 00:00:00', 0.00072723850706204, 0.00155961538461538, 0.000828809920678657, 0.00194326923076923, 0.00144920689184967, 0.00306884615384615, 0.00230869681022401, 0.00567980769230771, 0.00400609390131511, 0.0108621153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 900); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 915, '2021-05-09 00:00:00', 0.000543340946934242, 0.00117576923076921, 0.000799830847501776, 0.0020057692307692, 0.00129157109158396, 0.00296826923076921, 0.00215134315826542, 0.00542423076923079, 0.00408662044406456, 0.0109755769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 915); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 930, '2021-05-09 00:00:00', 0.000587070989024171, 0.00150211538461536, 0.000808158305132011, 0.00215538461538458, 0.00106887043181108, 0.00296999999999999, 0.00219928503242444, 0.00526557692307694, 0.00443959754326383, 0.0111228846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 930); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 945, '2021-05-09 00:00:00', 0.000593672177086122, 0.00154557692307689, 0.00085035460928866, 0.00217480769230769, 0.00103141308966799, 0.00304519230769232, 0.00209733816648995, 0.0051992307692308, 0.00452108986179902, 0.0113434615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 945); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 960, '2021-05-09 00:00:00', 0.000694130668257363, 0.00168923076923077, 0.000939838365808806, 0.00238192307692307, 0.00137432670228568, 0.00358173076923078, 0.00205563903595788, 0.00507538461538464, 0.00448856207915874, 0.0113134615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 960); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 975, '2021-05-09 00:00:00', 0.000867710803471712, 0.00166403846153843, 0.000984987543849379, 0.0022426923076923, 0.00211774633477705, 0.00393153846153849, 0.00198940656980922, 0.00483750000000002, 0.00474877989593119, 0.0113275 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 975); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 990, '2021-05-09 00:00:00', 0.000570544004909761, 0.0013826923076923, 0.00126343713124767, 0.00262923076923079, 0.00207657736154025, 0.00354346153846158, 0.00188739422525832, 0.00438980769230771, 0.00457805973765509, 0.0111251923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 990); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1005, '2021-05-09 00:00:00', 0.00120291747910589, 0.0021176923076923, 0.00200161872954408, 0.00295653846153848, 0.00193184200659929, 0.00327846153846156, 0.00177767385820736, 0.00427711538461541, 0.00454948101858461, 0.0110784615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1005); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1020, '2021-05-09 00:00:00', 0.00184788974238186, 0.00205250000000001, 0.0018169084901388, 0.00241269230769233, 0.00168319070860625, 0.00277980769230771, 0.00159811749832778, 0.00382846153846155, 0.00447253904828809, 0.0109234615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1020); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1035, '2021-05-09 00:00:00', 0.000700698662325421, 0.00127884615384617, 0.000963027058490383, 0.00172634615384617, 0.00104810686478048, 0.00240000000000003, 0.00123854835935522, 0.00341096153846152, 0.0041632438027983, 0.0106848076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1035); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1050, '2021-05-09 00:00:00', 0.000698660614208463, 0.00124442307692307, 0.000826253569758349, 0.00164480769230767, 0.000979416231153083, 0.00228692307692308, 0.00115063467436284, 0.00321692307692305, 0.00424229293950988, 0.0106307692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1050); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1065, '2021-05-09 00:00:00', 0.000573724136336762, 0.00112923076923075, 0.000731797891392253, 0.00162807692307693, 0.000932677060938042, 0.00211749999999998, 0.00109518737420377, 0.00307423076923073, 0.00422832793375639, 0.0105736538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1065); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1080, '2021-05-09 00:00:00', 0.000534758500489854, 0.0011544230769231, 0.000595009663787079, 0.00149250000000002, 0.000902508661795232, 0.00194173076923076, 0.000992331907873845, 0.00287115384615382, 0.00403389909202195, 0.0104532692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1080); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1095, '2021-05-09 00:00:00', 0.000459497384273119, 0.000999615384615383, 0.000682318220368019, 0.00137192307692303, 0.000861567087436531, 0.00189538461538457, 0.00101220133296767, 0.00278153846153843, 0.004045997609224, 0.0104155769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1095); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1110, '2021-05-09 00:00:00', 0.000369215384294841, 0.000954999999999954, 0.000694015517450092, 0.00137846153846149, 0.000740768545810047, 0.0017609615384615, 0.000974090285659081, 0.00270173076923073, 0.00401487924907033, 0.0104242307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1110); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1125, '2021-05-09 00:00:00', 0.000530453942030211, 0.000920769230769234, 0.000525522487259503, 0.00122173076923076, 0.000628497506267632, 0.00154865384615385, 0.00114853565632336, 0.00259692307692306, 0.00402769476442602, 0.0103663461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1125); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1140, '2021-05-09 00:00:00', 0.000334233969180058, 0.000907884615384611, 0.000337198013042791, 0.00113250000000001, 0.000514899392712183, 0.00141576923076923, 0.00120666477723325, 0.00266673076923077, 0.00399918890334221, 0.0103917307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1140); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1155, '2021-05-09 00:00:00', 0.000276654741788128, 0.000715384615384605, 0.000472137732511947, 0.00103096153846155, 0.000468383348912442, 0.00141019230769229, 0.00118858927369315, 0.0025876923076923, 0.00401782105605284, 0.0103690384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1155); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1170, '2021-05-09 00:00:00', 0.000356841701598889, 0.000760000000000008, 0.000386187329991685, 0.000990576923076931, 0.000595741845226422, 0.00141211538461536, 0.00114746632261622, 0.00256019230769231, 0.00401829694599017, 0.0103671153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1170); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1185, '2021-05-09 00:00:00', 0.00023779637378355, 0.000743653846153859, 0.00034404812945954, 0.00104365384615383, 0.000655141088738778, 0.00143461538461538, 0.00111121672745894, 0.00247615384615384, 0.00399474678604483, 0.0104182692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1185); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1200, '2021-05-09 00:00:00', 0.000284726386877997, 0.000686346153846132, 0.000454717367840042, 0.000953269230769207, 0.000601053690165421, 0.00139153846153844, 0.00113784636315883, 0.00235788461538461, 0.00404451799923722, 0.0103396153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1200); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1215, '2021-05-09 00:00:00', 0.000444324249238705, 0.00070096153846151, 0.000495019191547164, 0.000969999999999992, 0.000642519230481429, 0.00142019230769229, 0.00114792917229912, 0.00235576923076924, 0.00406530269475719, 0.01031 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1215); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1230, '2021-05-09 00:00:00', 0.000396673863326231, 0.000693076923076946, 0.000477834538468966, 0.00101038461538461, 0.00065390910330461, 0.00141365384615384, 0.00113433445413874, 0.00238557692307695, 0.00400315452535201, 0.0102519230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1230); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1245, '2021-05-09 00:00:00', 0.000268811915944649, 0.000784615384615392, 0.000360913371238131, 0.00112230769230771, 0.000523176393257131, 0.00132153846153844, 0.00103757700362989, 0.00231096153846157, 0.00390559962893517, 0.0103523076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1245); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1260, '2021-05-09 00:00:00', 0.00030155041675674, 0.000754423076923092, 0.000448196771690567, 0.000907115384615392, 0.000531472591376662, 0.00123134615384618, 0.00122553096813022, 0.00231692307692311, 0.00390023955871748, 0.0103311538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1260); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1275, '2021-05-09 00:00:00', 0.00030926668849939, 0.000598269230769239, 0.000358692711855757, 0.00075269230769232, 0.000596814138056911, 0.00123365384615386, 0.00119092176646756, 0.0022894230769231, 0.00388740779757096, 0.0103157692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1275); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1290, '2021-05-09 00:00:00', 0.000202214375963096, 0.000495576923076916, 0.000423303718931868, 0.000904038461538466, 0.00063796515458255, 0.00122846153846153, 0.00111893995164382, 0.00226884615384617, 0.0038818313134594, 0.0103128846153847 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1290); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1305, '2021-05-09 00:00:00', 0.000419236164397201, 0.000774807692307695, 0.000504777635735253, 0.000992307692307694, 0.000738818729719685, 0.00127365384615385, 0.00116521949071345, 0.0022876923076923, 0.00387990463800337, 0.010315 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1305); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1320, '2021-05-09 00:00:00', 0.000318016267121438, 0.000702115384615381, 0.000421800946492, 0.000924038461538443, 0.000639357520063356, 0.00125403846153845, 0.000994014858270012, 0.00231346153846152, 0.00369065353812323, 0.0102515384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1320); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1335, '2021-05-09 00:00:00', 0.000344252814077073, 0.000514999999999983, 0.000472624749506563, 0.000746923076923077, 0.000543851117918775, 0.00128403846153845, 0.00129168644980713, 0.00247173076923075, 0.00369125730091231, 0.0102423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1335); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1350, '2021-05-09 00:00:00', 0.00027625914534114, 0.000496346153846177, 0.000382691932740452, 0.000871346153846157, 0.000481660788714022, 0.00124634615384615, 0.00230517985281977, 0.0028180769230769, 0.00368561722729773, 0.0102371153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1350); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1365, '2021-05-09 00:00:00', 0.000283696818126959, 0.000698269230769236, 0.00041390862053576, 0.00106288461538462, 0.000447348986122244, 0.00126134615384616, 0.00232531202207359, 0.00299999999999999, 0.0036817026422776, 0.0102371153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1365); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1380, '2021-05-09 00:00:00', 0.000328726271445486, 0.000804807692307695, 0.000431886381070117, 0.000944615384615381, 0.000447031275794497, 0.00107519230769232, 0.00231247680237845, 0.00303019230769229, 0.00367824484168531, 0.0102313461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1380); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1395, '2021-05-09 00:00:00', 0.00042023857692798, 0.000572307692307727, 0.000422314501836643, 0.000778461538461565, 0.000549265383524626, 0.00108269230769233, 0.00226490913385405, 0.00300076923076926, 0.00365393847049371, 0.0102071153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1395); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1410, '2021-05-09 00:00:00', 0.000362585374561856, 0.000578076923076935, 0.00038735453845481, 0.00071846153846154, 0.000674337424097525, 0.00118519230769231, 0.00224950524474917, 0.00297961538461541, 0.00377797731800825, 0.0103061538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1410); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 2, 1425, '2021-05-09 00:00:00', 0.000300675713378004, 0.000476730769230792, 0.000479850016631821, 0.000830961538461559, 0.000636297100417756, 0.00112500000000001, 0.00222174537244937, 0.00303750000000003, 0.00377200724467045, 0.010300576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 2 and fromtime = 1425); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 0, '2021-05-09 00:00:00', 0.000409146249947581, 0.000669423076923073, 0.000579282215000073, 0.00090173076923075, 0.000769349075517731, 0.00115, 0.00224481991739619, 0.0030473076923077, 0.00372248231901572, 0.0102588461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 0); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 15, '2021-05-09 00:00:00', 0.00032776005529375, 0.000549423076923072, 0.000332018593084575, 0.000692115384615384, 0.000478072290960934, 0.00102365384615387, 0.00225368386459561, 0.00291980769230772, 0.00366913939291156, 0.0102082692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 15); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 30, '2021-05-09 00:00:00', 0.00020453521419589, 0.000489423076923072, 0.000387726906270583, 0.000713076923076923, 0.000450824757015924, 0.0010601923076923, 0.00225323367629728, 0.00296500000000001, 0.00367867070473102, 0.0102119230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 30); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 45, '2021-05-09 00:00:00', 0.000341859845325752, 0.000513076923076928, 0.000354246546044724, 0.000776153846153858, 0.000462500103950083, 0.00115211538461537, 0.00212857302326811, 0.00297634615384616, 0.00367827352895978, 0.010213076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 45); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 60, '2021-05-09 00:00:00', 0.000256957120038475, 0.000629807692307719, 0.000340156581591454, 0.00087750000000001, 0.000511328774258426, 0.00135134615384615, 0.00212536382405825, 0.00297076923076924, 0.00367477099234142, 0.0102396153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 60); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 75, '2021-05-09 00:00:00', 0.000248736886009157, 0.000529038461538469, 0.000268263647584561, 0.000779230769230767, 0.000920620714518204, 0.00152249999999999, 0.00208580308274778, 0.00291749999999998, 0.00362151651723631, 0.0102567307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 75); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 90, '2021-05-09 00:00:00', 0.000192862246574685, 0.000564615384615377, 0.000434368551418641, 0.00102096153846154, 0.00205985945188952, 0.00186480769230768, 0.00200864776557612, 0.00293538461538461, 0.00365229727495112, 0.0103257692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 90); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 105, '2021-05-09 00:00:00', 0.000406452760051921, 0.000765384615384625, 0.00083240395611375, 0.00121711538461537, 0.00211031558886709, 0.00192673076923075, 0.00192771869955537, 0.00297076923076921, 0.00367802009866094, 0.0103453846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 105); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 120, '2021-05-09 00:00:00', 0.000764998340873009, 0.000937692307692302, 0.00199278294970011, 0.00152826923076923, 0.00200052027848144, 0.00193576923076922, 0.00186167670497492, 0.00294192307692305, 0.00365195579318598, 0.0103236538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 120); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 135, '2021-05-09 00:00:00', 0.00137580180817754, 0.00103384615384614, 0.00142057102548994, 0.00134403846153844, 0.00134285838934944, 0.00172057692307692, 0.00140589281788644, 0.00275615384615384, 0.00353819933016782, 0.0102875 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 135); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 150, '2021-05-09 00:00:00', 0.00041387381949279, 0.000798461538461543, 0.000424478503578254, 0.00106499999999999, 0.000487615587874791, 0.0014098076923077, 0.000766648851520998, 0.00245269230769229, 0.00333424502468181, 0.0101382692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 150); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 165, '2021-05-09 00:00:00', 0.000284118880860696, 0.000696538461538456, 0.000373299271568876, 0.000982115384615405, 0.000463244909474311, 0.0013196153846154, 0.000744119200542068, 0.00234423076923076, 0.00336005772042914, 0.0100932692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 165); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 180, '2021-05-09 00:00:00', 0.000242203109298486, 0.000702884615384634, 0.000305902699462548, 0.000917307692307707, 0.000411141749840074, 0.00125346153846154, 0.000609836831897257, 0.00231019230769232, 0.0033571181608865, 0.0101021153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 180); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 195, '2021-05-09 00:00:00', 0.000264394882412948, 0.000600576923076929, 0.000340950312193168, 0.000878653846153855, 0.000359139998415026, 0.00121153846153846, 0.000669952150989481, 0.00237826923076923, 0.00336203814099998, 0.0100976923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 195); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 210, '2021-05-09 00:00:00', 0.000290119869125735, 0.000648461538461559, 0.000361781702135443, 0.000935000000000011, 0.000433938536945235, 0.00124942307692307, 0.000745876356014566, 0.00247346153846155, 0.00335746573383055, 0.0100969230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 210); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 225, '2021-05-09 00:00:00', 0.000284309487381961, 0.000701730769230789, 0.000303752429556602, 0.000936538461538474, 0.000506530734127168, 0.00121923076923076, 0.000682672688775552, 0.00253000000000001, 0.00338476471174088, 0.0101069230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 225); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 240, '2021-05-09 00:00:00', 0.000208780709394779, 0.000594230769230751, 0.000401199020245768, 0.000860576923076907, 0.000469002091187747, 0.00108980769230767, 0.000696838244115198, 0.00258653846153845, 0.00335307508117551, 0.0100675 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 240); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 255, '2021-05-09 00:00:00', 0.000318216725857359, 0.000571730769230783, 0.000389325699126072, 0.000802499999999962, 0.000416344762832991, 0.000989807692307661, 0.00115182579144859, 0.00295557692307695, 0.00331952339025676, 0.0100534615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 255); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 270, '2021-05-09 00:00:00', 0.000200754729803448, 0.00051769230769224, 0.000237778258047259, 0.000662499999999933, 0.000336169428436575, 0.000946730769230737, 0.00123154312207834, 0.0032973076923077, 0.00331771976838592, 0.0100526923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 270); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 285, '2021-05-09 00:00:00', 0.000208039289928239, 0.000507884615384586, 0.000247657098548648, 0.000715961538461523, 0.000440010358269694, 0.00102134615384612, 0.00122166036133681, 0.00363096153846156, 0.00328728983534137, 0.0100776923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 285); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 300, '2021-05-09 00:00:00', 0.000194701052899056, 0.000507500000000011, 0.000322710217711451, 0.000746730769230785, 0.000578022890150948, 0.0010876923076923, 0.00155172608605833, 0.00404461538461537, 0.00325924594865844, 0.0101080769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 300); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 315, '2021-05-09 00:00:00', 0.000290427271446746, 0.000520000000000008, 0.000403280776401987, 0.000730769230769219, 0.000563994817215688, 0.00104307692307692, 0.00157841630708173, 0.00423903846153847, 0.00324303755997134, 0.0100961538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 315); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 330, '2021-05-09 00:00:00', 0.000299846884002733, 0.000513076923076894, 0.000484813723149247, 0.000732884615384591, 0.000491658887378685, 0.00110230769230766, 0.00158713637870707, 0.00434326923076922, 0.00324139787034027, 0.0100880769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 330); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 345, '2021-05-09 00:00:00', 0.000250550470886674, 0.000468461538461542, 0.000334670676245268, 0.000697307692307692, 0.000334152429519593, 0.0010146153846154, 0.0016087927628648, 0.00449307692307692, 0.00324114478825951, 0.0100865384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 345); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 360, '2021-05-09 00:00:00', 0.000318500633980802, 0.000549423076923081, 0.000310451532201339, 0.000783076923076921, 0.000378029557248959, 0.00104788461538464, 0.00170277322443307, 0.00467442307692308, 0.00324068590199434, 0.0100863461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 360); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 375, '2021-05-09 00:00:00', 0.000193636157621616, 0.000565192307692295, 0.000268738935371518, 0.000743846153846176, 0.000492322947479998, 0.00127326923076923, 0.00158142073416963, 0.00483653846153846, 0.00320169923634314, 0.010105 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 375); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 390, '2021-05-09 00:00:00', 0.000246791176129526, 0.000566730769230793, 0.000332685344524729, 0.000788461538461571, 0.000522643318584991, 0.00148903846153847, 0.00160118581057916, 0.00494999999999998, 0.00319005005989178, 0.0101107692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 390); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 405, '2021-05-09 00:00:00', 0.000259527381095824, 0.00060230769230771, 0.000391811817075494, 0.0010225, 0.000509443436884404, 0.00157884615384617, 0.00171990135003326, 0.00520442307692308, 0.00318295250574784, 0.0101155769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 405); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 420, '2021-05-09 00:00:00', 0.000390486875579729, 0.000844999999999976, 0.000446076787111819, 0.00123750000000002, 0.000709487463975534, 0.00179269230769232, 0.00175192708181594, 0.00528249999999999, 0.00316010316287304, 0.01013 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 420); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 435, '2021-05-09 00:00:00', 0.000289605832920397, 0.00075846153846158, 0.000474326729326793, 0.00117038461538461, 0.00113499427311333, 0.00225500000000001, 0.00188185772575935, 0.00539749999999998, 0.00316653846434147, 0.0101453846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 435); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 450, '2021-05-09 00:00:00', 0.000306019607214955, 0.000769999999999989, 0.000477734718791131, 0.00122230769230769, 0.00104850701549324, 0.00252980769230767, 0.00188833289315859, 0.00551365384615384, 0.00317357997923726, 0.0101232692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 450); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 465, '2021-05-09 00:00:00', 0.000321350036803848, 0.000829615384615379, 0.000800845730846718, 0.00178173076923078, 0.00101372291768816, 0.00270307692307693, 0.00189374273291322, 0.00552653846153845, 0.0032228990831238, 0.0101675 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 465); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 480, '2021-05-09 00:00:00', 0.00079776816084722, 0.00151903846153845, 0.000929781632758686, 0.00210673076923074, 0.00147443951541441, 0.0030432692307692, 0.00195630684237891, 0.00566230769230768, 0.00324999015974845, 0.0102090384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 480); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 495, '2021-05-09 00:00:00', 0.000759565994499491, 0.00129749999999996, 0.000757189438749545, 0.00183038461538462, 0.00157357296768069, 0.00293173076923078, 0.00197529558644934, 0.00555057692307691, 0.0032942450051334, 0.0102669230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 495); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 510, '2021-05-09 00:00:00', 0.000424308895100641, 0.00117903846153847, 0.00148243028114701, 0.00194346153846152, 0.00165864723610725, 0.0029844230769231, 0.00192898570397864, 0.0054803846153846, 0.00339980791312598, 0.0102453846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 510); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 525, '2021-05-09 00:00:00', 0.00153080456472558, 0.00147884615384613, 0.001634049759152, 0.00220884615384614, 0.00165348844521563, 0.00306403846153847, 0.00187095936929123, 0.00566980769230767, 0.00355978782859534, 0.0103607692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 525); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 540, '2021-05-09 00:00:00', 0.000657070772443894, 0.00174499999999998, 0.000917220047417542, 0.00229115384615387, 0.00110360946269678, 0.00312038461538462, 0.00165076682647326, 0.00547365384615382, 0.00350600320878348, 0.0103025 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 540); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 555, '2021-05-09 00:00:00', 0.000523234320210503, 0.00143807692307698, 0.000782310606227063, 0.00197326923076925, 0.000930264230453674, 0.00288846153846155, 0.0015125179719212, 0.00542384615384613, 0.00353718121694926, 0.0103501923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 555); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 570, '2021-05-09 00:00:00', 0.000528434116408653, 0.00145615384615383, 0.000822787031983351, 0.0022475, 0.000876780561968678, 0.00291807692307691, 0.00144650815626938, 0.00537461538461536, 0.00359118392734208, 0.010405 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 570); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 585, '2021-05-09 00:00:00', 0.000711225080677409, 0.00165365384615386, 0.000765794107697758, 0.00216884615384617, 0.00118704487634695, 0.00310846153846155, 0.00147221857699919, 0.00522153846153845, 0.00354408664592815, 0.0104369230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 585); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 600, '2021-05-09 00:00:00', 0.000563306174432571, 0.00147038461538463, 0.000733416557049132, 0.00202961538461538, 0.00117884710628649, 0.00289249999999998, 0.00140427627130629, 0.00506961538461536, 0.00371774180838937, 0.0105319230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 600); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 615, '2021-05-09 00:00:00', 0.000451770917101203, 0.00133980769230771, 0.00119451665474433, 0.00210096153846155, 0.00118431070507444, 0.00269961538461537, 0.00156227527614747, 0.00496903846153847, 0.0037805065187699, 0.0105684615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 615); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 630, '2021-05-09 00:00:00', 0.00116456165408017, 0.00156038461538462, 0.00116690143608556, 0.0019601923076923, 0.00112586699924995, 0.0026275, 0.00156328244409004, 0.00499000000000001, 0.00382951900976533, 0.0106396153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 630); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 645, '2021-05-09 00:00:00', 0.000614709718860517, 0.00129096153846152, 0.000666623668485183, 0.00174365384615382, 0.000711014875966863, 0.00243307692307692, 0.00136348051522005, 0.00482865384615385, 0.00378813841534945, 0.0104894230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 645); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 660, '2021-05-09 00:00:00', 0.000457574710167226, 0.00124115384615381, 0.000551298467257105, 0.00168999999999999, 0.000744878410315302, 0.00239961538461538, 0.00188240669397941, 0.00517480769230769, 0.00387729053394449, 0.0104532692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 660); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 675, '2021-05-09 00:00:00', 0.000411446089561427, 0.00115826923076924, 0.00046424297351876, 0.00165346153846158, 0.000677577046428062, 0.00217442307692308, 0.0022932001573213, 0.0054148076923077, 0.00390321920391954, 0.0104580769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 675); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 690, '2021-05-09 00:00:00', 0.000333467620386365, 0.00111942307692311, 0.000560379678981464, 0.00159923076923078, 0.000606312942807109, 0.00207923076923074, 0.00266177731253734, 0.00563230769230771, 0.00404146459077173, 0.0105559615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 690); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 705, '2021-05-09 00:00:00', 0.000424159802977052, 0.00115653846153847, 0.000570127954599128, 0.00158173076923074, 0.000889455148694128, 0.00248230769230767, 0.00281820193631437, 0.00592192307692307, 0.00402343091728365, 0.0106028846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 705); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 720, '2021-05-09 00:00:00', 0.000385706544488875, 0.00115653846153844, 0.000489191640912316, 0.00159230769230768, 0.000923860399877359, 0.00248403846153846, 0.00281712844113401, 0.00603057692307692, 0.00405773546641286, 0.0106463461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 989290 and enddate = '2021-05-09 00:00:00' and dayofweek = 3 and fromtime = 720); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 989290, 3, 735, '2021-05-09 00:00:00', 0.000345050720909269, 0.00114499999999999, 0.000862992557236822, 0.00181692307692307, 0.00096718870961151, 0.00264500000000001, 0.00308888590819508, 0.00632807692307692, 0.004[...];

[ Date: 2021-05-09 17:08:58 - Database: acaweb_fx - User: pgperfstats ]