select powerstats_tdata_add ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

select updateresultsmaterializedview ();

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

select updateresultsmaterializedview ();

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

select updateresultsmaterializedview ();

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

select updateresultsmaterializedview ();

[ Date: 2025-08-03 14:02:30 - 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-03 14:01:17 - 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-03 14:03:19 - 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-03 14:05: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-03 14:11:17 - 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-03 14:16:18 - 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-03 14:18: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-03 14:20: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-03 14:26: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-03 14:31:18 - 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-03 14:33:17 - 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-03 14:35:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select powerstats_tdata_add ();

[ Date: 2025-08-03 14:02:57 - 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-03 00:00:00', 175.808656641684, 347.913076923078, 275.668278455215, 470.397692307692, 317.189524247667, 656.762692307692, 1361.64455509652, 2192.33, 2623.48382124721, 4015.21538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 188.630030134286, 306.257307692307, 260.043901110208, 471.283846153846, 297.841142709693, 641.558846153845, 1350.73631619208, 2185.71807692308, 2610.28797337199, 4005.87769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 236.480632800755, 368.604615384617, 300.934430217714, 488.717692307692, 276.219762171633, 651.206923076923, 1329.72783467092, 2252.83884615385, 2608.30096442841, 4004.16692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 227.089616178621, 332.521923076923, 250.751757348857, 477.311538461538, 619.063320797203, 1029.65269230769, 1331.78056185175, 2267.84692307692, 2610.65189736934, 4005.60307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 135.419360624692, 344.45, 185.258480036365, 490.39576923077, 891.69785604732, 1296.01076923077, 1338.02527607838, 2276.57615384615, 2585.981621983, 4013.11461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 166.074617398787, 359.341923076923, 598.118093990964, 914.780769230769, 1068.37938406455, 1474.95307692308, 1356.97041957494, 2298.35576923077, 2554.12483326258, 4026.65615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 559.690832448938, 821.340769230769, 837.707402622551, 1161.83384615385, 1283.61943236771, 1673.07, 1450.16304213333, 2345.95423076923, 2497.99334215153, 4006.22423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 590.899430982453, 808.770769230768, 881.770282616652, 1078.99538461538, 1121.44921578472, 1538.18192307692, 1271.45030743642, 2193.83807692308, 2187.82131245046, 3909.92730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 430.536166249267, 677.116153846153, 744.990047967395, 1088.17230769231, 751.132712380442, 1365.1, 1037.43298904526, 1991.53076923077, 2059.32098747853, 3797.10846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 687.71376956685, 801.160384615384, 685.036111668463, 985.875384615384, 707.829469585392, 1175.78846153846, 1043.91332239777, 1963.99346153846, 2089.29617594825, 3765.18 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 375.412874814059, 594.338076923077, 412.726111942944, 787.116538461538, 466.239293777514, 982.366923076922, 961.903811863825, 1819.41307692308, 2122.41000575811, 3687.51307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 223.533921898979, 549.573461538461, 378.138542527226, 764.063846153845, 461.245518603871, 976.241923076921, 941.120343798817, 1805.94, 2100.46514035567, 3689.09423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 310.661857798178, 538.508846153846, 338.846449363358, 698.806923076923, 415.141971662523, 886.409615384615, 1161.1265039501, 1863.26076923077, 2115.30983167867, 3716.73730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 206.617153601683, 475.802307692308, 308.37585941859, 635.598076923077, 360.899610062667, 800.079230769231, 1210.07299863419, 1841.65346153846, 2106.50713155246, 3738.35423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 235.422991127753, 438.253461538461, 234.029968449472, 573.127307692307, 398.045190816897, 855.387307692308, 1208.44749220553, 1817.60461538462, 2095.24921312606, 3766.54423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 142.89471098195, 381.371153846154, 217.400861469174, 548.043461538462, 390.771461949112, 845.174615384616, 1201.28454518096, 1801.27884615385, 2074.65224913077, 3798.32923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 122.6621732502, 400.932307692308, 270.391313185452, 673.996923076923, 368.613521078439, 867.055384615385, 1173.30176879496, 1784.00576923077, 2070.14620408883, 3805.95923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 222.387764037018, 509.96576923077, 282.507522752663, 639.090384615385, 516.9841868031, 889.152692307692, 1175.52994092969, 1738.99692307692, 2067.97972111542, 3818.53384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 224.462666223482, 407.791923076922, 315.38207350865, 612.011153846153, 771.247176452431, 931.025384615383, 1235.73145527684, 1685.66384615385, 2065.46119575299, 3821.44423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 234.649137961012, 457.115384615385, 427.882721073643, 665.384230769232, 809.890778437154, 962.171538461539, 1178.76328710058, 1630.93192307692, 2013.01423582386, 3816.10153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 304.191808160574, 462.220000000001, 601.975842666847, 683.407692307693, 709.398101339114, 917.263461538462, 1049.01911605938, 1544.445, 1939.36846803711, 3816.84384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 398.281786858925, 483.80346153846, 490.239895441624, 639.751153846153, 523.750043761188, 834.209615384616, 915.183984927873, 1469.55730769231, 1819.30935665818, 3760.01 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 239.779179685104, 411.262307692306, 256.051313690472, 553.248846153847, 372.12915481115, 742.787307692308, 728.682526794867, 1410.71807692308, 1651.33213339818, 3678.34423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 203.454358153976, 376.920384615385, 273.916093872672, 527.657692307694, 414.408071397488, 757.540769230769, 695.786356013218, 1387.57692307692, 1646.43857299365, 3657.04423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 240.901669764945, 407.873461538461, 307.44597224628, 545.172307692308, 583.44119159979, 845.97923076923, 674.110014470931, 1399.735, 1635.02285713992, 3655.455 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 218.18940908655, 389.048461538462, 295.932582491091, 563.070384615385, 511.909926683921, 838.538461538462, 690.177619367987, 1433.26730769231, 1672.49416261384, 3682.37423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 216.64945506864, 414.631538461537, 430.724998270805, 620.000769230767, 438.892887405783, 810.70076923077, 727.104050749695, 1464.43384615385, 1714.04522007164, 3728.73769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 354.375089902472, 405.759230769228, 391.365132128749, 568.506923076923, 446.313787309057, 776.976923076923, 758.24413318545, 1441.39307692308, 1723.56812439597, 3728.45538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 226.632528716898, 403.353846153845, 304.921368133088, 541.608076923077, 376.609250364966, 734.122692307692, 774.126853661594, 1419.88, 1777.90199670134, 3738.36115384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 196.504734400589, 353.694615384615, 307.989721500823, 544.456923076923, 302.147948241613, 723.938846153846, 802.264176171032, 1404.16923076923, 1773.21581239774, 3751.12576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 235.668072751619, 405.68769230769, 231.258974977938, 518.950384615384, 283.187842412881, 691.717692307694, 803.337379671734, 1396.49461538462, 1797.67652256799, 3774.13807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 155.87321838597, 375.175, 218.84589069445, 510.614615384615, 291.193111065229, 682.540384615385, 809.481649854067, 1404.24769230769, 1798.1238825804, 3793.125 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 115.249347982805, 349.147692307692, 170.575446150783, 442.741538461539, 331.506880269244, 679.585384615386, 765.689356150792, 1367.09115384615, 1772.1369212203, 3774.79807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 133.332113131661, 290.928076923078, 222.18859852075, 448.166153846155, 382.150560465576, 679.148076923078, 772.552682896523, 1356.83884615385, 1789.06995613325, 3760.67115384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 168.775590628959, 310.828076923077, 309.252462673362, 468.728461538461, 443.623085347843, 684.658461538461, 785.244552510579, 1385.69653846154, 1821.76009917712, 3768.15461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 281.627208099917, 339.756923076923, 340.827985922292, 480.829615384616, 436.896001397972, 666.198461538462, 918.439586583931, 1478.85269230769, 1836.55272667366, 3782.24730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 257.017372972813, 316.404615384617, 382.009406880753, 468.28576923077, 440.395341204487, 648.318846153847, 1006.46581300135, 1467.89730769231, 1816.32567737164, 3776.79346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 255.352289256356, 349.272692307692, 250.053886437732, 442.961153846155, 391.828447908205, 666.143076923078, 982.386240599663, 1461.52346153846, 1785.22120251137, 3763.21807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 166.612145933186, 309.06269230769, 256.121723948115, 461.173076923076, 474.277855698048, 703.048461538462, 974.205854158067, 1582.57961538462, 1780.68933950215, 3763.73615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 173.260058224625, 305.130000000001, 357.194895525591, 498.778461538462, 502.361753131529, 705.285769230771, 949.390101139433, 1579.78153846154, 1739.88904499975, 3725.26307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 336.202395042951, 397.296153846155, 422.93133889157, 523.446153846155, 490.179392673587, 680.134615384616, 914.465169498883, 1593.39884615385, 1825.9777361437, 3779.18269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 226.243627812006, 305.021538461539, 333.589595881157, 429.501923076925, 365.44420835934, 600.680769230771, 880.878292661628, 1526.24769230769, 1825.10101485277, 3738.02615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 291.836910222395, 318.828076923078, 292.308028505231, 421.193846153848, 286.826014132932, 603.189230769231, 868.874234007344, 1554.38461538462, 1797.67879092071, 3734.82692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 187.226062539788, 285.696923076923, 222.924363274943, 411.548461538461, 254.892575524249, 556.584230769231, 857.004263654776, 1488.37230769231, 1766.14213428008, 3720.74923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 193.790899689491, 319.882307692308, 230.706763363233, 447.028461538461, 319.225666777258, 590.60423076923, 849.130511276005, 1488.67038461538, 1759.08257442496, 3727.90846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 213.244032499061, 330.407307692307, 245.841805266344, 425.333846153845, 374.082035900599, 627.596538461536, 874.164252996761, 1540.95576923077, 1738.33270746036, 3744.22769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 155.326490916591, 289.002692307691, 231.379792530676, 405.906538461538, 435.86615786059, 682.408076923077, 846.267387547223, 1527.045, 1730.25142502292, 3750.40461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 181.702962077799, 282.489615384615, 248.824191220659, 447.953846153843, 623.811548044269, 788.525769230768, 833.750810612179, 1531.82730769231, 1731.38410518912, 3750.39153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 195.893864144298, 360.464230769229, 368.797048115166, 537.012307692309, 735.761197631719, 834.312692307693, 819.61021853571, 1533.30192307692, 1733.32534715482, 3747.37576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 295.33494995995, 412.519615384616, 539.113419710121, 665.806538461538, 675.314423366915, 818.220769230771, 891.836005605033, 1556.24153846154, 1730.52426127113, 3782.44 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 455.417660556179, 467.052307692305, 588.383917076781, 574.671153846154, 670.590008330093, 880.758076923077, 937.972272541228, 1553.63807692308, 1733.19881494092, 3797.92384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 267.010069906334, 364.859230769232, 260.446978495403, 502.979230769232, 568.84226511979, 895.041153846154, 851.820256739739, 1488.01807692308, 1720.70372094483, 3780.36423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 254.774907067759, 397.360769230769, 405.199324026318, 647.570769230769, 593.633440796205, 926.996538461538, 788.62888754178, 1466.30576923077, 1671.47390110221, 3750.17461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 349.710128607197, 469.777692307693, 500.481096893626, 689.690384615385, 563.297510029594, 881.21153846154, 753.498601905395, 1411.57423076923, 1672.79456232663, 3746.92846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 260.049967029711, 409.398076923075, 321.904970341346, 574.772307692307, 397.916800786877, 764.667307692308, 673.770222766008, 1294.15692307693, 1655.05876271918, 3715.48846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 236.578783486276, 382.219615384614, 263.853463698785, 511.755384615385, 295.399280742835, 671.46076923077, 615.539340131763, 1258.67538461539, 1618.69024862586, 3676.52730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 166.525299849142, 358.894615384615, 230.072772542481, 499.324230769232, 254.010436268944, 659.381538461539, 533.176055184545, 1192.19692307692, 1606.30131691392, 3637.97923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 141.599152040052, 327.967692307693, 145.022293384898, 408.258846153847, 295.179024582343, 662.974230769231, 547.221816810502, 1193.59576923077, 1589.32008973881, 3614.13076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 105.425009104176, 267.866153846156, 223.182042467925, 464.181923076924, 312.725658334044, 661.907307692309, 665.345640672115, 1211.07423076923, 1573.27215145172, 3594.18153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 198.660772533329, 344.853461538462, 296.562768041541, 513.622692307692, 324.476857929568, 644.000384615385, 796.737116941726, 1220.98384615385, 1577.40334192797, 3587.45153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 204.203231727608, 349.73, 234.119721510172, 431.12, 261.066378782514, 552.078846153845, 767.318081664864, 1153.93538461539, 1579.95533463513, 3555.895 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 115.374559353438, 280.775, 148.526433400304, 379.061153846154, 330.006263523074, 549.587307692307, 772.808443412626, 1130.20538461539, 1584.26558055149, 3543.66807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 146.866186100974, 282.250384615383, 172.66338996975, 354.270384615383, 410.529706608427, 565.649999999998, 775.124005106576, 1151.09269230769, 1579.43538861187, 3540.73346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 104.136280021015, 237.343846153848, 330.080648015696, 404.03230769231, 425.520817485333, 544.774230769232, 761.166738945194, 1137.98269230769, 1565.94781400992, 3526.79769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 295.41846318036, 329.859615384617, 380.847142186993, 448.220000000001, 382.998593158493, 598.214230769232, 746.279866336091, 1153.83884615385, 1565.88998609677, 3525.90692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 195.190144688553, 279.483461538464, 222.059586326595, 374.093461538463, 236.139617655449, 540.637692307695, 711.436936517484, 1136.54576923077, 1568.56010474815, 3512.33653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 151.896295710644, 268.408846153847, 215.791072714757, 382.719230769231, 264.866129581604, 554.083461538464, 709.387293584996, 1161.78961538462, 1576.65922972672, 3486.51230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 130.117971918385, 245.721923076924, 183.762212833281, 377.134230769231, 220.705706744385, 538.361538461539, 712.433809480193, 1160.39230769231, 1577.53132927115, 3494.01 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 168.767637043907, 287.595769230769, 197.353567963303, 386.910384615386, 219.953534389914, 498.301153846155, 725.983986027662, 1173.25384615385, 1578.0072684021, 3491.22461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 146.146762557895, 256.326923076924, 169.843231629821, 365.707692307694, 316.739468938407, 540.049230769232, 738.502320982134, 1143.87, 1554.69957583881, 3459.70423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 141.085633996356, 277.628076923078, 135.152287455527, 342.807307692308, 500.855724767737, 582.686153846154, 857.648368091131, 1172.04576923077, 1548.82974718219, 3455.01269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 96.3727411260758, 233.861923076923, 300.799118200427, 404.733076923075, 638.768399212228, 624.611923076922, 853.952571513103, 1184.25461538462, 1553.37168878921, 3450.07038461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 254.541270683921, 319.524230769229, 450.905887220894, 455.47769230769, 592.177795213175, 618.386538461537, 799.187393824884, 1154.67615384616, 1541.02994338447, 3423.64346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 320.246252483208, 296.99153846154, 463.832120311449, 433.916153846155, 486.968886229752, 581.609615384617, 672.680332528356, 1102.03230769231, 1509.76934372256, 3389.09269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 262.508101563769, 289.561153846153, 263.754640663511, 383.106538461539, 357.31405117821, 567.744230769232, 548.779346363012, 1061.48115384615, 1490.08519376062, 3359.76384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 125.771403735265, 248.518461538464, 244.198956683969, 406.658461538463, 265.896389130459, 566.506153846155, 540.771587417603, 1075.73307692308, 1489.90157295368, 3353.24538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 234.119717859508, 320.561153846154, 245.870283798969, 437.510769230769, 255.739360913834, 577.643846153846, 560.242507462205, 1063.59653846154, 1480.2558988585, 3336.74423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 143.167441118647, 282.277307692306, 178.299079973466, 393.220769230768, 252.29776355605, 572.27923076923, 556.738205517154, 1041.27230769231, 1479.79880388242, 3332.99961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 160.526630303079, 286.202692307691, 210.557675333496, 391.555384615385, 298.031100614581, 597.038461538462, 547.815938541542, 1041.30807692308, 1474.64711316384, 3329.06769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 156.912795022732, 265.674615384615, 189.734807666264, 395.901923076924, 246.210652899879, 556.71423076923, 563.14837213282, 1070.70961538462, 1475.89301896664, 3323.87769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 121.121829851664, 278.348846153846, 200.078234057041, 428.599230769231, 266.223072887843, 532.655384615383, 509.370795564639, 1048.56307692308, 1503.11196470773, 3316.99653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 165.28898332501, 314.406153846154, 157.973203277791, 393.734615384613, 313.747643697191, 515.868461538461, 497.741991769447, 1014.96115384615, 1508.38045750207, 3327.80692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 115.70367453044, 265.050384615382, 176.316991943923, 337.918076923074, 408.311804984111, 508.174230769231, 503.154255698833, 1015.13038461539, 1520.534820973, 3321.80923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 163.496337383583, 238.054615384616, 260.436000518658, 331.596923076924, 400.148538937153, 534.06153846154, 510.146111948484, 1036.86807692308, 1520.18638905938, 3324.80576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 226.526212695472, 268.736923076923, 371.07517499309, 392.978076923078, 369.840554685184, 528.604615384616, 522.820709367356, 1062.95076923077, 1525.01429732859, 3319.56615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 225.588111429794, 274.072307692309, 296.063149351361, 413.760384615385, 307.05548563311, 505.105769230771, 555.876122363747, 1142.83692307692, 1525.42162378194, 3323.93846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 160.614150813011, 273.00576923077, 157.17789109991, 332.748846153848, 188.451760446909, 438.723461538462, 495.649475463799, 1112.43346153846, 1606.8625228027, 3348.06961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 109.221813071451, 219.738846153849, 162.531556986991, 305.066153846155, 227.119412908716, 451.330000000001, 586.366924508484, 1283.66846153846, 1741.8352936923, 3382.85192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 155.340947201756, 247.611538461539, 165.414986607809, 327.692307692308, 294.34643367533, 488.045769230769, 610.703632614556, 1376.86384615385, 1742.21195699936, 3381.42346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 102.550554140948, 227.031153846153, 209.878233296942, 349.429615384616, 294.902726388523, 487.110769230771, 665.924920830822, 1491.74346153846, 1741.86997788486, 3383.71384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 204.557832114877, 276.143461538462, 284.40354251283, 357.255384615385, 312.289885135837, 536.403076923077, 724.878993767608, 1606.10153846154, 1730.65705924413, 3394.32653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 114.113779658051, 210.129615384616, 135.129921184705, 335.58076923077, 219.18553807185, 519.129615384616, 756.546612233916, 1727.63884615385, 1720.28155840159, 3387.92615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 108.988512250675, 268.538846153847, 156.847026182053, 381.896923076924, 211.153871936669, 506.534615384616, 754.121005933092, 1820.67153846154, 1719.56942396922, 3386.03538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 95.9400261196869, 244.029615384615, 154.99263425923, 366.291153846153, 228.614300059161, 475.566538461538, 786.406542120941, 1875.91115384615, 1720.40254531799, 3373.64615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 130.392863783025, 252.251538461537, 185.780373450854, 338.713461538459, 264.931426377587, 515.537692307693, 789.648917640374, 1918.02115384615, 1737.48612725472, 3380.58884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 120.689258254412, 236.785, 179.760369143098, 352.902307692308, 311.921315802316, 552.700384615384, 780.94394510401, 1967.47115384616, 1755.81393454546, 3394.65 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 121.047303016378, 256.866538461539, 217.469666654032, 372.291153846155, 310.025307918812, 587.196923076924, 784.710126096353, 1990.81692307692, 1755.67951061901, 3394.33076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 179.196900646703, 288.61576923077, 258.535203486878, 456.135, 418.994822141681, 693.48153846154, 748.31074763404, 2016.55615384615, 1742.70729942586, 3398.91192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 269.156684777017, 370.538076923078, 286.249249248863, 470.426538461541, 452.266616959509, 717.300000000002, 760.391391593829, 2023.545, 1739.0702024494, 3396.02076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 200.642155773368, 328.444230769231, 373.595281986558, 529.951153846155, 613.417454053424, 994.204230769232, 813.566645567811, 2069.20269230769, 1750.78321627533, 3434.23923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 281.968355958607, 407.195000000001, 374.333572437121, 538.088461538463, 616.521704931664, 1103.48038461539, 806.352982310237, 2109.77615384615, 1736.48293921071, 3422.04538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 290.709241176445, 384.574230769231, 557.560843550245, 860.647307692309, 648.102284809569, 1218.70076923077, 870.773843465772, 2175.84807692308, 1702.26530410112, 3419.03230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 520.390958460448, 792.75076923077, 569.366354440956, 976.094230769231, 699.452035480523, 1335.08538461538, 865.922598333219, 2162.79807692308, 1700.03189230361, 3465.42423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 344.368378977201, 624.51076923077, 475.20853799585, 894.661923076924, 638.026739729975, 1341.95769230769, 844.98593316721, 2018.79769230769, 1686.79493998949, 3435.58692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 271.569116786416, 642.99807692308, 413.358424789134, 903.551923076924, 584.299882867982, 1298.92653846154, 997.114219902846, 1982.54269230769, 1643.98472254782, 3467.30884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 296.362260619305, 624.619230769229, 455.182741452772, 925.987307692308, 663.406337716068, 1231.62538461538, 1234.46303851781, 1964.28115384615, 1620.35835052203, 3459.00769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 286.221399562271, 608.72076923077, 429.884893481787, 830.840384615384, 558.644002479631, 1054.00769230769, 1203.4762831329, 1860.09076923077, 1512.87037782239, 3387.31269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 278.3076577492, 537.774615384614, 413.161701283576, 727.513461538458, 434.53562113842, 975.756923076922, 1190.24381379957, 1773.67192307692, 1482.81637543784, 3336.00884615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 321.739311151845, 508.377307692308, 334.318142552179, 667.28653846154, 414.052865273728, 906.66576923077, 1182.94340276948, 1752.22961538462, 1473.55220530302, 3339.18576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 195.790825269843, 446.970384615386, 236.527196492529, 656.913846153847, 371.514139771909, 843.777692307692, 1160.91569190797, 1691.08307692308, 1444.42757800362, 3363.77423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 219.222406686416, 486.624230769232, 366.913045439086, 619.06576923077, 499.577844839176, 802.736923076924, 1229.25683713347, 1736.68923076923, 1434.06518011078, 3328.62692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 194.205408179468, 386.163076923077, 240.986589435053, 535.826538461538, 472.134249249089, 793.774999999999, 1105.06269331271, 1699.92346153846, 1320.62943790586, 3324.45653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 200.878855293816, 415.641923076922, 272.814135243139, 573.637307692307, 399.849827842712, 814.665384615385, 1005.37611253692, 1691.43961538462, 1220.49798787973, 3319.89230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 213.974102864376, 432.946153846153, 327.136058159055, 599.819615384614, 397.130575142967, 874.975769230768, 956.047553123798, 1679.005, 1183.76656738169, 3327.45115384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 219.526237183271, 424.709615384615, 262.130598118864, 592.896923076923, 345.983152768142, 802.35076923077, 932.404740554229, 1663.16, 1118.74239030908, 3304.48769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 156.795596430021, 396.260384615384, 236.618563871508, 594.436153846154, 251.10536449773, 719.656538461539, 907.149039613328, 1645.75923076923, 1073.46082407231, 3282.515 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 180.22964095671, 436.860769230771, 211.498214459457, 556.513461538462, 303.525241628079, 737.58576923077, 930.391753369184, 1647.33576923077, 1071.9194041893, 3285.52846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 178.419721912641, 360.110769230769, 221.44936230243, 501.081923076924, 542.975341179151, 770.103846153846, 998.506759918336, 1638.42884615385, 1092.82955341282, 3285.43730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 218.680381069301, 412.653846153845, 331.621393706507, 544.719615384614, 652.964868667996, 865.638846153846, 985.550014508571, 1654.61461538462, 1263.97141614693, 3401.89730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 234.553186766145, 343.273076923077, 452.093506505696, 544.263846153846, 555.769929707773, 812.849230769231, 931.617026617614, 1605.13961538462, 1390.48167576325, 3476.97576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 315.99075701112, 427.642692307693, 409.574725673048, 620.536923076924, 539.484395560739, 897.138461538462, 920.521764522791, 1632.45807692308, 1415.69199871702, 3470.75923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 189.16633074991, 398.294230769229, 270.16706522731, 545.938461538461, 536.510850864675, 874.426538461538, 899.799688842253, 1602.13384615385, 1452.17969125672, 3465.72769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 210.34330417055, 380.32576923077, 413.495096115464, 627.926538461539, 623.858568609782, 930.059615384617, 873.53900339851, 1588.46230769231, 1509.17382488545, 3484.63923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 343.562310090122, 457.237692307693, 454.584824876502, 608.620000000001, 555.639455958489, 869.215384615386, 834.372767556289, 1519.80346153846, 1500.70162408839, 3443.20153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 253.418850438435, 382.441538461539, 377.710624889558, 580.217692307694, 516.364343193685, 813.494615384617, 698.985190081914, 1430.99538461539, 1468.60444017012, 3465.18923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 256.506205648427, 415.258076923079, 310.20985636501, 591.985000000002, 471.003622109379, 829.831923076925, 657.242753651836, 1419.03038461538, 1447.00721584996, 3485.80538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 214.603120416414, 396.652692307694, 358.308154303183, 606.411923076924, 497.411125010753, 858.41730769231, 673.349048660843, 1423.70269230769, 1490.5688456411, 3533.51038461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 261.397159142057, 444.363461538462, 354.494825078428, 611.97076923077, 552.84924582218, 839.296923076923, 678.459473065721, 1413.28384615385, 1468.9128311757, 3558.35615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 262.248877334841, 424.679230769229, 466.398562172379, 632.707307692307, 511.441542341463, 811.346153846153, 660.757656916315, 1345.34846153846, 1481.86443319764, 3559.84807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 359.920200683217, 429.620384615384, 396.358879702959, 543.200769230769, 466.305101806169, 725.867692307692, 691.402991733031, 1319.12576923077, 1530.25542977957, 3541.56461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 229.740747816716, 345.20076923077, 293.15910507882, 488.618846153847, 322.182991369812, 668.869999999999, 719.192654967734, 1292.95346153846, 1551.45294848553, 3534.89730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 174.217010668172, 297.923076923078, 239.950595618861, 428.675384615385, 266.546600255651, 638.919615384614, 680.954184350618, 1256.58384615385, 1554.30570334073, 3533.57846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 161.669552732156, 295.596153846154, 242.695002466376, 478.153076923077, 536.817820035669, 726.570384615384, 681.412553447502, 1249.62961538462, 1591.40682708588, 3523.93346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 171.865821013417, 339.443846153847, 191.757968945632, 466.576923076923, 499.781252981898, 705.241923076924, 674.143155718884, 1240.73115384616, 1636.9229002166, 3505.09153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 135.356058748769, 308.129999999999, 506.433919371371, 511.955384615386, 486.539212356637, 685.516153846157, 706.513434580306, 1217.91230769231, 1656.73456280243, 3487.48807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 423.424182770205, 361.098846153848, 391.283360988506, 531.017692307694, 426.246500325268, 666.743461538462, 636.590927679499, 1166.22038461539, 1665.45146479552, 3467.13153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 163.050150586112, 393.766923076924, 203.258629243254, 478.054615384616, 286.55753971907, 604.994615384615, 589.641303024657, 1139.76384615385, 1666.10849590129, 3461.28230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 139.250978512237, 279.806153846156, 214.348696963258, 406.924615384615, 243.316704366016, 581.633461538462, 493.120668909595, 1140.30538461538, 1679.24286271957, 3451.58884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 146.092929459828, 282.583076923075, 183.702217949008, 383.819230769231, 263.356777844169, 583.097307692308, 426.617655586178, 1124.66461538461, 1691.48448494438, 3451.97653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 110.398404846335, 260.556153846156, 122.659283513317, 404.690000000001, 240.859476810413, 562.085769230771, 404.571634045767, 1125.53230769231, 1731.7928631411, 3488.92769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 97.1581552030584, 292.842307692307, 168.053706749225, 418.961923076925, 211.797391080396, 531.002692307694, 397.774892699569, 1121.95692307692, 1735.72470686875, 3492.00884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 166.177106300664, 293.907692307694, 203.076927612705, 392.043846153847, 249.916802680719, 554.976923076924, 393.147229992101, 1120.11230769231, 1755.26860943727, 3499.98038461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 142.272175801822, 278.11076923077, 138.518584297724, 351.209615384618, 242.135696939672, 553.147307692308, 391.372751974185, 1121.53038461538, 1777.7939925485, 3542.04153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 79.782045307104, 219.545769230772, 168.106316962257, 379.268846153847, 229.435404351304, 568.564615384616, 399.31571478468, 1117.995, 1780.11728056622, 3545.22230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 153.845121162109, 313.72423076923, 203.409884697411, 447.733846153846, 266.015194520623, 637.679615384616, 398.55812876398, 1132.38038461538, 1775.79669991342, 3538.03923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 160.170854066716, 335.332692307692, 179.90776582888, 451.781538461538, 284.138973063426, 657.478461538463, 413.605086778904, 1118.14423076923, 1788.34545466344, 3558.13076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 110.816112971688, 300.676923076923, 157.091645977264, 443.069615384616, 391.785014139132, 649.410000000001, 401.397674764642, 1074.84769230769, 1792.1299876665, 3551.33846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 121.734338812652, 316.793076923078, 247.544922483543, 468.629230769233, 371.135266480272, 617.815769230772, 414.486094208052, 1083.54961538462, 1797.00881487278, 3543.69230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 236.637478234925, 333.094230769232, 347.381604104412, 489.15307692308, 358.33463876962, 661.803076923078, 451.486628671923, 1068.80846153846, 1824.54905269001, 3569.58 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 173.650965285587, 335.236153846156, 236.690572637326, 416.079230769232, 327.399486318144, 695.18423076923, 447.82919168121, 1041.83461538461, 1812.50569954584, 3585.14692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 221.896121799228, 297.461538461538, 319.845157820996, 469.528461538462, 324.231822103591, 657.693846153845, 437.738334581112, 1012.91538461538, 1796.05221956156, 3565.43 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 193.044243892031, 337.689615384615, 230.434198383432, 512.013846153844, 274.938939323737, 607.27269230769, 401.712954564096, 999.846153846152, 1761.40627449761, 3554.24653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 130.853528892186, 345.776538461539, 151.084473190943, 426.870769230769, 244.954023370791, 555.778461538462, 357.279086871659, 958.210384615384, 1761.30726272719, 3565.91653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 111.465798820158, 288.578846153847, 198.525996157065, 393.893076923076, 227.542123186355, 511.608076923077, 424.76142937817, 951.909230769231, 1761.39802745643, 3560.12076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 133.148051969921, 277.090769230768, 193.275143687796, 358.926538461538, 190.236508852696, 452.97269230769, 407.747339846062, 924.866538461536, 1750.86173817791, 3562.53923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 143.347118308619, 239.460769230769, 133.355420735488, 324.683461538461, 139.369368019497, 425.686923076923, 403.988557501515, 899.581923076922, 1757.34210587747, 3559.46538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 72.5429511774809, 242.858461538462, 98.6054174303604, 316.148846153846, 141.655366211856, 454.403846153847, 400.787435946367, 896.947307692307, 1757.22539102114, 3547.36576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 80.4193537641692, 221.459615384615, 126.285694827856, 309.513076923078, 189.65936889065, 436.980000000001, 459.216518011009, 909.126923076923, 1746.88868238931, 3542.42961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 109.490926646214, 215.725384615385, 154.949016749182, 311.343461538462, 229.900601897027, 408.886153846155, 475.675373934303, 895.77346153846, 1733.54624821842, 3553.21807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 116.175878658839, 213.696923076923, 187.151852767909, 312.77230769231, 307.331481888105, 458.47653846154, 513.277116492118, 919.647692307693, 1761.61549953554, 3593.44961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 173.685154804274, 245.800769230771, 208.641464605231, 298.566153846155, 345.498704075939, 476.453076923077, 516.674138042391, 948.485384615385, 1785.78442449512, 3617.01576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 110.505914556644, 201.98, 216.100263658757, 341.21576923077, 254.661718229981, 459.780384615382, 462.913759598749, 965.725384615384, 1720.89706711484, 3600.07269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 209.658387377032, 264.948461538462, 250.426108991483, 351.826153846153, 234.857455309844, 432.881153846152, 478.618577643394, 960.525769230769, 1705.0453542976, 3594.94961538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 147.293109587128, 233.730384615383, 152.691327068698, 304.104999999997, 158.757345211054, 407.912307692308, 436.739482666199, 973.676538461537, 1694.5511222339, 3576.81192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 111.527414426299, 225.366153846155, 140.276476661684, 296.503846153846, 134.592713738669, 410.576538461539, 413.997892077319, 976.297307692307, 1707.71987003904, 3573.47307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 115.134612365101, 217.217307692307, 128.288656308285, 315.33576923077, 171.701577253634, 457.95923076923, 426.940025204228, 1035.10423076923, 1711.80173738846, 3566.75307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 103.89455377227, 229.523461538462, 86.1301583847668, 286.700769230771, 155.058898588198, 445.549230769232, 502.904640094387, 1051.92730769231, 1706.96378812836, 3552.31846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 62.6732357758502, 194.968846153846, 169.777822852285, 323.407307692308, 174.865170678617, 438.352692307691, 609.056062249167, 1073.81230769231, 1692.37521463374, 3538.91884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 126.226419177848, 242.362307692308, 134.208561513558, 315.346538461539, 171.8642664484, 435.824615384614, 601.53207211292, 1051.40730769231, 1691.97735865307, 3536.95115384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 116.332252500527, 228.949615384616, 151.61520177283, 320.883846153845, 216.712513398601, 450.443461538461, 595.732296430072, 1058.01538461538, 1694.88797926017, 3532.40384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 108.00006873787, 222.14076923077, 124.600958934452, 299.57923076923, 252.947814623126, 455.498846153846, 588.983805939062, 1045.96230769231, 1705.27926681332, 3519.33076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 88.1454346625298, 193.630384615384, 179.479941256354, 314.73576923077, 288.436353759104, 468.874615384616, 577.560518750933, 1034.99961538461, 1699.00006968117, 3519.50615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 178.955116104141, 260.529615384614, 233.280318444438, 352.888461538461, 311.854320044572, 502.352307692307, 546.880965749051, 1031.41115384615, 1691.30578616223, 3512.69461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 141.766908305363, 227.522307692307, 194.201234208627, 327.821923076922, 294.224773517694, 499.016538461539, 568.082992922283, 1047.99653846154, 1680.44635390079, 3515.24230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 101.07531480801, 232.096538461537, 180.902576099785, 320.866538461537, 282.456897813563, 503.937692307692, 571.564030999555, 1047.76269230769, 1671.96139619794, 3530.38807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-08-03 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-03 00:00:00', 146.4704702383[...];

[ Date: 2025-08-03 14:51:49 - 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 ('400' = 0 OR ar.patternlengthbars <= '400') 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-03 14:16: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 ('400' = 0 OR ar.patternlengthbars <= '400') 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-03 14:36:55 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.145 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a.*, rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = '627' AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON sg.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN 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 ('400' = 0 OR ar.patternlengthbars <= '400') 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-03 14:41:53 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.145 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a.*, rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = '627' AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON sg.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN 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 ('400' = 0 OR ar.patternlengthbars <= '400') 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;