select powerstats_tdata_add ();

[ Date: 2024-07-21 14:02:29 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2024-07-21 14:17:07 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2024-07-21 14:47:04 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2024-07-21 14:32:04 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2024-07-21 14:02:17 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select * from roundnumber_changes;

[ Date: 2024-07-21 14:06:03 - Database: acaweb_fx - User: postgres - Remote: 192.168.4.119 - Application: [unknown] ]

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: 2024-07-21 14:01: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: 2024-07-21 14:03:22 - 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: 2024-07-21 14:05:13 - 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: 2024-07-21 14:11:13 - 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: 2024-07-21 14:16:13 - 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: 2024-07-21 14:18:13 - 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: 2024-07-21 14:20:13 - 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: 2024-07-21 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: 2024-07-21 14:31:13 - 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: 2024-07-21 14:33:13 - 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: 2024-07-21 14:35:13 - 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: 2024-07-21 14:41:13 - 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: 2024-07-21 14:46: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: 2024-07-21 14:48:13 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select powerstats_tdata_add ();

[ Date: 2024-07-21 14:02:39 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2024-07-21 14:02:26 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 0, '2024-07-21 00:00:00', 0.0502914123270218, 0.0858846153846166, 0.0537700087981603, 0.115423076923077, 0.0486694502189565, 0.140346153846156, 0.161165872508851, 0.386038461538464, 1.02257236493975, 0.965807692307697 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 0); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 15, '2024-07-21 00:00:00', 0.0520619305768108, 0.0692692307692336, 0.0485309734562975, 0.0961538461538472, 0.0798934001317725, 0.185346153846161, 0.176487946853648, 0.406346153846158, 1.02447586674283, 0.961807692307699 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 15); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 30, '2024-07-21 00:00:00', 0.0411096095821888, 0.0599999999999979, 0.0446053635960798, 0.0830384615384601, 0.106894829694352, 0.206230769230776, 0.174822265788388, 0.402230769230771, 1.02589945826165, 0.959461538461545 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 30); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 45, '2024-07-21 00:00:00', 0.0438945765004499, 0.061576923076923, 0.0713679630776028, 0.163884615384623, 0.111901089566432, 0.210576923076929, 0.41361578046075, 0.472576923076927, 1.02629796543019, 0.958076923076931 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 45); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 60, '2024-07-21 00:00:00', 0.0692508928018006, 0.139615384615387, 0.0956333704229968, 0.177692307692312, 0.107409675828293, 0.201961538461543, 0.408009826427675, 0.463461538461539, 1.02414824422729, 0.947115384615389 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 60); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 75, '2024-07-21 00:00:00', 0.0454411030472868, 0.0824230769230769, 0.0578986515054888, 0.111576923076923, 0.0732039511333808, 0.164461538461541, 0.380131944704224, 0.437153846153848, 1.02654231356455, 0.934807692307698 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 75); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 90, '2024-07-21 00:00:00', 0.0401439141857656, 0.0794230769230747, 0.0480332577091548, 0.104923076923077, 0.0799076004857124, 0.17523076923077, 0.378603677498496, 0.433230769230769, 1.0260925111989, 0.929807692307698 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 90); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 105, '2024-07-21 00:00:00', 0.0347798571236084, 0.0700384615384615, 0.0638023028279858, 0.126423076923078, 0.104562208204568, 0.184153846153849, 0.376266503343656, 0.430807692307694, 1.02379447456697, 0.92761538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 105); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 120, '2024-07-21 00:00:00', 0.0557537580658186, 0.0988076923076951, 0.0799427198782873, 0.134038461538464, 0.11972671445357, 0.19438461538462, 0.377516787196787, 0.432269230769233, 1.02289812110193, 0.927615384615389 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 120); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 135, '2024-07-21 00:00:00', 0.0487586363158823, 0.0827307692307685, 0.0711899841702044, 0.122423076923079, 0.105812402937392, 0.20376923076923, 0.376499187863054, 0.42796153846154, 1.02290753022188, 0.931153846153851 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 135); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 150, '2024-07-21 00:00:00', 0.0535947184539104, 0.083076923076923, 0.0852999143294754, 0.131346153846156, 0.0966670813430546, 0.213730769230768, 0.380376495674402, 0.431038461538462, 1.0232748792292, 0.934961538461543 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 150); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 165, '2024-07-21 00:00:00', 0.0543561050282883, 0.0998846153846168, 0.0668372650547585, 0.165499999999998, 0.0766985307250728, 0.204769230769229, 0.378688792464818, 0.420807692307692, 1.02279425406767, 0.931384615384619 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 165); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 180, '2024-07-21 00:00:00', 0.0495164463742956, 0.123038461538461, 0.0635140808131443, 0.155961538461539, 0.100172658637284, 0.226807692307693, 0.379417367105855, 0.415538461538464, 1.02371578086889, 0.923000000000003 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 180); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 195, '2024-07-21 00:00:00', 0.0577331393968439, 0.104346153846155, 0.0592238647324349, 0.137115384615385, 0.105220998196834, 0.243461538461539, 0.43887374038555, 0.418999999999999, 1.02398302945673, 0.922269230769232 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 195); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 210, '2024-07-21 00:00:00', 0.0377920626587109, 0.0929999999999981, 0.0742558674190393, 0.161576923076923, 0.100488813001556, 0.22680769230769, 0.664573817165215, 0.450961538461536, 1.02510630743278, 0.914307692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 210); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 225, '2024-07-21 00:00:00', 0.0640162960022369, 0.127615384615387, 0.094688517702071, 0.19065384615385, 0.375274726034142, 0.287000000000001, 0.843931653266199, 0.483653846153848, 1.02426703849819, 0.912615384615387 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 225); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 240, '2024-07-21 00:00:00', 0.0855310739754007, 0.130730769230768, 0.0860019409441114, 0.156576923076923, 0.367782136597199, 0.2625, 0.930165652740663, 0.483307692307692, 1.02403743321003, 0.911230769230771 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 240); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 255, '2024-07-21 00:00:00', 0.0332661990615119, 0.0940000000000017, 0.344754976535734, 0.198923076923078, 0.345052363919093, 0.230423076923075, 0.962403085230686, 0.46746153846154, 1.02636408969497, 0.904730769230773 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 255); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 270, '2024-07-21 00:00:00', 0.334960213481223, 0.156230769230769, 0.33206189413792, 0.181307692307691, 0.330626977818719, 0.208961538461536, 0.961765165643963, 0.459923076923078, 1.02685045948953, 0.912115384615388 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 270); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 285, '2024-07-21 00:00:00', 0.0763776145215382, 0.0844999999999968, 0.0795646616571462, 0.116153846153843, 0.0925818805997422, 0.162269230769233, 0.844449723420297, 0.430153846153849, 0.915943314504023, 0.892346153846157 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 285); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 300, '2024-07-21 00:00:00', 0.0528793110626601, 0.0866923076923052, 0.0745069227552794, 0.114192307692306, 0.0834396788105015, 0.159500000000004, 0.84655723146982, 0.421884615384622, 0.916078995585995, 0.892384615384619 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 300); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 315, '2024-07-21 00:00:00', 0.0461571396260774, 0.0751923076923104, 0.0588749391637777, 0.115538461538466, 0.0643800733624465, 0.148923076923081, 0.845631518224921, 0.421230769230775, 0.913698300652565, 0.909769230769235 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 315); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 330, '2024-07-21 00:00:00', 0.0448307758302142, 0.0829615384615411, 0.051629463859913, 0.105192307692313, 0.0708534022851748, 0.142730769230773, 0.846080429891954, 0.422423076923081, 0.914426320369561, 0.91115384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 330); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 345, '2024-07-21 00:00:00', 0.041201642984417, 0.0731538461538467, 0.055377807273863, 0.105307692307693, 0.068694238925385, 0.140538461538464, 0.847049529929535, 0.417884615384619, 0.917398093271651, 0.91469230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 345); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 360, '2024-07-21 00:00:00', 0.033801797858419, 0.0698076923076911, 0.0481366644205688, 0.0964615384615377, 0.0579904634069609, 0.131423076923076, 0.849367196120827, 0.406923076923078, 0.921040465159669, 0.908538461538464 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 360); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 375, '2024-07-21 00:00:00', 0.0377348849006013, 0.061192307692308, 0.0372259834813546, 0.0854230769230771, 0.342192100794502, 0.192076923076922, 0.847840860430414, 0.419269230769233, 0.920299008266001, 0.909769230769235 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 375); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 390, '2024-07-21 00:00:00', 0.0265211961674806, 0.0625769230769224, 0.0453501420572801, 0.0896538461538457, 0.570788836072165, 0.236846153846152, 0.845150223333107, 0.431500000000003, 0.918854731968845, 0.911461538461543 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 390); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 405, '2024-07-21 00:00:00', 0.0429343147682043, 0.0636538461538462, 0.346750171648785, 0.159807692307691, 0.75348578262326, 0.268230769230768, 0.949371276971481, 0.456307692307696, 0.9159073349165, 0.928384615384619 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 405); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 420, '2024-07-21 00:00:00', 0.351308404944453, 0.129653846153848, 0.577809807675636, 0.199576923076923, 0.840530236494522, 0.273038461538458, 0.948368208272261, 0.462538461538465, 0.915959703514046, 0.926538461538465 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 420); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 435, '2024-07-21 00:00:00', 0.31214073748872, 0.117999999999995, 0.489245945700746, 0.177653846153843, 0.599380675235827, 0.226076923076924, 0.678388947887114, 0.415269230769234, 0.67254943312741, 0.873500000000003 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 435); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 450, '2024-07-21 00:00:00', 0.310548955635265, 0.120423076923076, 0.392101493925311, 0.152692307692303, 0.416831522874097, 0.195961538461538, 0.497957695144723, 0.383884615384617, 0.524225013343874, 0.839769230769233 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 450); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 465, '2024-07-21 00:00:00', 0.233976622763897, 0.0984999999999981, 0.323400518528679, 0.146846153846154, 0.317998461534744, 0.182307692307693, 0.491100534905649, 0.386153846153848, 0.521718857387622, 0.847615384615387 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 465); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 480, '2024-07-21 00:00:00', 0.32744985053499, 0.123269230769233, 0.324067761195335, 0.147923076923077, 0.35001569415363, 0.188115384615388, 0.492059095888037, 0.39092307692308, 0.521805824480274, 0.847961538461542 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 480); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 495, '2024-07-21 00:00:00', 0.157984225113191, 0.0911538461538441, 0.190472529818306, 0.126769230769232, 0.27214944141324, 0.192961538461542, 0.492963735598659, 0.391269230769235, 0.527510677981608, 0.856346153846158 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 495); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 510, '2024-07-21 00:00:00', 0.19423470734774, 0.100807692307695, 0.272577373630654, 0.137769230769235, 0.321245137646531, 0.214038461538464, 0.492276184208074, 0.393807692307697, 0.535625881203835, 0.863269230769234 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 510); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 525, '2024-07-21 00:00:00', 0.0886546020324884, 0.0809615384615392, 0.0997183109487006, 0.131692307692308, 0.146236799535758, 0.179192307692308, 0.493024049967296, 0.390923076923078, 0.537299035776309, 0.871576923076924 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 525); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 540, '2024-07-21 00:00:00', 0.0683203765077025, 0.106076923076925, 0.109990992638208, 0.146461538461539, 0.111988103763815, 0.181153846153846, 0.494752987319469, 0.392961538461541, 0.553033231718143, 0.891653846153848 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 540); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 555, '2024-07-21 00:00:00', 0.0831646837027875, 0.0922692307692308, 0.0848476372002264, 0.121192307692307, 0.353023775621199, 0.242115384615382, 0.511254139723694, 0.417653846153846, 0.55610067295548, 0.892038461538463 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 555); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 570, '2024-07-21 00:00:00', 0.0768798062912798, 0.0882307692307686, 0.0725697224425225, 0.120730769230769, 0.372021835587436, 0.250615384615381, 0.511148986259237, 0.413615384615385, 0.559965647297979, 0.895615384615386 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 570); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 585, '2024-07-21 00:00:00', 0.0291366013539933, 0.082692307692309, 0.347606667635441, 0.19934615384615, 0.493750259201491, 0.27203846153846, 0.501829514415464, 0.405307692307692, 0.551267787782082, 0.898576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 585); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 600, '2024-07-21 00:00:00', 0.351818364413318, 0.174192307692305, 0.367526534887146, 0.21207692307692, 0.493601115819709, 0.276692307692307, 0.502571565512353, 0.404538461538463, 0.550568954669759, 0.901423076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 600); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 615, '2024-07-21 00:00:00', 0.119344646362476, 0.115769230769233, 0.245663221629815, 0.174538461538461, 0.239941146630074, 0.22707692307692, 0.300082932126847, 0.346384615384618, 0.537444192451642, 0.8945 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 615); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 630, '2024-07-21 00:00:00', 0.150750634645945, 0.124076923076923, 0.214184065341366, 0.166423076923075, 0.256118256940936, 0.218192307692308, 0.303088128843994, 0.33542307692308, 0.53805432382299, 0.901153846153849 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 630); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 645, '2024-07-21 00:00:00', 0.0957488140115351, 0.103653846153847, 0.120884153062089, 0.146461538461538, 0.151526103361768, 0.182, 0.276637268750142, 0.320461538461544, 0.477457788710162, 0.879500000000003 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 645); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 660, '2024-07-21 00:00:00', 0.0801370364774284, 0.102230769230767, 0.0984716124654128, 0.130461538461538, 0.152146250490975, 0.176807692307693, 0.285541033020584, 0.322807692307693, 0.483754235123577, 0.881000000000002 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 660); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 675, '2024-07-21 00:00:00', 0.0441989383791736, 0.0821153846153832, 0.157104418975215, 0.133038461538458, 0.155933042829783, 0.165923076923074, 0.280564280307768, 0.324653846153847, 0.491917823030821, 0.885230769230771 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 675); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 690, '2024-07-21 00:00:00', 0.157514057980676, 0.0939615384615356, 0.155628037814033, 0.123615384615385, 0.156127270569192, 0.16173076923077, 0.285703689968361, 0.351038461538464, 0.490808983680552, 0.88546153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 690); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 705, '2024-07-21 00:00:00', 0.0520339681953405, 0.0754230769230752, 0.0907176176596718, 0.116615384615385, 0.0923457716328244, 0.145692307692309, 0.249347866366524, 0.380038461538463, 0.492123180327225, 0.886230769230771 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 705); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 720, '2024-07-21 00:00:00', 0.0911637326673611, 0.0928846153846184, 0.0915312220795987, 0.115269230769235, 0.0934327648015489, 0.140807692307696, 0.252242182161387, 0.386961538461542, 0.497403411574703, 0.884923076923078 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 720); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 735, '2024-07-21 00:00:00', 0.0364284757594088, 0.0680769230769246, 0.0407640301472523, 0.0911153846153846, 0.174133163014796, 0.16496153846154, 0.238485090648323, 0.378461538461541, 0.506080189754092, 0.882038461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 735); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 750, '2024-07-21 00:00:00', 0.0287206170921509, 0.0619230769230774, 0.0438480768809064, 0.0824230769230769, 0.186475306676244, 0.171000000000002, 0.233954144093369, 0.37769230769231, 0.518831712748791, 0.886884615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 750); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 765, '2024-07-21 00:00:00', 0.0351127634037272, 0.0631153846153832, 0.174071002312713, 0.133923076923078, 0.184082143035697, 0.172653846153846, 0.234539814563292, 0.383730769230772, 0.518460640149872, 0.887653846153848 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 765); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 780, '2024-07-21 00:00:00', 0.17011494756374, 0.113153846153846, 0.180968985868167, 0.145423076923079, 0.179703088454259, 0.166000000000001, 0.247471126520931, 0.388961538461543, 0.520200152308259, 0.887038461538463 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 780); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 795, '2024-07-21 00:00:00', 0.0927772518537752, 0.0794615384615386, 0.0952454642570376, 0.103461538461538, 0.0975541585282475, 0.140576923076926, 0.260179582951113, 0.403153846153848, 0.514650909317701, 0.86396153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 795); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 810, '2024-07-21 00:00:00', 0.0306746700816098, 0.0651538461538446, 0.0450966142341637, 0.0872307692307682, 0.0564027822554396, 0.119923076923077, 0.22796623569157, 0.390269230769233, 0.524492893550154, 0.863346153846155 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 810); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 825, '2024-07-21 00:00:00', 0.0318552736848787, 0.0619615384615392, 0.0405502347522404, 0.0911923076923135, 0.0911526192712, 0.135000000000003, 0.221042996165558, 0.400384615384617, 0.542831773062477, 0.867423076923078 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 825); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 840, '2024-07-21 00:00:00', 0.024981993515333, 0.0645000000000041, 0.0334552743915718, 0.0811538461538445, 0.107215268717445, 0.148076923076923, 0.218502680849597, 0.423307692307691, 0.54284288703086, 0.867 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 840); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 855, '2024-07-21 00:00:00', 0.0254404886261742, 0.0534615384615347, 0.0838258634588159, 0.0981538461538448, 0.105879583271973, 0.151615384615383, 0.224965118663726, 0.444769230769232, 0.541884023924506, 0.871153846153845 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 855); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 870, '2024-07-21 00:00:00', 0.0745387560524478, 0.0808846153846157, 0.0972984069756548, 0.118500000000001, 0.102857840656971, 0.191846153846154, 0.220269698324574, 0.442500000000002, 0.542100752770041, 0.871884615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 870); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 885, '2024-07-21 00:00:00', 0.0416562674202172, 0.076269230769232, 0.0567860762999035, 0.115538461538462, 0.12281262776466, 0.226307692307693, 0.207696138996002, 0.431615384615386, 0.54237424490702, 0.871692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 00:00:00' and dayofweek = 1 and fromtime = 885); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840241630275300, 1, 900, '2024-07-21 00:00:00', 0.0431802661480406, 0.0858461538461538, 0.0737782123352454, 0.143769230769231, 0.125220623762161, 0.231269230769236, 0.213274153650611, 0.434769230769232, 0.543130487225533, 0.869615384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 915, '2024-07-21 00:00:00', 0.0489604550003987, 0.0986153846153865, 0.10406950340259, 0.169692307692311, 0.102685898964534, 0.207076923076929, 0.198195474604861, 0.419384615384619, 0.553047413463314, 0.869807692307695 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 930, '2024-07-21 00:00:00', 0.088937532096323, 0.121730769230772, 0.0890268412420577, 0.149538461538467, 0.0894120022918974, 0.186115384615388, 0.188232131647639, 0.401153846153848, 0.548247467986716, 0.857384615384617 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 945, '2024-07-21 00:00:00', 0.0362380165869248, 0.0930769230769226, 0.0487245318089394, 0.126000000000001, 0.0746077331524913, 0.179076923076921, 0.291217212086414, 0.44476923076923, 0.58627770264217, 0.923230769230768 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 960, '2024-07-21 00:00:00', 0.0384635691771611, 0.0936153846153856, 0.0522300826962931, 0.12730769230769, 0.0828967940365513, 0.192961538461538, 0.348629854408102, 0.446153846153846, 0.597009497411891, 0.933499999999997 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 975, '2024-07-21 00:00:00', 0.0350179075067879, 0.0935769230769206, 0.0615046839992368, 0.135884615384611, 0.145181822341718, 0.239192307692305, 0.344279137641804, 0.44473076923077, 0.597628328027995, 0.934538461538459 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 990, '2024-07-21 00:00:00', 0.0584243495075844, 0.107730769230768, 0.078068697558378, 0.14719230769231, 0.154923186922274, 0.234923076923077, 0.344493405094851, 0.435115384615387, 0.593450588961255, 0.938192307692306 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1005, '2024-07-21 00:00:00', 0.0411706392768154, 0.0983076923076938, 0.133641380049515, 0.18046153846154, 0.165975906499895, 0.23819230769231, 0.346505517771583, 0.425076923076925, 0.593852000469426, 0.931961538461536 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1020, '2024-07-21 00:00:00', 0.108880032781322, 0.132692307692307, 0.118715432215672, 0.156923076923078, 0.16583606362912, 0.229999999999999, 0.343614589553246, 0.407884615384617, 0.579303560652457, 0.931846153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1035, '2024-07-21 00:00:00', 0.0565638101208259, 0.0907692307692346, 0.111499299756343, 0.148423076923078, 0.128426381186327, 0.221153846153847, 0.33091246344243, 0.378461538461541, 0.575069752290971, 0.946499999999996 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1050, '2024-07-21 00:00:00', 0.105391438858263, 0.110653846153848, 0.106946830787006, 0.154769230769231, 0.116631813841676, 0.198500000000002, 0.32393029877049, 0.355038461538464, 0.572724330251071, 0.949038461538458 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1065, '2024-07-21 00:00:00', 0.0466065858667435, 0.112576923076923, 0.0734341777480934, 0.152461538461542, 0.0708199015922666, 0.169461538461542, 0.314325722778139, 0.328500000000003, 0.568595830499607, 0.947461538461536 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1080, '2024-07-21 00:00:00', 0.0638309907851584, 0.100653846153849, 0.0639118623875543, 0.113615384615388, 0.0719972328528048, 0.146807692307696, 0.313145323845261, 0.307923076923078, 0.56672125966285, 0.952884615384611 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1095, '2024-07-21 00:00:00', 0.0289301812060578, 0.0676538461538467, 0.0357991834887576, 0.0916923076923083, 0.0511609827294834, 0.129384615384617, 0.315905577421725, 0.293423076923078, 0.573373171543765, 0.949923076923074 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1110, '2024-07-21 00:00:00', 0.0296647161559944, 0.0666538461538463, 0.038908037532308, 0.0913461538461549, 0.0660799166510929, 0.129653846153849, 0.319634351191387, 0.292038461538461, 0.578755977540157, 0.953192307692305 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1125, '2024-07-21 00:00:00', 0.0322440930786021, 0.0631923076923066, 0.0403969534266394, 0.0979230769230766, 0.262912003412665, 0.188807692307691, 0.320190664352447, 0.285307692307693, 0.587958962461209, 0.95830769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1140, '2024-07-21 00:00:00', 0.0354525034377018, 0.0729999999999988, 0.0623085745426635, 0.096961538461539, 0.327012744988044, 0.192846153846153, 0.319293655529732, 0.275038461538461, 0.586257123952124, 0.960153846153845 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1155, '2024-07-21 00:00:00', 0.0465955593790433, 0.0638846153846176, 0.251006064897611, 0.147269230769229, 0.307285434834679, 0.199538461538461, 0.301419931963059, 0.265153846153843, 0.586509414968042, 0.959423076923074 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1170, '2024-07-21 00:00:00', 0.243178316973683, 0.118423076923075, 0.301597867774547, 0.148923076923076, 0.296736508344717, 0.195653846153846, 0.300367531278189, 0.261423076923078, 0.5870854910881, 0.959423076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1185, '2024-07-21 00:00:00', 0.148746232014333, 0.0818076923076916, 0.173050268374869, 0.132653846153848, 0.195704270618861, 0.159192307692305, 0.240987098282171, 0.237307692307691, 0.582317830213548, 0.952846153846152 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1200, '2024-07-21 00:00:00', 0.0632725484283289, 0.0818461538461566, 0.0783281165747866, 0.104576923076924, 0.0878113800229668, 0.127038461538463, 0.153324472430707, 0.21207692307692, 0.537183436653985, 0.932730769230766 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1215, '2024-07-21 00:00:00', 0.052230966352859, 0.0600769230769213, 0.0549176166214838, 0.0767692307692289, 0.107668072547776, 0.118576923076924, 0.145621891845339, 0.207846153846156, 0.528906797082433, 0.927999999999997 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1230, '2024-07-21 00:00:00', 0.0372057067582985, 0.0557692307692303, 0.0508056477781121, 0.0794230769230779, 0.107050850605608, 0.121730769230771, 0.145312125599187, 0.206576923076926, 0.528256243182736, 0.930538461538459 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1245, '2024-07-21 00:00:00', 0.0289769138878123, 0.0503076923076942, 0.107195644285791, 0.0908846153846186, 0.105469879039541, 0.119846153846155, 0.146348356801373, 0.196807692307694, 0.534107122646328, 0.933461538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1260, '2024-07-21 00:00:00', 0.0950955228259379, 0.0669615384615401, 0.0930060130396885, 0.0809615384615392, 0.093235582510939, 0.112923076923075, 0.144514934016685, 0.195615384615385, 0.533609971363413, 0.933192307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1275, '2024-07-21 00:00:00', 0.0254993212579315, 0.0458461538461552, 0.0422523554190959, 0.0726923076923072, 0.0642026119765824, 0.106846153846152, 0.10779079452632, 0.184153846153847, 0.519077957684437, 0.926384615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1290, '2024-07-21 00:00:00', 0.0367444396630804, 0.052923076923076, 0.0480758375262079, 0.0773846153846132, 0.0810185164021156, 0.108999999999997, 0.107648294852336, 0.182346153846153, 0.519616025393899, 0.927576923076922 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1305, '2024-07-21 00:00:00', 0.0498164785835107, 0.0601923076923087, 0.0655315308722555, 0.0866923076923062, 0.0838842150732855, 0.104192307692311, 0.109103592269705, 0.189076923076923, 0.520776650782271, 0.930999999999998 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1320, '2024-07-21 00:00:00', 0.0502789755724565, 0.0621538461538467, 0.073404935906142, 0.0772692307692291, 0.0787197658689469, 0.0961923076923112, 0.105485638832974, 0.184500000000002, 0.525757820820428, 0.932615384615383 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1335, '2024-07-21 00:00:00', 0.0299045918779137, 0.0412692307692278, 0.0444135287774074, 0.060192307692312, 0.0530588787610978, 0.0802692307692271, 0.0890076314792087, 0.18603846153846, 0.518438329542156, 0.92630769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1350, '2024-07-21 00:00:00', 0.0394708266172131, 0.0451153846153891, 0.045373068935387, 0.0606538461538472, 0.0648807663807525, 0.0799230769230738, 0.0913872992353875, 0.190961538461536, 0.516108397976179, 0.924961538461537 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1365, '2024-07-21 00:00:00', 0.0182328950399652, 0.0420384615384633, 0.0243088144823727, 0.0550384615384587, 0.0813148486771282, 0.0867692307692319, 0.0935454887289505, 0.19403846153846, 0.514749313146326, 0.924153846153844 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1380, '2024-07-21 00:00:00', 0.0198432705120756, 0.0416538461538428, 0.0438405502492119, 0.0550769230769226, 0.0769761301663318, 0.088269230769227, 0.0998029828442748, 0.202346153846149, 0.514474082474968, 0.92230769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1395, '2024-07-21 00:00:00', 0.0342211135906572, 0.0347307692307678, 0.0650139866608565, 0.057538461538463, 0.0641580380478813, 0.116576923076923, 0.0932348647234462, 0.219499999999998, 0.512347051849095, 0.91930769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1410, '2024-07-21 00:00:00', 0.0454247137072348, 0.0402692307692307, 0.046470652442819, 0.0631923076923044, 0.0532689547340756, 0.113307692307693, 0.091860839568087, 0.227576923076921, 0.514223610444386, 0.918807692307689 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 1, 1425, '2024-07-21 00:00:00', 0.0306668450384987, 0.0511538461538444, 0.0474798742788776, 0.0994615384615411, 0.0487032458245433, 0.107615384615387, 0.107779489985516, 0.248461538461534, 0.516124791111606, 0.921999999999997 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 0, '2024-07-21 00:00:00', 0.0384450056774404, 0.0654615384615417, 0.042034198531124, 0.0790769230769246, 0.0429077902197106, 0.0910384615384633, 0.136401156097061, 0.281653846153844, 0.516487128441893, 0.92107692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 15, '2024-07-21 00:00:00', 0.0331954584474848, 0.0435384615384595, 0.0337541336499946, 0.053692307692305, 0.0437287618780184, 0.0857307692307665, 0.149881532705511, 0.295923076923076, 0.516801620919105, 0.920346153846151 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 30, '2024-07-21 00:00:00', 0.0206054884398808, 0.0311153846153823, 0.023588523937254, 0.0455384615384614, 0.0424164880858649, 0.0859615384615357, 0.151887043048948, 0.308923076923074, 0.517073742694999, 0.918153846153842 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 45, '2024-07-21 00:00:00', 0.016464974479645, 0.0311538461538495, 0.0374007815632027, 0.070461538461536, 0.0469452217606217, 0.0984230769230757, 0.153296555232508, 0.32007692307692, 0.518098161177381, 0.915769230769228 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 60, '2024-07-21 00:00:00', 0.0346514956942118, 0.062615384615383, 0.0393537213566315, 0.0743461538461525, 0.0554488398990791, 0.105576923076922, 0.171281917856541, 0.329846153846149, 0.518098161177381, 0.915769230769228 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 75, '2024-07-21 00:00:00', 0.0310969699241182, 0.0423076923076921, 0.0391072686535198, 0.0695384615384635, 0.0588550762466578, 0.116999999999998, 0.178808500916482, 0.351000000000001, 0.516079804502544, 0.916269230769229 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 90, '2024-07-21 00:00:00', 0.0309106155526892, 0.0541153846153861, 0.0414941701187752, 0.0746153846153867, 0.0728895159708261, 0.125192307692308, 0.186886049197408, 0.352653846153848, 0.513778922824264, 0.912692307692306 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 105, '2024-07-21 00:00:00', 0.0263820743337925, 0.0484230769230786, 0.0550347722248952, 0.0901153846153798, 0.0752402919881471, 0.121692307692307, 0.196298614752744, 0.353115384615387, 0.513695060697117, 0.910846153846152 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 120, '2024-07-21 00:00:00', 0.0451337840374424, 0.0715384615384555, 0.0670957066149104, 0.0949230769230721, 0.0748479895418804, 0.138307692307692, 0.210923157717539, 0.364461538461537, 0.512941083736344, 0.912346153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 135, '2024-07-21 00:00:00', 0.0290005835485056, 0.059076923076922, 0.0399959421018598, 0.0783461538461552, 0.0525636317677437, 0.145846153846158, 0.210707234003815, 0.366538461538463, 0.512925751112035, 0.915115384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 150, '2024-07-21 00:00:00', 0.0366404778269118, 0.0562692307692316, 0.0459240845141369, 0.10069230769231, 0.0546518632239203, 0.151115384615387, 0.209405815068767, 0.363653846153847, 0.513569259803763, 0.914230769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 165, '2024-07-21 00:00:00', 0.0330474716826481, 0.0821538461538493, 0.0537799648138983, 0.125269230769235, 0.0880237118403498, 0.179423076923079, 0.237161042331994, 0.387000000000002, 0.518030631704935, 0.917153846153845 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 180, '2024-07-21 00:00:00', 0.0493248572066991, 0.0996923076923093, 0.0570479959871833, 0.125076923076923, 0.133681118855511, 0.205807692307694, 0.241669122180272, 0.37973076923077, 0.523762459370804, 0.916076923076922 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 195, '2024-07-21 00:00:00', 0.031700715837585, 0.0798461538461525, 0.0634322897632982, 0.124153846153844, 0.116391150866376, 0.200499999999999, 0.22906933112387, 0.354038461538457, 0.536105065764594, 0.918192307692305 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 210, '2024-07-21 00:00:00', 0.0574569805627181, 0.0932307692307662, 0.0973690205036818, 0.145615384615382, 0.11809766492839, 0.207461538461536, 0.222355584939631, 0.339615384615381, 0.536533404222099, 0.914423076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 225, '2024-07-21 00:00:00', 0.0524446228086222, 0.108038461538463, 0.0877749307122423, 0.149961538461541, 0.106930005862931, 0.194115384615384, 0.235421589102156, 0.323730769230767, 0.529916672694869, 0.906999999999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 240, '2024-07-21 00:00:00', 0.081846770529778, 0.110576923076922, 0.0930857999581357, 0.145384615384611, 0.114688903627968, 0.178769230769226, 0.233490810229307, 0.310961538461533, 0.529234583729545, 0.91026923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 255, '2024-07-21 00:00:00', 0.0417470220034156, 0.0905769230769216, 0.0555494512885725, 0.11930769230769, 0.10284650998155, 0.171730769230768, 0.245072573238715, 0.285615384615383, 0.529327649003904, 0.902999999999998 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 270, '2024-07-21 00:00:00', 0.0415831511737425, 0.0750384615384602, 0.0665584416422591, 0.0991153846153835, 0.112959434515911, 0.153076923076922, 0.26738130939799, 0.281269230769227, 0.523932362046859, 0.911999999999997 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 285, '2024-07-21 00:00:00', 0.0405126381041026, 0.0699230769230763, 0.0886454649800984, 0.122461538461538, 0.105870951925152, 0.149461538461536, 0.300330720270936, 0.300307692307688, 0.521667615957193, 0.925692307692305 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 300, '2024-07-21 00:00:00', 0.0876060500193899, 0.102499999999998, 0.0997726646701629, 0.119769230769229, 0.138770696308139, 0.159115384615378, 0.36337776275047, 0.319961538461534, 0.520314360599585, 0.923076923076921 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 315, '2024-07-21 00:00:00', 0.0641760199643267, 0.0731923076923074, 0.0682427905462437, 0.101038461538461, 0.111596139993899, 0.142461538461537, 0.357993126276941, 0.322961538461538, 0.518742552124478, 0.918653846153845 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 330, '2024-07-21 00:00:00', 0.0580152897618751, 0.0805769230769219, 0.103520848884881, 0.112384615384611, 0.102738300849969, 0.137038461538461, 0.3513441113999, 0.32826923076923, 0.516754250475617, 0.917653846153844 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 345, '2024-07-21 00:00:00', 0.0742203061577731, 0.0775769230769185, 0.0754474345794148, 0.0976538461538446, 0.175181892285173, 0.151153846153843, 0.335860657920005, 0.332692307692307, 0.515142053597469, 0.925846153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 360, '2024-07-21 00:00:00', 0.0486366117240922, 0.0719999999999995, 0.0697356878065049, 0.0991153846153835, 0.173614125621688, 0.146769230769231, 0.327267223205462, 0.341346153846152, 0.515955794170841, 0.926692307692306 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 375, '2024-07-21 00:00:00', 0.0512314206472812, 0.0684615384615374, 0.173778090147705, 0.120230769230767, 0.174835452310494, 0.14234615384615, 0.332682190686544, 0.365999999999999, 0.515993609083859, 0.926730769230768 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 390, '2024-07-21 00:00:00', 0.174028613916037, 0.0939615384615378, 0.176500668989794, 0.112384615384615, 0.172934015873549, 0.135423076923078, 0.336077841257964, 0.395653846153847, 0.515993609083859, 0.926730769230768 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 405, '2024-07-21 00:00:00', 0.0629356325633882, 0.0614230769230783, 0.0731263711245579, 0.0868846153846159, 0.098305465846942, 0.125269230769232, 0.270175350467062, 0.383000000000002, 0.464069397993283, 0.909384615384613 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 420, '2024-07-21 00:00:00', 0.0469861026916945, 0.066423076923076, 0.0497668409841216, 0.0874615384615407, 0.0719217523530844, 0.126461538461538, 0.275389059053101, 0.388423076923082, 0.453421420551993, 0.903769230769229 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 435, '2024-07-21 00:00:00', 0.0408455439618389, 0.0660384615384653, 0.0652442983067344, 0.0975384615384627, 0.0986051956814911, 0.136769230769229, 0.281935846494305, 0.396307692307696, 0.454093389242619, 0.904384615384614 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 450, '2024-07-21 00:00:00', 0.0550680837341684, 0.0764230769230767, 0.0571475418409331, 0.09680769230769, 0.111755557425056, 0.145769230769229, 0.274383930904236, 0.39169230769231, 0.447477011012428, 0.897346153846152 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 465, '2024-07-21 00:00:00', 0.0314160174727159, 0.0636153846153834, 0.0685365708104923, 0.101307692307693, 0.132643791353443, 0.161153846153845, 0.265253008393001, 0.38396153846154, 0.439811807656236, 0.891884615384613 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 480, '2024-07-21 00:00:00', 0.067121348203201, 0.0806538461538476, 0.0878612279940126, 0.109346153846152, 0.223960161292482, 0.181076923076923, 0.264807843248938, 0.385923076923079, 0.441330535470256, 0.893192307692305 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 495, '2024-07-21 00:00:00', 0.051854663761768, 0.0698846153846146, 0.124785113757152, 0.121730769230765, 0.224166023638389, 0.201615384615383, 0.261650195137295, 0.38023076923077, 0.427253758141641, 0.895423076923074 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 510, '2024-07-21 00:00:00', 0.103843736154193, 0.0901923076923066, 0.199353559131663, 0.132192307692306, 0.202445042874887, 0.201653846153843, 0.251747520039726, 0.387576923076925, 0.428540594971424, 0.895807692307691 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 525, '2024-07-21 00:00:00', 0.12480915277088, 0.0877307692307684, 0.140917722857649, 0.147730769230766, 0.163008031892721, 0.205461538461537, 0.242486821212076, 0.37646153846154, 0.429893305188804, 0.893423076923075 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 540, '2024-07-21 00:00:00', 0.0966895826064805, 0.118346153846153, 0.109744907013422, 0.154230769230767, 0.149654185990959, 0.214153846153843, 0.243201100706014, 0.376846153846156, 0.422856265814359, 0.903692307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 555, '2024-07-21 00:00:00', 0.0546419393731706, 0.0946923076923018, 0.127683599332338, 0.151307692307689, 0.134254591670508, 0.208846153846151, 0.225812679346942, 0.359615384615383, 0.406816193611582, 0.917153846153844 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 570, '2024-07-21 00:00:00', 0.093037833495511, 0.102961538461539, 0.0866869167663825, 0.130692307692306, 0.144564981396442, 0.215923076923077, 0.256720779177566, 0.357961538461539, 0.401484700350319, 0.916730769230767 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 585, '2024-07-21 00:00:00', 0.0533816015553615, 0.0916538461538465, 0.0964011171336471, 0.146846153846155, 0.140206468631635, 0.215576923076928, 0.277190212392417, 0.361576923076925, 0.398724296494941, 0.917230769230768 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 600, '2024-07-21 00:00:00', 0.082096865863534, 0.115846153846154, 0.120472173614426, 0.17523076923077, 0.137922966236171, 0.212769230769233, 0.260858207874286, 0.352730769230771, 0.395267654206034, 0.916038461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 615, '2024-07-21 00:00:00', 0.0939887472806421, 0.117730769230769, 0.0998918492093406, 0.145692307692308, 0.126581934547732, 0.197115384615386, 0.232443928722606, 0.3475, 0.401814532417061, 0.923961538461537 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 630, '2024-07-21 00:00:00', 0.0718266288738726, 0.0967692307692315, 0.0851942215447447, 0.131153846153851, 0.119025200951472, 0.18196153846154, 0.235681561564621, 0.32996153846154, 0.403430819538927, 0.929115384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 645, '2024-07-21 00:00:00', 0.0475452820598841, 0.0869230769230788, 0.0728672660495686, 0.130038461538462, 0.0911375967340707, 0.169307692307693, 0.206121700421413, 0.312346153846153, 0.421389299269052, 0.939307692307691 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 660, '2024-07-21 00:00:00', 0.0551028688349888, 0.0953846153846161, 0.0697712305709487, 0.129769230769234, 0.0962639000952002, 0.169538461538464, 0.186373855049878, 0.302576923076926, 0.419462395857438, 0.933692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 675, '2024-07-21 00:00:00', 0.0437212323001768, 0.0831153846153869, 0.0538985514290853, 0.108576923076926, 0.102856315014982, 0.168692307692309, 0.154370642884633, 0.315153846153848, 0.445467691999528, 0.93723076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 690, '2024-07-21 00:00:00', 0.0434302446901492, 0.0798846153846186, 0.0639524943881165, 0.119192307692311, 0.0994023448106028, 0.179884615384616, 0.147585412037077, 0.30742307692308, 0.446646175572845, 0.940615384615386 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 705, '2024-07-21 00:00:00', 0.0612911463050328, 0.09026923076923, 0.0891444894539202, 0.131499999999998, 0.101031906612943, 0.172384615384613, 0.260184552843671, 0.428807692307692, 0.505722356178232, 0.968307692307691 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 720, '2024-07-21 00:00:00', 0.0535261977554348, 0.0914230769230762, 0.0725787423847602, 0.126923076923075, 0.0824272173122799, 0.149615384615385, 0.277173558512463, 0.425307692307689, 0.524759830779757, 0.972999999999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 735, '2024-07-21 00:00:00', 0.0642409406962434, 0.0874615384615374, 0.0646514084563086, 0.108269230769234, 0.0714495733959375, 0.149807692307694, 0.289183497773672, 0.438153846153844, 0.523328142388104, 0.97376923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 750, '2024-07-21 00:00:00', 0.0529252738810554, 0.0747307692307741, 0.0599473230299883, 0.098192307692313, 0.0980362884148184, 0.152076923076929, 0.287510601811214, 0.449884615384615, 0.524631095298253, 0.982884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 765, '2024-07-21 00:00:00', 0.0275862005636615, 0.0669615384615412, 0.0518892459586187, 0.106576923076926, 0.0986800969722956, 0.147192307692309, 0.288301124627601, 0.48146153846154, 0.524797409995953, 0.989192307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 780, '2024-07-21 00:00:00', 0.0466921340764762, 0.0836538461538455, 0.0821413790598006, 0.113384615384618, 0.100127096155913, 0.146653846153847, 0.278275405917346, 0.500807692307694, 0.525350373926406, 0.989846153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 795, '2024-07-21 00:00:00', 0.0756810717113891, 0.0737692307692321, 0.0879927269721765, 0.101999999999999, 0.102986720577873, 0.142769230769231, 0.271955573294896, 0.546076923076922, 0.524447524690359, 0.991615384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 810, '2024-07-21 00:00:00', 0.0376727814414916, 0.0670384615384581, 0.0451276650608714, 0.0848846153846151, 0.093903682241227, 0.135692307692307, 0.276296833134226, 0.559499999999997, 0.524819986720721, 0.990461538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 825, '2024-07-21 00:00:00', 0.0397820987960083, 0.0598461538461521, 0.0894203642268438, 0.102807692307691, 0.0905512774407618, 0.131576923076923, 0.270757152047028, 0.571653846153846, 0.522786769298769, 0.999615384615386 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 840, '2024-07-21 00:00:00', 0.0537565452186667, 0.0736153846153852, 0.0564765982850065, 0.0963846153846176, 0.0725402063580013, 0.134807692307698, 0.274792475543612, 0.58023076923077, 0.523542142892637, 0.998846153846155 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 855, '2024-07-21 00:00:00', 0.033095223917565, 0.0604230769230768, 0.0385597638039356, 0.0848461538461523, 0.100412541355841, 0.168961538461542, 0.284447018184141, 0.589115384615385, 0.524433374810742, 0.997730769230768 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 870, '2024-07-21 00:00:00', 0.0292047677877867, 0.0649615384615371, 0.0764838142756631, 0.109576923076925, 0.10306073638693, 0.177653846153848, 0.290215516735145, 0.594384615384615, 0.524003047554262, 1.00207692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 885, '2024-07-21 00:00:00', 0.0604012735474486, 0.0740769230769259, 0.0916148795439151, 0.130384615384617, 0.280766127696234, 0.312461538461536, 0.293320231933527, 0.593961538461538, 0.528625307173821, 1.00334615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 900, '2024-07-21 00:00:00', 0.0636910934481078, 0.105653846153846, 0.0637495218684973, 0.130192307692308, 0.300223386061881, 0.330192307692304, 0.287671268050076, 0.597038461538463, 0.528701253435829, 1.00084615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 915, '2024-07-21 00:00:00', 0.0390855472009836, 0.0889999999999997, 0.285238189265365, 0.272769230769229, 0.309958749116469, 0.345115384615383, 0.28974085238099, 0.582807692307693, 0.53208706632829, 1.01238461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 930, '2024-07-21 00:00:00', 0.290124729145137, 0.245038461538456, 0.305073751486676, 0.283076923076916, 0.307156156727136, 0.351230769230765, 0.294536154238912, 0.572884615384615, 0.540237275506007, 1.01492307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 945, '2024-07-21 00:00:00', 0.0947327901967513, 0.123307692307685, 0.154402610579763, 0.197384615384612, 0.194398987018574, 0.289615384615384, 0.208758870838698, 0.487115384615387, 0.543174894627729, 1.01161538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 960, '2024-07-21 00:00:00', 0.0845381661645294, 0.138692307692306, 0.0997593411859108, 0.185384615384616, 0.156192622695876, 0.28715384615385, 0.193226308130768, 0.460384615384618, 0.549515749056877, 1.02603846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 975, '2024-07-21 00:00:00', 0.0519008670447825, 0.108499999999999, 0.152220972981338, 0.188769230769231, 0.170410725556275, 0.318846153846155, 0.194026235339454, 0.438500000000001, 0.538802970981471, 1.02480769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 990, '2024-07-21 00:00:00', 0.156268250626436, 0.151615384615387, 0.147892169658011, 0.209576923076928, 0.19677947438303, 0.329807692307692, 0.192345382460425, 0.431884615384617, 0.549002126939975, 1.02884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 1005, '2024-07-21 00:00:00', 0.0607880048896293, 0.131307692307691, 0.134816758830416, 0.263038461538459, 0.157570853415706, 0.306576923076923, 0.161984424702359, 0.403076923076925, 0.561092660659678, 1.01557692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 1020, '2024-07-21 00:00:00', 0.144324959193324, 0.20557692307692, 0.169765290463495, 0.244423076923071, 0.164430415490754, 0.290192307692306, 0.162450749933166, 0.390384615384617, 0.574888533677486, 1.02911538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 1035, '2024-07-21 00:00:00', 0.0595522911785576, 0.122653846153846, 0.064295711066436, 0.163461538461543, 0.0831235317973295, 0.223807692307697, 0.116095193036378, 0.334576923076929, 0.584212363917307, 1.03761538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 1050, '2024-07-21 00:00:00', 0.040194010269421, 0.118038461538464, 0.0629044207814204, 0.174384615384617, 0.0719330137109403, 0.208961538461544, 0.0970956467375565, 0.323269230769236, 0.588505612024742, 1.03484615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 1065, '2024-07-21 00:00:00', 0.0604371256252812, 0.126615384615386, 0.0611499669790482, 0.159038461538467, 0.0691728715165551, 0.201384615384617, 0.0941538838612256, 0.314923076923084, 0.58958527927558, 1.03319230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 1080, '2024-07-21 00:00:00', 0.0454912812159292, 0.106960000000003, 0.0519975319927126, 0.133080000000002, 0.0618231887455391, 0.18324, 0.0979461246468319, 0.297120000000004, 0.604601185355548, 1.05448 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 1095, '2024-07-21 00:00:00', 0.0340324053717111, 0.0862692307692295, 0.0460069727156808, 0.124192307692303, 0.0529422907876676, 0.157615384615383, 0.0885659424036444, 0.281615384615387, 0.604816122088743, 1.04530769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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 515840241630275300, 2, 1110, '2024-07-21 00:00:00', 0.0289177081760223, 0.0850769230769205, 0.0396621307469045, 0.11373076923077, 0.0359366964793096, 0.134384615384618, 0.0852834188952426, 0.264307692307696, 0.603913433684511, 1.03765384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241630275300 and enddate = '2024-07-21 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, a[...];

[ Date: 2024-07-21 14:55:49 - Database: acaweb_fx - User: pgperfstats - Remote: 192.168.3.100 - Application: [unknown] ]

WITH rar_max as ( SELECT resultuid FROM relevance_autochartist_results ORDER BY resultuid DESC LIMIT 1 ), ar AS ( SELECT a.*, rr.age, rr.relevant from autochartist_results a LEFT OUTER JOIN relevance_autochartist_results rr on a.resultuid = rr.resultuid WHERE CASE WHEN FALSE = 't' THEN true ELSE a.resultuid > ( select min(resultuid) from relevance_autochartist_results) END ), all_results AS ( SELECT ar.resultuid AS resultuid, ar.direction AS direction, ar.predictiontimeto AS predictiontimeto, ar.predictionpricefrom AS predictionpricefrom, ar.predictionpriceto AS predictionpriceto, cp.pip AS pip, s.exchange AS exchange, s.symbolid AS symbolid, coalesce(bim.code, s.symbol) AS symbol_code, s.longname AS symbol_name, s.timegranularity AS interval, ar.pattern AS pattern_name, ar.breakout AS breakout, ar.patternendtime AS identified, dtt.timezone AS timezone, ar.patternlengthbars AS length, g.basegroupname, newLevels.profit, newLevels.stop, newLevels.filtered, CASE WHEN ar.age IS NOT NULL THEN ar.age WHEN ar.resultuid <= rm.resultuid THEN 11 ELSE 0 END as age, CASE WHEN ar.relevant IS NOT NULL THEN ar.relevant WHEN ar.resultuid <= rm.resultuid THEN 0 ELSE 1 END as relevant FROM ar INNER JOIN symbols s ON ar.symbolid = s.symbolid AND s.nonliquid = 0 INNER JOIN brokersymbollist bsl ON bsl.brokerid = '627' AND bsl.symbolid = s.symbolid INNER JOIN symbolgroup sg on bsl.symbolid = sg.symbolid INNER JOIN groups g ON sg.groupid = g.groupid INNER JOIN brokergroups bg on g.groupid = bg.groupid AND bsl.brokerid = bg.brokerid INNER JOIN downloadersymbolsettings dss ON sg.symbolid = dss.symbolid INNER JOIN datafeedstimetable dtt ON dss.classname = dtt.classname AND dtt.dayofweek = 3 INNER JOIN rar_max rm ON 1 = 1 LEFT OUTER JOIN autochartist_symbolupdates au on dss.symbolid = au.symbolid LEFT OUTER JOIN currencypips cp ON s.symbol = cp.symbol LEFT JOIN LATERAL calc_cp_signal (ar.resultuid) newLevels on true LEFT OUTER JOIN brokerinstrumentmap bim ON dss.datafeedinstrumentid = bim.datafeedinstrumentid AND bim.brokerid = bsl.brokerid AND bim.TYPE = 'OUTBOUND' WHERE ar.gmttimefound > now() - INTERVAL '7 DAYS' AND dss.enabled = 1 AND s.deleted = 0 AND (ar.simulation = 0 OR ar.simulation IS NULL) AND ('7' = 0 OR s.timegranularity in ('15', '30', '60', '120', '240', '480', '1440')) AND ('0' = 0 OR s.exchange in ('')) AND ('221' = 0 OR coalesce(bim.code, s.symbol) in ('#ADBE', '#AIRF', '#ALVG', '#AMZN', '#APPL', '#BA', '#BABA', '#BAYGn', '#BMWG', '#BNPP', '#BP', '#CAT', '#CBKG', '#DAIGn', '#DBKGn', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#META', '#MSFT', '#NFLX', '#RDSa', '#TSLA', '#VOWG', '#WMT', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS_200', 'BTCEUR', 'BTCGBP', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CL_BRENT', 'DASHUSD', 'EOSUSD', 'ESP_35', 'ETHEUR', 'ETHGBP', 'ETHUSD', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', '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', '#BP', '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', '#AIRF', '#ALVG', '#BAYGn', '#BMWG', '#BNPP', '#CBKG', '#DAIGn', '#DBKGn', '#RDSa', '#VOWG', 'AUS_200', 'ESP_35', 'EUR_50', 'FRA_40', 'GBR_100', 'HKG_50', 'NAS100', 'SPX500', 'US30', '#ADBE', '#AMZN', '#APPL', '#BA', '#BABA', '#CAT', '#DIS', '#EA', '#FB', '#FDX', '#GE', '#GM', '#GOOGL', '#GS', '#INTC', '#JPM', '#KO', '#MSFT', '#NFLX', '#TSLA', '#WMT', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('400' = 0 OR ar.patternlengthbars <= '400') and newLevels.filtered = false 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;