select updateageforrelevantresults ();

[ Date: 2025-08-10 15:02:05 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2025-08-10 15:32:07 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2025-08-10 15:47:07 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2025-08-10 15:17:06 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateresultsmaterializedview ();

[ Date: 2025-08-10 15:47:25 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateresultsmaterializedview ();

[ Date: 2025-08-10 15:17:20 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateresultsmaterializedview ();

[ Date: 2025-08-10 15:02:23 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateresultsmaterializedview ();

[ Date: 2025-08-10 15:32:21 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select cleanuppatternresultsrelevance ();

[ Date: 2025-08-10 15:00:06 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

[ Date: 2025-08-10 15:01:16 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

[ Date: 2025-08-10 15:03:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

[ Date: 2025-08-10 15:05:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

[ Date: 2025-08-10 15:11:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

[ Date: 2025-08-10 15:16:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

[ Date: 2025-08-10 15:18:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

[ Date: 2025-08-10 15:20:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

[ Date: 2025-08-10 15:26:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

[ Date: 2025-08-10 15:31:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

[ Date: 2025-08-10 15:33:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit 1) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then 0 else 1 end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then 11 else 0 end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike 'kl_%' inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike 'kl_%') sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike 'kl_%'; update solr_relevance_old set newrelevant = 0 where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike 'kl_%' and a.resultuid is null); UPDATE solr_relevance_old SET new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total FROM ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total FROM whatshot_probability WHERE type in ('kl', 'ekl')) sub WHERE result_uid = sub.resultuid;

[ Date: 2025-08-10 15:35:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2025-08-10 15:47: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 515840243185493300, 1, 900, '2025-08-10 00:00:00', 174.447385788997, 331.243846153847, 274.03958497549, 449.258461538461, 314.033073675369, 625.035, 1200.08351904005, 2037.55653846154, 2493.41645471186, 3773.18038461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 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 515840243185493300, 1, 915, '2025-08-10 00:00:00', 178.021301156308, 288.385769230769, 238.039462840803, 440.171538461539, 278.776820859653, 600.913846153845, 1186.79593261262, 2030.94461538462, 2478.58037183152, 3763.84269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 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 515840243185493300, 1, 930, '2025-08-10 00:00:00', 197.826754867833, 335.12153846154, 281.514804481314, 453.643076923077, 251.58780295035, 614.585769230769, 1172.0837055338, 2098.06538461538, 2476.31379663244, 3762.13192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 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 515840243185493300, 1, 945, '2025-08-10 00:00:00', 209.004651762733, 308.707692307693, 195.344250203033, 436.310769230768, 559.638010746781, 964.116153846153, 1176.4672097426, 2113.07346153846, 2473.46296335833, 3771.75576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 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 515840243185493300, 1, 960, '2025-08-10 00:00:00', 128.349729114815, 328.889615384615, 181.482378674582, 475.104230769232, 855.595385552433, 1228.35884615385, 1184.71830444392, 2121.80269230769, 2448.15650672837, 3779.26730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 975, '2025-08-10 00:00:00', 154.207193802563, 345.127307692308, 528.297902827997, 851.532692307691, 1034.4454590571, 1420.59038461538, 1207.99437622761, 2154.28846153846, 2420.31301030517, 3795.09730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 990, '2025-08-10 00:00:00', 487.981139038574, 763.24423076923, 800.864676993659, 1101.62192307692, 1171.88815685569, 1562.45115384615, 1317.79336114792, 2203.43846153846, 2369.02296097065, 3779.81692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1005, '2025-08-10 00:00:00', 592.447155172122, 781.676538461537, 880.06246357867, 1062.90192307692, 1056.87748954077, 1443.205, 1206.74043036502, 2074.95846153846, 2122.54215456829, 3732.81076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1020, '2025-08-10 00:00:00', 430.06857491049, 668.808461538461, 700.733552013997, 1018.45692307692, 635.639872281952, 1268.01115384615, 976.625111695612, 1890.51769230769, 2013.07559062831, 3641.75346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1035, '2025-08-10 00:00:00', 649.343634759451, 734.748846153846, 619.381057315596, 910.665769230769, 607.523749124389, 1094.01307692308, 997.767596233791, 1871.80307692308, 2060.65778883868, 3625.13846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1050, '2025-08-10 00:00:00', 352.540389821564, 566.996538461539, 365.787419345426, 753.20923076923, 441.142986637947, 948.459615384615, 932.097805134948, 1746.68423076923, 2122.20655213403, 3608.60384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1065, '2025-08-10 00:00:00', 205.854866569781, 533.082307692307, 357.667740569157, 731.569615384614, 457.599588906654, 947.35346153846, 898.240148589111, 1726.49576923077, 2094.90070155733, 3627.97576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1080, '2025-08-10 00:00:00', 302.354776700892, 517.444615384615, 341.338071012395, 678.117692307693, 422.349554490118, 869.854999999999, 1087.70165178622, 1758.69230769231, 2109.68728742907, 3658.95038461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1095, '2025-08-10 00:00:00', 198.365015591499, 455.168846153846, 306.865754574312, 622.172307692307, 359.009126300969, 786.459230769231, 1134.30374973366, 1735.38961538462, 2101.47932347774, 3680.56730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1110, '2025-08-10 00:00:00', 234.074739078058, 430.952307692306, 237.034328806219, 565.826153846153, 398.303720610868, 841.767307692308, 1130.22041586913, 1711.34076923077, 2091.00470219951, 3708.75730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1125, '2025-08-10 00:00:00', 141.831035885878, 374.047307692308, 197.414816253649, 533.702692307693, 391.503354193314, 830.833846153846, 1119.89798025631, 1693.02692307692, 2071.28795912747, 3740.54230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1140, '2025-08-10 00:00:00', 117.103396679373, 394.054615384615, 270.185942972327, 653.599615384615, 357.915040432995, 840.311923076923, 1090.62377800434, 1670.90269230769, 2066.99643509379, 3748.17230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1155, '2025-08-10 00:00:00', 227.386293276441, 499.205000000001, 285.539097283609, 615.831538461539, 500.96964954837, 863.053846153845, 1089.24756246114, 1631.63346153846, 2065.19260890168, 3760.74692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1170, '2025-08-10 00:00:00', 224.741168719794, 399.571538461537, 282.09295803934, 583.57923076923, 757.654941122633, 901.326538461537, 1148.78706053814, 1578.30038461538, 2062.75547629777, 3763.65730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1185, '2025-08-10 00:00:00', 173.18238245805, 424.264615384616, 397.127666535006, 634.866538461539, 792.406716722203, 918.572307692308, 1087.74552534292, 1526.22653846154, 2010.07819324171, 3758.31461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1200, '2025-08-10 00:00:00', 302.6521640434, 456.558076923078, 602.997007681948, 674.14576923077, 711.007075610471, 900.798076923078, 1004.85387371131, 1471.82615384615, 1936.34379879766, 3759.05692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1215, '2025-08-10 00:00:00', 396.741484990105, 468.168076923076, 485.988093891039, 623.980384615384, 518.811646599745, 814.413461538462, 814.928729870382, 1378.86192307692, 1814.20300438241, 3702.22307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1230, '2025-08-10 00:00:00', 234.137567331358, 399.439615384613, 254.056540533495, 541.439615384616, 325.083522557133, 699.153076923077, 631.585417785579, 1323.97076923077, 1645.43887617419, 3613.13423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1245, '2025-08-10 00:00:00', 205.097749162162, 364.259230769232, 277.566649442007, 510.957692307694, 365.935248759207, 700.562692307692, 623.935861025794, 1301.295, 1642.75076600275, 3585.16115384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1260, '2025-08-10 00:00:00', 241.810088900678, 395.526923076922, 271.499434832956, 507.131153846154, 505.754202503699, 774.446923076923, 615.608818123476, 1318.58076923077, 1631.23641181533, 3583.57192307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1275, '2025-08-10 00:00:00', 190.126594825252, 365.050384615385, 259.878052459522, 525.263076923077, 459.418141795265, 780.228846153847, 667.155007392296, 1366.15615384615, 1669.99823026332, 3610.49115384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 1, 1290, '2025-08-10 00:00:00', 205.689148113959, 394.819615384614, 399.645035327795, 580.506923076921, 423.600662170799, 770.386538461539, 733.282746659054, 1416.01038461539, 1713.63371172542, 3656.85461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 and fromtime = 1290); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 1, 1305, '2025-08-10 00:00:00', 350.697762088011, 388.571538461536, 388.491462601966, 543.171153846154, 450.81899623975, 755.941153846153, 770.75722926084, 1409.21461538462, 1723.14664239654, 3656.57230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 and fromtime = 1305); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 1, 1320, '2025-08-10 00:00:00', 203.240198016648, 375.085384615384, 298.792068061747, 516.353846153846, 378.294694582859, 714.548461538461, 783.49320336839, 1390.04269230769, 1777.90996975667, 3666.47807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 and fromtime = 1320); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 1, 1335, '2025-08-10 00:00:00', 188.914604905131, 339.602307692308, 307.448836666426, 532.786538461538, 295.481848367142, 703.982307692307, 810.239254014801, 1374.95230769231, 1773.76187592034, 3679.24269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 and fromtime = 1335); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 1, 1350, '2025-08-10 00:00:00', 235.444787588221, 391.24769230769, 221.291139179901, 493.003461538461, 279.316803587171, 664.593076923078, 811.014420568748, 1367.27769230769, 1799.17160980547, 3702.255 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 and fromtime = 1350); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 1, 1365, '2025-08-10 00:00:00', 150.955433666313, 354.785769230769, 215.016907794572, 489.898461538461, 286.628221425488, 661.468461538462, 817.389227988347, 1375.03076923077, 1800.40716584448, 3721.24192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 and fromtime = 1365); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 1, 1380, '2025-08-10 00:00:00', 113.109383755454, 341.088461538461, 173.713084350206, 434.682307692308, 325.647024611241, 657.093076923078, 772.584462226224, 1337.87423076923, 1773.68135536742, 3702.915 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 and fromtime = 1380); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 1, 1395, '2025-08-10 00:00:00', 133.520544057978, 285.81153846154, 196.010582698602, 428.275384615386, 344.488464770594, 638.040000000001, 775.588213986302, 1318.81769230769, 1781.88185263938, 3676.28846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 and fromtime = 1395); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 1, 1410, '2025-08-10 00:00:00', 134.571558117433, 292.773076923077, 300.107857781423, 449.253076923076, 423.222571580706, 649.770769230769, 792.798883628028, 1343.79538461539, 1800.38061364659, 3666.83230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 and fromtime = 1410); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 1, 1425, '2025-08-10 00:00:00', 282.521253378601, 330.421153846154, 330.30834813014, 453.682692307693, 434.944763568714, 647.349615384616, 932.670796300685, 1433.16807692308, 1793.65252392391, 3661.25884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 1 and fromtime = 1425); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 2, 0, '2025-08-10 00:00:00', 241.219434026684, 296.568076923079, 374.057902051994, 449.05653846154, 435.671363395005, 628.092307692309, 1018.9582662408, 1422.2126923077, 1759.45584842941, 3646.47730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 2 and fromtime = 0); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 2, 15, '2025-08-10 00:00:00', 251.153451175847, 336.038461538462, 247.850190098465, 432.049615384616, 396.018463364447, 651.91153846154, 997.440896818531, 1425.85307692308, 1727.50323058293, 3633.72230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 2 and fromtime = 15); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 2, 30, '2025-08-10 00:00:00', 163.230802619622, 302.579615384613, 256.363691813018, 451.369999999999, 478.985851195564, 692.338461538462, 992.156600045657, 1553.85692307692, 1731.54068516176, 3640.19769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 2 and fromtime = 30); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 2, 45, '2025-08-10 00:00:00', 174.533998291276, 300.503461538463, 361.377949325164, 491.852307692308, 509.314274710161, 695.34653846154, 963.049346000267, 1560.91653846154, 1697.4254141689, 3609.45230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 2 and fromtime = 45); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 2, 60, '2025-08-10 00:00:00', 338.966420761478, 390.269615384616, 426.591905176906, 515.502307692309, 495.978485190483, 668.160384615385, 926.851530691864, 1576.61538461538, 1789.19600454734, 3663.37192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 75, '2025-08-10 00:00:00', 226.217002617805, 305.09576923077, 334.784297744085, 427.260000000001, 368.551758161382, 595.950384615386, 887.872921081357, 1516.88846153846, 1792.14758968687, 3627.68269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 90, '2025-08-10 00:00:00', 292.901241523751, 315.066923076924, 293.769089010137, 416.335384615386, 291.564426731964, 597.766538461539, 877.585812510665, 1542.16, 1764.00511184054, 3624.48346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 105, '2025-08-10 00:00:00', 187.293717833367, 281.450384615385, 225.357314661372, 404.38076923077, 261.195677344666, 549.416538461539, 865.817160216957, 1473.78692307692, 1730.92229884804, 3610.40576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 120, '2025-08-10 00:00:00', 197.587336137332, 310.854615384617, 238.958223577648, 436.970769230769, 322.506076114258, 578.758846153846, 858.226881448832, 1473.53576923077, 1724.19506331795, 3617.565 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 135, '2025-08-10 00:00:00', 217.053468423369, 319.891153846153, 250.817676973963, 416.388846153846, 368.850915935713, 606.838846153844, 881.221747266915, 1518.32192307692, 1704.3753567966, 3633.40346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 150, '2025-08-10 00:00:00', 158.458962138467, 283.024999999999, 230.943495426912, 396.569999999999, 435.991335065802, 668.112692307693, 851.569683661071, 1507.04115384615, 1697.45833910626, 3637.94576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 165, '2025-08-10 00:00:00', 178.640497476399, 272.751153846154, 240.489862600356, 429.761538461536, 627.831003237706, 768.992307692306, 840.713625882571, 1505.73384615385, 1700.53864145633, 3634.67307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 180, '2025-08-10 00:00:00', 198.293663514884, 350.706923076922, 372.415786062379, 527.537307692309, 741.868624002619, 807.496538461539, 828.645935135239, 1500.58192307692, 1705.50263452901, 3626.73423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 195, '2025-08-10 00:00:00', 297.975697209586, 399.566538461539, 542.209771883684, 641.343076923076, 681.435781721554, 791.397692307693, 870.706916742678, 1487.89346153846, 1705.32635929418, 3661.67346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 210, '2025-08-10 00:00:00', 457.112191045718, 454.921153846151, 590.425719570601, 561.247692307692, 678.477880745967, 866.181538461538, 873.32002495869, 1460.82461538461, 1709.17856305667, 3677.15730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 225, '2025-08-10 00:00:00', 268.505596305812, 354.553461538463, 263.771245433498, 488.301538461539, 578.650971346815, 880.306153846154, 759.365378927997, 1390.24230769231, 1696.04626489061, 3658.43423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 240, '2025-08-10 00:00:00', 256.766208324587, 392.765769230769, 409.715358256662, 641.51923076923, 600.414385760755, 917.692692307692, 715.490025646437, 1379.34346153846, 1656.44511706007, 3639.05807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 255, '2025-08-10 00:00:00', 349.793269929541, 469.680000000001, 502.157358660993, 687.79576923077, 568.802819519682, 874.528461538463, 686.731712867999, 1326.63884615385, 1663.25594618914, 3641.34846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 270, '2025-08-10 00:00:00', 262.641661031792, 405.84846153846, 327.587396974635, 566.033846153846, 406.692366626178, 751.110000000001, 581.665254502967, 1207.76, 1643.31791739199, 3609.90846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 285, '2025-08-10 00:00:00', 237.666157036746, 375.393846153845, 266.857552292489, 505.523461538462, 302.759919094067, 657.455384615386, 513.925270360015, 1174.19115384615, 1606.02012356259, 3572.86 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 300, '2025-08-10 00:00:00', 168.118921732391, 357.027307692308, 235.859063055428, 492.044230769232, 264.823336328494, 650.028076923078, 437.554257719674, 1112.91384615385, 1599.33176944873, 3542.84 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 315, '2025-08-10 00:00:00', 145.978575222531, 320.57, 153.868860149955, 398.500384615386, 297.162068641907, 649.436538461539, 465.030784062899, 1117.14692307692, 1583.36017597557, 3521.82576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 330, '2025-08-10 00:00:00', 109.335996704584, 264.689230769232, 222.796093663105, 464.523461538463, 313.355877600237, 659.561153846155, 618.930731867842, 1141.55230769231, 1571.86493232705, 3508.80346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 345, '2025-08-10 00:00:00', 198.489026901122, 345.118076923077, 296.23518143555, 507.011923076923, 324.740079056133, 638.824230769231, 759.350675696119, 1151.46192307692, 1575.62059189373, 3502.07346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 360, '2025-08-10 00:00:00', 197.173889351114, 339.734615384616, 231.363673499936, 425.389230769231, 257.246436666956, 541.814615384615, 721.809662831925, 1084.28846153846, 1576.39899576667, 3470.51692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 375, '2025-08-10 00:00:00', 115.345908677402, 276.623846153847, 150.740200018237, 371.438461538462, 275.833428547291, 504.758076923077, 737.049036094719, 1054.19807692308, 1580.37817278139, 3458.72038461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 390, '2025-08-10 00:00:00', 148.924310578845, 278.154230769229, 175.58955554185, 348.470769230768, 305.052828853275, 499.949230769229, 753.603040280081, 1081.17923076923, 1575.37150074812, 3455.78576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 405, '2025-08-10 00:00:00', 105.288039589572, 230.363846153848, 282.056315496638, 364.116538461541, 302.01988269547, 477.719230769232, 713.97882406704, 1075.08807692308, 1561.06035981444, 3441.85 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 420, '2025-08-10 00:00:00', 255.321480428408, 297.421923076925, 282.546343055708, 391.316923076924, 293.238646301032, 538.637307692309, 713.488120766184, 1098.42230769231, 1560.95193656159, 3440.95923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 435, '2025-08-10 00:00:00', 127.398675941071, 249.246538461541, 160.942058382702, 341.182692307694, 206.498930528801, 510.36153846154, 699.830001092023, 1098.02730769231, 1562.86356869773, 3427.38884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 450, '2025-08-10 00:00:00', 127.651407241031, 248.021153846155, 171.520727570932, 352.442307692307, 205.179483541756, 513.577692307694, 699.194067945813, 1123.27115384615, 1569.53915036034, 3401.56461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 465, '2025-08-10 00:00:00', 109.943471727693, 227.273461538462, 174.608020807925, 358.867692307693, 209.477904213896, 511.294615384616, 702.205094815336, 1121.87384615385, 1570.83693899604, 3409.06230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 480, '2025-08-10 00:00:00', 160.65640785803, 273.875384615385, 179.386231710755, 362.779230769232, 213.971977394596, 476.973076923078, 716.668163200964, 1134.73538461539, 1571.1582925543, 3406.27692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 495, '2025-08-10 00:00:00', 105.008708286503, 231.460000000001, 150.417956057829, 345.383846153848, 318.196190376314, 520.115000000001, 727.730719108062, 1105.35153846154, 1545.94722990907, 3374.75653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 510, '2025-08-10 00:00:00', 136.140735586941, 269.043076923077, 130.231785535813, 331.659615384616, 504.423045781857, 570.990384615385, 851.708767486956, 1139.35307692308, 1539.77488573687, 3370.065 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 525, '2025-08-10 00:00:00', 96.2514518931441, 232.383461538461, 302.371908335008, 397.806923076921, 636.783250409429, 595.764999999999, 846.942347491345, 1158.18692307692, 1544.06070290143, 3365.12269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 540, '2025-08-10 00:00:00', 257.396551341431, 313.732307692305, 454.57329866218, 441.396153846152, 581.09800095972, 588.95923076923, 792.382653616, 1132.50653846154, 1530.11886217032, 3338.69576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 555, '2025-08-10 00:00:00', 319.21705431499, 280.87153846154, 452.339574843943, 406.025000000001, 455.945383871796, 543.385000000002, 662.752634038115, 1079.86269230769, 1496.59249641644, 3304.145 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 570, '2025-08-10 00:00:00', 256.359326310969, 275.158846153845, 248.992947884378, 367.168076923077, 345.421188483767, 543.008461538462, 542.140706280347, 1053.67307692308, 1474.97707261117, 3274.81615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 585, '2025-08-10 00:00:00', 124.220550568491, 244.433461538463, 243.855671052809, 393.776153846155, 259.44707878131, 559.591923076924, 534.250078897514, 1067.925, 1474.40103851105, 3268.29769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 600, '2025-08-10 00:00:00', 230.313643715228, 306.40576923077, 243.802213943695, 423.320384615385, 249.348542189136, 570.729615384616, 553.772333290079, 1055.78846153846, 1463.65762482335, 3251.79653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 615, '2025-08-10 00:00:00', 132.37360803946, 268.67423076923, 160.966884071037, 386.306538461538, 245.660506622453, 565.365, 549.89725955435, 1033.46423076923, 1462.96923275377, 3248.05192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 630, '2025-08-10 00:00:00', 132.88507027561, 276.886923076922, 195.615887789939, 382.239615384616, 290.296955942598, 586.701538461539, 540.862690545389, 1033.5, 1457.51975910037, 3244.12 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 645, '2025-08-10 00:00:00', 146.433155173799, 256.053076923077, 173.895754744485, 377.993076923077, 229.751225255962, 541.301153846153, 535.039085626316, 1041.54961538462, 1458.46594609268, 3238.93 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 660, '2025-08-10 00:00:00', 120.129430158284, 273.083076923076, 199.154195756414, 425.770769230769, 266.287545259168, 532.948076923076, 500.529244047352, 1035.10884615385, 1485.59498235374, 3232.04884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 675, '2025-08-10 00:00:00', 164.116091769961, 312.384615384615, 158.769683609261, 394.834230769229, 313.718475429805, 515.165, 488.846124738026, 1000.51076923077, 1491.56581401941, 3242.85923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 690, '2025-08-10 00:00:00', 113.840963372321, 261.431538461536, 171.614134287897, 329.180769230766, 408.997452386458, 501.971153846154, 494.178761349186, 992.646153846155, 1503.50369980175, 3236.86153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 705, '2025-08-10 00:00:00', 157.471327419898, 225.80076923077, 259.135938440694, 324.333461538463, 399.143789044075, 529.377307692309, 515.230074324681, 1041.76384615385, 1503.32742707108, 3239.85807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 720, '2025-08-10 00:00:00', 224.683548303284, 260.223076923077, 370.676365054268, 385.025384615386, 369.108957803059, 523.632307692308, 528.508448282961, 1069.07769230769, 1507.90235381126, 3234.61846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 735, '2025-08-10 00:00:00', 226.038583413404, 271.71653846154, 295.950665458594, 410.094230769231, 294.420260812016, 484.803846153848, 563.00753988516, 1155.68346153846, 1508.57037627264, 3238.99076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 750, '2025-08-10 00:00:00', 155.595535953367, 265.176153846154, 154.801584847779, 326.380769230771, 163.043088922956, 426.248461538462, 504.440317476707, 1125.28, 1592.21367271612, 3263.12192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 765, '2025-08-10 00:00:00', 107.982957219395, 215.945384615387, 126.13788385548, 282.633461538463, 215.903492927885, 440.887692307693, 578.509135383756, 1274.10769230769, 1730.10783780474, 3297.90423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 780, '2025-08-10 00:00:00', 126.259963616586, 229.407307692309, 154.344318357965, 321.834230769231, 291.639758418605, 482.187692307692, 604.697359966251, 1367.30307692308, 1730.41412575412, 3296.47576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 795, '2025-08-10 00:00:00', 112.279306487815, 236.705769230768, 209.241204304063, 358.751153846154, 294.945453803553, 486.209230769232, 662.148406649492, 1482.18269230769, 1730.18676857749, 3298.76615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 810, '2025-08-10 00:00:00', 204.484595527765, 276.411923076924, 283.530826500673, 349.498076923077, 314.177819297633, 530.071153846154, 720.79250335895, 1599.61769230769, 1719.50449084076, 3309.25846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 825, '2025-08-10 00:00:00', 107.243220044618, 201.68153846154, 134.912018093274, 329.665000000001, 211.739710919944, 495.197307692308, 760.288917141777, 1733.44384615385, 1710.81995715977, 3298.98807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 840, '2025-08-10 00:00:00', 111.218218435651, 261.140000000001, 160.534533395346, 372.442692307694, 208.298796423645, 485.436538461539, 759.059230332775, 1829.36576923077, 1710.25442548236, 3296.655 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 855, '2025-08-10 00:00:00', 96.7945241712489, 242.108461538461, 150.47170814322, 352.836538461537, 230.375824518583, 460.511153846154, 790.511682298147, 1884.60538461538, 1710.41890109101, 3284.26576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 870, '2025-08-10 00:00:00', 121.712108475445, 242.721538461537, 176.174027643561, 323.658076923075, 264.478586827861, 514.482307692308, 793.257440084772, 1926.71538461539, 1727.97472954136, 3291.20846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 885, '2025-08-10 00:00:00', 116.157042289242, 229.605769230769, 181.588293296003, 345.723076923077, 357.996611143396, 592.976923076923, 783.38678454172, 1974.82884615385, 1747.92275043898, 3303.93307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 900, '2025-08-10 00:00:00', 121.940217764534, 252.542692307692, 219.672689540599, 380.945000000001, 351.548805228214, 618.81576923077, 786.404878425767, 1996.90038461539, 1748.53085146698, 3302.33961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 915, '2025-08-10 00:00:00', 185.568550735715, 299.383076923077, 318.983067925848, 499.11923076923, 438.967804413946, 709.350000000002, 749.80348327976, 2022.45230769231, 1735.87285792236, 3306.73346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 930, '2025-08-10 00:00:00', 299.072443546068, 400.603846153847, 307.326622900431, 488.299230769233, 453.855911958681, 719.609615384618, 760.151942222181, 2017.88807692308, 1740.15700184995, 3292.28923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 945, '2025-08-10 00:00:00', 194.390098311062, 315.21576923077, 364.679603449174, 502.520384615386, 590.740749522027, 946.835384615386, 813.673042631611, 2063.54576923077, 1754.21468721547, 3330.50769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 960, '2025-08-10 00:00:00', 276.354285701135, 390.654230769232, 373.641545948065, 524.87230769231, 600.106177940589, 1060.59230769231, 806.756263801764, 2104.11923076923, 1739.18639968941, 3318.31384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 975, '2025-08-10 00:00:00', 289.250390723225, 369.928461538462, 532.786534329289, 811.848846153847, 641.883654486243, 1186.98384615385, 871.593398462043, 2170.19115384615, 1704.83236534956, 3315.30076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 990, '2025-08-10 00:00:00', 510.879488072812, 757.158461538462, 569.072958496941, 944.982692307693, 681.430233412163, 1309.93807692308, 866.658156693061, 2157.14115384615, 1705.53928679361, 3361.69269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1005, '2025-08-10 00:00:00', 349.301716845965, 612.55653846154, 472.907488115642, 886.470384615386, 635.240223934221, 1339.06, 844.961084555696, 2019.23153846154, 1690.44232326153, 3331.85538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1020, '2025-08-10 00:00:00', 255.017050143712, 628.080000000003, 363.2027249273, 877.768846153847, 577.829138082024, 1292.63384615385, 997.829966649629, 1976.25, 1655.99310201095, 3356.88038461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1035, '2025-08-10 00:00:00', 277.750865646785, 609.37346153846, 455.551692267906, 926.658076923077, 657.839585577962, 1216.54423076923, 1240.77656215452, 1949.2, 1628.96918174281, 3351.68961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1050, '2025-08-10 00:00:00', 285.339456125777, 601.776923076924, 431.234110937972, 820.412692307692, 563.319217190533, 1031.31192307692, 1214.00121910343, 1824.68615384615, 1516.82310057628, 3279.99461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1065, '2025-08-10 00:00:00', 278.819543635995, 531.305769230768, 411.707522515121, 715.466538461535, 440.275009611037, 963.709999999999, 1197.77548607928, 1736.14269230769, 1482.99285736358, 3228.69076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1080, '2025-08-10 00:00:00', 310.634939983357, 494.662307692308, 330.574859064538, 653.57153846154, 418.963038610071, 892.18576923077, 1190.69222326097, 1713.26307692308, 1454.57242756071, 3258.94961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1095, '2025-08-10 00:00:00', 195.776818797874, 447.038846153847, 236.695273160693, 650.203846153847, 372.808884878649, 824.592692307692, 1147.29081839778, 1629.82961538462, 1424.66836481634, 3287.42269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1110, '2025-08-10 00:00:00', 217.623912508218, 478.289230769232, 366.659699535393, 603.479230769232, 499.920116802215, 785.326538461539, 1211.06707709581, 1667.49576923077, 1412.18627535671, 3252.27538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1125, '2025-08-10 00:00:00', 193.71826002848, 378.652692307692, 240.249213188178, 528.961538461537, 472.644787831201, 788.799999999999, 1082.66518295725, 1630.10961538462, 1296.24017277379, 3248.88384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1140, '2025-08-10 00:00:00', 195.666078272299, 404.007692307691, 270.068658766619, 558.59, 402.678267961103, 805.531923076924, 982.626758441101, 1617.46730769231, 1192.38204162366, 3247.53115384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1155, '2025-08-10 00:00:00', 203.65733125409, 410.081538461538, 324.355282405905, 590.686153846153, 401.555907987341, 863.366538461538, 909.084152526893, 1594.26653846154, 1155.24913842167, 3255.09 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1170, '2025-08-10 00:00:00', 221.418236194276, 430.140769230769, 260.089866392663, 598.328076923077, 343.486543328174, 806.763461538462, 840.513530955927, 1568.03, 1086.9340198446, 3232.12653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1185, '2025-08-10 00:00:00', 156.732195092825, 396.461153846152, 239.525023018151, 588.839615384615, 250.297948136584, 713.684230769231, 748.361401386029, 1529.22269230769, 1039.5057634052, 3208.27384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1200, '2025-08-10 00:00:00', 187.344582669312, 427.03653846154, 213.093133616411, 553.737692307693, 304.076081979493, 728.95, 746.73238239237, 1512.86576923077, 1043.07480778588, 3202.68153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1215, '2025-08-10 00:00:00', 177.722780057982, 361.546538461538, 221.04479682147, 488.815384615385, 543.121086852221, 750.156538461538, 794.769993371957, 1490.45730769231, 1067.43905003446, 3198.53769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1230, '2025-08-10 00:00:00', 215.497119748375, 395.930384615383, 331.320218775408, 536.294230769229, 630.796253197982, 814.476153846153, 783.591312514472, 1504.54192307692, 1252.14558916427, 3312.89653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1245, '2025-08-10 00:00:00', 234.610321210759, 350.481153846154, 451.425745314179, 534.512692307692, 540.508270184078, 771.12576923077, 703.685382549725, 1455.06692307692, 1384.76812903316, 3387.975 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1260, '2025-08-10 00:00:00', 316.242364673289, 409.876923076923, 381.370875459327, 578.306153846155, 498.21218189056, 836.568076923078, 695.922148621193, 1481.61153846154, 1410.260575103, 3380.98461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1275, '2025-08-10 00:00:00', 166.829844882557, 375.20346153846, 263.157158472621, 520.48923076923, 389.106950849486, 790.980769230769, 661.114394879178, 1451.28730769231, 1442.27590522335, 3382.16961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1290, '2025-08-10 00:00:00', 180.555033504598, 351.530384615386, 307.196421008047, 566.928076923078, 479.559506481328, 838.673846153847, 621.460827960528, 1437.61576923077, 1500.53931550765, 3401.40807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1305, '2025-08-10 00:00:00', 218.800930476506, 405.404230769231, 251.478281176296, 534.339230769232, 419.804138295283, 786.994615384617, 598.70394864921, 1378.12192307692, 1497.21639755175, 3369.13538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1320, '2025-08-10 00:00:00', 168.572390335836, 338.923461538462, 329.663108457009, 530.831538461539, 501.193252292351, 769.93076923077, 600.189165053308, 1331.72076923077, 1481.29696422208, 3433.49153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1335, '2025-08-10 00:00:00', 239.991938415887, 386.923846153849, 304.101537336817, 557.041153846155, 458.126856641428, 790.261923076925, 592.004464316459, 1338.88115384615, 1458.30324401393, 3463.92153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1350, '2025-08-10 00:00:00', 201.97208508451, 368.195769230771, 356.823153388341, 584.335000000001, 450.567877640413, 808.455769230771, 608.909216109747, 1345.40923076923, 1502.26009986538, 3511.62653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1365, '2025-08-10 00:00:00', 262.226610575954, 438.766923076924, 309.469211327049, 572.40076923077, 449.990607318215, 769.808846153846, 610.915220567785, 1338.14423076923, 1481.1569023255, 3536.47230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1380, '2025-08-10 00:00:00', 228.973353698971, 391.651923076922, 432.182173706343, 589.28846153846, 418.738714420414, 743.712307692307, 619.80561523718, 1285.37653846154, 1494.02509083395, 3537.96423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1395, '2025-08-10 00:00:00', 336.387927842475, 396.446923076922, 334.294726528277, 496.793846153846, 376.836849358527, 665.482307692307, 623.57170304292, 1247.73961538462, 1541.76464485322, 3519.68076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1410, '2025-08-10 00:00:00', 221.916228915672, 335.408076923078, 281.971738923491, 474.296538461539, 307.662951649767, 644.064615384615, 651.272215606087, 1221.56730769231, 1562.70896392628, 3513.01346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 2, 1425, '2025-08-10 00:00:00', 134.107186341602, 272.982692307693, 197.933374476984, 402.310384615385, 246.546489483143, 609.437307692306, 604.330826758375, 1185.19769230769, 1565.52203505471, 3511.69461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 0, '2025-08-10 00:00:00', 159.050495128482, 286.926153846154, 202.187175539438, 444.516153846154, 492.443982103706, 669.073076923076, 603.993069946616, 1178.24346153846, 1602.22647810222, 3502.04961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 3 and fromtime = 0); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 3, 15, '2025-08-10 00:00:00', 142.913286948632, 317.687692307693, 181.242060929151, 444.105384615385, 472.003299598801, 668.991923076924, 627.587131834665, 1182.55269230769, 1642.62561267507, 3495.11192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 3 and fromtime = 15); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 3, 30, '2025-08-10 00:00:00', 127.246013037134, 293.914615384615, 487.414207435368, 476.734615384616, 473.212378256725, 660.979230769234, 679.215968288324, 1170.25461538462, 1663.21451291962, 3475.38769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 3 and fromtime = 30); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 3, 45, '2025-08-10 00:00:00', 408.980290914442, 328.942692307694, 380.642266442674, 513.458846153848, 421.575309374804, 654.742307692308, 618.353346000114, 1128.84846153846, 1673.32597359097, 3450.89692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 00:00:00' and dayofweek = 3 and fromtime = 45); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243185493300, 3, 60, '2025-08-10 00:00:00', 164.310762454751, 395.797692307693, 204.734691619705, 481.966153846155, 286.007241377127, 603.771923076923, 571.508373519112, 1104.74769230769, 1674.59285005157, 3442.99038461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 75, '2025-08-10 00:00:00', 137.387718510567, 270.481538461541, 216.611471677182, 398.716923076923, 243.441093032003, 568.453846153846, 475.690127244779, 1097.31307692308, 1689.2090721688, 3430.53576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 90, '2025-08-10 00:00:00', 148.992468130234, 273.26346153846, 173.219625518056, 361.413846153847, 265.978819920225, 566.913076923077, 404.619657162701, 1081.67230769231, 1701.51842120388, 3430.46192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 105, '2025-08-10 00:00:00', 100.194581537049, 244.255769230771, 125.281280652778, 392.755000000001, 244.478344522501, 554.87730769231, 381.40561413802, 1082.54, 1743.28415014014, 3462.84461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 120, '2025-08-10 00:00:00', 96.2041215717115, 284.670769230769, 170.649614314966, 408.955384615386, 212.327790273582, 516.18230769231, 373.760853340536, 1078.96461538461, 1747.23797078743, 3465.92576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 135, '2025-08-10 00:00:00', 163.394767219198, 279.771153846156, 204.216396590631, 380.447307692309, 211.386998360462, 517.529615384617, 368.47083298327, 1077.26923076923, 1766.7769067102, 3473.89730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 150, '2025-08-10 00:00:00', 142.988622645838, 274.226923076924, 138.4443812661, 339.971923076925, 225.22812696498, 525.671923076924, 363.861729345726, 1082.29769230769, 1789.79500561308, 3515.95846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 165, '2025-08-10 00:00:00', 82.2021387893202, 211.798461538465, 142.368001126007, 356.163846153848, 222.464219618485, 546.102307692308, 373.201407424999, 1077.07, 1792.15088103189, 3519.13923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 180, '2025-08-10 00:00:00', 136.274872746788, 294.836923076923, 197.763315201625, 427.683461538461, 231.541916258405, 603.003846153847, 375.527567163644, 1089.71961538462, 1787.7503923089, 3511.95615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 195, '2025-08-10 00:00:00', 161.227945278153, 322.371153846154, 181.562428763392, 434.672307692307, 279.517205424198, 629.448076923078, 409.940424256989, 1083.01, 1800.51854564469, 3532.04769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 210, '2025-08-10 00:00:00', 112.728373330969, 295.094615384615, 148.117901807466, 427.009615384616, 371.127762982797, 617.966153846155, 406.547849601231, 1051.35076923077, 1804.17542355998, 3525.25538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 225, '2025-08-10 00:00:00', 111.658580501178, 302.673461538462, 251.313051958032, 454.28730769231, 358.805215803781, 588.620000000003, 422.923775415672, 1057.68038461538, 1808.90710700118, 3517.60923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 240, '2025-08-10 00:00:00', 238.419269762002, 326.734615384617, 337.998826711893, 468.958846153849, 347.468368113615, 631.35653846154, 458.380607555975, 1042.93923076923, 1836.65129147973, 3543.49692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 255, '2025-08-10 00:00:00', 165.919862327016, 325.001153846155, 225.434106437746, 398.574230769232, 317.232166713179, 666.511538461537, 453.773758130635, 1015.35, 1824.91922584881, 3559.06384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 270, '2025-08-10 00:00:00', 218.035924493753, 290.204615384615, 309.344113427101, 447.96, 324.028403446601, 639.678076923076, 439.624940281529, 1005.49153846154, 1808.28292783352, 3539.34692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 285, '2025-08-10 00:00:00', 188.804193832169, 325.653846153846, 230.995522196026, 506.828846153845, 277.37003184943, 599.111923076921, 400.786302102984, 1008.71423076923, 1773.70485183966, 3528.16346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 300, '2025-08-10 00:00:00', 130.809523384781, 346.738076923077, 151.266527592347, 426.485384615385, 248.165909237844, 548.259615384616, 357.313174609528, 967.078461538461, 1773.78500430902, 3539.83346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 315, '2025-08-10 00:00:00', 114.482378373942, 282.873076923078, 198.34786244219, 381.749230769231, 232.252637574823, 500.887307692309, 425.387531790088, 954.812307692308, 1773.78649848128, 3534.03769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 330, '2025-08-10 00:00:00', 131.627405877348, 271.124999999998, 194.854137999131, 352.960769230769, 191.051992435407, 450.42846153846, 408.348572793092, 926.683076923075, 1763.36143929502, 3536.45615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 345, '2025-08-10 00:00:00', 144.64526672306, 234.144230769231, 134.861492304571, 322.318846153846, 141.012290402155, 423.132692307692, 404.713421736343, 901.39846153846, 1769.74892335225, 3533.38230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 360, '2025-08-10 00:00:00', 73.6510269613495, 240.602692307693, 98.979123725858, 314.231538461539, 146.075689168846, 446.953076923077, 401.530475287514, 898.763846153845, 1769.447544137, 3521.28269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 375, '2025-08-10 00:00:00', 78.9006045721236, 218.975384615385, 126.460870472316, 304.276153846155, 193.074362087213, 428.659230769232, 459.815120159765, 910.943461538461, 1759.10653602775, 3516.34653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 390, '2025-08-10 00:00:00', 105.702214488848, 206.839615384615, 152.825986638398, 301.59, 230.604779522155, 398.362307692309, 476.306256939798, 897.589999999999, 1746.02509586604, 3527.135 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 405, '2025-08-10 00:00:00', 112.993504483152, 204.14076923077, 185.594866333593, 305.294230769233, 304.230112567141, 441.243846153847, 513.774056325722, 921.464230769232, 1774.51201249683, 3567.36653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 420, '2025-08-10 00:00:00', 173.573887667915, 243.451923076925, 208.664826699516, 293.17153846154, 345.493543885577, 459.791153846154, 517.256990897771, 951.916153846154, 1798.86304506276, 3590.93269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 435, '2025-08-10 00:00:00', 111.275153326547, 199.409615384616, 218.490759034652, 331.936538461539, 251.911426121289, 456.01769230769, 463.431498602131, 969.156153846153, 1734.20003181981, 3573.98961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 450, '2025-08-10 00:00:00', 209.849625331677, 256.070384615385, 243.90304700055, 331.198076923076, 241.143703485, 437.522307692306, 479.158066186451, 963.956538461538, 1718.39016340979, 3568.86653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 465, '2025-08-10 00:00:00', 127.253756029196, 215.17346153846, 149.395454494234, 302.413461538459, 188.607948114193, 417.519615384615, 436.655183257736, 973.275384615383, 1708.30835814633, 3549.85384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 480, '2025-08-10 00:00:00', 126.708887154162, 232.849615384616, 168.272723578309, 311.242692307692, 176.8902726986, 424.63076923077, 414.201970442146, 980.343076923076, 1721.46716111099, 3546.30346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 495, '2025-08-10 00:00:00', 118.346817227362, 221.229615384615, 135.497684052308, 318.663461538462, 168.27046497872, 455.321923076922, 429.502875298698, 1031.21538461538, 1730.14833744091, 3533.26153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 510, '2025-08-10 00:00:00', 111.450661486807, 232.975384615385, 92.9249307584457, 290.152692307694, 152.483275764415, 441.949615384617, 505.216874521766, 1048.03846153846, 1725.0704059412, 3518.82692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 525, '2025-08-10 00:00:00', 61.1637173808635, 193.160384615385, 168.624272708474, 321.527692307693, 174.872749368044, 435.386538461537, 612.006626501205, 1068.52423076923, 1710.36339682901, 3505.42730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 540, '2025-08-10 00:00:00', 126.236098460843, 242.401153846154, 134.35492863079, 312.76076923077, 165.9909382573, 420.67346153846, 604.315497586639, 1046.11923076923, 1709.92964479006, 3503.45961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 555, '2025-08-10 00:00:00', 114.250575873318, 223.31076923077, 150.163528380026, 312.34346153846, 209.08443527878, 436.790384615384, 599.883585720277, 1048.78615384615, 1712.71728367832, 3498.91230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 570, '2025-08-10 00:00:00', 106.989644815964, 219.445384615385, 115.36206346709, 290.200769230768, 252.051843557264, 448.056153846154, 593.358181653701, 1034.38923076923, 1722.73674932631, 3485.83923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 585, '2025-08-10 00:00:00', 86.0395537269841, 190.248461538461, 179.442304107433, 313.51076923077, 289.914490231438, 461.403076923077, 581.794007332097, 1023.42653846154, 1716.52497335339, 3486.01461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 600, '2025-08-10 00:00:00', 179.134901866207, 262.611153846153, 233.411622024598, 351.428076923076, 313.831029703027, 493.072692307692, 551.339334300225, 1018.10884615384, 1708.77075746226, 3479.20307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 615, '2025-08-10 00:00:00', 143.13966534768, 224.220384615384, 195.248992684096, 321.931923076922, 296.57403149376, 493.932692307692, 572.057845308026, 1028.73769230769, 1698.07528276911, 3481.75076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 630, '2025-08-10 00:00:00', 100.516518251403, 228.945769230768, 182.242404797735, 315.907692307691, 284.621415424338, 497.613076923077, 568.233262201495, 1015.89807692307, 1689.99104098913, 3496.89653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-10 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 515840243185493300, 3, 645, '2025-08-10 00:00:00', 147.812688956717, 216.643846153845, 216.053519157779, 356.1[...];

[ Date: 2025-08-10 15:00:16 - 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 autochartist_symbolupdates au on dss.symbolid = au.symbolid 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 ('213' = 0 OR coalesce(bim.code, s.symbol) in ('#ADBE', '#ALVG', '#AMZN', '#APPL', '#BA', '#BABA', '#BAYGn', '#BMWG', '#BNPP', '#CAT', '#CBKG', '#DAIGn', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#META', '#MSFT', '#NFLX', '#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', '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', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'OMGUSD', 'SPX500', 'TRXUSD', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDDKK', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'USOIL', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XMRUSD', 'XPTUSD', 'XRPUSD', 'ZARJPY', 'ZECUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'HKDJPY', 'NOKJPY', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDDKK', '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', '#ALVG', '#BAYGn', '#BMWG', '#BNPP', '#CBKG', '#DAIGn', '#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 ('500' = 0 OR ar.patternlengthbars <= '500') and newLevels.filtered = false AND ar.patternstarttime >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), 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: 2025-08-10 15:02:28 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

select updateageforrelevantresults ();

[ Date: 2025-08-10 15:02:22 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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 autochartist_symbolupdates au on dss.symbolid = au.symbolid 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 ('213' = 0 OR coalesce(bim.code, s.symbol) in ('#ADBE', '#ALVG', '#AMZN', '#APPL', '#BA', '#BABA', '#BAYGn', '#BMWG', '#BNPP', '#CAT', '#CBKG', '#DAIGn', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#META', '#MSFT', '#NFLX', '#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', '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', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'OMGUSD', 'SPX500', 'TRXUSD', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDDKK', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'USOIL', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XMRUSD', 'XPTUSD', 'XRPUSD', 'ZARJPY', 'ZECUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'HKDJPY', 'NOKJPY', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDDKK', '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', '#ALVG', '#BAYGn', '#BMWG', '#BNPP', '#CBKG', '#DAIGn', '#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 ('500' = 0 OR ar.patternlengthbars <= '500') and newLevels.filtered = false AND ar.patternstarttime >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), 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: 2025-08-10 15:47:01 - 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_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a.*, rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.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, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '627' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.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 hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.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 autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.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 kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.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 ('213' = 0 OR coalesce(bim.code, s.symbol) in ('#ADBE', '#ALVG', '#AMZN', '#APPL', '#BA', '#BABA', '#BAYGn', '#BMWG', '#BNPP', '#CAT', '#CBKG', '#DAIGn', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#META', '#MSFT', '#NFLX', '#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', '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', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'OMGUSD', 'SPX500', 'TRXUSD', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDDKK', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'USOIL', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XMRUSD', 'XPTUSD', 'XRPUSD', 'ZARJPY', 'ZECUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'HKDJPY', 'NOKJPY', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDDKK', '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', '#ALVG', '#BAYGn', '#BMWG', '#BNPP', '#CBKG', '#DAIGn', '#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 p.patternname in ('')) AND ('2' = 0 OR kr.patternclassid in ('1', '2')) AND ('500' = 0 OR kr.patternlengthbars <= '500') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), 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 LIMIT 200;

[ Date: 2025-08-10 15:47:24 - 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 autochartist_symbolupdates au on dss.symbolid = au.symbolid 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 ('213' = 0 OR coalesce(bim.code, s.symbol) in ('#ADBE', '#ALVG', '#AMZN', '#APPL', '#BA', '#BABA', '#BAYGn', '#BMWG', '#BNPP', '#CAT', '#CBKG', '#DAIGn', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#META', '#MSFT', '#NFLX', '#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', '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', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'OMGUSD', 'SPX500', 'TRXUSD', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDDKK', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDZAR', 'USOIL', 'XAGUSD', 'XAUEUR', 'XAUUSD', 'XMRUSD', 'XPTUSD', 'XRPUSD', 'ZARJPY', 'ZECUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURJPY', 'EURMXN', 'EURNOK', 'EURNZD', 'EURPLN', 'EURSEK', 'EURTRY', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GBPZAR', 'HKDJPY', 'NOKJPY', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDDKK', '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', '#ALVG', '#BAYGn', '#BMWG', '#BNPP', '#CBKG', '#DAIGn', '#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 ('500' = 0 OR ar.patternlengthbars <= '500') and newLevels.filtered = false AND ar.patternstarttime >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), 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;