select powerstats_tdata_add ();

[ Date: 2025-05-25 14:02:49 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2025-05-25 14:02:19 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

[ Date: 2025-05-25 14:17: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-05-25 14: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-05-25 14:03:29 - 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-05-25 14:05:24 - 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-05-25 14:11:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2025-05-25 14: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-05-25 14:18: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-05-25 14: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-05-25 14:26: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-05-25 14:31: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-05-25 14: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-05-25 14: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-05-25 14: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-05-25 14:46: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-05-25 14: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-05-25 14:50:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select powerstats_tdata_add ();

[ Date: 2025-05-25 14:02:58 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

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

WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a.*, rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('7' = 0 OR s.timegranularity in ('15', '30', '60', '120', '240', '480', '1440')) AND ('0' = 0 OR s.exchange in ('')) AND ('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 p.patternname in ('')) AND ('2' = 0 OR kr.patternclassid in ('1', '2')) AND ('400' = 0 OR kr.patternlengthbars <= '400') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('10' = 0 OR age <= '10') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200;

[ Date: 2025-05-25 14:05:57 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.250 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 1, 900, '2025-05-25 00:00:00', 0.0217593377197002, 0.0430750000000004, 0.0307448883956588, 0.0637976923076926, 0.0687748803125093, 0.102075, 0.0934961812276519, 0.193161923076923, 0.225331712637169, 0.41299 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 915, '2025-05-25 00:00:00', 0.0210951596927238, 0.0456776923076924, 0.0586997971337077, 0.072973461538462, 0.0860152828316887, 0.109116153846154, 0.0902104918927873, 0.193656538461538, 0.224752592993683, 0.40951576923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 930, '2025-05-25 00:00:00', 0.0608545218748396, 0.0556138461538464, 0.0674870728555872, 0.0804988461538465, 0.0946064174697546, 0.115462307692308, 0.0905325150879726, 0.192081923076924, 0.224466087504069, 0.40955076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 945, '2025-05-25 00:00:00', 0.0338653517057454, 0.0507769230769236, 0.0735117601057547, 0.0774646153846159, 0.0780591048254703, 0.106243076923078, 0.0790817191128656, 0.185844615384616, 0.224644671805189, 0.405937692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 960, '2025-05-25 00:00:00', 0.0541756212899656, 0.0560230769230764, 0.064288212093305, 0.0806530769230765, 0.0625166414128134, 0.106951538461539, 0.0807861902669395, 0.184665384615385, 0.224715120209155, 0.406308846153847 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 975, '2025-05-25 00:00:00', 0.0390683294222589, 0.0521603846153859, 0.0419706074368165, 0.0714961538461557, 0.0424161804920995, 0.104333461538462, 0.104413778958821, 0.187257307692309, 0.224322433515824, 0.406267692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 990, '2025-05-25 00:00:00', 0.0287721235493408, 0.0479384615384621, 0.0352284553079554, 0.0701692307692317, 0.0528908447043391, 0.102621538461538, 0.10532075096653, 0.178648076923078, 0.226019535479704, 0.404687692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1005, '2025-05-25 00:00:00', 0.0244328843978767, 0.0472100000000006, 0.0322360702725275, 0.0736488461538451, 0.0598353391451522, 0.109101153846154, 0.105157885144928, 0.176598076923078, 0.22597994592339, 0.405236538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1020, '2025-05-25 00:00:00', 0.0325539045513495, 0.0580315384615379, 0.0551818008237666, 0.0797969230769222, 0.0672886928402821, 0.109688076923076, 0.106733371432671, 0.171255769230769, 0.22725067847982, 0.404648461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1035, '2025-05-25 00:00:00', 0.045148245000392, 0.0547411538461545, 0.0543003783653057, 0.0798211538461549, 0.0593206983256783, 0.102955384615385, 0.0977875581680083, 0.165642692307693, 0.225826899456539, 0.407226923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1050, '2025-05-25 00:00:00', 0.0380400424006871, 0.0556046153846168, 0.0419356226632411, 0.076541923076924, 0.0428452481091943, 0.0918684615384623, 0.0868231733201725, 0.158284230769232, 0.225996578430192, 0.410133076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1065, '2025-05-25 00:00:00', 0.0284215427178315, 0.0520623076923085, 0.0328510874120459, 0.0669180769230765, 0.0337777145831626, 0.0858076923076924, 0.0773234940324399, 0.15228576923077, 0.225036281393775, 0.413556538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1080, '2025-05-25 00:00:00', 0.0231315737068158, 0.0468330769230767, 0.0272358258097394, 0.0613965384615383, 0.031467605653091, 0.0851584615384621, 0.0805899066174884, 0.150293846153847, 0.224129381228446, 0.416995384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1095, '2025-05-25 00:00:00', 0.0214529347212415, 0.044921923076923, 0.025637299113717, 0.0619446153846146, 0.0347885608520077, 0.0882969230769232, 0.0841038072174002, 0.147522692307693, 0.225149497409029, 0.416243461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1110, '2025-05-25 00:00:00', 0.0155134597043991, 0.0411499999999999, 0.0267143564428168, 0.0599080769230771, 0.0475046856846773, 0.0919450000000007, 0.0857762985525998, 0.14334576923077, 0.226350759788023, 0.415196153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1125, '2025-05-25 00:00:00', 0.0279057269473767, 0.0446926923076921, 0.0303731116032182, 0.0623173076923071, 0.0458842605978932, 0.0870311538461539, 0.0859365958510206, 0.137647692307692, 0.227398693665147, 0.413883846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1140, '2025-05-25 00:00:00', 0.0176224040968839, 0.0399669230769221, 0.0409130184359266, 0.0646515384615382, 0.0552053466808599, 0.0881569230769238, 0.0959843639862564, 0.135754615384615, 0.227970458603403, 0.414310384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1155, '2025-05-25 00:00:00', 0.0373278130435657, 0.0480888461538458, 0.0436800071375736, 0.0639034615384616, 0.0805099513820408, 0.0965365384615394, 0.0973550267296898, 0.132641538461539, 0.227435363412248, 0.416267692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1170, '2025-05-25 00:00:00', 0.0234877987605354, 0.038411153846154, 0.0380407392409776, 0.0596250000000008, 0.0709841200280312, 0.0812619230769237, 0.0891106584672214, 0.120527307692307, 0.228250963705775, 0.416686153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1185, '2025-05-25 00:00:00', 0.029853252254216, 0.0424830769230777, 0.070596158140184, 0.0641519230769241, 0.0689062579730327, 0.0741096153846168, 0.102579335276879, 0.124594615384615, 0.228256382981607, 0.416780384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1200, '2025-05-25 00:00:00', 0.0704512146065526, 0.0472534615384614, 0.0692511510506953, 0.0539753846153849, 0.0673985633640547, 0.066663461538462, 0.154658483005423, 0.151928461538461, 0.228594955945764, 0.417030384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1215, '2025-05-25 00:00:00', 0.0638684869122603, 0.0374973076923083, 0.0626161527992955, 0.0473892307692319, 0.0660963043305286, 0.0673330769230771, 0.206497252416067, 0.236720769230769, 0.228135042701601, 0.418067307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1230, '2025-05-25 00:00:00', 0.062825513337767, 0.0399830769230773, 0.0661694415374999, 0.0546057692307692, 0.0663875007014469, 0.0682657692307689, 0.206917468241289, 0.236929230769231, 0.228003691519373, 0.418792307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1245, '2025-05-25 00:00:00', 0.0673947546657864, 0.0463126923076928, 0.0679366425474165, 0.0577361538461536, 0.0680487538901339, 0.069485, 0.21091844525423, 0.237822692307692, 0.227846882287206, 0.42057 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1260, '2025-05-25 00:00:00', 0.0683188279184734, 0.039491923076923, 0.0676548341555539, 0.0463061538461539, 0.0742434930710073, 0.0691107692307698, 0.214602634244353, 0.232536153846154, 0.228056407652884, 0.422573461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1275, '2025-05-25 00:00:00', 0.0108462026818318, 0.0210138461538456, 0.0217722960062687, 0.035724230769231, 0.0749643669649889, 0.0683323076923074, 0.230755991754194, 0.242797692307692, 0.229278379233964, 0.424761923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1290, '2025-05-25 00:00:00', 0.0192948868196893, 0.0278257692307692, 0.0739548397885752, 0.0556419230769238, 0.0765235247891379, 0.0698230769230771, 0.227864219986715, 0.250733076923077, 0.22941061020899, 0.425042692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1305, '2025-05-25 00:00:00', 0.0650916359946614, 0.041517307692308, 0.0662065644665365, 0.052752307692307, 0.0706368536541219, 0.0652769230769232, 0.225993977162769, 0.250195384615385, 0.22817582090471, 0.429641538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1320, '2025-05-25 00:00:00', 0.0645070947225084, 0.0406415384615379, 0.0701425115779408, 0.0527676923076921, 0.0834132711780042, 0.0681261538461546, 0.224642169309669, 0.252208076923077, 0.228376279583632, 0.430022692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1335, '2025-05-25 00:00:00', 0.071693257772262, 0.040545, 0.0704063435308537, 0.0475642307692312, 0.0836106916497755, 0.0663930769230774, 0.223351457095004, 0.253982307692308, 0.229537095423342, 0.431530769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1350, '2025-05-25 00:00:00', 0.0632977903138439, 0.0334211538461543, 0.0827903581788637, 0.0547507692307696, 0.0823398037291436, 0.0643930769230771, 0.223606525556355, 0.252639230769231, 0.230324590462777, 0.434019615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1365, '2025-05-25 00:00:00', 0.0773196024950981, 0.046795, 0.0769368251449507, 0.0541907692307693, 0.0928267866222652, 0.0753511538461534, 0.22037026689328, 0.250708846153846, 0.230326433000242, 0.434961153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1380, '2025-05-25 00:00:00', 0.0696766812256111, 0.0352588461538462, 0.0687167540079174, 0.0417742307692307, 0.153480204071555, 0.101404615384615, 0.213050829568547, 0.250689615384615, 0.231469685514108, 0.43438 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1395, '2025-05-25 00:00:00', 0.0592482374434364, 0.0309180769230768, 0.077808671792763, 0.0538469230769233, 0.200324104988353, 0.19416923076923, 0.211658623438418, 0.250739615384615, 0.239272257468028, 0.437935384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1410, '2025-05-25 00:00:00', 0.029758727591182, 0.0314796153846158, 0.145936651055807, 0.0857557692307695, 0.193638429242195, 0.188629230769231, 0.210515227368107, 0.251164615384615, 0.23628813294496, 0.442671153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 1, 1425, '2025-05-25 00:00:00', 0.1444654869111, 0.0704673076923079, 0.196962920235881, 0.174610384615385, 0.2001262346036, 0.179173846153846, 0.209603057965434, 0.248737307692307, 0.236333256082299, 0.452362307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 0, '2025-05-25 00:00:00', 0.15813232581753, 0.126567307692308, 0.15628160117114, 0.132486153846154, 0.159625956115683, 0.142845384615385, 0.208533743666435, 0.245203461538461, 0.234264118053501, 0.458299230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 15, '2025-05-25 00:00:00', 0.0294112016650909, 0.028069230769232, 0.031667052426531, 0.0409757692307693, 0.145577500850922, 0.115685000000001, 0.20842657295999, 0.228539615384616, 0.25474503534711, 0.472845000000001 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 30, '2025-05-25 00:00:00', 0.0216787093853713, 0.0246138461538462, 0.0222215497243973, 0.0319680769230764, 0.179075794232928, 0.131858076923076, 0.212003136543198, 0.224071923076923, 0.260411376548426, 0.469229615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 45, '2025-05-25 00:00:00', 0.0201717698891678, 0.0211873076923067, 0.143997261027371, 0.104400769230769, 0.179446842278838, 0.138369615384615, 0.213188772495537, 0.226263076923077, 0.273757526452488, 0.475374230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 60, '2025-05-25 00:00:00', 0.144293325931803, 0.0882426923076924, 0.17879755637635, 0.116503076923077, 0.180149999012362, 0.140998076923076, 0.206411461377139, 0.220669615384615, 0.280933736072296, 0.476016538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 75, '2025-05-25 00:00:00', 0.123786098389364, 0.060907692307693, 0.13212752037564, 0.0876361538461541, 0.177287409238826, 0.149091153846154, 0.180164677715011, 0.202178076923077, 0.291612835757645, 0.477051153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 90, '2025-05-25 00:00:00', 0.0592244839871013, 0.0415534615384613, 0.0733235995266082, 0.060476538461539, 0.133296337190717, 0.115767307692308, 0.142955380578912, 0.170472692307692, 0.290213554761636, 0.453180769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 105, '2025-05-25 00:00:00', 0.0455521735046738, 0.0364111999999997, 0.107733316999277, 0.0889659999999995, 0.10489857601512, 0.097701999999999, 0.112439598758622, 0.155677599999999, 0.294688451514477, 0.4604132 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 120, '2025-05-25 00:00:00', 0.0215483692083288, 0.0364334615384617, 0.0235906791763177, 0.0460199999999997, 0.0536902160360707, 0.0678450000000006, 0.0651273256333609, 0.125118076923076, 0.290645410785403, 0.452808846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 135, '2025-05-25 00:00:00', 0.0229295562840753, 0.0289407692307687, 0.0291026708819228, 0.0405626923076908, 0.0541294372023773, 0.0721496153846145, 0.0717515798464501, 0.126317692307691, 0.293788191157141, 0.455929230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 150, '2025-05-25 00:00:00', 0.0133452658330161, 0.0275980769230762, 0.0507863487957149, 0.0489100000000002, 0.0554071357081794, 0.0752992307692302, 0.0699072861482647, 0.123933846153846, 0.294189473921407, 0.454253076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 165, '2025-05-25 00:00:00', 0.0467192978954751, 0.037769615384616, 0.0486101700533481, 0.058923846153846, 0.0523653081930574, 0.0755369230769223, 0.0681199803299578, 0.123248076923076, 0.294599037225436, 0.453646923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 180, '2025-05-25 00:00:00', 0.0300199842079605, 0.0467196153846153, 0.0388284066374095, 0.0597449999999998, 0.0474552444568726, 0.0781676923076919, 0.064212875240215, 0.120771153846153, 0.295429319067119, 0.452627307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 195, '2025-05-25 00:00:00', 0.0229709106882197, 0.035454615384615, 0.0245422578141331, 0.0464788461538453, 0.0352377483869863, 0.0696292307692309, 0.0611693866281284, 0.119867307692308, 0.296102360526793, 0.450288461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 210, '2025-05-25 00:00:00', 0.0182999032742296, 0.0346596153846143, 0.0338643080747939, 0.0555942307692308, 0.0354966602719397, 0.0669976923076928, 0.0619026733509948, 0.11991, 0.295684133361678, 0.450345384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 225, '2025-05-25 00:00:00', 0.0329335780298179, 0.0435046153846152, 0.0334920394514178, 0.0558111538461544, 0.0355708865484975, 0.0672553846153852, 0.063298402745676, 0.119586923076923, 0.29653938754833, 0.449126538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 240, '2025-05-25 00:00:00', 0.0211782982428124, 0.0358573076923083, 0.0214954186889986, 0.0420838461538468, 0.0287905423386542, 0.0598619230769231, 0.060622360861826, 0.115157307692308, 0.297252171256093, 0.448297307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 255, '2025-05-25 00:00:00', 0.013931117979324, 0.0287019230769232, 0.022644282239758, 0.0462569230769231, 0.0316530364395917, 0.0635203846153849, 0.0556791068299821, 0.111654230769231, 0.297409712306364, 0.445486923076924 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 270, '2025-05-25 00:00:00', 0.0215335571965809, 0.0372915384615388, 0.0220029034762366, 0.0460557692307691, 0.0318402483876086, 0.0618857692307697, 0.0590784118647544, 0.114752692307693, 0.297407565647133, 0.445498076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 285, '2025-05-25 00:00:00', 0.0202114984067526, 0.0329896153846152, 0.0288701266736714, 0.0477669230769236, 0.0316871006805362, 0.0615215384615381, 0.0671981505205668, 0.124014230769231, 0.29763415694, 0.444904230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 300, '2025-05-25 00:00:00', 0.0257922706161839, 0.0368465384615377, 0.0272555720654583, 0.0453761538461539, 0.0303053882083945, 0.0637623076923069, 0.0647870388129748, 0.121843076923077, 0.297902192485283, 0.443653461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 315, '2025-05-25 00:00:00', 0.0222284533009797, 0.0303280769230764, 0.0217247526214116, 0.0425226923076912, 0.0370110360111061, 0.0617388461538453, 0.118332356912476, 0.147957307692307, 0.297150569806208, 0.445901923076924 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 330, '2025-05-25 00:00:00', 0.0196498977135727, 0.0333519230769218, 0.0254008272821066, 0.0475411538461535, 0.0337407234157083, 0.0596638461538467, 0.117642141465614, 0.149776153846154, 0.297270511241089, 0.445481538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 345, '2025-05-25 00:00:00', 0.0232975970104544, 0.0364376923076927, 0.0331621438111867, 0.0473369230769238, 0.0327181580377711, 0.0571742307692314, 0.122382678502877, 0.157121538461538, 0.297185365908475, 0.445923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 360, '2025-05-25 00:00:00', 0.0243754846074117, 0.0343053846153845, 0.0264395073298678, 0.0417303846153859, 0.0257157879551427, 0.0509469230769235, 0.122967353616879, 0.158923461538462, 0.29724034676025, 0.445706923076924 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 375, '2025-05-25 00:00:00', 0.0212380475127497, 0.0293130769230784, 0.0206844718420511, 0.0382092307692313, 0.0304434341942317, 0.0529484615384616, 0.124233321890088, 0.161849615384615, 0.315934858852507, 0.451133076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 390, '2025-05-25 00:00:00', 0.0147908866744148, 0.0261761538461538, 0.0166247069193379, 0.0322719230769228, 0.0288204116236019, 0.0506630769230763, 0.125228284494912, 0.166611538461539, 0.316908767519078, 0.448267692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 405, '2025-05-25 00:00:00', 0.016215711967577, 0.0263988461538463, 0.0283080869010974, 0.04194, 0.0284157780358844, 0.0523457692307698, 0.128374043079648, 0.177326153846154, 0.316787920315785, 0.448885 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 420, '2025-05-25 00:00:00', 0.0227722556059923, 0.0313557692307692, 0.0218219892204739, 0.0400015384615389, 0.02648563564245, 0.0539692307692307, 0.130843004102098, 0.185507692307693, 0.316652317284091, 0.450234230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 435, '2025-05-25 00:00:00', 0.015094126096446, 0.0272888461538465, 0.0164552615106721, 0.0372407692307695, 0.0257245027551554, 0.0546550000000003, 0.129464637536517, 0.196027307692309, 0.316087742466939, 0.449214615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 450, '2025-05-25 00:00:00', 0.0162360184584959, 0.0304392307692311, 0.0242871857856072, 0.0414742307692314, 0.0332708980919685, 0.0651303846153852, 0.128409490682678, 0.197044230769232, 0.316040851975719, 0.448968461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 465, '2025-05-25 00:00:00', 0.0213749315428505, 0.0304523076923078, 0.0226835510752753, 0.04352576923077, 0.055402957645294, 0.0717796153846159, 0.128369595574054, 0.196240384615386, 0.316544888907621, 0.446621538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 480, '2025-05-25 00:00:00', 0.0222099236725047, 0.0370584615384622, 0.0306036675253143, 0.0535450000000006, 0.0518771278740595, 0.0736826923076924, 0.130224482467185, 0.198244615384617, 0.316291412523081, 0.445610384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 495, '2025-05-25 00:00:00', 0.0274953908221283, 0.0394326923076923, 0.0529248762623462, 0.058999230769231, 0.120451523624812, 0.108113461538461, 0.133215591446578, 0.198007307692309, 0.316994477924482, 0.444471153846155 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 510, '2025-05-25 00:00:00', 0.0511273951614981, 0.0489800000000008, 0.0509802759324994, 0.0637030769230767, 0.122231463143309, 0.114883076923077, 0.133110672579682, 0.197698846153847, 0.315947106308343, 0.445786153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 525, '2025-05-25 00:00:00', 0.0231566301421094, 0.0446665384615382, 0.116020401294176, 0.0915326923076922, 0.122835155572261, 0.115867307692307, 0.126377882749134, 0.187768076923078, 0.315439220667602, 0.44636076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 540, '2025-05-25 00:00:00', 0.119073402611098, 0.070734230769231, 0.12019261960703, 0.0824900000000002, 0.123053520551644, 0.107788076923077, 0.127861750901271, 0.175573461538462, 0.316711498464843, 0.443810384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 555, '2025-05-25 00:00:00', 0.0215269040969665, 0.0350200000000005, 0.0314538744293194, 0.0554761538461528, 0.0311947525098993, 0.0752980769230757, 0.0624745232271637, 0.145517307692308, 0.31634352316527, 0.441103846153847 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 570, '2025-05-25 00:00:00', 0.0200849416689758, 0.0428553846153833, 0.0240014832778822, 0.0552734615384611, 0.0304066782441972, 0.0791753846153841, 0.0557122999939443, 0.142158846153847, 0.316431467207964, 0.44539076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 585, '2025-05-25 00:00:00', 0.0147485213287513, 0.0386442307692308, 0.0203404762821487, 0.0549892307692295, 0.0334769144061071, 0.0865469230769236, 0.0552701922001908, 0.137404615384616, 0.320607332167224, 0.447869230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 600, '2025-05-25 00:00:00', 0.0181733167541362, 0.0422453846153837, 0.0260658053749758, 0.0630853846153843, 0.0386545292320809, 0.0933669230769234, 0.0531345362655377, 0.135658076923077, 0.332879630414081, 0.455236153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 615, '2025-05-25 00:00:00', 0.0217189003298616, 0.0447834615384612, 0.0253117631668629, 0.0661888461538463, 0.0410745148461435, 0.094454615384616, 0.0473583932565923, 0.131649615384616, 0.336551859542993, 0.468815384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 630, '2025-05-25 00:00:00', 0.0235012267208467, 0.0452357692307687, 0.032330120292907, 0.0642330769230766, 0.0401490456941855, 0.0889669230769232, 0.0486203012062304, 0.130465769230769, 0.37607730563481, 0.493078461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 645, '2025-05-25 00:00:00', 0.0195021588430226, 0.0432134615384611, 0.032803872494195, 0.0669011538461538, 0.0309117243676998, 0.0810092307692305, 0.0475607483686344, 0.126714230769231, 0.525061492395379, 0.536552692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 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 515840243198780300, 2, 660, '2025-05-25 00:00:00', 0.025117922243811, 0.0444746153846151, 0.0268628609307464, 0.056965769230769, 0.0291833943615462, 0.0701876923076923, 0.0469394890405139, 0.12608076923077, 0.663778191788145, 0.570868461538463 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 660); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 675, '2025-05-25 00:00:00', 0.0145029646412239, 0.034159230769231, 0.0182661073997294, 0.0457334615384621, 0.0263554983666368, 0.0692069230769233, 0.0446618015913442, 0.127224230769232, 0.663742311875279, 0.578921538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 675); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 690, '2025-05-25 00:00:00', 0.0163982948316157, 0.0340457692307693, 0.0197833257723607, 0.049881153846154, 0.0270081349682176, 0.0668376923076929, 0.0475099479526283, 0.131257692307693, 0.66323708287355, 0.580548846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 690); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 705, '2025-05-25 00:00:00', 0.0164620056026453, 0.035502692307693, 0.0229981810016484, 0.0538542307692308, 0.0247696105245602, 0.0635915384615387, 0.0498681591583857, 0.138714615384617, 0.662994973098127, 0.580995769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 705); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 720, '2025-05-25 00:00:00', 0.0168720231790337, 0.0389230769230775, 0.017573335483054, 0.0459300000000007, 0.0202958037080033, 0.060278076923077, 0.0538062620833729, 0.14135076923077, 0.66279066165837, 0.580688461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 720); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 735, '2025-05-25 00:00:00', 0.0131687394467118, 0.0306888461538454, 0.0172067838544972, 0.0413811538461539, 0.0253257353207852, 0.0627215384615391, 0.0512053672427175, 0.145352307692309, 0.661331356160727, 0.581384230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 735); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 750, '2025-05-25 00:00:00', 0.0149290717574282, 0.0310034615384617, 0.0187910395667723, 0.04708, 0.0326766307932747, 0.0659000000000005, 0.0513888369455418, 0.147958846153847, 0.661319515987429, 0.582355384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 750); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 765, '2025-05-25 00:00:00', 0.0155484229425364, 0.0317299999999996, 0.025793391893751, 0.0482942307692312, 0.0343968722392925, 0.0640603846153858, 0.0484433289715548, 0.148085384615385, 0.660104982069229, 0.583283846153847 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 765); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 780, '2025-05-25 00:00:00', 0.0225084862799648, 0.0384888461538455, 0.0300384939113385, 0.049062692307692, 0.034825096353061, 0.0635400000000005, 0.0467644207441786, 0.148803461538462, 0.659895295685496, 0.580919615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 780); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 795, '2025-05-25 00:00:00', 0.0173623544885084, 0.0312542307692313, 0.020626597456086, 0.0425088461538475, 0.0253035670486321, 0.0590257692307694, 0.0492831988160122, 0.15456153846154, 0.660726147497178, 0.578147692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 795); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 810, '2025-05-25 00:00:00', 0.0127886935400592, 0.0277976923076932, 0.019007446949511, 0.040633461538462, 0.0291666178730735, 0.061313076923077, 0.0518316504983652, 0.16416576923077, 0.660434898351546, 0.578433846153847 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 810); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 825, '2025-05-25 00:00:00', 0.0145151952847313, 0.0296069230769232, 0.0167671455485479, 0.0434446153846153, 0.027037771699265, 0.0617076923076928, 0.057670385398401, 0.168300000000001, 0.659634867203179, 0.580483076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 825); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 840, '2025-05-25 00:00:00', 0.0110990381634559, 0.0311019230769231, 0.021325910452203, 0.0451161538461536, 0.0244760668440387, 0.0618819230769234, 0.057271548893106, 0.174983846153847, 0.659533259241367, 0.579611538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 840); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 855, '2025-05-25 00:00:00', 0.0148812684116122, 0.0323515384615383, 0.0198006425109426, 0.0432503846153846, 0.0237547263896298, 0.066584615384616, 0.0592472635771867, 0.177154230769232, 0.659963890860822, 0.578421923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 855); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 870, '2025-05-25 00:00:00', 0.0122207887004696, 0.0279073076923068, 0.0150227686068641, 0.0460838461538454, 0.0306998715006085, 0.0720130769230767, 0.0616825229006134, 0.175990769230769, 0.660161573036481, 0.576985 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 870); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 885, '2025-05-25 00:00:00', 0.012129799751027, 0.0370449999999997, 0.0189294058137486, 0.0529073076923075, 0.0349491223285869, 0.0860465384615386, 0.0615002432465484, 0.177390769230769, 0.660633245783516, 0.575602307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 885); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 900, '2025-05-25 00:00:00', 0.013753221569453, 0.0366234615384621, 0.0231540903978945, 0.0544269230769234, 0.0323564564404793, 0.08300576923077, 0.0621264831972775, 0.173247692307693, 0.659772900342582, 0.572152307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 900); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 915, '2025-05-25 00:00:00', 0.0190887127502495, 0.0369623076923079, 0.0293086729825835, 0.0617099999999998, 0.0333929162640131, 0.0817561538461543, 0.0581242532669992, 0.174624615384616, 0.660709398008047, 0.569328076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 915); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 930, '2025-05-25 00:00:00', 0.0267277118765125, 0.0457630769230782, 0.0270173705946041, 0.0589546153846162, 0.0312556324819413, 0.0810653846153858, 0.0592368374227244, 0.173969615384616, 0.660299766758659, 0.569818461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 930); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 945, '2025-05-25 00:00:00', 0.0181420237697317, 0.0418276923076928, 0.0240069913054182, 0.0609665384615395, 0.0265114051422282, 0.0761488461538472, 0.0548880660085045, 0.169576923076924, 0.656648126038246, 0.572821538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 945); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 960, '2025-05-25 00:00:00', 0.0149630104796923, 0.0408288461538455, 0.0207050154756323, 0.0550746153846147, 0.0244094180216133, 0.0741180769230769, 0.0494561498517005, 0.165133076923077, 0.656984383270668, 0.571778461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 960); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 975, '2025-05-25 00:00:00', 0.0148770632803038, 0.0389796153846153, 0.0205648691667645, 0.053399615384616, 0.0362363092958518, 0.0921007692307702, 0.0507931351282223, 0.164951923076923, 0.658654703079403, 0.573386153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 975); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 990, '2025-05-25 00:00:00', 0.0195760403162006, 0.0387276923076929, 0.0242776215569306, 0.0574826923076927, 0.0427724759161781, 0.1029, 0.0535010399381318, 0.164467692307693, 0.66030558098796, 0.573539615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 990); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1005, '2025-05-25 00:00:00', 0.0183008243656276, 0.0437326923076921, 0.0377302823818674, 0.0777661538461536, 0.0411084481828256, 0.104039999999999, 0.0845862551809598, 0.172571538461538, 0.662833048640456, 0.575764999999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1005); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1020, '2025-05-25 00:00:00', 0.034384607408191, 0.0617088461538467, 0.035432601398235, 0.0818146153846152, 0.0357704666750924, 0.108366923076923, 0.0881005164256236, 0.172822307692307, 0.664220529969818, 0.57234423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1020); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1035, '2025-05-25 00:00:00', 0.0253427831541842, 0.0576350000000004, 0.0311638560194345, 0.0748150000000001, 0.031256640532607, 0.10171423076923, 0.0901968848993051, 0.172101538461539, 0.665101410365021, 0.569101538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1035); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1050, '2025-05-25 00:00:00', 0.022698730364359, 0.0517180769230769, 0.0243825987256362, 0.0751761538461539, 0.027126244674741, 0.0894530769230764, 0.0890761615697493, 0.16504, 0.663549139438359, 0.56878423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1050); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1065, '2025-05-25 00:00:00', 0.0186128783207919, 0.0506207692307699, 0.0226116076521646, 0.0633261538461534, 0.0356897095446938, 0.081700769230769, 0.0907949008708855, 0.161908076923077, 0.663441409818185, 0.565318461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1065); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1080, '2025-05-25 00:00:00', 0.0189676832574218, 0.0472480769230765, 0.0213332396039613, 0.0576999999999997, 0.0377717819074174, 0.0795926923076925, 0.0902650209413295, 0.156908461538461, 0.664965906979854, 0.567458461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1080); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1095, '2025-05-25 00:00:00', 0.0165943338105324, 0.0380811538461528, 0.0296729779066086, 0.0566346153846153, 0.0364772605605189, 0.0800249999999997, 0.0867306363545293, 0.153577692307692, 0.658537572339009, 0.569403076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1095); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1110, '2025-05-25 00:00:00', 0.0197570455164346, 0.0412865384615391, 0.0225615747711425, 0.0533419230769231, 0.0332818371996596, 0.0794292307692315, 0.0861679836357232, 0.150630384615384, 0.647600844647737, 0.567367307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1110); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1125, '2025-05-25 00:00:00', 0.013107107924856, 0.0366969230769221, 0.0270013233293935, 0.0556684615384603, 0.031790681314837, 0.0723123076923073, 0.081467800597253, 0.145256923076922, 0.643124008914181, 0.568794615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1125); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1140, '2025-05-25 00:00:00', 0.0185989386628548, 0.0398492307692299, 0.023122176141931, 0.0536015384615381, 0.0283109010181863, 0.0678173076923071, 0.0778562774189625, 0.140748461538461, 0.641381416766606, 0.569271538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1140); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1155, '2025-05-25 00:00:00', 0.0185350829094867, 0.0369023076923088, 0.0189516590708699, 0.0483815384615395, 0.0349894399717755, 0.0698815384615383, 0.183194362097074, 0.165701923076923, 0.636280757860989, 0.570581923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1155); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1170, '2025-05-25 00:00:00', 0.0124343704056394, 0.0328092307692308, 0.0209850457120897, 0.0492265384615383, 0.034270879562685, 0.0692850000000002, 0.18370364367267, 0.167861153846155, 0.634428978521996, 0.570717307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1170); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1185, '2025-05-25 00:00:00', 0.0181924903695494, 0.0349153846153847, 0.0273015204451214, 0.0515011538461536, 0.0564792765370969, 0.0776830769230768, 0.186126131372911, 0.173069615384616, 0.634842635378371, 0.568186923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1185); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1200, '2025-05-25 00:00:00', 0.0255959928474389, 0.0362453846153838, 0.0271569229139428, 0.0478130769230765, 0.0580215145561081, 0.0749792307692306, 0.187241859545759, 0.175093076923077, 0.634929235601528, 0.567261538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1200); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1215, '2025-05-25 00:00:00', 0.0112233247233671, 0.0277253846153847, 0.0544732844626964, 0.0522080769230775, 0.0535613468779923, 0.0706492307692322, 0.213969443855893, 0.231790000000001, 0.632482769638706, 0.565005384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1215); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1230, '2025-05-25 00:00:00', 0.0541732535482216, 0.0413700000000008, 0.05284672864193, 0.0529980769230774, 0.0523934789248251, 0.0690346153846159, 0.217790041093569, 0.22928653846154, 0.639423921651718, 0.566412692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1230); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1245, '2025-05-25 00:00:00', 0.0199233101667359, 0.0324399999999992, 0.024173556907051, 0.0444484615384617, 0.0347359604223276, 0.064942307692307, 0.227352418139768, 0.227015, 0.636250391151279, 0.558818076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1245); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1260, '2025-05-25 00:00:00', 0.021510984546363, 0.0341580769230774, 0.0255173488404683, 0.0447003846153844, 0.0329817277081631, 0.0635488461538459, 0.234459391277368, 0.226613076923078, 0.635795202705546, 0.55731923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1260); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1275, '2025-05-25 00:00:00', 0.0164312755485943, 0.028978076923077, 0.0269942202246784, 0.044228461538461, 0.0377708739985636, 0.0646788461538455, 0.255438507214856, 0.245011923076923, 0.631764397393645, 0.565746923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1275); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1290, '2025-05-25 00:00:00', 0.0254934367903704, 0.0331192307692305, 0.0271278086358746, 0.0469042307692313, 0.0368251668897995, 0.0647326923076918, 0.259249375806681, 0.245598076923077, 0.631905580061916, 0.564464230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1290); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1305, '2025-05-25 00:00:00', 0.0150607946720574, 0.0300280769230777, 0.0332550267247163, 0.0457376923076926, 0.0354891212648882, 0.0586819230769229, 0.258735559135934, 0.242624230769231, 0.631063808266767, 0.566148076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1305); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1320, '2025-05-25 00:00:00', 0.0251435459741433, 0.032611923076923, 0.0291391062636828, 0.0434853846153844, 0.0289373491449802, 0.0528465384615384, 0.259021620530321, 0.239216923076923, 0.630760495961333, 0.565895769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1320); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1335, '2025-05-25 00:00:00', 0.0173509231011367, 0.0275073076923077, 0.0241064773963664, 0.038502692307692, 0.188470344679311, 0.0879865384615379, 0.261614837080127, 0.241202692307692, 0.629631749155135, 0.568481923076922 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1335); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1350, '2025-05-25 00:00:00', 0.0196844917012979, 0.0271384615384614, 0.0207848867319874, 0.0345073076923072, 0.185101684955968, 0.0884915384615386, 0.257095526682204, 0.24102, 0.629921963572902, 0.572843461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1350); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1365, '2025-05-25 00:00:00', 0.0118223858583879, 0.0244407692307688, 0.178538669238735, 0.0722184615384609, 0.182836184629427, 0.101964615384616, 0.252362785755866, 0.240272307692308, 0.629525275572121, 0.573848076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1365); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1380, '2025-05-25 00:00:00', 0.17993529665453, 0.0616169230769226, 0.180772718554372, 0.0744184615384626, 0.182105924230927, 0.11282, 0.252619968356544, 0.239227307692308, 0.629525275572121, 0.573848076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1380); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1395, '2025-05-25 00:00:00', 0.0479496541112093, 0.0346342307692318, 0.0739417283302303, 0.0623926923076927, 0.15948619884347, 0.175501538461539, 0.252514544023477, 0.239409230769231, 0.631552104716992, 0.578632692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1395); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1410, '2025-05-25 00:00:00', 0.0590007884914717, 0.0424711538461539, 0.0625772399470018, 0.0634607692307689, 0.163035429216616, 0.172529615384616, 0.251722413439578, 0.240110384615385, 0.634457376095027, 0.58269423076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1410); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 2, 1425, '2025-05-25 00:00:00', 0.0407167571236545, 0.0437175999999997, 0.16240172339295, 0.1534312, 0.182585339613197, 0.163586, 0.255954108417895, 0.2349708, 0.644305265344776, 0.595145199999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 2 and fromtime = 1425); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 0, '2025-05-25 00:00:00', 0.169834322174306, 0.118573333333334, 0.171818097327912, 0.125080416666667, 0.203978644816815, 0.1409325, 0.261281836321058, 0.222675, 0.657513200581518, 0.592047916666666 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 0); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 15, '2025-05-25 00:00:00', 0.079261199930942, 0.0411333333333337, 0.117160119209362, 0.0654312500000002, 0.230043003002163, 0.144510416666667, 0.253334932665265, 0.203172916666667, 0.666646203977445, 0.601269166666666 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 15); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 30, '2025-05-25 00:00:00', 0.093872204325494, 0.0389816666666668, 0.152481918776041, 0.0715366666666665, 0.241010123456869, 0.155054999999999, 0.261715329711114, 0.203098333333333, 0.666906424509462, 0.602012083333333 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 30); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 45, '2025-05-25 00:00:00', 0.115464902590587, 0.0466220833333336, 0.224354683616563, 0.132447916666666, 0.232831794811967, 0.149263333333332, 0.262908428797193, 0.2034075, 0.666881904852808, 0.601981249999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 45); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 60, '2025-05-25 00:00:00', 0.227772010972435, 0.117052083333334, 0.232866424232007, 0.133050416666667, 0.23136093187565, 0.13887625, 0.263721214442641, 0.196435833333333, 0.667842160934016, 0.601185833333333 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 60); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 75, '2025-05-25 00:00:00', 0.079131245958575, 0.0590749999999997, 0.0879670800486334, 0.0731437499999992, 0.169450015800801, 0.12692875, 0.23956212414415, 0.18663875, 0.676390203031018, 0.612815416666666 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 75); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 90, '2025-05-25 00:00:00', 0.0560030147464267, 0.0428454166666663, 0.060237814160969, 0.0540787500000001, 0.147561548779076, 0.119827916666666, 0.201526568751771, 0.165344583333333, 0.675606927678763, 0.616828333333333 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 90); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 105, '2025-05-25 00:00:00', 0.0156941656287493, 0.0267556521739125, 0.0943788130910446, 0.0861917391304348, 0.126549554414584, 0.110270434782609, 0.171048688571574, 0.155764347826087, 0.689786392252243, 0.623499999999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 105); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 120, '2025-05-25 00:00:00', 0.047206105888456, 0.0540462499999999, 0.0941060627773216, 0.0732958333333326, 0.0980266759159118, 0.085207916666666, 0.121813679177597, 0.132, 0.675376147333304, 0.617359583333332 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 120); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 135, '2025-05-25 00:00:00', 0.0897309811496554, 0.0481470833333336, 0.0941264996146693, 0.0586758333333327, 0.0929547730598141, 0.0716354166666671, 0.192777933199846, 0.147283750000001, 0.675785491218408, 0.616577499999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 135); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 150, '2025-05-25 00:00:00', 0.0889663447103636, 0.0504029166666656, 0.0873541796574336, 0.0592791666666675, 0.0868426436481353, 0.0758258333333351, 0.190402587954625, 0.146000416666668, 0.676139467086484, 0.615009583333332 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 150); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 165, '2025-05-25 00:00:00', 0.0218366421046318, 0.0390991666666671, 0.0242595297127544, 0.0473908333333339, 0.0364203893538816, 0.0675904166666668, 0.178684187811154, 0.136462083333333, 0.677706900207167, 0.611128333333332 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 165); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 180, '2025-05-25 00:00:00', 0.0172121999831775, 0.0314974999999998, 0.0249878036191682, 0.0471158333333343, 0.0399383579175728, 0.0669662499999995, 0.178486199904476, 0.133652083333333, 0.677706997928935, 0.610836249999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 180); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 195, '2025-05-25 00:00:00', 0.0226177274964005, 0.0354933333333346, 0.0256553163685606, 0.050611666666667, 0.0403830313387774, 0.0654712499999999, 0.177124540585251, 0.132769166666666, 0.677732194296041, 0.609788749999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 195); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 210, '2025-05-25 00:00:00', 0.0185158996893027, 0.0366325000000002, 0.0237555218142368, 0.049995833333333, 0.040687311093976, 0.0648283333333334, 0.176786981494413, 0.131622083333333, 0.677740886433228, 0.609599583333332 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 210); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 225, '2025-05-25 00:00:00', 0.0187253038906466, 0.0346216666666666, 0.0301541089564342, 0.0497500000000004, 0.0377829141830887, 0.0646529166666673, 0.176264481037339, 0.132418333333333, 0.678690973522785, 0.612307499999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 225); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 240, '2025-05-25 00:00:00', 0.0271096690997083, 0.0367975000000002, 0.0301486051663803, 0.0494275000000005, 0.0417735401656483, 0.0649783333333342, 0.175874182867399, 0.133095833333333, 0.678459739787351, 0.611640833333333 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 240); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 255, '2025-05-25 00:00:00', 0.0226883613103557, 0.0323745833333341, 0.0260589050921446, 0.0429804166666677, 0.0444384440705684, 0.0629137500000002, 0.175007964978161, 0.132983333333333, 0.678475436253826, 0.611477916666666 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 255); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 270, '2025-05-25 00:00:00', 0.0201352352809408, 0.0327695833333337, 0.0379788483252018, 0.0494537500000002, 0.0407447647721835, 0.0634504166666667, 0.174126332971374, 0.137165833333334, 0.678355390744405, 0.611862916666666 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 270); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 285, '2025-05-25 00:00:00', 0.0355796272515925, 0.0372716666666664, 0.0388181740805673, 0.048912916666666, 0.038388953383073, 0.0592787499999992, 0.173530503243081, 0.137524166666667, 0.67808163296501, 0.612869166666666 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 285); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 300, '2025-05-25 00:00:00', 0.0214598690135732, 0.0324095833333331, 0.0218043588540508, 0.0424870833333332, 0.0257355586034277, 0.0522412499999992, 0.173947085256937, 0.143585416666667, 0.678488283305327, 0.612099999999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 300); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 315, '2025-05-25 00:00:00', 0.0149096778948276, 0.0315891666666669, 0.0159317424411181, 0.0381279166666667, 0.181067600875906, 0.0846250000000002, 0.187675940517893, 0.157913333333333, 0.680313403576788, 0.608334166666666 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 315); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 330, '2025-05-25 00:00:00', 0.0148860807467913, 0.0279999999999996, 0.0203172877768833, 0.0368749999999996, 0.18105243592292, 0.086568333333334, 0.18824408844145, 0.16971625, 0.679832267099521, 0.609453749999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 330); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 345, '2025-05-25 00:00:00', 0.0166924552079544, 0.0273049999999992, 0.18278204034391, 0.0744512500000001, 0.180828306748579, 0.0876120833333331, 0.199970529991388, 0.180382916666667, 0.679558668753138, 0.608824166666666 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 345); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 360, '2025-05-25 00:00:00', 0.18422094861474, 0.0668004166666665, 0.183050370140337, 0.0758254166666671, 0.180540710299263, 0.0900316666666668, 0.216662069209307, 0.189690833333333, 0.679401461874423, 0.608323333333333 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 360); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 375, '2025-05-25 00:00:00', 0.062796923953097, 0.0390683333333346, 0.0609511280822006, 0.0501633333333332, 0.0736632675850345, 0.0674399999999998, 0.165637315605556, 0.191910833333334, 0.679198764584318, 0.609429583333333 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 375); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 390, '2025-05-25 00:00:00', 0.0230847459477254, 0.0318879166666663, 0.0254663935412931, 0.0427150000000003, 0.0487168371464931, 0.0607529166666666, 0.232210702576611, 0.214832083333334, 0.676727790252344, 0.622250416666666 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 390); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 405, '2025-05-25 00:00:00', 0.0155618436594028, 0.0261495833333335, 0.0347799106494341, 0.0452924999999986, 0.0536879982270073, 0.0584866666666664, 0.456996591562584, 0.265679583333334, 0.697040719079518, 0.656161249999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 405); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 420, '2025-05-25 00:00:00', 0.0191994816458941, 0.032614583333333, 0.030460126751856, 0.0444300000000002, 0.034473193902308, 0.0561625000000007, 0.626090092475094, 0.301964583333334, 0.697030373035926, 0.656177083333332 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 420); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 435, '2025-05-25 00:00:00', 0.0192880335687502, 0.031182916666667, 0.0246441455551797, 0.0413383333333339, 0.0237376575671516, 0.0589529166666676, 0.623355179303932, 0.311722083333334, 0.696935342412497, 0.656685833333332 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 435); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 450, '2025-05-25 00:00:00', 0.026269432103558, 0.0327774999999996, 0.0255786084729612, 0.0454412500000002, 0.0274756117812438, 0.066605833333333, 0.622450640038276, 0.314878333333333, 0.696282543599752, 0.659629999999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 450); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 465, '2025-05-25 00:00:00', 0.0225058575789133, 0.035730833333333, 0.0231248279272874, 0.0471716666666667, 0.0303900392452214, 0.0664962499999995, 0.622140227908812, 0.315147916666666, 0.696461011470398, 0.658538749999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 465); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 480, '2025-05-25 00:00:00', 0.0178830789536455, 0.0364820833333341, 0.0280978875759703, 0.0535191666666674, 0.0393392603408684, 0.0755995833333332, 0.61822242075948, 0.320639166666667, 0.695265528842832, 0.659016666666666 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 480); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 495, '2025-05-25 00:00:00', 0.0260802158865368, 0.042217916666667, 0.0294190717372944, 0.0540908333333331, 0.0615092963266655, 0.0958104166666658, 0.617754684699304, 0.323016250000001, 0.697897018587717, 0.660623333333333 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 495); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 510, '2025-05-25 00:00:00', 0.0184982493296229, 0.0381224999999998, 0.0350705088130446, 0.0575166666666664, 0.0638719977980769, 0.10428625, 0.618813971594518, 0.321403333333334, 0.698347751672953, 0.662038333333333 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 510); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 525, '2025-05-25 00:00:00', 0.0282389817649864, 0.0397695833333334, 0.05613354363493, 0.0773241666666668, 0.0678483295053501, 0.110689166666668, 0.618571746947401, 0.320485416666668, 0.700605761323599, 0.670757916666667 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 525); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 540, '2025-05-25 00:00:00', 0.0520112550249988, 0.0607266666666666, 0.0531523272408963, 0.0786295833333333, 0.071433910222738, 0.110459166666667, 0.619677937872027, 0.31044375, 0.701385921875966, 0.666426666666667 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 540); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 555, '2025-05-25 00:00:00', 0.02148683610739, 0.0413904166666663, 0.0325013017771624, 0.0641545833333336, 0.101929552853565, 0.105948333333333, 0.621972101034313, 0.295199583333332, 0.707643812112817, 0.674362916666666 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243198780300 and enddate = '2025-05-25 00:00:00' and dayofweek = 3 and fromtime = 555); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243198780300, 3, 570, '2025-05-25 00:00:00', 0.0253620541581942, 0.0450479166666667, 0.0375114326316623, 0.0656895833333326, 0.221750949303967, 0.135939583333333, 0.622795360211885, 0.289253333333333, 0.709652002593372, 0.6704625 where not exists (select 1 from powerstats_trumpet[...];

[ Date: 2025-05-25 14:51:10 - Database: acaweb_fx - User: pgperfstats - Remote: 192.168.3.100 - Application: [unknown] ]

WITH rar_max as ( SELECT resultuid FROM relevance_keylevels_results ORDER BY resultuid DESC LIMIT 1 ), kr AS ( SELECT a.*, rr.age, rr.relevant from keylevels_results a LEFT OUTER JOIN relevance_keylevels_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_keylevels_results) END ), all_results AS ( SELECT kr.resultuid AS resultuid, kr.direction AS direction, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, p.patternname AS pattern_name, kr.breakout AS breakout, kr.atbaridentified AS identified, dtt.timezone AS timezone, kr.patternlengthbars AS length, g.basegroupname, newLevels.filtered, CASE WHEN kr.age IS NOT NULL THEN kr.age WHEN kr.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN kr.relevant IS NOT NULL THEN kr.relevant WHEN kr.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant, cps.pip FROM kr INNER JOIN brokersymbollist bsl ON bsl.brokerid = '689' AND bsl.symbolid = kr.symbolid INNER JOIN symbols s ON bsl.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN symbolgroup sg on s.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN hrspatterns p ON kr.patternid = p.patternid INNER JOIN downloadersymbolsettings dss ON s.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN relevance_keylevels_results rar ON rar.resultuid = kr.resultuid LEFT JOIN LATERAL calc_kl_signal_filter (kr.resultuid) newLevels on true LEFT JOIN currencypips cps on cps.symbol = s.symbol LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE kr.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (kr.simulation = 0 OR kr.simulation IS NULL) AND ('7' = 0 OR s.timegranularity in ('15', '30', '60', '120', '240', '480', '1440')) AND ('0' = 0 OR s.exchange in ('')) AND ('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 p.patternname in ('')) AND ('2' = 0 OR kr.patternclassid in ('1', '2')) AND ('400' = 0 OR kr.patternlengthbars <= '400') AND kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('10' = 0 OR age <= '10') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC LIMIT 200;

[ Date: 2025-05-25 14:51:13 - Database: acaweb_fx - User: postgres - Remote: 182.165.1.42 - Application: [unknown] - Bind query: yes ]

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