select cleanuppatternresultsrelevance ();

[ Date: 2025-04-27 15:00:07 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2025-04-27 15:02:04 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

[ Date: 2025-04-27 15:17:04 - 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-04-27 15:01: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-04-27 15:03:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

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

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

[ Date: 2025-04-27 15:11: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-04-27 15:16:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

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

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

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

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

[ Date: 2025-04-27 15: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-04-27 15:31: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-04-27 15:33:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2025-04-27 15:35:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2025-04-27 15:41: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-04-27 15:46: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-04-27 15:48:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2025-04-27 15:50:14 - 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, 0, 915, '2025-04-27 00:00:00', 93.3336246903894, 258.824615384617, 100.091074946001, 333.679615384616, 209.171747002316, 517.150000000001, 1274.50186720013, 1343.51384615385, 2562.41378198343, 4254.49884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 930, '2025-04-27 00:00:00', 89.3740427159051, 248.49923076923, 102.559194870385, 329.427307692308, 316.909158038412, 628.713846153847, 1455.78453657654, 1378.16923076923, 2561.85669032962, 4250.63884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 945, '2025-04-27 00:00:00', 94.0881855683186, 224.513461538461, 189.166147395922, 384.113846153845, 307.109959595031, 633.407692307692, 1760.2178433641, 1451.79576923077, 2557.84420552937, 4235.44807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 960, '2025-04-27 00:00:00', 146.630011479444, 306.112307692307, 311.25830474778, 506.902307692307, 351.245716400708, 690.845384615386, 1844.16909432247, 1488.14307692308, 2552.12108200423, 4249.82230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 975, '2025-04-27 00:00:00', 223.763362386733, 362.561153846154, 230.786733067902, 473.361923076924, 322.663434642879, 666.283461538462, 1843.09905085859, 1460.51961538461, 2571.97417601658, 4207.55807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 990, '2025-04-27 00:00:00', 162.37140263795, 321.561153846155, 241.660009986059, 468.027692307694, 430.819521788236, 669.334615384617, 1847.01618549203, 1469.82153846154, 2586.05015196642, 4213.16153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1005, '2025-04-27 00:00:00', 183.570003155788, 320.568846153848, 228.34917088226, 456.511153846156, 656.648183186869, 680.851153846156, 1854.29641797405, 1463.18076923077, 2570.04797542602, 4286.22076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1020, '2025-04-27 00:00:00', 124.571624602691, 322.698076923078, 388.407059528849, 468.360384615384, 646.818886487974, 672.568461538461, 1851.61309660594, 1445.77884615385, 2524.19689612872, 4365.65538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1035, '2025-04-27 00:00:00', 383.732529276079, 339.163846153844, 646.626581817813, 496.675769230768, 637.115481100443, 663.924615384616, 1846.20522461199, 1440.19615384615, 2473.79145121778, 4473.94307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1050, '2025-04-27 00:00:00', 428.725027934441, 350.585769230769, 426.935778914745, 470.938461538461, 577.189971933385, 616.447307692308, 1648.43638479677, 1409.01461538461, 2362.79203046435, 4551.48461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1065, '2025-04-27 00:00:00', 244.437696095782, 314.063846153846, 257.521881606202, 441.365, 908.025397953161, 681.799999999999, 1575.44459511906, 1421.52538461538, 2328.35631858016, 4581.82192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1080, '2025-04-27 00:00:00', 157.251045319747, 311.396923076921, 393.020425732066, 445.551153846151, 862.1941046203, 646.664999999999, 1533.84102802991, 1460.83038461538, 2299.15031571448, 4642.725 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1095, '2025-04-27 00:00:00', 245.480589526874, 293.982307692307, 665.173029237217, 461.896153846154, 765.230229604442, 649.957307692307, 1391.77668434647, 1419.86230769231, 2254.80146102043, 4624.23961538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1110, '2025-04-27 00:00:00', 548.227134493049, 347.542307692307, 582.008770069794, 429.196923076923, 826.023721058628, 692.076538461538, 1290.35499208241, 1408.66, 2225.16867420604, 4612.38961538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1125, '2025-04-27 00:00:00', 240.930088631538, 261.81, 406.889175102435, 441.09346153846, 776.296812096626, 713.859230769228, 1050.50760708709, 1370.83961538461, 2212.41462842795, 4614.975 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1140, '2025-04-27 00:00:00', 400.420548104308, 355.38192307692, 523.908446048912, 504.184230769229, 854.397522865989, 763.446538461537, 1042.56172450194, 1390.77730769231, 2188.48978489358, 4619.73653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1155, '2025-04-27 00:00:00', 270.725604407576, 316.945384615384, 565.834449181574, 523.476153846152, 658.69548092014, 708.756153846153, 908.49251526056, 1382.70730769231, 2193.34648260587, 4600.38346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1170, '2025-04-27 00:00:00', 360.93293645155, 380.85346153846, 461.18321977763, 518.227307692307, 451.605942135227, 690.009615384613, 850.357974516253, 1360.71076923077, 2193.97510395916, 4593.11615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1185, '2025-04-27 00:00:00', 294.077711487705, 337.975384615386, 325.620513505426, 433.463461538462, 509.022221917214, 665.881538461538, 857.937710354671, 1404.78384615385, 2186.7107540668, 4577.48923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1200, '2025-04-27 00:00:00', 216.807629126693, 320.153461538462, 295.597591788877, 478.939230769229, 425.815197964309, 634.685769230769, 810.635507292035, 1409.02115384615, 2164.75902473644, 4593.13461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1215, '2025-04-27 00:00:00', 239.185922612513, 356.049999999998, 362.995206376697, 483.612692307693, 412.839382954381, 594.266923076924, 885.39863671256, 1470.44730769231, 2161.47760435228, 4634.15269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1230, '2025-04-27 00:00:00', 275.611852926986, 329.664615384616, 283.804725019484, 417.14076923077, 405.432930635691, 582.720384615385, 888.335364006962, 1484.82423076923, 2218.98270541356, 4706.41730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1245, '2025-04-27 00:00:00', 191.097929552844, 287.95923076923, 256.778785455197, 417.099615384616, 514.679096579605, 665.260000000002, 1084.47241396479, 1560.20115384615, 2270.59039652496, 4756.34923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1260, '2025-04-27 00:00:00', 184.445285614421, 316.155769230769, 276.614325139923, 415.646153846153, 569.165581983363, 687.342307692309, 1056.10718225377, 1572.2, 2286.94600853618, 4788.80653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1275, '2025-04-27 00:00:00', 220.308355937762, 288.94, 361.910767253688, 468.446923076926, 501.761327278371, 685.771923076925, 1112.73331440909, 1711.01038461539, 2340.59774152531, 4828.37576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1290, '2025-04-27 00:00:00', 265.808946151467, 331.503076923079, 385.907293196375, 463.853076923078, 431.162763755619, 664.415769230769, 1220.05540443274, 1795.91846153846, 2409.00469479662, 4868.93192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1305, '2025-04-27 00:00:00', 218.987259452724, 289.078846153849, 275.534369387642, 437.714615384617, 432.465633087586, 647.994615384617, 1251.37403527464, 1802.33653846154, 2431.97304788396, 4898.655 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1320, '2025-04-27 00:00:00', 218.906729635109, 324.063461538464, 286.670468789246, 471.650384615385, 400.814753666157, 652.712692307694, 1283.53927328252, 1842.22884615385, 2561.50692716687, 5004.50961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1335, '2025-04-27 00:00:00', 199.782488347858, 324.497692307693, 325.479496252246, 470.853846153847, 346.829332889558, 653.213846153847, 1315.54678676189, 1852.51346153846, 2592.29330363558, 5073.14461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1350, '2025-04-27 00:00:00', 306.299184248645, 314.330769230769, 328.559185506146, 424.392692307694, 505.376556569302, 683.504615384616, 1354.35270813705, 1939.72307692308, 2583.0707207376, 5090.95961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1365, '2025-04-27 00:00:00', 186.811350732806, 261.348846153845, 241.889484119058, 419.110769230768, 568.313954809784, 734.71346153846, 1375.99171690312, 1976.075, 2588.26390252629, 5095.25384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1380, '2025-04-27 00:00:00', 191.80692977174, 327.662692307692, 414.049341878661, 499.393076923078, 557.447309336186, 752.723076923078, 1350.19612581449, 1994.94269230769, 2607.26223976731, 5162.62269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1395, '2025-04-27 00:00:00', 320.173642841841, 342.711153846152, 455.172370471467, 562.683846153845, 652.559694562526, 838.626538461538, 1288.59104830568, 2006.40153846154, 2611.51180812568, 5180.44038461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1410, '2025-04-27 00:00:00', 370.394713757965, 416.290384615385, 388.18203931839, 512.534230769232, 615.964532329206, 855.733461538462, 1176.8383265903, 2106.46038461539, 2621.05666708269, 5193.93884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 0, 1425, '2025-04-27 00:00:00', 178.122820987266, 273.777307692309, 413.287410898928, 576.386538461539, 690.302290663691, 896.636538461539, 1112.54433661343, 2137.18884615385, 2600.02899074041, 5208.24884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 0 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, 1, 0, '2025-04-27 00:00:00', 390.154028899435, 460.427692307693, 438.826194051113, 633.194230769231, 675.381879852714, 938.70576923077, 1280.25230915623, 2201.23961538462, 2595.39180481134, 5206.34461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 15, '2025-04-27 00:00:00', 259.397738215927, 386.346538461539, 642.918205983768, 663.834230769231, 705.656283593779, 1016.33076923077, 1362.56255184978, 2184.29076923077, 2646.32034488219, 5180.16576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 30, '2025-04-27 00:00:00', 535.952674054199, 480.934615384615, 540.605441054606, 658.175384615384, 756.168313812166, 1045.02153846154, 1324.9978085799, 2147.70153846154, 2650.43414459887, 5198.40653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 45, '2025-04-27 00:00:00', 370.949128936319, 502.018846153847, 525.355314051209, 770.454615384615, 713.785331762665, 1041.39653846154, 1307.77076978733, 2128.69692307692, 2664.05461104119, 5211.62461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 60, '2025-04-27 00:00:00', 322.356710767149, 557.596153846153, 504.269058604478, 784.164615384616, 553.953477381799, 984.510769230769, 1219.67366440025, 2058.75653846154, 2680.58069174079, 5226.11846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 75, '2025-04-27 00:00:00', 419.868096535822, 539.466153846154, 472.90560118631, 677.195769230769, 526.811417674442, 889.851923076923, 1182.18663066819, 1965.58115384615, 2695.64569489712, 5228.59576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 90, '2025-04-27 00:00:00', 445.473489594888, 469.330384615383, 476.412486319771, 618.27423076923, 628.901207555015, 991.098076923076, 1172.80792405583, 1952.99192307692, 2678.30362879644, 5227.84192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 105, '2025-04-27 00:00:00', 276.112334790363, 403.940769230769, 331.830462952673, 584.52923076923, 656.660808414699, 983.670384615384, 1180.05120484553, 1967.98576923077, 2653.69127194407, 5226.97192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 120, '2025-04-27 00:00:00', 262.76163581379, 462.523461538461, 493.575141783513, 768.848846153845, 628.78656478368, 978.407307692308, 1176.33205321182, 2000.12846153846, 2639.89282398547, 5209.865 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 135, '2025-04-27 00:00:00', 445.456149324056, 543.511153846154, 569.788781318535, 725.907307692308, 568.878111722065, 955.912692307693, 1141.76160046752, 1947.91692307692, 2615.22031832052, 5154.52269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 150, '2025-04-27 00:00:00', 403.246018356229, 482.488076923077, 455.178815298068, 627.488076923077, 501.087511917369, 1009.52653846154, 1091.86992635288, 1882.80461538462, 2615.93724303367, 5136.17884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 165, '2025-04-27 00:00:00', 292.217375842288, 441.718076923076, 362.906130601925, 661.402692307692, 585.924289223052, 1144.44846153846, 1061.62399929549, 1830.01192307692, 2606.82561525112, 5125.55423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 180, '2025-04-27 00:00:00', 280.320434174068, 490.023461538462, 381.391294745758, 757.360384615384, 881.715903562959, 1156.49961538462, 1072.71580671497, 1753.85807692308, 2605.65105511339, 5084.86153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 195, '2025-04-27 00:00:00', 264.654712736309, 546.231538461539, 424.1662310956, 821.855384615385, 852.127526943094, 1139.59307692308, 909.891278951248, 1681.89653846154, 2596.31695354204, 5064.46538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 210, '2025-04-27 00:00:00', 356.257876529824, 565.968461538462, 634.287720743149, 802.931538461538, 808.08599567135, 1108.39807692308, 864.371966264881, 1606.04384615385, 2613.47098751141, 5006.59038461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 225, '2025-04-27 00:00:00', 412.411745560747, 521.782692307691, 577.740171710033, 757.296538461538, 745.121678887726, 944.082692307692, 810.23256568251, 1531.01730769231, 2744.24293078146, 5077.12 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 240, '2025-04-27 00:00:00', 561.912913204939, 560.882307692308, 716.025944470322, 740.368846153847, 692.340633914684, 845.85576923077, 799.268070329444, 1497.76192307693, 2821.14513619976, 5079.69346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 255, '2025-04-27 00:00:00', 301.078297428019, 427.893076923076, 351.927212497349, 566.518076923076, 429.461698672259, 719.077692307692, 656.489885388483, 1383.33576923077, 2712.46937701018, 5020.025 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 270, '2025-04-27 00:00:00', 235.10109742374, 405.725384615384, 230.257003304169, 511.341153846154, 386.639245706064, 714.771923076923, 592.974378799079, 1326.65192307693, 2702.65368311119, 5032.64769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 285, '2025-04-27 00:00:00', 157.886398728278, 356.31076923077, 282.710561808634, 495.146923076924, 394.790079978444, 737.795769230769, 962.65800461111, 1520.18461538462, 2708.78600356362, 5025.64692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 300, '2025-04-27 00:00:00', 264.344949502321, 386.540769230771, 330.4787183403, 557.660384615385, 407.904748543657, 789.887307692307, 1496.89438183378, 1681.38846153846, 2712.02860736129, 5021.725 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 315, '2025-04-27 00:00:00', 158.278201278633, 364.459999999999, 281.740326242772, 533.720769230768, 342.122709158344, 738.415384615384, 1500.13313381267, 1647.86884615385, 2702.50548256198, 5038.12153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 330, '2025-04-27 00:00:00', 197.761447006234, 378.115, 253.176404870961, 508.579230769229, 332.175335146272, 726.586538461538, 1574.55904996244, 1693.30884615385, 2721.73359449058, 5024.56884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 345, '2025-04-27 00:00:00', 195.290457647459, 364.438076923074, 236.153347390728, 530.039615384615, 375.048452776233, 735.375384615384, 1580.94707902846, 1692.00615384615, 2735.86723154202, 5010.85576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 360, '2025-04-27 00:00:00', 146.294600483459, 335.938846153846, 235.404775431596, 479.669999999999, 371.933925974038, 655.667692307691, 1591.14342049251, 1683.27384615385, 2739.17230001768, 5006.62192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 375, '2025-04-27 00:00:00', 184.539567419522, 340.54923076923, 318.206272376654, 499.239615384613, 338.336624067488, 639.084230769229, 1552.66066053102, 1695.73384615385, 2753.10782489633, 4992.53576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 390, '2025-04-27 00:00:00', 242.824486190209, 344.238461538461, 236.330884264805, 435.955769230769, 267.728091291549, 606.571153846155, 1517.30352749343, 1689.11, 2762.75427116573, 4982.06269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 405, '2025-04-27 00:00:00', 147.076403282834, 271.051153846153, 190.843206461383, 412.037307692305, 269.462003832709, 588.708461538462, 1444.6156836231, 1638.74538461538, 2764.97526518134, 4990.92384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 420, '2025-04-27 00:00:00', 168.389483892369, 324.28846153846, 208.798458027021, 440.622307692309, 322.274772676027, 622.72923076923, 1430.02116678606, 1610.68807692308, 2762.83080235396, 4981.67038461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 435, '2025-04-27 00:00:00', 171.476485057101, 335.35653846154, 224.084678160872, 441.107692307694, 270.038736977608, 628.13730769231, 1417.233158799, 1602.75923076923, 2758.53352241727, 4985.42961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 450, '2025-04-27 00:00:00', 147.046407048932, 293.455, 199.888468577238, 410.826923076923, 212.734218710721, 594.097692307694, 1373.89798823729, 1581.72230769231, 2718.44169829714, 4961.69384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 465, '2025-04-27 00:00:00', 188.312561571282, 294.221538461539, 193.941146390816, 440.77076923077, 805.416578702837, 818.314230769232, 1376.47881772386, 1567.38769230769, 2712.96893294594, 4958.21461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 480, '2025-04-27 00:00:00', 132.393340525641, 313.613461538461, 196.078009832428, 425.620384615385, 1408.33371553636, 951.837307692309, 1381.93584075161, 1555.44461538461, 2683.15930457649, 4950.37923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 495, '2025-04-27 00:00:00', 154.391369475809, 286.973846153849, 764.970145079883, 615.773461538463, 1343.95149676015, 901.430384615386, 1307.90546332235, 1557.32730769231, 2681.32803843801, 4947.64461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 510, '2025-04-27 00:00:00', 746.167241360395, 517.220769230769, 1333.66215950217, 765.370000000001, 1335.78115581028, 979.364615384616, 1314.33006684371, 1602.72576923077, 2683.17765381574, 4944.47192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 525, '2025-04-27 00:00:00', 683.805875349588, 461.158846153847, 674.260868824865, 560.092692307694, 740.650956664576, 830.181923076923, 806.124556064003, 1424.68576923077, 2693.82744977216, 4949.195 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 540, '2025-04-27 00:00:00', 271.237995708282, 370.629615384615, 427.755745621257, 570.930000000001, 672.635939267295, 831.225, 720.759612478284, 1377.58961538461, 2663.96470824567, 4931.08230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 555, '2025-04-27 00:00:00', 333.736258971983, 414.236153846155, 444.547505416287, 588.380384615384, 546.849465315498, 846.859615384616, 698.323969730273, 1378.57038461538, 2659.5080914248, 4953.805 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 570, '2025-04-27 00:00:00', 322.41247180973, 406.347692307691, 465.467498477192, 575.008846153845, 422.85964633852, 788.671538461537, 751.741629371422, 1397.375, 2685.42033242871, 4991.83153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 585, '2025-04-27 00:00:00', 257.484182535846, 344.808076923076, 243.961539597158, 520.718846153847, 300.175014202611, 669.233461538461, 771.93546454251, 1382.34230769231, 2686.95312300193, 4987.40461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 600, '2025-04-27 00:00:00', 179.88268948914, 398.134615384616, 224.331761892617, 533.954615384614, 292.272823758635, 652.950384615383, 785.358773497526, 1354.75153846154, 2685.63898435733, 4986.97961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 615, '2025-04-27 00:00:00', 143.588462718978, 329.544999999999, 168.609403968506, 424.321153846153, 309.65774547145, 628.992307692308, 872.600929893279, 1374.01115384615, 2687.77990034315, 4975.20615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 630, '2025-04-27 00:00:00', 164.504555056879, 320.902307692309, 229.511443621849, 431.964230769232, 361.274205599274, 685.439230769231, 877.476912835975, 1406.50807692308, 2688.88709814969, 4980.93038461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 645, '2025-04-27 00:00:00', 170.686069096273, 301.316538461539, 267.585305415789, 484.567692307694, 390.389883698533, 680.263076923077, 867.105844846833, 1402.35653846154, 2682.95390751004, 4973.48923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 660, '2025-04-27 00:00:00', 182.558336055586, 372.999230769233, 317.742059381264, 534.049615384617, 383.046286665202, 655.710000000001, 915.909192270467, 1442.61846153846, 2669.02901383155, 4971.87884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 675, '2025-04-27 00:00:00', 248.022367941654, 393.879230769232, 305.0394774121, 499.769615384615, 294.940662660502, 638.631153846154, 896.0412714177, 1475.14961538461, 2634.28173307345, 4940.62269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 690, '2025-04-27 00:00:00', 200.454336685824, 329.708076923076, 217.415655875666, 435.649615384614, 556.690770410701, 726.977307692306, 859.032930143051, 1498.27307692307, 2635.0997604198, 4955.37730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 705, '2025-04-27 00:00:00', 141.70504921681, 309.44846153846, 187.091277302325, 448.228846153846, 547.918358380009, 719.405384615384, 850.973465308183, 1549.85115384615, 2654.18648503483, 4980.46846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 720, '2025-04-27 00:00:00', 129.811827966485, 324.940000000001, 498.683671322658, 559.349615384614, 511.269299479396, 713.706923076923, 816.150524554425, 1587.4123076923, 2659.56667917753, 4986.31923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 735, '2025-04-27 00:00:00', 389.036562875719, 417.433076923077, 403.981521562368, 517.630384615386, 446.526090285888, 696.285, 764.968585390579, 1589.02230769231, 2680.39595892352, 5007.94846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 750, '2025-04-27 00:00:00', 180.815449656443, 316.847692307694, 264.217708519961, 451.323461538463, 372.403745300716, 648.525, 707.124846197725, 1595.93307692308, 2716.21942791546, 5026.13423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 765, '2025-04-27 00:00:00', 220.9625946319, 341.912307692308, 238.07064627252, 462.723846153845, 386.904066169657, 713.438846153847, 814.041404083263, 1942.35461538461, 2720.06435119613, 5020.26 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 780, '2025-04-27 00:00:00', 191.938758154382, 364.405384615385, 287.515070764057, 514.002692307693, 387.19848502743, 714.103461538463, 1034.88717869348, 2216.16807692308, 2727.76583269484, 5021.87576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 795, '2025-04-27 00:00:00', 170.098423821215, 345.097692307693, 250.027620936937, 502.980769230771, 547.2030291088, 716.434615384615, 1142.64326347909, 2467.78307692308, 2731.20809752689, 5008.01730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 810, '2025-04-27 00:00:00', 196.821609104439, 323.607692307693, 248.130913288498, 431.58423076923, 568.15629868942, 700.082692307691, 1287.58240934265, 2707.52615384615, 2745.84034036428, 5011.75961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 825, '2025-04-27 00:00:00', 192.132244029589, 317.189615384615, 537.284625033926, 517.794615384614, 569.617545673073, 721.711153846153, 1279.99784884681, 2850.26269230769, 2746.0925955764, 5012.08653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 840, '2025-04-27 00:00:00', 543.907585937171, 444.439999999998, 575.039300451317, 582.52346153846, 666.731988623731, 831.806923076922, 1322.80554172556, 2996.04038461538, 2746.0925955764, 5012.08653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 855, '2025-04-27 00:00:00', 275.220776238613, 359.345769230769, 343.580531872581, 507.074615384615, 564.908306308338, 899.238076923077, 1332.02233099651, 3019.86576923077, 2713.245188336, 4979.03730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 870, '2025-04-27 00:00:00', 256.676060890885, 346.087692307691, 429.921754815204, 573.62923076923, 538.436770200695, 932.441923076922, 1327.70427586574, 3020.16807692308, 2713.15039355056, 4978.90346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 885, '2025-04-27 00:00:00', 339.476515805416, 400.139230769231, 408.198106429295, 696.112692307695, 416.383751163979, 936.005769230769, 1292.36607425058, 3034.17461538462, 2709.15007061366, 4975.755 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 00:00:00' and dayofweek = 1 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, 1, 900, '2025-04-27 00:00:00', 259.177085641045, 527.775769230769, 316.186042007163, 686.731923076922, 364.961657767162, 923.97192307692, 1271.41500857957, 3016.56423076923, 2706.65814899859, 4955.43730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 247.595807957555, 440.193076923075, 280.530964682771, 621.274615384614, 328.698950369717, 865.013076923076, 1426.12013096233, 3035.85, 2695.09125859304, 4940.62615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 230.051394266251, 436.120384615384, 311.902543842439, 633.00923076923, 325.106336487003, 898.67, 1428.45768139578, 3034.36115384615, 2699.68175844054, 4946.02384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 222.692329926636, 446.888076923077, 248.520926435707, 620.232692307692, 653.602896643262, 1408.27269230769, 1537.22373075439, 3104.34230769231, 2699.70066263403, 4947.39884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 165.47005452347, 435.690000000001, 263.588020698093, 664.38653846154, 963.031608668249, 1675.04307692308, 1524.82971748525, 3101.50692307692, 2651.47624377109, 4971.92769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 266.47583703189, 549.995384615385, 655.166967781144, 1245.82346153846, 1107.22785121019, 1976.62346153846, 1538.59917487449, 3128.45730769231, 2613.31571454953, 4974.44346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 639.876301936915, 1060.12269230769, 935.954676405617, 1465.96153846154, 1294.19313112552, 2137.07730769231, 1609.8597368297, 3133.88576923077, 2526.29000242262, 4968.74730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 580.780600750539, 903.271923076923, 846.529563463949, 1352.05230769231, 1091.00866380344, 1897.31692307692, 1537.5083500942, 2807.50423076923, 2178.74196199931, 4720.32615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 501.811271431802, 857.710000000001, 766.457505195268, 1282.42692307692, 876.074484446737, 1689.89884615385, 1435.27516499193, 2569.79115384615, 2047.88299230074, 4665.36115384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 653.023911526511, 890.44423076923, 659.18411849346, 1155.155, 796.099715289389, 1424.81961538461, 1332.91899679255, 2424.77769230769, 1952.6649859516, 4594.58576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 389.013136283835, 735.805769230771, 513.441978439029, 966.66076923077, 585.881355519909, 1208.08461538462, 1295.63794139549, 2290.67346153846, 1994.45903467786, 4516.00807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 326.760339049185, 634.106538461537, 482.729103103944, 905.106538461535, 640.95410797966, 1230.92, 1264.17716362225, 2247.6, 2000.95660425507, 4574.35 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 407.768147516924, 651.154230769229, 405.735519492498, 818.345384615385, 619.027813552462, 1118.39653846154, 1392.36407686081, 2293.57730769231, 2005.1407337156, 4585.42846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 284.297671786783, 557.680769230768, 516.463894213781, 872.752307692308, 966.096155083875, 1145.79961538462, 1449.1452926817, 2304.91153846154, 1995.7111273993, 4616.31576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 378.095579973961, 642.729615384617, 468.98460886276, 803.376923076923, 957.169864979365, 1166.23615384615, 1446.55221716955, 2260.61692307692, 1986.49316725967, 4612.31423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 409.589925523641, 570.48769230769, 927.830067455489, 878.942307692307, 1131.84016989761, 1234.19461538461, 1415.25808875223, 2259.94884615385, 1943.99911142782, 4639.28192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 732.382480041361, 624.286538461541, 710.858307935823, 860.42576923077, 948.43290232394, 1162.53884615385, 1295.93257163581, 2286.10115384616, 1914.11382882435, 4609.00615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 397.122368797752, 600.443461538461, 926.02925408791, 935.678846153846, 958.692867525601, 1195.59269230769, 1355.94978995996, 2336.16269230769, 1918.19980012723, 4617.98192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 697.096511025883, 665.092692307692, 731.714784495875, 870.145384615383, 892.088869689217, 1189.88923076923, 1316.62292341073, 2261.85884615385, 1909.05081324149, 4630.865 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 454.058541267362, 612.775384615385, 502.607194910237, 860.516538461539, 759.915239743525, 1163.06769230769, 1280.79341076669, 2224.11923076923, 1902.26702310334, 4665.70769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 323.870462886724, 595.397692307694, 545.559700486078, 832.482307692309, 667.308737069915, 1111.09461538462, 1231.42830795038, 2118.19846153846, 1815.87031877889, 4649.56692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 381.152485460165, 540.162692307691, 478.428716460616, 744.843076923078, 615.61651471725, 1028.98384615385, 1199.15815078335, 2086.71692307692, 1722.84174092926, 4645.01807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 250.489657640021, 484.563846153847, 335.758187005974, 687.351538461541, 507.113117993791, 927.955769230772, 1083.01027892991, 2008.47961538462, 1608.4859781242, 4584.57307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 284.633171193003, 475.929230769232, 351.875634024951, 697.29730769231, 428.978345984791, 888.389615384618, 1050.2052487721, 1974.16269230769, 1613.3799262962, 4580.69653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 265.91561561923, 530.183076923078, 330.703072473457, 671.069230769232, 524.379181516727, 913.131923076925, 1026.41106773823, 1965.92346153846, 1593.96372548668, 4583.81923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 255.040932243314, 480.323461538461, 303.820035661803, 642.838461538464, 489.216584796077, 975.436538461541, 1030.14315020845, 1976.75423076923, 1611.73553554651, 4622.48076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 249.481834292598, 437.435000000001, 419.153364774573, 642.004615384616, 487.431092915154, 937.242692307694, 966.287719793326, 1954.61923076923, 1616.83240269551, 4643.48692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 314.920605970164, 448.866153846153, 366.807019890044, 650.813846153846, 474.56856723182, 947.567307692309, 992.953503773776, 1920.31615384615, 1630.32354223099, 4650.92615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 242.898610882432, 481.056153846154, 368.43212598252, 684.560000000001, 597.300916082825, 1042.45423076923, 999.156487098686, 1904.65076923077, 1663.08371690405, 4666.27923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 263.010699268768, 488.564615384617, 353.824865340948, 689.40153846154, 738.732798845741, 1073.83230769231, 1062.53168344297, 1901.57807692308, 1659.82848484053, 4662.49 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 244.193002893521, 484.036923076924, 456.790982478185, 747.82576923077, 658.169014086341, 1007.67076923077, 1031.93425226797, 1829.58038461539, 1676.8920495406, 4633.79730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 346.437867643513, 545.60423076923, 634.43154251782, 760.401538461539, 751.592960552862, 1048.76615384615, 1004.69704246772, 1787.39923076923, 1673.9563633155, 4592.43269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 619.355909948764, 530.827307692308, 621.830688971252, 645.80230769231, 748.720867700681, 1026.22769230769, 985.354541411054, 1741.47076923077, 1632.95574727868, 4546.97230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 261.236950438601, 408.277692307693, 473.471957759013, 700.458076923077, 605.352945977672, 996.939615384616, 912.278360861422, 1691.29, 1640.51479792393, 4539.60076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 355.741996970579, 508.816153846153, 422.988108816495, 659.488076923076, 668.14500821039, 1003.17730769231, 969.961610412494, 1705.455, 1664.82003761386, 4549.30615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 277.706725511757, 401.687692307692, 422.105475267098, 668.322307692308, 609.566342804079, 912.823461538463, 1074.17476723848, 1730.71038461539, 1677.17481298357, 4555.20230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 370.645075980327, 485.972692307694, 588.703438040033, 710.468076923078, 714.412588849482, 962.668846153848, 1152.98633221761, 1709.72384615385, 1663.55338102809, 4541.105 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 514.950923479272, 500.901923076924, 528.332685004878, 614.402692307694, 755.435191131982, 934.496153846155, 1149.19141619254, 1705.54884615385, 1640.30459680132, 4522.61653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 287.481995817801, 387.000769230769, 499.840256063415, 632.188461538463, 617.656137257494, 869.140384615385, 1056.04247644088, 1684.06076923077, 1636.7221287323, 4517.565 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 324.526713554702, 426.978846153849, 466.504233288237, 630.209615384617, 523.999790906007, 779.978461538462, 1025.81040898719, 1653.88769230769, 1587.7306107316, 4495.55692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 299.731398304189, 460.004230769231, 312.725933760144, 584.183076923077, 454.183054644437, 729.206923076922, 981.974496217777, 1634.65307692308, 1641.51467895534, 4558.84461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 221.882343663343, 356.62153846154, 378.768053098664, 486.821923076926, 635.246831881544, 780.746538461538, 956.959705643147, 1645.45615384615, 1630.59127422799, 4547.28269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 287.209162819603, 344.886538461541, 338.22951294873, 470.78153846154, 519.998670992975, 806.682307692306, 952.455575451887, 1664.24576923077, 1626.55231240749, 4530.66692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 225.726646443466, 334.178846153845, 480.201471020876, 588.058846153843, 480.050841738824, 801.523076923075, 942.479505482951, 1651.46923076923, 1629.84440467728, 4527.74461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 385.192315559584, 486.163076923075, 399.226545354698, 666.260384615384, 535.31490963918, 878.594999999999, 931.98867746977, 1655.09961538461, 1623.9011868847, 4532.83153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 308.794175243241, 468.261923076921, 334.15354856413, 595.744999999998, 528.828539277001, 827.185384615383, 931.297972158545, 1632.25115384615, 1621.82569869377, 4534.04653846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 207.799918932761, 403.502692307691, 386.487435749412, 602.271923076922, 565.393945662123, 864.560769230767, 878.272763956534, 1607.73038461538, 1617.87034068636, 4537.33384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 304.904770235915, 445.203846153845, 318.863841820395, 569.097307692307, 692.029148830842, 892.26346153846, 866.743856161317, 1597.53576923077, 1586.95329038764, 4539.74807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 179.146702390483, 393.12576923077, 459.611919135963, 618.230384615384, 769.907647992626, 881.021538461539, 875.183787130541, 1571.56192307692, 1591.52044427266, 4520.31461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 401.392766600725, 470.959230769233, 585.506581405828, 683.90153846154, 733.001717621349, 853.780384615386, 895.033160248612, 1561.15615384615, 1584.44352906181, 4543.51461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 451.2278705863, 466.274615384614, 594.783196709654, 594.868076923077, 678.656521601771, 870.706153846153, 921.466827549426, 1544.445, 1545.3754481476, 4515.85576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 277.662937320388, 385.714230769233, 326.213233633368, 531.84153846154, 567.640572022065, 890.878461538463, 852.257195133022, 1461.5, 1521.18845438144, 4491.04923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 316.886365882885, 439.407692307693, 390.64745033775, 654.010769230769, 601.120137776649, 927.086153846155, 781.827820992677, 1440.07692307692, 1471.12232025071, 4466.57961538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 272.46177459148, 444.268461538461, 449.478752763687, 651.455000000001, 583.266380751079, 856.307692307692, 740.709430754163, 1362.93807692308, 1470.24447378298, 4475.70423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 275.515680378003, 422.823076923077, 360.416242017692, 557.896923076923, 535.472490826131, 776.843461538464, 663.89729997157, 1257.01153846154, 1456.98547713072, 4492.70461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 254.406096844275, 363.516538461539, 356.455573369896, 519.172307692309, 415.52848083393, 690.608076923079, 651.963499702365, 1235.49807692308, 1435.03759446868, 4456.09230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 209.775202060536, 353.27653846154, 291.492804514702, 505.439615384619, 301.261820873218, 619.069615384616, 562.885836036595, 1184.38884615385, 1460.46094391921, 4454.52423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 155.983885361475, 320.992692307694, 229.03850684513, 431.635384615385, 268.157887296617, 581.669230769232, 637.250532809631, 1209.41692307693, 1535.51756115604, 4469.35884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 180.833200830531, 296.921153846153, 226.946739177686, 414.57923076923, 284.357335169353, 582.716153846154, 730.101926549671, 1227.10346153846, 1523.78661975109, 4452.86730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 166.016595712135, 306.050384615384, 235.587438257254, 465.596153846154, 293.028074395874, 629.248076923076, 827.137140690801, 1247.19307692308, 1516.9314971013, 4456.845 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 170.402480458652, 321.092307692307, 226.235683121693, 422.871538461539, 269.44665019229, 587.359615384614, 799.014512021191, 1221.37269230769, 1490.78818186772, 4448.47269230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 192.380783283092, 297.863846153846, 248.452360525344, 447.808846153846, 321.208180729234, 601.499230769231, 808.633056667952, 1231.73807692308, 1480.58012898338, 4454.51730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 134.376801002028, 314.296538461537, 149.767853934014, 409.179999999999, 387.261996180284, 603.801538461538, 833.319706062166, 1259.36346153846, 1477.47770449152, 4471.20153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 112.218556146203, 271.436538461539, 283.372989168258, 414.323076923078, 395.894465806425, 561.498076923078, 825.253236515826, 1250.92038461539, 1471.0584350379, 4469.08807692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 269.092687614108, 338.139230769232, 363.85829754241, 465.377692307694, 363.789842163767, 585.878461538462, 814.398635269088, 1248.75192307692, 1470.77637540115, 4469.91692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 201.532603455467, 306.053461538464, 213.921162618742, 379.428076923079, 212.981980614469, 542.43230769231, 799.763071063212, 1249.41269230769, 1472.15694643895, 4465.96730769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 135.059708671616, 259.422307692309, 187.595523348673, 372.957307692308, 251.152866381904, 551.140384615387, 790.362254549238, 1302.00807692308, 1468.37616677749, 4455.09192307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 118.507496700226, 253.033076923078, 173.22758903424, 390.551153846154, 314.841109160453, 556.564230769235, 847.965356678879, 1343.03346153846, 1459.71509637484, 4449.37615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 150.245346630614, 303.778076923077, 193.495406405024, 405.579615384617, 325.068024980332, 602.213846153848, 877.201697180651, 1369.87615384615, 1453.28848970877, 4448.65 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 159.400574435794, 275.952307692308, 284.117284588329, 400.234615384618, 430.27596846693, 664.138076923078, 909.661146247665, 1382.70615384616, 1437.76634941201, 4435.06846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 217.150541552664, 294.563846153848, 243.153064619797, 428.315, 531.461865384671, 678.276923076923, 995.146439985282, 1410.72076923077, 1468.42598995654, 4450.53961538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 182.03717948392, 309.842307692308, 353.659024889143, 507.02846153846, 642.197044876533, 698.178076923076, 1120.01956913508, 1461.91153846154, 1477.04322633356, 4442.97538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 304.00934125451, 394.054999999999, 466.938729557334, 511.213846153844, 603.408251809157, 689.050769230769, 1104.64649783003, 1459.94192307692, 1482.68852283395, 4435.59346153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 323.061928293348, 307.706153846153, 457.610078776175, 464.178461538462, 509.460512697651, 692.896923076925, 999.764270079393, 1415.57076923077, 1465.70489090356, 4403.32884615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 256.282045146777, 330.636153846154, 283.96534391257, 452.79076923077, 463.483279632196, 727.181153846155, 921.598246681358, 1402.42692307692, 1463.5914401606, 4374.62076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 164.658374070027, 282.119230769232, 313.516809697049, 499.331153846155, 402.553436504256, 679.305769230769, 919.182292803687, 1409.33038461539, 1465.3068315175, 4370.03038461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 265.121551482452, 401.552692307693, 388.763961343564, 544.526538461539, 357.98604769718, 641.575384615385, 909.754471200967, 1375.94692307692, 1462.5892793187, 4351.175 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 275.686975071646, 350.361923076923, 259.002651646955, 444.918076923077, 342.706306180672, 635.650000000001, 917.910571165504, 1360.98423076923, 1476.59263861114, 4327.13384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 149.643225839121, 298.796538461538, 223.338150756615, 409.720769230769, 354.905577151921, 682.558461538463, 908.391709126289, 1356.46423076923, 1479.80162449244, 4318.97769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 149.984857422855, 297.501923076922, 273.327314773671, 454.974230769231, 416.063451934733, 703.759615384616, 877.193936594498, 1399.89307692308, 1482.47366387649, 4314.27076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243185493300 and enddate = '2025-04-27 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-04-27 00:00:00', 202.939823070404, 338.090384615386, 270.336101891417, 527.474615384616, 464.504784014612, 681.747307692[...];

[ Date: 2025-04-27 15:06:41 - 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 = '689' AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON sg.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN 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 ('310' = 0 OR coalesce(bim.code, s.symbol) in ('#AAPL', '#ADS', '#AIG', '#ALV', '#AMZN', '#AXP', '#BA', '#BABA', '#BAC', '#BAS', '#BAYN', '#BEI', '#BIDU', '#BMW', '#C', '#CAT', '#CBK', '#CL', '#CSCO', '#CVX', '#DAI', '#DB1', '#DBK', '#DIS', '#DPW', '#DTE', '#EBAY', '#EON', '#F', '#FB', '#FDX', '#FME', '#GE', '#GM', '#GOOG', '#GS', '#HPQ', '#IBM', '#IFX', '#INTC', '#JD', '#JNJ', '#JPM', '#KO', '#LHA', '#LMT', '#MA', '#MCD', '#META', '#MMM', '#MSFT', '#MUV2', '#NFLX', '#NKE', '#NTES', '#ORCL', '#PFE', '#PG', '#QCOM', '#RACE', '#RWE', '#SAP', '#SIE', '#T', '#UBER', '#V', '#VOW', '#WB', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS200', 'BRENT', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CHI50', 'ESP35', 'ETHUSD', 'EU50', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'EURUSD', 'FRA40', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GER30', 'HK50', 'HKCH50', 'IT40', 'JP225', 'LTCUSD', 'NAS100', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'SPX500', 'UK100', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'WTI', 'XAGUSD', 'XAUUSD', '#ADS', '#ALV', '#BAS', '#BAYN', '#BEI', '#BMW', '#CBK', '#DAI', '#DB1', '#DBK', '#DPW', '#DTE', '#EON', '#FME', '#IFX', '#LHA', '#MUV2', '#RWE', '#SAP', '#SIE', '#VOW', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'XAGUSD', 'XAUUSD', 'BTCUSD', 'ETHUSD', 'LTCUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'XAGUSD', 'XAUUSD', 'BRENT', 'WTI', 'AUS200', 'CHI50', 'ESP35', 'EU50', 'FRA40', 'GER30', 'HK50', 'HKCH50', 'IT40', 'JP225', 'NAS100', 'SPX500', 'UK100', 'US30', 'AUDUSD', 'EURUSD', 'GBPUSD', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDJPY', '#AAPL', '#AIG', '#AMZN', '#AXP', '#BA', '#BABA', '#BAC', '#BIDU', '#C', '#CAT', '#CL', '#CSCO', '#CVX', '#DIS', '#EBAY', '#F', '#FB', '#FDX', '#GE', '#GM', '#GOOG', '#GS', '#HPQ', '#IBM', '#INTC', '#JD', '#JNJ', '#JPM', '#KO', '#LMT', '#MA', '#MCD', '#MMM', '#MSFT', '#NFLX', '#NKE', '#NTES', '#ORCL', '#PFE', '#PG', '#QCOM', '#RACE', '#T', '#UBER', '#V', '#WB', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('400' = 0 OR ar.patternlengthbars <= '400') and newLevels.filtered = false 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-04-27 15:06:31 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver - Bind query: yes ]