select updateageforrelevantresults ();

[ Date: 2023-07-16 16:02:13 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2023-07-16 16:32:07 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2023-07-16 16:47:06 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2023-07-16 16:17:07 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:31:29 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:36:20 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:41:18 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:46:41 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:51:31 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:33:37 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:35:45 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver ]

SELECT resultuid FROM relevance_fibonacci_results ORDER BY resultuid DESC LIMIT 1), fr AS ( SELECT a.*, rr.age, rr.relevant from fibonacci_results a LEFT OUTER JOIN relevance_fibonacci_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = $1 THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_fibonacci_results) END), all_results AS ( SELECT fr.resultuid AS resultuid, fr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, 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, newLevels.filtered, CASE WHEN fr.age IS NOT NULL THEN fr.age WHEN fr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN fr.relevant IS NOT NULL THEN fr.relevant WHEN fr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM fr INNER JOIN brokersymbollist bsl ON bsl.brokerid = $2 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 JOIN LATERAL calc_fib_signal_filter (fr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE fr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (fr.simulation = 0 OR fr.simulation IS NULL) AND ($3 = 0 OR s.timegranularity in ($4, $5, $6, $7, $8, $9, $10)) AND ($11 = 0 OR s.exchange in ($12)) AND ($13 = 0 OR coalesce(bim.code, s.symbol) in ($14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242)) AND ($243 = 0 OR fr.pattern in ($244)) AND ($245 = 0 OR fr.patternlengthbars <= $246) AND ($247 = 0 OR ($248 = 1 AND fr.timed > cast('1970-01-01' as timestamp)) OR ($249 = 2 AND fr.timed < cast('1970-01-01' as timestamp)))), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = $250 OR relevant = 1) AND ($251 = 0 OR age <= $252) ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;

[ Date: 2023-07-16 16:35:45 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.145 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:39:51 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:40:45 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.145 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:40:45 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:49:03 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:50:45 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.145 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:50:45 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:52:46 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver ]

WITH rar_max as ( ;

[ Date: 2023-07-16 16:56:32 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver ]

select updateageforrelevantresults ();

[ Date: 2023-07-16 16:02:24 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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 515840233499223300, 1, 960, '2023-07-16 00:00:00', 0.178156802154298, 0.490384615384616, 0.193457608157047, 0.565384615384616, 0.344398918965515, 0.888846153846154, 0.387846123333231, 1.44384615384615, 0.832164924482197, 2.60230769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 1 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 515840233499223300, 1, 975, '2023-07-16 00:00:00', 0.113262798563612, 0.297307692307692, 0.253429705016234, 0.541153846153845, 0.365624649901213, 0.854230769230766, 0.335374188264163, 1.37038461538461, 0.842554814468837, 2.61115384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 1 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 515840233499223300, 1, 990, '2023-07-16 00:00:00', 0.221690012265915, 0.457692307692307, 0.268554248924467, 0.654230769230767, 0.371516020981806, 0.841923076923075, 0.352822683729161, 1.39961538461538, 0.827802744991453, 2.62576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 1 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 515840233499223300, 1, 1005, '2023-07-16 00:00:00', 0.178823505596568, 0.404615384615386, 0.2732068813189, 0.594999999999999, 0.299302779549662, 0.793076923076923, 0.422407932617823, 1.38269230769231, 0.815975866913118, 2.61615384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 1 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 515840233499223300, 1, 1020, '2023-07-16 00:00:00', 0.18810635289644, 0.44, 0.213854012030493, 0.548461538461539, 0.226443064672914, 0.727307692307693, 0.45442254142356, 1.37038461538461, 0.798511403511849, 2.66730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 1 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 515840233499223300, 1, 1035, '2023-07-16 00:00:00', 0.15284582478382, 0.344615384615386, 0.211918707200516, 0.511538461538462, 0.234250687545168, 0.755769230769233, 0.503658767268231, 1.37192307692307, 0.803508173334525, 2.68423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1050, '2023-07-16 00:00:00', 0.15689339840012, 0.393461538461538, 0.182333591149679, 0.538461538461539, 0.253384778851939, 0.779615384615386, 0.524983223175165, 1.35076923076923, 0.780842247438377, 2.71115384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1065, '2023-07-16 00:00:00', 0.151101086897278, 0.356538461538462, 0.256475819822934, 0.550384615384618, 0.307581133761733, 0.766923076923078, 0.551715645823241, 1.31692307692308, 0.795796359726436, 2.73961538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1080, '2023-07-16 00:00:00', 0.162289864132051, 0.395000000000001, 0.240682682896286, 0.601923076923078, 0.342472682796072, 0.763461538461539, 0.56354537050302, 1.30923076923077, 0.806445667968163, 2.76884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1095, '2023-07-16 00:00:00', 0.179848226611731, 0.465769230769232, 0.249576872695798, 0.583846153846154, 0.290151419355215, 0.689615384615385, 0.548825459153805, 1.22576923076923, 0.817208757812931, 2.74692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1110, '2023-07-16 00:00:00', 0.158111936979422, 0.359230769230768, 0.191348252790964, 0.463076923076923, 0.256135781298786, 0.608461538461539, 0.516005366698389, 1.08846153846154, 0.789570866892994, 2.67307692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1125, '2023-07-16 00:00:00', 0.103269624694852, 0.276153846153846, 0.188325413947406, 0.387692307692308, 0.255644284113689, 0.605000000000002, 0.486725953536644, 1.02692307692308, 0.78876495475278, 2.65692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1140, '2023-07-16 00:00:00', 0.180126451310012, 0.291538461538463, 0.243292796061423, 0.429230769230771, 0.239915690319618, 0.603461538461541, 0.501559567748439, 0.995, 0.792376076212454, 2.65961538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1155, '2023-07-16 00:00:00', 0.163394755588563, 0.304615384615386, 0.210972838207998, 0.461538461538463, 0.212908069724577, 0.585384615384616, 0.450083923798149, 0.963461538461538, 0.75611283244276, 2.64115384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1170, '2023-07-16 00:00:00', 0.117688637449057, 0.308846153846153, 0.105338282908702, 0.401923076923078, 0.306730901856735, 0.600384615384616, 0.410185886566642, 0.892692307692307, 0.795743387318762, 2.65346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1185, '2023-07-16 00:00:00', 0.076489315493181, 0.268846153846154, 0.136425240164149, 0.369615384615384, 0.349919771024512, 0.570384615384614, 0.410050653531413, 0.85153846153846, 0.811478802036037, 2.67538461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1200, '2023-07-16 00:00:00', 0.121751954651817, 0.25346153846154, 0.299174505289781, 0.415769230769231, 0.339092227073312, 0.536538461538462, 0.38859985351753, 0.825384615384615, 0.828561775237437, 2.69884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1215, '2023-07-16 00:00:00', 0.206727433796433, 0.313333333333331, 0.245663476077055, 0.411249999999998, 0.271212722009329, 0.522083333333332, 0.297632871314572, 0.798749999999998, 0.782708045223739, 2.60166666666667 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1230, '2023-07-16 00:00:00', 0.137518773421953, 0.256250000000003, 0.167435364989825, 0.334583333333335, 0.220345167302629, 0.552916666666667, 0.257816570565143, 0.734583333333333, 0.780096147920241, 2.5875 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1245, '2023-07-16 00:00:00', 0.0988631025381987, 0.220000000000002, 0.117535070313601, 0.333333333333336, 0.192730193628898, 0.528333333333335, 0.219939056117366, 0.670833333333334, 0.79092268626723, 2.5875 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1260, '2023-07-16 00:00:00', 0.108384046101238, 0.254166666666666, 0.163246057723668, 0.416666666666665, 0.186873106601817, 0.492083333333332, 0.20694420938287, 0.625416666666666, 0.808002434886557, 2.58625 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 1, 1275, '2023-07-16 00:00:00', 0.134444644069003, 0.331666666666666, 0.158049707829303, 0.396666666666667, 0.193135831153524, 0.451666666666666, 0.183514403336318, 0.575833333333333, 0.811443516031857, 2.57833333333333 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 60, '2023-07-16 00:00:00', 0.0530152372871756, 0.138846153846154, 0.0519659651932075, 0.157307692307692, 0.0508466775255247, 0.17576923076923, 0.212640903511424, 0.501923076923079, 0.861446725885275, 2.56769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 75, '2023-07-16 00:00:00', 0.026582238141577, 0.0688461538461541, 0.0354769697778064, 0.0988461538461536, 0.0743918936857626, 0.133076923076924, 0.217790301401636, 0.513846153846156, 0.859964310529579, 2.57115384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 90, '2023-07-16 00:00:00', 0.0326496554346286, 0.0749999999999974, 0.0398767331429466, 0.0869230769230744, 0.114384641249804, 0.139615384615384, 0.219512747132932, 0.524615384615386, 0.859964310529579, 2.57115384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 105, '2023-07-16 00:00:00', 0.0257801354654195, 0.0561538461538448, 0.0586567590701654, 0.0961538461538451, 0.112845708142375, 0.136923076923076, 0.22275063670806, 0.525384615384617, 0.859964310529579, 2.57115384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 120, '2023-07-16 00:00:00', 0.0658623272732306, 0.0746153846153834, 0.116484399747844, 0.106153846153845, 0.115161425165523, 0.143076923076921, 0.216316008156159, 0.533846153846155, 0.859964310529579, 2.57115384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 135, '2023-07-16 00:00:00', 0.0886479640965415, 0.0723076923076921, 0.0889191508316154, 0.101153846153845, 0.12165588290812, 0.211923076923076, 0.215406949391504, 0.538076923076924, 0.859964310529579, 2.57115384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 150, '2023-07-16 00:00:00', 0.0460451283650496, 0.0680769230769224, 0.0802035871056628, 0.103846153846151, 0.127499622925536, 0.251923076923076, 0.235215122486106, 0.553076923076923, 0.860404287798205, 2.57346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 165, '2023-07-16 00:00:00', 0.0776312783909644, 0.0711538461538448, 0.117245961058859, 0.198846153846153, 0.141271152262373, 0.278461538461539, 0.237280749000321, 0.553076923076923, 0.860404287798205, 2.57346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 180, '2023-07-16 00:00:00', 0.0603273123500868, 0.170769230769231, 0.0874845041223795, 0.221538461538462, 0.137842719737443, 0.283846153846154, 0.211708435208571, 0.537307692307693, 0.860586651427608, 2.57423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 195, '2023-07-16 00:00:00', 0.0712309353711282, 0.135384615384616, 0.106150111417022, 0.200384615384616, 0.128040858863339, 0.287692307692308, 0.214755675128738, 0.510000000000001, 0.856347970251489, 2.57038461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 210, '2023-07-16 00:00:00', 0.0727863047134989, 0.125384615384615, 0.105813333462574, 0.177307692307692, 0.1149374411783, 0.288846153846154, 0.209784138140576, 0.48423076923077, 0.845773928695806, 2.56153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 225, '2023-07-16 00:00:00', 0.0699681246106993, 0.126538461538462, 0.0778805791926616, 0.215769230769231, 0.133313395945275, 0.322692307692309, 0.191121789604267, 0.473461538461539, 0.830321253862252, 2.55423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 240, '2023-07-16 00:00:00', 0.0619180599974383, 0.174615384615385, 0.100448226235441, 0.224615384615385, 0.136411143239842, 0.350000000000001, 0.170593534010389, 0.473076923076922, 0.820239833594653, 2.54576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 255, '2023-07-16 00:00:00', 0.0639182169771526, 0.141538461538461, 0.0969924660040055, 0.226538461538463, 0.126880319138215, 0.318846153846155, 0.176794100145208, 0.461923076923075, 0.815978883588011, 2.54153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 270, '2023-07-16 00:00:00', 0.0889840089350545, 0.173076923076923, 0.100680759753866, 0.246153846153846, 0.127783470701869, 0.306153846153846, 0.188195070645819, 0.454230769230768, 0.811726839237474, 2.53730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 285, '2023-07-16 00:00:00', 0.065300488866118, 0.148076923076921, 0.0868181122542093, 0.21576923076923, 0.0998005703698841, 0.261923076923076, 0.177599376298282, 0.441538461538461, 0.807329215090387, 2.52730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 300, '2023-07-16 00:00:00', 0.0723453257221638, 0.145384615384615, 0.083471782426987, 0.176538461538462, 0.0799999999999998, 0.239999999999999, 0.177578584987477, 0.433076923076922, 0.808464927168482, 2.52653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 315, '2023-07-16 00:00:00', 0.0528975788307358, 0.0969230769230757, 0.0537572893089493, 0.144615384615384, 0.0789556837726079, 0.214999999999999, 0.151874442069251, 0.444615384615385, 0.800082784178275, 2.52269230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 330, '2023-07-16 00:00:00', 0.0382381203271516, 0.113076923076923, 0.0695977453215708, 0.169615384615384, 0.142693323653857, 0.21576923076923, 0.15602415986487, 0.453461538461538, 0.800082784178275, 2.52269230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 345, '2023-07-16 00:00:00', 0.0570451912623126, 0.113076923076924, 0.0675232153809679, 0.149230769230769, 0.123550052143311, 0.186153846153846, 0.151769055323692, 0.475384615384616, 0.790874199857347, 2.515 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 360, '2023-07-16 00:00:00', 0.0461585894998457, 0.0988461538461525, 0.0969250305053413, 0.132307692307691, 0.0940343636042772, 0.15230769230769, 0.146797610544376, 0.478461538461539, 0.777546436901656, 2.50769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 375, '2023-07-16 00:00:00', 0.0774090036504387, 0.0919230769230775, 0.0747354307901179, 0.115769230769229, 0.0709409288395303, 0.133846153846152, 0.214040973791323, 0.55846153846154, 0.770100992377973, 2.50346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 390, '2023-07-16 00:00:00', 0.0241565407610107, 0.0665384615384617, 0.0323443016025061, 0.0830769230769219, 0.0377379629306317, 0.121923076923076, 0.270041592238048, 0.627692307692307, 0.757950779810526, 2.49576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 405, '2023-07-16 00:00:00', 0.0240288288392215, 0.0557692307692309, 0.0280356915377502, 0.0850000000000003, 0.047271718655186, 0.141153846153847, 0.321004433230828, 0.699615384615385, 0.757950779810526, 2.49576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 420, '2023-07-16 00:00:00', 0.0235470069958275, 0.062307692307693, 0.0411601001718139, 0.0930769230769237, 0.0926507088270437, 0.161923076923076, 0.332194799199783, 0.755769230769231, 0.757276598181831, 2.49961538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 435, '2023-07-16 00:00:00', 0.0402683307518252, 0.0715384615384632, 0.0514721732141201, 0.125769230769233, 0.100409162928489, 0.195000000000001, 0.338170871692901, 0.823461538461539, 0.754816839728991, 2.50269230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 450, '2023-07-16 00:00:00', 0.0455800226144992, 0.0984615384615402, 0.0976248707277768, 0.138846153846154, 0.102645019362849, 0.210000000000001, 0.354934663543327, 0.861153846153846, 0.754816839728991, 2.50269230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 465, '2023-07-16 00:00:00', 0.0936022682170926, 0.0957692307692306, 0.101348598715218, 0.156538461538462, 0.0940180015496217, 0.260769230769232, 0.350949481352428, 0.891538461538462, 0.755513070700964, 2.5 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 480, '2023-07-16 00:00:00', 0.0695667913701535, 0.116538461538463, 0.0624783039265498, 0.156538461538463, 0.0835859760044423, 0.278846153846155, 0.364658955527152, 0.918076923076923, 0.745414288525825, 2.50769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 495, '2023-07-16 00:00:00', 0.04987985565336, 0.110000000000001, 0.0612096020622216, 0.201153846153846, 0.080892140913309, 0.296538461538463, 0.387867741137858, 0.974230769230769, 0.743209671213053, 2.50384615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 510, '2023-07-16 00:00:00', 0.0432452754200261, 0.146923076923079, 0.0886653171287319, 0.211538461538463, 0.0759514014657768, 0.316153846153849, 0.391019377839712, 1.00192307692308, 0.742305452368082, 2.50423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 525, '2023-07-16 00:00:00', 0.0562808889547641, 0.136538461538461, 0.0599846134117229, 0.216923076923079, 0.100827346717813, 0.326923076923079, 0.39015204136928, 1.02884615384615, 0.74847342072946, 2.49730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 540, '2023-07-16 00:00:00', 0.0523244317106857, 0.175384615384616, 0.0694372987776639, 0.241538461538462, 0.103854928404224, 0.345384615384616, 0.396408685769936, 1.05961538461539, 0.74912174218573, 2.50076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 555, '2023-07-16 00:00:00', 0.0686988970911339, 0.176538461538462, 0.0939066639725932, 0.257692307692308, 0.174974723449284, 0.431923076923077, 0.394055247981218, 1.07346153846154, 0.767200004010587, 2.52038461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 570, '2023-07-16 00:00:00', 0.0554478271752965, 0.172307692307694, 0.076469199430479, 0.246538461538464, 0.236782275843962, 0.494615384615385, 0.357971206405466, 1.06923076923077, 0.76804777495634, 2.52576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 585, '2023-07-16 00:00:00', 0.0782392779579708, 0.175769230769232, 0.155575853376564, 0.349615384615384, 0.28985619776816, 0.556153846153847, 0.343822852419897, 1.09307692307692, 0.824802074159893, 2.55769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 600, '2023-07-16 00:00:00', 0.134820678623924, 0.306153846153844, 0.226549026787714, 0.427307692307691, 0.297742273683903, 0.592307692307691, 0.335177564881661, 1.1, 0.844961264474022, 2.57346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 615, '2023-07-16 00:00:00', 0.203785709471038, 0.303846153846154, 0.253968199099503, 0.420384615384615, 0.308603055969711, 0.589615384615384, 0.348754266585427, 1.05846153846154, 0.875174268360307, 2.605 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 630, '2023-07-16 00:00:00', 0.118366445349244, 0.271153846153847, 0.133139602846612, 0.376923076923077, 0.204116482581733, 0.526538461538461, 0.287912379833758, 0.99153846153846, 0.906837700685529, 2.57115384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 645, '2023-07-16 00:00:00', 0.110826267366818, 0.267692307692306, 0.162361893975725, 0.40576923076923, 0.220817014394621, 0.538076923076922, 0.322344297535796, 1.00538461538461, 0.951747946594137, 2.62807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 660, '2023-07-16 00:00:00', 0.111505087845284, 0.305769230769231, 0.125244376505111, 0.403076923076922, 0.212331018785437, 0.562692307692307, 0.354754302841578, 1.01115384615384, 0.946743162312049, 2.63884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 675, '2023-07-16 00:00:00', 0.0773215066111336, 0.281153846153845, 0.18641393147014, 0.393076923076924, 0.249904904990802, 0.582692307692307, 0.343561661692068, 1.06115384615384, 0.936303123171946, 2.63653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 690, '2023-07-16 00:00:00', 0.129960940877813, 0.275384615384616, 0.146655535708154, 0.390384615384616, 0.223163617106375, 0.575, 0.346963309964524, 1.05653846153846, 0.931934299434, 2.64153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 705, '2023-07-16 00:00:00', 0.0951662512901256, 0.286153846153846, 0.191353076797843, 0.429999999999999, 0.244458900116469, 0.568076923076923, 0.364359079016208, 1.06153846153846, 0.927995358078576, 2.64923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 720, '2023-07-16 00:00:00', 0.155492270399036, 0.315384615384614, 0.16426666874792, 0.396538461538462, 0.253653003439436, 0.520384615384615, 0.34937680782524, 1.05192307692307, 0.989554678397541, 2.69230769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 735, '2023-07-16 00:00:00', 0.0720427223677311, 0.216923076923079, 0.105195056918089, 0.305000000000001, 0.138470768923099, 0.456923076923077, 0.32385466826008, 1.12538461538461, 1.00355437551504, 2.66576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 750, '2023-07-16 00:00:00', 0.0603375122508004, 0.216153846153846, 0.110389520126896, 0.304615384615385, 0.150702968170453, 0.439230769230769, 0.346275346198103, 1.14884615384615, 1.058115305626, 2.68 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 765, '2023-07-16 00:00:00', 0.0916078599247912, 0.21, 0.103114574065044, 0.313846153846153, 0.16558335107687, 0.484615384615383, 0.439443004092856, 1.25307692307692, 1.08172575793711, 2.69884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 780, '2023-07-16 00:00:00', 0.0901084816293009, 0.223461538461536, 0.117458339586686, 0.297307692307692, 0.174865662724275, 0.484999999999998, 0.520126759697908, 1.32038461538461, 1.0817589664701, 2.71230769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 795, '2023-07-16 00:00:00', 0.0698129368659289, 0.195384615384618, 0.136391405098031, 0.338846153846154, 0.198137869637825, 0.461153846153846, 0.508009842424337, 1.425, 1.09640931436001, 2.70576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 810, '2023-07-16 00:00:00', 0.124034734589209, 0.256153846153845, 0.142966375820976, 0.35076923076923, 0.17557159398771, 0.43576923076923, 0.50775539235102, 1.48346153846154, 1.10506171077247, 2.68423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 825, '2023-07-16 00:00:00', 0.0915339365397429, 0.212307692307693, 0.138339604429993, 0.285384615384616, 0.172500613153872, 0.392692307692309, 0.565580981075076, 1.54538461538462, 1.12102919745137, 2.65769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 840, '2023-07-16 00:00:00', 0.0688007155597875, 0.191538461538462, 0.101205807069635, 0.261153846153846, 0.156309357955995, 0.393846153846152, 0.577851325036252, 1.62807692307692, 1.14797674862543, 2.66884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 855, '2023-07-16 00:00:00', 0.0855794727364347, 0.199615384615385, 0.147937616790113, 0.308461538461538, 0.190256507014971, 0.478461538461537, 0.573187175765068, 1.68346153846154, 1.18618016532708, 2.69923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 870, '2023-07-16 00:00:00', 0.14919115255269, 0.225, 0.156728574784071, 0.290384615384615, 0.207045517106374, 0.500384615384613, 0.564494600369351, 1.73692307692308, 1.26771781621087, 2.73730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 885, '2023-07-16 00:00:00', 0.109806122850159, 0.204230769230768, 0.17455217425876, 0.392692307692306, 0.263124422162712, 0.572307692307689, 0.585269563140319, 1.78730769230769, 1.28990715229371, 2.77730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 900, '2023-07-16 00:00:00', 0.142005417014768, 0.308461538461538, 0.16859236226883, 0.399230769230767, 0.297173608932816, 0.59807692307692, 0.594702899321617, 1.78653846153846, 1.29332677767305, 2.76307692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 915, '2023-07-16 00:00:00', 0.0882696916361358, 0.236538461538461, 0.238127309195344, 0.413846153846152, 0.368534937285465, 0.754999999999997, 0.590976766431253, 1.74846153846154, 1.30075126221497, 2.75461538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 930, '2023-07-16 00:00:00', 0.224678916199574, 0.346153846153845, 0.283394804794683, 0.443846153846151, 0.350291526940284, 0.791923076923076, 0.564981824077965, 1.74269230769231, 1.27435467831913, 2.75961538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 945, '2023-07-16 00:00:00', 0.17248232908375, 0.293076923076921, 0.228210766280108, 0.631923076923074, 0.352365413477805, 0.894230769230767, 0.545906726324336, 1.72692307692308, 1.2451988410877, 2.77192307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 960, '2023-07-16 00:00:00', 0.211628484341346, 0.538846153846153, 0.247284327165187, 0.638461538461539, 0.384738072739605, 0.94076923076923, 0.540326397082927, 1.73384615384615, 1.31459780336626, 2.81923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 975, '2023-07-16 00:00:00', 0.164095656905917, 0.360769230769231, 0.238612656831107, 0.629999999999998, 0.351248542290979, 0.99653846153846, 0.552281979260038, 1.69923076923077, 1.26083006846222, 2.77730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 990, '2023-07-16 00:00:00', 0.201424542084237, 0.519615384615384, 0.301939372416688, 0.71076923076923, 0.341587470496211, 1.025, 0.577908164117662, 1.67538461538462, 1.24546049562154, 2.75038461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1005, '2023-07-16 00:00:00', 0.178482923121944, 0.448076923076923, 0.219590177726251, 0.699615384615383, 0.275531374731696, 0.968461538461539, 0.601044219543082, 1.56692307692308, 1.22607265439131, 2.68307692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1020, '2023-07-16 00:00:00', 0.148224881125319, 0.488846153846153, 0.250791056152635, 0.688076923076924, 0.277966517076041, 0.93423076923077, 0.647499331748986, 1.47923076923077, 1.24378454725889, 2.62 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1035, '2023-07-16 00:00:00', 0.214870622969695, 0.41423076923077, 0.185805936810013, 0.610384615384615, 0.271271932824724, 0.832692307692307, 0.670283063052755, 1.37076923076923, 1.36319607484086, 2.60653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1050, '2023-07-16 00:00:00', 0.131486179443373, 0.426153846153846, 0.24526437854816, 0.608846153846153, 0.280997125635447, 0.829230769230769, 0.684025303175702, 1.33884615384615, 1.3950281497022, 2.63346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1065, '2023-07-16 00:00:00', 0.193591163180394, 0.401538461538463, 0.21933185253962, 0.567692307692308, 0.292816561112138, 0.801538461538461, 0.655568807630794, 1.25230769230769, 1.33899968403512, 2.62807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1080, '2023-07-16 00:00:00', 0.105472562965265, 0.392692307692307, 0.168809405498079, 0.546153846153847, 0.237300523517202, 0.726538461538463, 0.603204264420754, 1.16923076923077, 1.31830503065343, 2.59807692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1095, '2023-07-16 00:00:00', 0.160249804992081, 0.41, 0.172134115869441, 0.566923076923077, 0.24197933796091, 0.675000000000001, 0.584450300578376, 1.14692307692308, 1.30204549134754, 2.61769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1110, '2023-07-16 00:00:00', 0.121698871747505, 0.368846153846152, 0.146647143222719, 0.485769230769231, 0.253439114217568, 0.589230769230769, 0.543006587295361, 1.06192307692308, 1.24892008736163, 2.59423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1125, '2023-07-16 00:00:00', 0.122660256242758, 0.318461538461539, 0.17017502302494, 0.406538461538463, 0.20356817039999, 0.52, 0.495072333487354, 0.986153846153846, 1.22376198037665, 2.54576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1140, '2023-07-16 00:00:00', 0.137061468523602, 0.294615384615385, 0.189537493753772, 0.402692307692308, 0.211012212552149, 0.513076923076924, 0.482475029246233, 0.966923076923077, 1.23252036962415, 2.54230769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1155, '2023-07-16 00:00:00', 0.11063175229284, 0.299230769230769, 0.113861589390193, 0.377307692307693, 0.238030379444433, 0.542307692307691, 0.425678101567188, 0.935384615384616, 1.19277388404573, 2.53846153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1170, '2023-07-16 00:00:00', 0.116333737417561, 0.281538461538464, 0.146600975964849, 0.370384615384616, 0.300260655994857, 0.562692307692306, 0.417643204366893, 0.914615384615386, 1.16455319923401, 2.53192307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1185, '2023-07-16 00:00:00', 0.100435972715878, 0.259230769230768, 0.180134992115955, 0.413846153846151, 0.324381778867952, 0.553461538461535, 0.392989332405621, 0.896153846153845, 1.12370705188743, 2.52846153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1200, '2023-07-16 00:00:00', 0.145149790004882, 0.297307692307692, 0.217312253185629, 0.403846153846153, 0.317502029066805, 0.536538461538461, 0.37298546063641, 0.863076923076924, 1.11202545626645, 2.52384615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1215, '2023-07-16 00:00:00', 0.144111602052555, 0.271923076923076, 0.206770404071762, 0.364999999999999, 0.240403506949974, 0.504615384615385, 0.341553014242976, 0.802307692307693, 1.10207468684505, 2.57384615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1230, '2023-07-16 00:00:00', 0.106053687420026, 0.239230769230769, 0.160063929535865, 0.337307692307693, 0.21882764556047, 0.561538461538463, 0.329611659614533, 0.760384615384617, 1.12032557081207, 2.59423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1245, '2023-07-16 00:00:00', 0.12050981447424, 0.238846153846153, 0.15064374683849, 0.351538461538462, 0.273394614768863, 0.573846153846156, 0.347784415982086, 0.735000000000002, 1.13352879913196, 2.59653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1260, '2023-07-16 00:00:00', 0.11662695294762, 0.264615384615385, 0.197509103977123, 0.454615384615385, 0.248317414736739, 0.561538461538464, 0.295512071860668, 0.689230769230771, 1.13692764129406, 2.56730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1275, '2023-07-16 00:00:00', 0.154746442732817, 0.337692307692307, 0.175162342282368, 0.415384615384616, 0.243688641192307, 0.481923076923078, 0.275771644662753, 0.615000000000002, 1.13838238810097, 2.54769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1290, '2023-07-16 00:00:00', 0.0895600357302306, 0.197200000000001, 0.128740048159072, 0.256400000000002, 0.170994151946784, 0.298400000000001, 0.217609742428964, 0.510400000000002, 1.16873179130201, 2.5544 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1305, '2023-07-16 00:00:00', 0.0724177694584218, 0.148800000000002, 0.106641142779573, 0.198400000000001, 0.106900265044885, 0.231200000000001, 0.205598313871168, 0.459600000000002, 1.16789739846158, 2.5552 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1320, '2023-07-16 00:00:00', 0.0779380095546026, 0.139200000000001, 0.0826397805740865, 0.167200000000001, 0.0790611577619913, 0.225600000000002, 0.208056883247508, 0.457200000000001, 1.16698000554137, 2.5544 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1335, '2023-07-16 00:00:00', 0.044241760061432, 0.1064, 0.0551905789061864, 0.147200000000001, 0.0797015265433055, 0.227600000000003, 0.214224959641339, 0.465600000000001, 1.16938260063448, 2.5484 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1350, '2023-07-16 00:00:00', 0.0420317340430613, 0.112000000000003, 0.0607919950870719, 0.159600000000001, 0.0892617872701801, 0.225200000000002, 0.207309752142375, 0.472400000000002, 1.16788084437868, 2.5496 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1365, '2023-07-16 00:00:00', 0.0431972221329098, 0.110800000000002, 0.0673597307991452, 0.169600000000001, 0.124322162143361, 0.286800000000002, 0.212980437286306, 0.4724, 1.17286330547653, 2.556 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1380, '2023-07-16 00:00:00', 0.0369167421341899, 0.10913043478261, 0.0464766506041839, 0.133478260869566, 0.158686555589631, 0.287826086956523, 0.188535022066073, 0.459999999999999, 0.789872656970256, 2.37478260869565 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1395, '2023-07-16 00:00:00', 0.0378680880803568, 0.0860869565217399, 0.116744374647593, 0.207391304347827, 0.138800621930239, 0.292608695652175, 0.180981076904819, 0.472173913043478, 0.791658088851665, 2.36956521739131 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1410, '2023-07-16 00:00:00', 0.0976360912988151, 0.173478260869564, 0.128341503427287, 0.225217391304348, 0.114399964067546, 0.283478260869566, 0.169972097221843, 0.48217391304348, 1.41381146050306, 2.55086956521739 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 2, 1425, '2023-07-16 00:00:00', 0.0639278918964099, 0.115416666666667, 0.0650292576293644, 0.181250000000001, 0.0668981488446474, 0.218333333333335, 0.158538958774413, 0.439583333333334, 1.3854269995256, 2.54083333333334 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 60, '2023-07-16 00:00:00', 0.0451867918074099, 0.135384615384617, 0.0581152700706516, 0.155769230769234, 0.0700812715023403, 0.190769230769233, 0.159277696540929, 0.44423076923077, 1.58543956535234, 2.67884615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 75, '2023-07-16 00:00:00', 0.0317877576821915, 0.0876923076923088, 0.04915438786267, 0.121923076923078, 0.0640972818336432, 0.157307692307691, 0.167315455169154, 0.457692307692307, 1.58582727743161, 2.67807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 90, '2023-07-16 00:00:00', 0.0440017482170181, 0.0819230769230795, 0.0508270067521655, 0.10923076923077, 0.0591113681634422, 0.146923076923076, 0.168504736294995, 0.455384615384614, 1.58642685108585, 2.67692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 105, '2023-07-16 00:00:00', 0.0303340377489347, 0.0680769230769229, 0.0520059168231388, 0.103846153846153, 0.0619043927856, 0.138076923076922, 0.167002993985137, 0.465, 1.58663150682871, 2.67653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 120, '2023-07-16 00:00:00', 0.0465816074630963, 0.0846153846153875, 0.0554200741192624, 0.110769230769232, 0.0726265473818995, 0.141153846153847, 0.166591162384489, 0.483846153846153, 1.58663150682871, 2.67653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 135, '2023-07-16 00:00:00', 0.0313024943709939, 0.0703846153846153, 0.0429830020070539, 0.0934615384615382, 0.110984406389089, 0.22153846153846, 0.164251214724463, 0.492307692307692, 1.58706158089044, 2.67730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 150, '2023-07-16 00:00:00', 0.026150452268481, 0.0596153846153834, 0.0387754878955566, 0.0865384615384599, 0.0999823061269423, 0.222692307692307, 0.158925720433745, 0.494230769230768, 1.58706158089044, 2.67730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 165, '2023-07-16 00:00:00', 0.028098727044806, 0.0615384615384597, 0.0925410511818732, 0.200384615384613, 0.131352725367761, 0.25153846153846, 0.158203860693922, 0.492692307692307, 1.59188755884327, 2.685 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 180, '2023-07-16 00:00:00', 0.0869632990669932, 0.191153846153845, 0.0896797721811427, 0.207692307692308, 0.137405072126738, 0.261923076923077, 0.154591272517119, 0.487692307692307, 1.5906852417941, 2.68653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 195, '2023-07-16 00:00:00', 0.0370612798151713, 0.108461538461538, 0.0980517916519295, 0.163076923076922, 0.122540417194302, 0.268076923076924, 0.147038979656627, 0.462692307692308, 1.5906852417941, 2.68653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 210, '2023-07-16 00:00:00', 0.0983189472310144, 0.128846153846154, 0.118657230970299, 0.173461538461539, 0.112400383245993, 0.294615384615385, 0.148978573575584, 0.461153846153846, 1.5903905664478, 2.68692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 225, '2023-07-16 00:00:00', 0.046609672155698, 0.102692307692309, 0.079281387863348, 0.21846153846154, 0.0801661735685039, 0.298846153846154, 0.145120109405438, 0.449615384615384, 1.5903905664478, 2.68692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 240, '2023-07-16 00:00:00', 0.0733925169105248, 0.187692307692307, 0.0793124299114686, 0.237692307692307, 0.0848963168540575, 0.299230769230768, 0.159366051784998, 0.458461538461537, 1.5903905664478, 2.68692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 255, '2023-07-16 00:00:00', 0.0706725928816483, 0.151153846153846, 0.0669431446481617, 0.225769230769229, 0.0972522493313145, 0.284999999999998, 0.166761460222034, 0.445769230769229, 1.58749846759466, 2.68923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 270, '2023-07-16 00:00:00', 0.0555697759578001, 0.170000000000001, 0.0625312229702404, 0.203076923076923, 0.0887728302163194, 0.256153846153845, 0.160057681910183, 0.427692307692306, 1.5876411627123, 2.68730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 285, '2023-07-16 00:00:00', 0.0374987179267997, 0.116923076923077, 0.075112223731202, 0.185384615384614, 0.0905198660728468, 0.235384615384614, 0.167905193029145, 0.421923076923075, 1.5884324154529, 2.68153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 300, '2023-07-16 00:00:00', 0.0634495559783215, 0.134615384615385, 0.0686260771247965, 0.151538461538461, 0.0972704398136377, 0.23153846153846, 0.176783657441692, 0.412692307692306, 1.58712240815305, 2.68153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 315, '2023-07-16 00:00:00', 0.0390837365350165, 0.0834615384615369, 0.075708956893133, 0.150384615384615, 0.105954997704032, 0.207692307692308, 0.172627210619167, 0.418076923076923, 1.58902911819184, 2.69153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 330, '2023-07-16 00:00:00', 0.0507361197388397, 0.113076923076924, 0.0684116499300642, 0.148076923076922, 0.0907820721033872, 0.19423076923077, 0.172439510018398, 0.430769230769231, 1.58969551995149, 2.69038461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 345, '2023-07-16 00:00:00', 0.0437281813725865, 0.0919230769230759, 0.0615804664333895, 0.131923076923077, 0.0602213864388344, 0.161153846153847, 0.156944380152776, 0.433461538461537, 1.58991809174609, 2.68653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 360, '2023-07-16 00:00:00', 0.0449888875168094, 0.1, 0.0525122696285219, 0.131538461538462, 0.0431900985804002, 0.15423076923077, 0.155732018347102, 0.447307692307691, 1.5900115142302, 2.68615384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 375, '2023-07-16 00:00:00', 0.0420402737310875, 0.0892307692307679, 0.0416154557087419, 0.110384615384614, 0.0447437146423927, 0.135, 0.163949804701131, 0.493461538461536, 1.58996661793694, 2.68461538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 390, '2023-07-16 00:00:00', 0.0349769154641254, 0.0692307692307691, 0.0378925606662583, 0.089615384615384, 0.0622562940902041, 0.139615384615384, 0.157116321435866, 0.508461538461537, 1.59134220078524, 2.685 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 405, '2023-07-16 00:00:00', 0.0202636468735358, 0.0611538461538457, 0.0285899390587757, 0.0857692307692309, 0.0882165168557108, 0.163076923076923, 0.172535837971755, 0.586153846153846, 1.59097028933241, 2.68769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 420, '2023-07-16 00:00:00', 0.0251671336346547, 0.0657692307692305, 0.0587249128106224, 0.106153846153846, 0.116088162783558, 0.192692307692307, 0.189007529357554, 0.629615384615384, 1.59102371495162, 2.68730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 435, '2023-07-16 00:00:00', 0.0606477851710483, 0.0730769230769238, 0.0902858707746592, 0.133461538461539, 0.122504630995668, 0.21076923076923, 0.290319717658891, 0.728461538461539, 1.59021740168299, 2.69076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 450, '2023-07-16 00:00:00', 0.0758541109884364, 0.104615384615384, 0.11010274921461, 0.148846153846153, 0.101190604610993, 0.21653846153846, 0.301317363997088, 0.791923076923077, 1.59068035758288, 2.69 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 465, '2023-07-16 00:00:00', 0.054828403644041, 0.0869230769230766, 0.0705407683541943, 0.139999999999998, 0.0900085466027461, 0.221538461538463, 0.362400543385568, 0.893076923076925, 1.59085637315252, 2.69 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 480, '2023-07-16 00:00:00', 0.0474276777355232, 0.104230769230768, 0.0617937014465194, 0.152307692307692, 0.112487948072396, 0.231538461538461, 0.354106459437533, 0.940769230769232, 1.59096177974689, 2.68923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 495, '2023-07-16 00:00:00', 0.0394442157210166, 0.0996153846153853, 0.0722740510940041, 0.166538461538464, 0.0951023739896209, 0.252692307692309, 0.344143306464933, 0.971153846153848, 1.59101810655461, 2.68884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 510, '2023-07-16 00:00:00', 0.0576354591709485, 0.134615384615385, 0.0851821577561861, 0.179999999999999, 0.0845667692509207, 0.266538461538462, 0.347163672328509, 0.988846153846156, 1.59101810655461, 2.68884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 525, '2023-07-16 00:00:00', 0.0498258505658982, 0.121153846153845, 0.0665085303956181, 0.189230769230768, 0.0903744347785302, 0.276538461538461, 0.366118097802421, 1.01769230769231, 1.59101810655461, 2.68884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 540, '2023-07-16 00:00:00', 0.0662768087992729, 0.156153846153845, 0.0712276955641887, 0.215769230769231, 0.117337776722391, 0.301923076923075, 0.490249543992258, 1.10384615384616, 1.59078577584016, 2.68923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 555, '2023-07-16 00:00:00', 0.0677234194238725, 0.162307692307694, 0.0821976978902794, 0.222692307692307, 0.142157009621811, 0.383846153846153, 0.493734279204451, 1.12153846153846, 1.59228529527169, 2.68730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 570, '2023-07-16 00:00:00', 0.0449153049125184, 0.145769230769228, 0.0828018951845512, 0.211923076923074, 0.105192131908164, 0.40576923076923, 0.53390866404139, 1.16230769230769, 1.5868407413668, 2.70653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 585, '2023-07-16 00:00:00', 0.0772568144865887, 0.163846153846152, 0.107766128544819, 0.33153846153846, 0.144311628616152, 0.495384615384616, 0.565918314301224, 1.18653846153846, 1.58595256500992, 2.70846153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 600, '2023-07-16 00:00:00', 0.0754850978670614, 0.275, 0.0856827780918564, 0.348461538461539, 0.161710091973736, 0.516923076923077, 0.572078531456868, 1.18538461538462, 1.57468199475811, 2.70076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 615, '2023-07-16 00:00:00', 0.100998095945494, 0.256153846153848, 0.152418452345458, 0.400769230769232, 0.255612687779471, 0.615384615384618, 0.576319355913022, 1.2, 1.56644389032562, 2.70769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 630, '2023-07-16 00:00:00', 0.125357335399496, 0.287692307692309, 0.149110181254821, 0.375384615384616, 0.251865959467455, 0.662692307692308, 0.561560463214919, 1.18692307692308, 1.5357571923472, 2.70307692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 645, '2023-07-16 00:00:00', 0.0867959587857536, 0.24153846153846, 0.202969114740299, 0.447307692307693, 0.29282838239908, 0.727307692307692, 0.560578821741076, 1.15615384615385, 1.4908461201097, 2.68307692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 660, '2023-07-16 00:00:00', 0.148062876456642, 0.348846153846155, 0.203932492601012, 0.502692307692307, 0.286119125271546, 0.711923076923078, 0.550973543969078, 1.15038461538462, 1.43844900447028, 2.66346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 675, '2023-07-16 00:00:00', 0.117504828051381, 0.32923076923077, 0.196853713745475, 0.500769230769232, 0.191184566483644, 0.626538461538463, 0.584401863841602, 1.10846153846154, 1.37687164923298, 2.63346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 690, '2023-07-16 00:00:00', 0.158727633191141, 0.352307692307694, 0.168829454229362, 0.450769230769232, 0.235778253058641, 0.560769230769233, 0.702891281668903, 1.08192307692308, 1.35182935882626, 2.60884615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 705, '2023-07-16 00:00:00', 0.0848890678836432, 0.243076923076922, 0.149637510723029, 0.360769230769232, 0.205006941721117, 0.489615384615386, 0.715859891749345, 1.05923076923077, 1.36661986161253, 2.55538461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 720, '2023-07-16 00:00:00', 0.142267894643007, 0.271923076923078, 0.21376658730062, 0.358076923076924, 0.377517600201022, 0.566538461538463, 0.693548401061803, 1.08423076923077, 1.35654544282952, 2.55346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 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 515840233499223300, 3, 735, '2023-07-16 00:00:00', 0.11102944862305, 0.236538461538462, 0.145471117937019, 0.345384615384617, 0.355921555748108, 0.521923076923078, 0.658677579583633, 1.11192307692308, 1.32324542755245, 2.53230769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 750, '2023-07-16 00:00:00', 0.119599974273215, 0.231923076923078, 0.339163904102654, 0.388076923076923, 0.363196280902679, 0.526538461538461, 0.640466656791387, 1.09846153846154, 1.31589975068246, 2.51192307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 765, '2023-07-16 00:00:00', 0.241709615988977, 0.273461538461537, 0.248213307769439, 0.345384615384614, 0.29495997120861, 0.48576923076923, 0.551413986597532, 1.11576923076923, 1.26686481581046, 2.47769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 780, '2023-07-16 00:00:00', 0.107677581410716, 0.217692307692308, 0.157020331853504, 0.319230769230767, 0.210958617888765, 0.44653846153846, 0.534937523311043, 1.20307692307692, 1.20885476636106, 2.45461538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 795, '2023-07-16 00:00:00', 0.111818534310663, 0.219230769230767, 0.156735936677437, 0.323076923076922, 0.192333444429598, 0.441923076923075, 0.533811404322364, 1.23115384615385, 1.17294901194186, 2.44423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 810, '2023-07-16 00:00:00', 0.097844460556224, 0.201538461538464, 0.111532678895193, 0.276538461538463, 0.137088966059944, 0.404230769230769, 0.520130752792026, 1.26, 1.15822251083951, 2.43923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 825, '2023-07-16 00:00:00', 0.086533230611133, 0.2, 0.122863276105533, 0.309230769230768, 0.171905609162523, 0.41346153846154, 0.509714248755727, 1.39384615384615, 1.15902691280892, 2.44076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 840, '2023-07-16 00:00:00', 0.0858343664364044, 0.22653846153846, 0.0878039774813095, 0.308461538461539, 0.219146947538368, 0.444230769230769, 0.522471640746764, 1.43384615384615, 1.14779098874584, 2.43807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 855, '2023-07-16 00:00:00', 0.0760566590418955, 0.213846153846153, 0.138028425166145, 0.319615384615386, 0.272047789919345, 0.495, 0.633130439835389, 1.51307692307692, 1.1379285498727, 2.43576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 870, '2023-07-16 00:00:00', 0.140627713649029, 0.241923076923078, 0.212921437299156, 0.333461538461537, 0.390152041369278, 0.531153846153847, 0.678428614236887, 1.56576923076923, 1.13709102538011, 2.43 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 885, '2023-07-16 00:00:00', 0.124136401405253, 0.225384615384614, 0.184022155856718, 0.381923076923076, 0.328737678915062, 0.572692307692307, 0.579524473499279, 1.63615384615385, 1.09718156410659, 2.41076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 900, '2023-07-16 00:00:00', 0.123230865264537, 0.294615384615385, 0.227513651323304, 0.392307692307692, 0.280700223342653, 0.616153846153848, 0.579643524404971, 1.69115384615385, 1.07383396510605, 2.40923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 915, '2023-07-16 00:00:00', 0.155243233470774, 0.272692307692306, 0.234734874994027, 0.442692307692307, 0.257718092854605, 0.698846153846152, 0.614933767540488, 1.72346153846154, 1.05494097538131, 2.44730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and enddate = '2023-07-16 00:00:00' and dayofweek = 3 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 515840233499223300, 3, 930, '2023-07-16 00:00:00', 0.220786008475314, 0.357692307692306, 0.206621541806418, 0.472692307692308, 0.324304700029986, 0.751538461538461, 0.625888291827027, 1.73807692307692, 1.04873352192061, 2.475 where not exists (select 1 from powerstats_trumpet where symbolid = 515840233499223300 and endda[...];

[ Date: 2023-07-16 16:00:08 - Database: acaweb_fx - User: pgperfstats - Remote: 192.168.3.100 - Application: [unknown] ]

WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a.*, rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = '627' AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.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 sg.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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('7' = 0 OR s.timegranularity in ('15', '30', '60', '120', '240', '480', '1440')) AND ('0' = 0 OR s.exchange in ('')) AND ('229' = 0 OR coalesce(bim.code, s.symbol) in ('#ADBE', '#AIRF', '#ALVG', '#AMZN', '#APPL', '#BA', '#BABA', '#BAYGn', '#BMWG', '#BNPP', '#BP', '#CAT', '#CBKG', '#DAIGn', '#DBKGn', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#META', '#MSFT', '#NFLX', '#RDSa', '#TSLA', '#VOWG', '#WMT', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS_200', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CL_BRENT', 'DASHUSD', 'EOSUSD', 'ESP_35', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'EUR_50', 'FRA_40', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'GBR_100', 'HKDJPY', 'HKG_50', 'IOTAUSD', 'LTCEUR', 'LTCUSD', 'NAS100', 'NEOUSD', 'NOKJPY', 'NOKSEK', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'OMGUSD', 'SPX500', 'TRXUSD', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'USOIL', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XMRUSD', 'XPTUSD', 'XRPUSD', 'ZARJPY', 'ZECUSD', '#BP', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'HKDJPY', 'NOKJPY', 'NOKSEK', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'ZARJPY', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'DASHUSD', 'EOSUSD', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'IOTAUSD', 'LTCEUR', 'LTCUSD', 'NEOUSD', 'OMGUSD', 'TRXUSD', 'XMRUSD', 'XRPUSD', 'ZECUSD', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XPTUSD', 'CL_BRENT', 'USOIL', '#AIRF', '#ALVG', '#BAYGn', '#BMWG', '#BNPP', '#CBKG', '#DAIGn', '#DBKGn', '#RDSa', '#VOWG', 'AUS_200', 'ESP_35', 'EUR_50', 'FRA_40', 'GBR_100', 'HKG_50', 'NAS100', 'SPX500', 'US30', '#ADBE', '#AMZN', '#APPL', '#BA', '#BABA', '#CAT', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#MSFT', '#NFLX', '#TSLA', '#WMT', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('400' = 0 OR ar.patternlengthbars <= '400') and newLevels.filtered = false ), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('10' = 0 OR age <= '10') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;

[ Date: 2023-07-16 16:25:49 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a.*, rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = '627' AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.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 sg.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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('7' = 0 OR s.timegranularity in ('15', '30', '60', '120', '240', '480', '1440')) AND ('0' = 0 OR s.exchange in ('')) AND ('229' = 0 OR coalesce(bim.code, s.symbol) in ('#ADBE', '#AIRF', '#ALVG', '#AMZN', '#APPL', '#BA', '#BABA', '#BAYGn', '#BMWG', '#BNPP', '#BP', '#CAT', '#CBKG', '#DAIGn', '#DBKGn', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#META', '#MSFT', '#NFLX', '#RDSa', '#TSLA', '#VOWG', '#WMT', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS_200', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CL_BRENT', 'DASHUSD', 'EOSUSD', 'ESP_35', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'EUR_50', 'FRA_40', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'GBR_100', 'HKDJPY', 'HKG_50', 'IOTAUSD', 'LTCEUR', 'LTCUSD', 'NAS100', 'NEOUSD', 'NOKJPY', 'NOKSEK', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'OMGUSD', 'SPX500', 'TRXUSD', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'USOIL', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XMRUSD', 'XPTUSD', 'XRPUSD', 'ZARJPY', 'ZECUSD', '#BP', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'HKDJPY', 'NOKJPY', 'NOKSEK', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'ZARJPY', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'DASHUSD', 'EOSUSD', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'IOTAUSD', 'LTCEUR', 'LTCUSD', 'NEOUSD', 'OMGUSD', 'TRXUSD', 'XMRUSD', 'XRPUSD', 'ZECUSD', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XPTUSD', 'CL_BRENT', 'USOIL', '#AIRF', '#ALVG', '#BAYGn', '#BMWG', '#BNPP', '#CBKG', '#DAIGn', '#DBKGn', '#RDSa', '#VOWG', 'AUS_200', 'ESP_35', 'EUR_50', 'FRA_40', 'GBR_100', 'HKG_50', 'NAS100', 'SPX500', 'US30', '#ADBE', '#AMZN', '#APPL', '#BA', '#BABA', '#CAT', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#MSFT', '#NFLX', '#TSLA', '#WMT', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('400' = 0 OR ar.patternlengthbars <= '400') and newLevels.filtered = false ), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('10' = 0 OR age <= '10') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;

[ Date: 2023-07-16 16:00:49 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a.*, rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = '627' AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.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 sg.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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('7' = 0 OR s.timegranularity in ('15', '30', '60', '120', '240', '480', '1440')) AND ('0' = 0 OR s.exchange in ('')) AND ('229' = 0 OR coalesce(bim.code, s.symbol) in ('#ADBE', '#AIRF', '#ALVG', '#AMZN', '#APPL', '#BA', '#BABA', '#BAYGn', '#BMWG', '#BNPP', '#BP', '#CAT', '#CBKG', '#DAIGn', '#DBKGn', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#META', '#MSFT', '#NFLX', '#RDSa', '#TSLA', '#VOWG', '#WMT', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS_200', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CL_BRENT', 'DASHUSD', 'EOSUSD', 'ESP_35', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'EUR_50', 'FRA_40', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'GBR_100', 'HKDJPY', 'HKG_50', 'IOTAUSD', 'LTCEUR', 'LTCUSD', 'NAS100', 'NEOUSD', 'NOKJPY', 'NOKSEK', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'OMGUSD', 'SPX500', 'TRXUSD', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'USOIL', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XMRUSD', 'XPTUSD', 'XRPUSD', 'ZARJPY', 'ZECUSD', '#BP', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'HKDJPY', 'NOKJPY', 'NOKSEK', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'ZARJPY', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'DASHUSD', 'EOSUSD', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'IOTAUSD', 'LTCEUR', 'LTCUSD', 'NEOUSD', 'OMGUSD', 'TRXUSD', 'XMRUSD', 'XRPUSD', 'ZECUSD', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XPTUSD', 'CL_BRENT', 'USOIL', '#AIRF', '#ALVG', '#BAYGn', '#BMWG', '#BNPP', '#CBKG', '#DAIGn', '#DBKGn', '#RDSa', '#VOWG', 'AUS_200', 'ESP_35', 'EUR_50', 'FRA_40', 'GBR_100', 'HKG_50', 'NAS100', 'SPX500', 'US30', '#ADBE', '#AMZN', '#APPL', '#BA', '#BABA', '#CAT', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#MSFT', '#NFLX', '#TSLA', '#WMT', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('400' = 0 OR ar.patternlengthbars <= '400') and newLevels.filtered = false ), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('10' = 0 OR age <= '10') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;

[ Date: 2023-07-16 16:00:48 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.145 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a.*, rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = '627' AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.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 sg.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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('7' = 0 OR s.timegranularity in ('15', '30', '60', '120', '240', '480', '1440')) AND ('0' = 0 OR s.exchange in ('')) AND ('229' = 0 OR coalesce(bim.code, s.symbol) in ('#ADBE', '#AIRF', '#ALVG', '#AMZN', '#APPL', '#BA', '#BABA', '#BAYGn', '#BMWG', '#BNPP', '#BP', '#CAT', '#CBKG', '#DAIGn', '#DBKGn', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#META', '#MSFT', '#NFLX', '#RDSa', '#TSLA', '#VOWG', '#WMT', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS_200', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CL_BRENT', 'DASHUSD', 'EOSUSD', 'ESP_35', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'EUR_50', 'FRA_40', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'GBR_100', 'HKDJPY', 'HKG_50', 'IOTAUSD', 'LTCEUR', 'LTCUSD', 'NAS100', 'NEOUSD', 'NOKJPY', 'NOKSEK', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'OMGUSD', 'SPX500', 'TRXUSD', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'USOIL', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XMRUSD', 'XPTUSD', 'XRPUSD', 'ZARJPY', 'ZECUSD', '#BP', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'HKDJPY', 'NOKJPY', 'NOKSEK', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'ZARJPY', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'DASHUSD', 'EOSUSD', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'IOTAUSD', 'LTCEUR', 'LTCUSD', 'NEOUSD', 'OMGUSD', 'TRXUSD', 'XMRUSD', 'XRPUSD', 'ZECUSD', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XPTUSD', 'CL_BRENT', 'USOIL', '#AIRF', '#ALVG', '#BAYGn', '#BMWG', '#BNPP', '#CBKG', '#DAIGn', '#DBKGn', '#RDSa', '#VOWG', 'AUS_200', 'ESP_35', 'EUR_50', 'FRA_40', 'GBR_100', 'HKG_50', 'NAS100', 'SPX500', 'US30', '#ADBE', '#AMZN', '#APPL', '#BA', '#BABA', '#CAT', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#MSFT', '#NFLX', '#TSLA', '#WMT', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('400' = 0 OR ar.patternlengthbars <= '400') and newLevels.filtered = false ), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('10' = 0 OR age <= '10') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;

[ Date: 2023-07-16 16:20:48 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.145 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a.*, rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.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 sg.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 currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('7' = 0 OR s.timegranularity in ('15', '30', '60', '120', '240', '480', '1440')) AND ('0' = 0 OR s.exchange in ('')) AND ('312' = 0 OR coalesce(bim.code, s.symbol) in ('#AAPL', '#ADS', '#AIG', '#ALV', '#AMZN', '#AXP', '#BA', '#BABA', '#BAC', '#BAS', '#BAYN', '#BEI', '#BIDU', '#BMW', '#C', '#CAT', '#CBK', '#CL', '#CSCO', '#CVX', '#DAI', '#DB1', '#DBK', '#DIS', '#DPW', '#DTE', '#EBAY', '#EON', '#F', '#FB', '#FDX', '#FME', '#GE', '#GM', '#GOOG', '#GS', '#HPQ', '#IBM', '#IFX', '#INTC', '#JD', '#JNJ', '#JPM', '#KO', '#LHA', '#LIN', '#LMT', '#MA', '#MCD', '#META', '#MMM', '#MSFT', '#MUV2', '#NFLX', '#NKE', '#NTES', '#ORCL', '#PFE', '#PG', '#QCOM', '#RACE', '#RWE', '#SAP', '#SIE', '#T', '#UBER', '#V', '#VOW', '#WB', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS200', 'BRENT', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CHI50', 'ESP35', 'ETHUSD', 'EU50', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'EURUSD', 'FRA40', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GER30', 'HK50', 'HKCH50', 'IT40', 'JP225', 'LTCUSD', 'NAS100', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'SPX500', 'UK100', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'WTI', 'XAGUSD', 'XAUUSD', '#ADS', '#ALV', '#BAS', '#BAYN', '#BEI', '#BMW', '#CBK', '#DAI', '#DB1', '#DBK', '#DPW', '#DTE', '#EON', '#FME', '#IFX', '#LHA', '#LIN', '#MUV2', '#RWE', '#SAP', '#SIE', '#VOW', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'XAGUSD', 'XAUUSD', 'BTCUSD', 'ETHUSD', 'LTCUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'XAGUSD', 'XAUUSD', 'BRENT', 'WTI', 'AUS200', 'CHI50', 'ESP35', 'EU50', 'FRA40', 'GER30', 'HK50', 'HKCH50', 'IT40', 'JP225', 'NAS100', 'SPX500', 'UK100', 'US30', 'AUDUSD', 'EURUSD', 'GBPUSD', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDJPY', '#AAPL', '#AIG', '#AMZN', '#AXP', '#BA', '#BABA', '#BAC', '#BIDU', '#C', '#CAT', '#CL', '#CSCO', '#CVX', '#DIS', '#EBAY', '#F', '#FB', '#FDX', '#GE', '#GM', '#GOOG', '#GS', '#HPQ', '#IBM', '#INTC', '#JD', '#JNJ', '#JPM', '#KO', '#LMT', '#MA', '#MCD', '#MMM', '#MSFT', '#NFLX', '#NKE', '#NTES', '#ORCL', '#PFE', '#PG', '#QCOM', '#RACE', '#T', '#UBER', '#V', '#WB', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('400' = 0 OR ar.patternlengthbars <= '400') and newLevels.filtered = false ), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('10' = 0 OR age <= '10') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;