select powerstats_tdata_add ();

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

select updateageforrelevantresults ();

[ Date: 2024-09-29 14:17:16 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

[ Date: 2024-09-29 14:47:05 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

[ Date: 2024-09-29 14:32:06 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2024-09-29 14:01:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2024-09-29 14:03:16 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2024-09-29 14:05:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2024-09-29 14:11: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-09-29 14:16: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-09-29 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-09-29 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-09-29 14:26: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-09-29 14:31:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2024-09-29 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-09-29 14:35:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2024-09-29 14:41: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-09-29 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-09-29 14:48: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-09-29 14:50:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select powerstats_tdata_add ();

[ Date: 2024-09-29 14:02:31 - 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 515840241626884300, 5, 900, '2024-09-29 00:00:00', 0.000186327530756861, 0.000624444444444436, 0.000284138122986802, 0.00097037037037037, 0.0023307465514679, 0.00292222222222223, 0.00286293844226811, 0.0043837037037037, 0.00468051881849185, 0.00617777777777778 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 915, '2024-09-29 00:00:00', 0.000266520793435201, 0.000727777777777792, 0.00231697181781705, 0.00259259259259259, 0.00237071773184885, 0.00298444444444446, 0.00287301240597745, 0.00436814814814815, 0.00470125818159654, 0.00615851851851852 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 930, '2024-09-29 00:00:00', 0.00225237336047686, 0.00229629629629629, 0.0023182492903223, 0.00255518518518519, 0.0022609460239194, 0.00281000000000001, 0.00276517259627307, 0.00433777777777777, 0.00457110574066141, 0.00614333333333334 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 945, '2024-09-29 00:00:00', 0.000723072149465973, 0.00105444444444445, 0.000875124085625678, 0.00143962962962964, 0.00116439155455015, 0.00176666666666667, 0.00191482393766391, 0.00342740740740741, 0.00391397368776159, 0.00550148148148148 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 960, '2024-09-29 00:00:00', 0.000494145208597116, 0.00091111111111111, 0.000602040925812586, 0.00123925925925927, 0.000869749611936904, 0.00171481481481481, 0.00190473147564217, 0.00335407407407406, 0.00401113091597261, 0.00547407407407407 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 975, '2024-09-29 00:00:00', 0.000407905846350824, 0.000915555555555567, 0.000593414716400804, 0.0011988888888889, 0.00126943456017398, 0.00217222222222223, 0.00190824735744818, 0.00330814814814814, 0.00401680469316346, 0.0055474074074074 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 990, '2024-09-29 00:00:00', 0.000379443286904916, 0.000808148148148134, 0.000615017429628164, 0.00128185185185184, 0.00130768155685206, 0.00238185185185185, 0.00178603900507108, 0.00318259259259258, 0.00382056916151883, 0.00549888888888888 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1005, '2024-09-29 00:00:00', 0.000619011711177998, 0.00105703703703705, 0.0011990902296814, 0.00186407407407409, 0.00137667473766803, 0.00245222222222223, 0.00175423955326986, 0.00314555555555556, 0.00379405476593995, 0.00551851851851851 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1020, '2024-09-29 00:00:00', 0.000987600187856461, 0.00137814814814816, 0.00105484231413624, 0.00181333333333334, 0.00115137091580211, 0.0022837037037037, 0.00139305143756155, 0.00291333333333334, 0.00351683314711054, 0.00541333333333332 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1035, '2024-09-29 00:00:00', 0.000401864245479578, 0.00105777777777778, 0.000601594983536692, 0.00141370370370371, 0.000854345520153448, 0.00198296296296297, 0.00095925422124098, 0.00256925925925926, 0.003278776915662, 0.00537629629629629 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1050, '2024-09-29 00:00:00', 0.000494641658547247, 0.0011062962962963, 0.000582580711060962, 0.00151814814814815, 0.00080334556858434, 0.00195555555555556, 0.000879732055814999, 0.00245148148148148, 0.00326245114360161, 0.00542518518518518 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1065, '2024-09-29 00:00:00', 0.000466747550987982, 0.00108925925925926, 0.000755434630846032, 0.0014725925925926, 0.000760869573003485, 0.00175074074074075, 0.000908247271073855, 0.00232851851851853, 0.00328433283411443, 0.00545037037037037 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1080, '2024-09-29 00:00:00', 0.00071343477192324, 0.000977407407407408, 0.000750560474339686, 0.00125222222222221, 0.000812226197565305, 0.00147037037037036, 0.000902243326349943, 0.0021374074074074, 0.00333172029347604, 0.00547296296296295 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1095, '2024-09-29 00:00:00', 0.000386412751879141, 0.000700740740740734, 0.000450745820692556, 0.000961111111111112, 0.000876593705325624, 0.0013462962962963, 0.000879441839303739, 0.00200888888888889, 0.00333677813453161, 0.00545962962962962 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1110, '2024-09-29 00:00:00', 0.000413227171367893, 0.000765185185185181, 0.000636353796127714, 0.000993333333333328, 0.000893067953948851, 0.0013737037037037, 0.000863732211587211, 0.00195888888888889, 0.00331886835826417, 0.00544888888888889 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1125, '2024-09-29 00:00:00', 0.000405408942003506, 0.00063888888888888, 0.000589313183706266, 0.000941481481481481, 0.000612824714787298, 0.00119185185185185, 0.00071858380030631, 0.0018137037037037, 0.00331440011889755, 0.00543592592592592 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1140, '2024-09-29 00:00:00', 0.000286266864915782, 0.000615555555555563, 0.000358725585349091, 0.000829259259259264, 0.00043215058839961, 0.00102185185185185, 0.000711669719163165, 0.00177259259259261, 0.00331721852557812, 0.00545814814814815 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1155, '2024-09-29 00:00:00', 0.000218948536278431, 0.000506666666666664, 0.00025675378696819, 0.000659259259259257, 0.00043024772563386, 0.00098851851851851, 0.000704851523028556, 0.00167185185185186, 0.00325380189634016, 0.00545037037037037 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1170, '2024-09-29 00:00:00', 0.000216066229162745, 0.000473333333333338, 0.00036124073938977, 0.000627777777777783, 0.000525630268807991, 0.00100888888888889, 0.000709699788060966, 0.00162740740740741, 0.00324398891837875, 0.00546888888888889 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1185, '2024-09-29 00:00:00', 0.000325852377741474, 0.000455185185185186, 0.000415774771924249, 0.00074925925925925, 0.000668264964425083, 0.0010237037037037, 0.000787661438252838, 0.00162481481481482, 0.00323070846842875, 0.00545814814814815 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1200, '2024-09-29 00:00:00', 0.000266336868712024, 0.000532592592592582, 0.000412258044380815, 0.000714814814814802, 0.000522541728046524, 0.000929629629629626, 0.000624818834142004, 0.00152703703703704, 0.0030616987817549, 0.00535925925925926 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1215, '2024-09-29 00:00:00', 0.000233959477339664, 0.00043703703703703, 0.000350333174754183, 0.000608888888888898, 0.000381135654937184, 0.00081518518518518, 0.000839239243078227, 0.00216074074074075, 0.00310731766591752, 0.00528000000000001 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1230, '2024-09-29 00:00:00', 0.000207466058048453, 0.000380370370370379, 0.000277887841442642, 0.00058296296296297, 0.000333581958560296, 0.000796666666666668, 0.000783998626372424, 0.0022, 0.00310349628222577, 0.00528259259259259 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1245, '2024-09-29 00:00:00', 0.000213806233335484, 0.000438518518518521, 0.000238589755071488, 0.000555925925925925, 0.000258602974800182, 0.00074296296296297, 0.000793537106631526, 0.00222370370370371, 0.0030997731283585, 0.0053062962962963 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1260, '2024-09-29 00:00:00', 0.000151252133793892, 0.000351851851851862, 0.000200363629547831, 0.000529259259259272, 0.000250952601056868, 0.000708148148148149, 0.000842563413288931, 0.00222851851851853, 0.00311050618355738, 0.00529888888888889 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1275, '2024-09-29 00:00:00', 0.00017072328120803, 0.000378148148148158, 0.000194013686479353, 0.000484814814814829, 0.000228916063443719, 0.000662222222222218, 0.000937570510168951, 0.00239666666666668, 0.00310742823833637, 0.00529222222222223 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1290, '2024-09-29 00:00:00', 0.000116513941549931, 0.000312962962962957, 0.000174312650960566, 0.000488148148148143, 0.00019861557881534, 0.000615925925925923, 0.000987457814021913, 0.00241037037037038, 0.00307645066886318, 0.00527777777777778 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1305, '2024-09-29 00:00:00', 0.000144923597122234, 0.000364814814814816, 0.000213744262347829, 0.000474074074074059, 0.000186101096809289, 0.000615185185185194, 0.000992002349275777, 0.00240074074074075, 0.00307366583291379, 0.00527703703703704 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1320, '2024-09-29 00:00:00', 0.000163102924874351, 0.000315555555555542, 0.000139981683783541, 0.000438888888888882, 0.000193794763232677, 0.000594444444444461, 0.00100429590082318, 0.00240555555555557, 0.0030741453309285, 0.00527814814814815 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1335, '2024-09-29 00:00:00', 0.000129912308797939, 0.000301851851851856, 0.000134736209512694, 0.000410000000000009, 0.000266514914085868, 0.000610740740740753, 0.0009987196932278, 0.0024388888888889, 0.00306809363864575, 0.00528703703703704 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1350, '2024-09-29 00:00:00', 8.52263619048126e-05, 0.00029407407407408, 0.000176773069070814, 0.000448888888888906, 0.000275678391424804, 0.000622962962962977, 0.00099201010356955, 0.00246074074074074, 0.0030386257015049, 0.00529666666666667 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1365, '2024-09-29 00:00:00', 0.000141691048681131, 0.000349259259259278, 0.000207136218719502, 0.000441481481481504, 0.000344529077002631, 0.000661851851851862, 0.000988126662930579, 0.00250407407407408, 0.00302842125993649, 0.00530740740740741 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1380, '2024-09-29 00:00:00', 0.000192614342405458, 0.000321851851851847, 0.000231062823686606, 0.000458518518518521, 0.000350142828000232, 0.00070333333333334, 0.00104434714949628, 0.00255074074074074, 0.0030361883342671, 0.0053037037037037 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1395, '2024-09-29 00:00:00', 0.000208245280537395, 0.00031740740740741, 0.000332373404128682, 0.000464814814814813, 0.000902187907225004, 0.0017625925925926, 0.00108110158023225, 0.00260962962962963, 0.00303470866726226, 0.00530481481481482 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1410, '2024-09-29 00:00:00', 0.000201927323249361, 0.000298518518518529, 0.000184486659776072, 0.000497407407407418, 0.000861802589752273, 0.00181962962962962, 0.00120537944280614, 0.00269370370370369, 0.00304731702086295, 0.00530222222222222 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 5, 1425, '2024-09-29 00:00:00', 0.000147158208950571, 0.000413461538461544, 0.000888033696519372, 0.00173961538461539, 0.000824029219048786, 0.00191192307692308, 0.0011246072818818, 0.00279153846153846, 0.00293283354716639, 0.00549615384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 5 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 515840241626884300, 1, 0, '2024-09-29 00:00:00', 0.000528399278104582, 0.000781666666666667, 0.000582763127109833, 0.00103041666666666, 0.000752593583183686, 0.00153833333333334, 0.0011636969449604, 0.00279416666666666, 0.00298396945893957, 0.00564291666666666 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 15, '2024-09-29 00:00:00', 0.000535632480200877, 0.000656923076923085, 0.000622252484001588, 0.00105307692307692, 0.000906837700685525, 0.00186884615384617, 0.00129946734649832, 0.00263923076923077, 0.00288404566271329, 0.00541076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 30, '2024-09-29 00:00:00', 0.000524005871957707, 0.000803076923076919, 0.000573860476208148, 0.00102961538461538, 0.000866075143302328, 0.00186692307692308, 0.00134860982553831, 0.0025526923076923, 0.00288084295890042, 0.00538192307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 45, '2024-09-29 00:00:00', 0.000596609909920526, 0.000779230769230776, 0.00088683022397404, 0.0015296153846154, 0.000855954348171586, 0.00172461538461541, 0.00135336048981216, 0.00246615384615385, 0.00286855739675215, 0.00535153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 60, '2024-09-29 00:00:00', 0.000531977443130809, 0.00115000000000001, 0.00057430640441653, 0.00130961538461539, 0.000570911417081352, 0.00141038461538464, 0.00123752438981403, 0.00216884615384616, 0.0027952297827659, 0.00519153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 75, '2024-09-29 00:00:00', 0.000234235910010543, 0.000482307692307684, 0.000255941098993197, 0.000614615384615376, 0.000338002275823024, 0.000831538461538465, 0.0012911524369278, 0.00177884615384615, 0.00276947240185118, 0.00507423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 90, '2024-09-29 00:00:00', 0.000185177253961213, 0.000398846153846153, 0.000197797487733906, 0.00054038461538462, 0.0004032920300954, 0.000772692307692305, 0.00130240983742267, 0.00172923076923077, 0.00276828144411765, 0.00506307692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 105, '2024-09-29 00:00:00', 0.000124930134321309, 0.000316538461538456, 0.000250907276774645, 0.000527692307692306, 0.000417952702513641, 0.00073730769230768, 0.00126659063874395, 0.00173038461538462, 0.00275194923924562, 0.00505615384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 120, '2024-09-29 00:00:00', 0.000162198833344953, 0.000392692307692314, 0.000288787385192209, 0.000526923076923074, 0.000547654579512977, 0.000761538461538459, 0.00119080535127087, 0.00169423076923077, 0.00267744496459992, 0.00503653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 135, '2024-09-29 00:00:00', 0.000283474052536637, 0.00036846153846154, 0.000327986866528793, 0.000509230769230758, 0.000653541476524998, 0.000857307692307694, 0.00117471253439363, 0.00170846153846155, 0.0026585397090537, 0.00502423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 150, '2024-09-29 00:00:00', 0.00014121451222001, 0.000301538461538451, 0.000323871056963201, 0.000502692307692296, 0.000680669918875173, 0.000946538461538458, 0.000984264895551671, 0.00171423076923078, 0.00246142060294768, 0.00497923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 165, '2024-09-29 00:00:00', 0.000255059872307546, 0.000383461538461544, 0.000395522633797556, 0.000656923076923093, 0.000651521768926114, 0.00092615384615385, 0.000979580208362413, 0.00173576923076924, 0.00241483801017471, 0.00496884615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 180, '2024-09-29 00:00:00', 0.000404131928192537, 0.000571153846153847, 0.00066489710019382, 0.000791923076923077, 0.000669983696701758, 0.00100307692307692, 0.00106092325539887, 0.00174307692307694, 0.00241125706124099, 0.00497615384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 195, '2024-09-29 00:00:00', 0.000317161691352456, 0.000496538461538461, 0.000552484876228792, 0.000656538461538467, 0.000787901301901738, 0.000922692307692315, 0.00132493413479253, 0.00177769230769232, 0.00234024275532392, 0.00494807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 210, '2024-09-29 00:00:00', 0.000311469963979728, 0.000421538461538465, 0.000545162784440089, 0.000662307692307688, 0.000823436794080841, 0.000878076923076936, 0.00153993686184256, 0.00178846153846155, 0.00234529410981617, 0.00492730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 225, '2024-09-29 00:00:00', 0.00040216338050024, 0.000499230769230777, 0.000638260255574581, 0.000678076923076937, 0.000737890131492364, 0.000934615384615405, 0.00145637764544565, 0.00173038461538464, 0.0022294841417829, 0.00486346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 240, '2024-09-29 00:00:00', 0.000481694445122151, 0.000538461538461547, 0.000520808395300399, 0.000645769230769247, 0.000664227023284591, 0.000958461538461549, 0.00149068167163679, 0.0017496153846154, 0.00220846904856317, 0.00487653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 255, '2024-09-29 00:00:00', 0.000297745632274354, 0.000457307692307703, 0.000675117881444522, 0.000751923076923084, 0.000691010519790778, 0.000943461538461553, 0.00154644684556367, 0.0017446153846154, 0.00223586280024925, 0.00491230769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 270, '2024-09-29 00:00:00', 0.000513271258318041, 0.00053923076923077, 0.000545878684747368, 0.00071346153846155, 0.00058648798269543, 0.000868076923076926, 0.00157248005979775, 0.00171153846153846, 0.00223461536872765, 0.00489461538461537 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 285, '2024-09-29 00:00:00', 0.000200333567984836, 0.000408461538461546, 0.000272068995774117, 0.000561538461538477, 0.000426962077220704, 0.000763846153846162, 0.00187852401143516, 0.00176269230769231, 0.00220060274959804, 0.00483269230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 300, '2024-09-29 00:00:00', 0.000174569360251053, 0.0003623076923077, 0.000269321654989266, 0.000523076923076925, 0.000342692506259137, 0.000706923076923075, 0.00188388636763311, 0.00176961538461538, 0.00217853814782722, 0.00486730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 315, '2024-09-29 00:00:00', 0.000157224484294075, 0.00035346153846154, 0.000285205459004837, 0.000503076923076931, 0.000452247039366096, 0.000730769230769236, 0.00217003636977674, 0.00187538461538462, 0.00216448839220726, 0.004915 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 330, '2024-09-29 00:00:00', 0.000200284413157513, 0.000335384615384618, 0.000229651575552719, 0.000470384615384618, 0.000432296372696056, 0.000728076923076932, 0.00210589140636088, 0.00191884615384616, 0.00214837441229051, 0.00490384615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 345, '2024-09-29 00:00:00', 0.000157478203620002, 0.000330769230769216, 0.000338712494375613, 0.00049692307692307, 0.000494198340749942, 0.000739999999999997, 0.00201547474842489, 0.00196769230769232, 0.00214463972229872, 0.00488346153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 360, '2024-09-29 00:00:00', 0.000251432817146966, 0.000312307692307693, 0.000293036096490096, 0.000456923076923081, 0.000635307315096707, 0.000729230769230768, 0.00190889774880284, 0.00195884615384616, 0.00213643545690912, 0.0048526923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 375, '2024-09-29 00:00:00', 0.000183718848746175, 0.000303846153846155, 0.000279375402254059, 0.000468846153846151, 0.000858858634378293, 0.00085692307692308, 0.00177223982575721, 0.002005, 0.00213894542671419, 0.00483346153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 390, '2024-09-29 00:00:00', 0.000233945753080955, 0.000321153846153849, 0.000494767233539793, 0.000501153846153841, 0.00105884872167114, 0.000853846153846162, 0.00174133582675439, 0.00203230769230769, 0.00216377135149222, 0.00480769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 405, '2024-09-29 00:00:00', 0.000331662479035541, 0.000329999999999997, 0.000715593782490067, 0.000627692307692308, 0.000951328787296198, 0.000797692307692307, 0.00156336028624733, 0.00202076923076924, 0.0022498389685965, 0.00483076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 420, '2024-09-29 00:00:00', 0.000531665163569935, 0.000479615384615384, 0.000767130918522944, 0.000584615384615389, 0.000802949945752933, 0.000756153846153838, 0.00149992861368593, 0.00208538461538462, 0.0022705381266597, 0.00484076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 435, '2024-09-29 00:00:00', 0.000430370323540805, 0.000341153846153839, 0.000459974581237514, 0.000473846153846141, 0.000512395880605558, 0.000621538461538451, 0.00149672627372592, 0.00216846153846153, 0.00227168297490242, 0.00483653846153845 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 450, '2024-09-29 00:00:00', 0.000313154668101637, 0.000344615384615366, 0.000344328331683595, 0.000454999999999979, 0.000506850455869769, 0.000654230769230759, 0.00148322704315233, 0.00229769230769231, 0.002273152335076, 0.00482846153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 465, '2024-09-29 00:00:00', 0.000252622247634686, 0.000314999999999997, 0.000474124293992458, 0.000484615384615387, 0.000914338769065044, 0.000819230769230773, 0.00147900756746385, 0.00231923076923077, 0.00227322505569644, 0.00482807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 480, '2024-09-29 00:00:00', 0.000424914289999945, 0.000408076923076915, 0.000428049062608492, 0.000524999999999993, 0.000931535374447027, 0.000896923076923064, 0.001474937130342, 0.00237653846153847, 0.00227322505569644, 0.00482807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 495, '2024-09-29 00:00:00', 0.000380363591236674, 0.000382692307692308, 0.000914445523464687, 0.000671153846153858, 0.00118392963668259, 0.00107576923076924, 0.00145930399637845, 0.00238807692307693, 0.00225221371441179, 0.00485115384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 510, '2024-09-29 00:00:00', 0.000664152438479641, 0.00049769230769231, 0.000654707568308173, 0.000664999999999997, 0.00101668844028806, 0.00115076923076924, 0.00142278816197145, 0.00244692307692309, 0.00225246367681802, 0.00485615384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 525, '2024-09-29 00:00:00', 0.000260723254399404, 0.000433846153846144, 0.000741367551322437, 0.000845384615384615, 0.00125690070594911, 0.00133923076923078, 0.00141664397568553, 0.00244192307692309, 0.00234406011999561, 0.00488538461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 540, '2024-09-29 00:00:00', 0.000758135770264022, 0.000715384615384631, 0.0010298104381203, 0.00102153846153848, 0.00127848762817032, 0.00142884615384618, 0.00142780132209792, 0.00246384615384616, 0.0023557788847526, 0.00489692307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 555, '2024-09-29 00:00:00', 0.000514191972531075, 0.000675769230769247, 0.000746457067651022, 0.00100307692307694, 0.000783009676725743, 0.0012919230769231, 0.00103782583391359, 0.0023223076923077, 0.00240167444793132, 0.00490192307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 570, '2024-09-29 00:00:00', 0.000452313880125132, 0.00065961538461541, 0.000484618803406754, 0.000859230769230792, 0.000875771308399289, 0.00132923076923077, 0.00103547833614005, 0.00233076923076924, 0.00244189110196303, 0.00492807692307691 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 585, '2024-09-29 00:00:00', 0.000339984615036539, 0.000601538461538465, 0.000653487213693991, 0.00100153846153847, 0.000817575402309496, 0.00136846153846155, 0.00102933772584421, 0.00230807692307693, 0.00247260339287594, 0.00493346153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 600, '2024-09-29 00:00:00', 0.000403484248095936, 0.00071346153846155, 0.000554711290118233, 0.000993846153846149, 0.00113261793408695, 0.00139076923076923, 0.00101832683282997, 0.00230153846153847, 0.00247671668514217, 0.00491846153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 615, '2024-09-29 00:00:00', 0.000474975626905061, 0.000705384615384612, 0.000799440669853231, 0.00103423076923078, 0.00113686349901147, 0.00143884615384616, 0.00104583547757467, 0.00228038461538463, 0.00250241006908264, 0.00492807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 630, '2024-09-29 00:00:00', 0.000455230288298802, 0.000741153846153855, 0.000785754708250892, 0.0010423076923077, 0.000766127625439476, 0.00140346153846155, 0.000848933086064723, 0.00220076923076925, 0.00251607939828249, 0.00487653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 645, '2024-09-29 00:00:00', 0.00040234791680067, 0.00068038461538461, 0.000721836653160623, 0.00103192307692306, 0.000703856628757681, 0.00131307692307691, 0.000866774125487928, 0.00215423076923078, 0.0025418123455519, 0.004925 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 660, '2024-09-29 00:00:00', 0.000594195124646645, 0.000749615384615385, 0.000583828873768816, 0.00100807692307693, 0.000700491256190975, 0.00127999999999999, 0.000781435759454253, 0.00207461538461539, 0.00255642144713751, 0.00490884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 675, '2024-09-29 00:00:00', 0.000315886298921249, 0.000641923076923081, 0.000412746336702752, 0.000856538461538462, 0.000525142032069578, 0.00111692307692308, 0.000625065288897594, 0.00203884615384617, 0.00262487450249459, 0.00491307692307691 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 690, '2024-09-29 00:00:00', 0.000264437865320733, 0.000559230769230761, 0.000552080958388709, 0.000855769230769222, 0.000495956108479851, 0.00108730769230769, 0.000986556404095349, 0.00209846153846154, 0.00262918086102878, 0.00487999999999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 705, '2024-09-29 00:00:00', 0.000438020723078433, 0.000623076923076914, 0.000410312638774952, 0.000777307692307686, 0.000425329736340389, 0.00107576923076923, 0.00119739614934303, 0.00227846153846154, 0.00262892560681239, 0.00488461538461537 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 720, '2024-09-29 00:00:00', 0.000229411286691689, 0.000521538461538462, 0.000332625916007762, 0.000749999999999998, 0.000440740809930801, 0.0011026923076923, 0.00128190819304059, 0.00230615384615384, 0.00264422229369272, 0.00489653846153844 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 735, '2024-09-29 00:00:00', 0.000328329337474058, 0.00053807692307693, 0.000357678841764711, 0.00079692307692308, 0.000532894130054129, 0.00108807692307694, 0.00129649966626118, 0.00239923076923077, 0.00263377401051449, 0.00488846153846152 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 750, '2024-09-29 00:00:00', 0.0002136150383643, 0.000530769230769219, 0.000272161999269099, 0.000711923076923065, 0.000474005679940013, 0.00104423076923078, 0.00129420394302978, 0.00241961538461539, 0.0025896589618059, 0.00488153846153845 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 765, '2024-09-29 00:00:00', 0.000190736628727846, 0.000457307692307691, 0.00029489424440742, 0.000728846153846163, 0.000459291260028389, 0.000997307692307697, 0.00127340542821812, 0.00242576923076923, 0.0025424115747425, 0.00486384615384614 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 780, '2024-09-29 00:00:00', 0.000295756916818805, 0.000548076923076931, 0.000452698745134297, 0.000781923076923097, 0.000475897209327989, 0.000946923076923089, 0.00128378892346054, 0.002405, 0.00250553654625421, 0.00487576923076922 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 795, '2024-09-29 00:00:00', 0.000341476432343651, 0.000546923076923082, 0.000347352182174706, 0.000711538461538456, 0.000352512956663132, 0.000864230769230765, 0.00135255905601197, 0.00263000000000001, 0.00248999280196675, 0.00487192307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 810, '2024-09-29 00:00:00', 0.000225459871919926, 0.000458076923076918, 0.000233910239194421, 0.000595000000000004, 0.000402400489371162, 0.000893076923076928, 0.00135644535459412, 0.00265, 0.00249360946297656, 0.00486192307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 825, '2024-09-29 00:00:00', 0.000149189090135241, 0.000414230769230771, 0.000372147199991535, 0.000651538461538468, 0.000420903241210547, 0.00090346153846156, 0.00140082310968065, 0.00273423076923078, 0.00253170167764993, 0.00491576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 840, '2024-09-29 00:00:00', 0.000303152665272031, 0.000501538461538472, 0.000325566961090718, 0.000695384615384615, 0.000543015086913217, 0.00101423076923078, 0.00145648153491159, 0.00290769230769232, 0.00253711610965013, 0.00490692307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 855, '2024-09-29 00:00:00', 0.000188852812039914, 0.000464230769230762, 0.000301021849449774, 0.000646923076923083, 0.000563122066286218, 0.00108230769230769, 0.00149789534398716, 0.00300230769230771, 0.0025412852290494, 0.00492115384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 870, '2024-09-29 00:00:00', 0.000288125239863075, 0.000508076923076921, 0.000552951938376053, 0.000780384615384612, 0.000996646453786965, 0.00126192307692308, 0.00154735252807944, 0.00307961538461541, 0.0025533926752159, 0.00491307692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 885, '2024-09-29 00:00:00', 0.000565250250910012, 0.000580384615384621, 0.000580461354971527, 0.000859230769230775, 0.00130129030640301, 0.0015526923076923, 0.0017344234244799, 0.00315615384615387, 0.00255982899068249, 0.00491730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 900, '2024-09-29 00:00:00', 0.000256411028203982, 0.00062884615384617, 0.000617857962268396, 0.000947307692307707, 0.000970670822758069, 0.00147538461538462, 0.00181968737805321, 0.00321307692307694, 0.00256096895725037, 0.004915 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 915, '2024-09-29 00:00:00', 0.000452485953883143, 0.00064653846153847, 0.000815003916932543, 0.00112076923076923, 0.000853264590580482, 0.0014873076923077, 0.00198058530587455, 0.0031969230769231, 0.00252389945551294, 0.00486730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 930, '2024-09-29 00:00:00', 0.000562745467808009, 0.000807692307692304, 0.0005728209547091, 0.000970384615384606, 0.000784999461048322, 0.00148192307692308, 0.0021739479860737, 0.00324538461538463, 0.00250536335457785, 0.00486846153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 945, '2024-09-29 00:00:00', 0.000268118228800999, 0.000609230769230764, 0.000762836508343399, 0.00107653846153846, 0.000716124720551264, 0.00150115384615385, 0.00219340844700312, 0.00324615384615386, 0.00253471054332868, 0.00520153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 960, '2024-09-29 00:00:00', 0.000554844538171255, 0.000817307692307701, 0.000563025344422037, 0.00108846153846155, 0.00075190547687449, 0.0015346153846154, 0.00204376530340073, 0.00319615384615386, 0.00232695628202629, 0.00523153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 975, '2024-09-29 00:00:00', 0.000326308961662949, 0.00071846153846154, 0.000494039082851365, 0.00110884615384615, 0.00126069162946985, 0.00188076923076924, 0.00207281068934098, 0.00316192307692309, 0.00229189474855667, 0.00533153846153847 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 990, '2024-09-29 00:00:00', 0.000514838286783776, 0.000822307692307695, 0.000817264103815039, 0.00110615384615386, 0.00127074999054162, 0.00184153846153848, 0.00208846914859076, 0.00314076923076924, 0.0022748009887596, 0.00531653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1005, '2024-09-29 00:00:00', 0.000621463904515273, 0.000735769230769247, 0.00111366532743838, 0.00144769230769232, 0.00115251751196439, 0.00187384615384617, 0.00193221785680442, 0.0029746153846154, 0.00221489673313715, 0.00525653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1020, '2024-09-29 00:00:00', 0.000629153766211774, 0.0010123076923077, 0.000779791293576976, 0.0013023076923077, 0.00102095618831639, 0.00189653846153847, 0.00163113820571829, 0.0027596153846154, 0.00186799802338885, 0.00524615384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1035, '2024-09-29 00:00:00', 0.000421349662942241, 0.000746538461538472, 0.000583422264283367, 0.00119846153846155, 0.000811790518640029, 0.00179038461538463, 0.00154215678141412, 0.00258653846153847, 0.00194526343875422, 0.00522538461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1050, '2024-09-29 00:00:00', 0.000439762873166177, 0.000830769230769233, 0.000564515312867185, 0.00123846153846154, 0.000792613689976686, 0.00163730769230771, 0.00139520585743301, 0.00232923076923076, 0.00186946820904113, 0.00508923076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1065, '2024-09-29 00:00:00', 0.000293333362470864, 0.000832692307692314, 0.00042434601266128, 0.00113153846153847, 0.00072882413199934, 0.00145384615384616, 0.00121665139435444, 0.00204615384615384, 0.00177206880401238, 0.00496038461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1080, '2024-09-29 00:00:00', 0.000380728855668241, 0.000767692307692307, 0.000578571184371129, 0.000993846153846166, 0.000783989501499565, 0.00124653846153847, 0.00121237116682716, 0.00185961538461539, 0.0019313553630706, 0.00508153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1095, '2024-09-29 00:00:00', 0.000393337005632566, 0.000635000000000018, 0.000516564985858875, 0.000820769230769236, 0.000732149312220278, 0.00111884615384617, 0.00101052035338996, 0.00166923076923078, 0.00183159203552959, 0.00499576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1110, '2024-09-29 00:00:00', 0.00031258352729864, 0.000547307692307691, 0.00038834798035544, 0.000736923076923079, 0.000773881028423527, 0.00108038461538462, 0.000985723318958458, 0.0016623076923077, 0.00185505799204396, 0.00499807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1125, '2024-09-29 00:00:00', 0.000220348325646888, 0.000495769230769238, 0.00034092904743454, 0.00074384615384615, 0.000577211866182195, 0.000998461538461538, 0.000994058348388066, 0.00164, 0.00182889979537931, 0.00498230769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1140, '2024-09-29 00:00:00', 0.000312835174099477, 0.000524615384615388, 0.00051475998888205, 0.000725384615384606, 0.000575716810727151, 0.000924615384615378, 0.000990503213212674, 0.00160615384615384, 0.00178412348658511, 0.00495384615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1155, '2024-09-29 00:00:00', 0.000371403367699392, 0.000457307692307686, 0.000435414038146876, 0.000634230769230752, 0.00052990332935501, 0.000928461538461532, 0.000990123923867808, 0.00153423076923076, 0.00179111791477149, 0.00496923076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1170, '2024-09-29 00:00:00', 0.000384786254352261, 0.000497307692307684, 0.000456703910141401, 0.000672307692307686, 0.00054961133120105, 0.000963846153846153, 0.000981222785021905, 0.00151692307692307, 0.00181023993309855, 0.00500384615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1185, '2024-09-29 00:00:00', 0.000296661423174622, 0.000469999999999992, 0.000451999489448305, 0.000703461538461535, 0.000483323748799742, 0.000914615384615394, 0.000923613305697541, 0.00146153846153846, 0.00182623766251822, 0.005 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1200, '2024-09-29 00:00:00', 0.00022532984369926, 0.000448461538461539, 0.000307769144252379, 0.000635384615384615, 0.000529665932451755, 0.00085500000000002, 0.000784923808159356, 0.00142576923076923, 0.00178974703842149, 0.0050423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1215, '2024-09-29 00:00:00', 0.000255029711692877, 0.000428076923076918, 0.000306048010311092, 0.000564230769230781, 0.000574553204338268, 0.000789230769230769, 0.000690062316026593, 0.001805, 0.00176031605553794, 0.00505384615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1230, '2024-09-29 00:00:00', 0.000257556864520325, 0.000383461538461544, 0.000529243291443985, 0.000582307692307698, 0.000574261800387774, 0.000706153846153839, 0.000690899079794964, 0.00180153846153846, 0.00179155506152102, 0.00507153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1245, '2024-09-29 00:00:00', 0.000325589642624902, 0.000396153846153858, 0.000354261963046461, 0.000511538461538461, 0.000469889184972195, 0.000669615384615382, 0.00054762704883467, 0.00172923076923077, 0.00181662086980619, 0.00509076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1260, '2024-09-29 00:00:00', 0.000196443767643955, 0.000336923076923085, 0.000222522946094242, 0.000432692307692316, 0.000351077681520126, 0.000616538461538461, 0.000513601461776007, 0.00168769230769231, 0.0018118266600737, 0.00509961538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1275, '2024-09-29 00:00:00', 0.000158164957706033, 0.000311923076923084, 0.000271360390511316, 0.000452692307692318, 0.000393926193789967, 0.000655384615384622, 0.000510066209880176, 0.00167346153846154, 0.00180687149941123, 0.00511615384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1290, '2024-09-29 00:00:00', 0.000268890598285155, 0.000346923076923078, 0.000297213986626067, 0.00046192307692308, 0.000395489375525876, 0.000690384615384629, 0.000502100204525557, 0.00165615384615385, 0.00180855301277015, 0.00514 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1305, '2024-09-29 00:00:00', 0.000184216010329017, 0.000353461538461535, 0.000274692555414231, 0.000530000000000001, 0.000343840973975773, 0.000668846153846159, 0.000497098040167584, 0.00163769230769231, 0.00182107428142334, 0.00516346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1320, '2024-09-29 00:00:00', 0.000260229484523542, 0.000379230769230773, 0.000317013952616991, 0.0004846153846154, 0.000335145662935702, 0.000631153846153856, 0.000549240734665022, 0.00164576923076923, 0.00189039259251779, 0.00521807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1335, '2024-09-29 00:00:00', 0.000324956091708493, 0.000312692307692319, 0.000333446339818651, 0.000407692307692318, 0.000340203785082717, 0.00059115384615385, 0.000623132039347615, 0.00166846153846154, 0.00189533175500714, 0.00524230769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1350, '2024-09-29 00:00:00', 0.000189645823738707, 0.00027153846153846, 0.000231808939895299, 0.000420769230769225, 0.00032909853563005, 0.000574615384615378, 0.000591555966531021, 0.00163769230769231, 0.0018892108242495, 0.00524153846153845 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1365, '2024-09-29 00:00:00', 0.000152184099037966, 0.00032, 0.000249700127845695, 0.000433076923076916, 0.000352633171789261, 0.000556923076923075, 0.000627537924076175, 0.00163961538461539, 0.00189865462488978, 0.00527423076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1380, '2024-09-29 00:00:00', 0.000193236801718665, 0.000262692307692304, 0.000290271225951487, 0.000354230769230767, 0.000403557259305858, 0.00060230769230768, 0.000773223124330859, 0.00164500000000001, 0.00191337334006239, 0.00530153846153845 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1395, '2024-09-29 00:00:00', 0.000112179115017694, 0.000208076923076916, 0.000145638646603893, 0.000298846153846143, 0.000369150375863282, 0.00129, 0.000727833877918686, 0.00170307692307692, 0.00192586827570958, 0.00530615384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1410, '2024-09-29 00:00:00', 0.0001247058076496, 0.000206538461538452, 0.000318047166313419, 0.000464999999999993, 0.000400799201596012, 0.00132, 0.000770929209560671, 0.00171038461538462, 0.00196725736457168, 0.00532846153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 1, 1425, '2024-09-29 00:00:00', 0.000316180085005118, 0.000404615384615384, 0.000375166014534283, 0.00122846153846155, 0.000423851389050446, 0.00132500000000001, 0.000790433182112581, 0.00177384615384615, 0.00196750181311616, 0.00532923076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 0, '2024-09-29 00:00:00', 0.000360764999155114, 0.00082076923076924, 0.000445665621462817, 0.00100461538461539, 0.000410643210285813, 0.00121961538461539, 0.0007973494552868, 0.00184307692307693, 0.00196922620492259, 0.00532961538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 15, '2024-09-29 00:00:00', 0.000454336371493113, 0.000598461538461539, 0.000516423797342404, 0.000901538461538458, 0.000460165354895553, 0.00109807692307693, 0.000825271237463552, 0.00182384615384617, 0.00194746035804426, 0.00537538461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 30, '2024-09-29 00:00:00', 0.000438422346426554, 0.000696923076923078, 0.000432306159318386, 0.000906153846153847, 0.000439264595221819, 0.00101423076923077, 0.000753714902231711, 0.00179692307692308, 0.00197946523469968, 0.00534115384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 45, '2024-09-29 00:00:00', 0.000393679486970717, 0.00072653846153846, 0.000362494774498139, 0.000837692307692308, 0.000400243195300811, 0.000911153846153837, 0.00076698139582292, 0.00172269230769231, 0.00199318423248214, 0.00531076923076922 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 60, '2024-09-29 00:00:00', 0.000302447452524341, 0.000512307692307714, 0.000311971399083565, 0.000556923076923092, 0.000367037411633285, 0.000652692307692318, 0.000778725586109486, 0.00155153846153847, 0.0020002635211007, 0.00520307692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 75, '2024-09-29 00:00:00', 0.000102342562016008, 0.000184999999999999, 0.000163908511066379, 0.000274999999999991, 0.000336079660886431, 0.000458461538461527, 0.000708972929937824, 0.00143115384615385, 0.00201553947731505, 0.00511923076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 90, '2024-09-29 00:00:00', 0.00010370149468547, 0.000195000000000005, 0.000163694368118903, 0.000260384615384622, 0.000351344012877154, 0.000468846153846168, 0.000665965580076154, 0.00142307692307694, 0.00204270785591464, 0.00513076923076922 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 105, '2024-09-29 00:00:00', 0.000104604750590745, 0.000183076923076927, 0.000219594031024386, 0.000341538461538457, 0.000346635033073475, 0.00051961538461539, 0.000624517044172175, 0.00141846153846155, 0.00205719603792676, 0.00513346153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 120, '2024-09-29 00:00:00', 0.000163387222925754, 0.000270769230769215, 0.000224126337998513, 0.000366153846153862, 0.000413253507593661, 0.000577692307692317, 0.000595007433696307, 0.00141461538461539, 0.00208706315558123, 0.00514615384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 135, '2024-09-29 00:00:00', 0.000197463920755168, 0.000250000000000015, 0.000278078295559973, 0.000373461538461547, 0.000392094964949137, 0.000722307692307706, 0.000578438747505206, 0.00140076923076924, 0.00209769030492697, 0.00514615384615383 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 150, '2024-09-29 00:00:00', 0.000161599695353872, 0.000242307692307687, 0.000275552870816811, 0.000394230769230786, 0.000328628150861221, 0.000702692307692334, 0.000515620164312997, 0.0013719230769231, 0.00221154383945835, 0.00519307692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 165, '2024-09-29 00:00:00', 0.000209575394915158, 0.000304615384615399, 0.000253968199099513, 0.000570384615384629, 0.000312847222483091, 0.000775769230769236, 0.000534035579339065, 0.00137500000000001, 0.00220843212744664, 0.0052126923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 180, '2024-09-29 00:00:00', 0.000183153991535503, 0.000454230769230769, 0.000224093387126537, 0.000554615384615397, 0.000337626101798102, 0.000799230769230783, 0.000520098215576787, 0.00133692307692308, 0.00219536059768007, 0.00521192307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 195, '2024-09-29 00:00:00', 0.00022759207773152, 0.000386923076923097, 0.000252352927464688, 0.000555000000000006, 0.00039739401102685, 0.000795000000000024, 0.000496089321982064, 0.00127615384615385, 0.00220424042385441, 0.00522961538461537 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 210, '2024-09-29 00:00:00', 0.000202858419745241, 0.000396538461538455, 0.000284520649514233, 0.000570000000000002, 0.000402574789993691, 0.000787692307692314, 0.000481585362670492, 0.00121730769230769, 0.00222046620191485, 0.00522307692307691 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 225, '2024-09-29 00:00:00', 0.000188823075512908, 0.000403076923076925, 0.000319002290804414, 0.000577692307692313, 0.000407685587753052, 0.000793461538461553, 0.000507174374504313, 0.00123538461538461, 0.00221288951373538, 0.00521999999999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 240, '2024-09-29 00:00:00', 0.00031976842582382, 0.000460384615384613, 0.00033946654984186, 0.00062153846153846, 0.00041647827535918, 0.000846923076923087, 0.000515762020255906, 0.00121230769230769, 0.00221865225895223, 0.0052353846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 255, '2024-09-29 00:00:00', 0.000177734460534644, 0.000418461538461539, 0.00037352046592061, 0.000591538461538472, 0.000378293333477943, 0.00081538461538462, 0.000496937234854263, 0.00114884615384616, 0.00222811710781858, 0.00522461538461537 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 270, '2024-09-29 00:00:00', 0.000370642892615192, 0.000421923076923078, 0.000364965751817902, 0.000590000000000009, 0.000365042674006963, 0.000721923076923092, 0.000499439840066984, 0.00110807692307693, 0.00223457560933752, 0.00521192307692306 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 285, '2024-09-29 00:00:00', 0.000236022489150112, 0.000391153846153851, 0.000239825898389759, 0.000527307692307701, 0.000288748226767773, 0.00064653846153847, 0.000558052106748225, 0.00113307692307692, 0.00223241435359878, 0.0052553846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 300, '2024-09-29 00:00:00', 0.00017485290521332, 0.000338461538461544, 0.000216392805226603, 0.000445384615384638, 0.000291680541794496, 0.000571538461538465, 0.000525954224390148, 0.00110961538461538, 0.0022611040189729, 0.00527923076923075 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 315, '2024-09-29 00:00:00', 0.00016501981233033, 0.000303461538461541, 0.000229917711031905, 0.000413076923076922, 0.000263172654646808, 0.00053038461538461, 0.000519220717851435, 0.00123692307692307, 0.00230902460259405, 0.00528115384615383 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 330, '2024-09-29 00:00:00', 0.000156747714987637, 0.000274615384615377, 0.000187321607443934, 0.000364230769230764, 0.000205971245192531, 0.000488076923076909, 0.00051476970205505, 0.00131038461538461, 0.00232033276791199, 0.00526807692307691 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 345, '2024-09-29 00:00:00', 0.000152079432686183, 0.000281923076923083, 0.000173095349446493, 0.000375000000000006, 0.000249702900386729, 0.000473461538461536, 0.000685184758912627, 0.00146307692307693, 0.00232318587620203, 0.00526615384615383 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 360, '2024-09-29 00:00:00', 0.00012387152152999, 0.000261923076923076, 0.000141430058822244, 0.000362307692307687, 0.000257888467245924, 0.000482307692307679, 0.000686550799285827, 0.00151, 0.00232322047697057, 0.00526423076923075 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 375, '2024-09-29 00:00:00', 0.000130772850628625, 0.000271538461538468, 0.000218154849731873, 0.000336538461538459, 0.000286765784891793, 0.000488846153846141, 0.000764742691769857, 0.00163923076923077, 0.00232360929457733, 0.00525807692307691 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 390, '2024-09-29 00:00:00', 0.000112274389161278, 0.000228461538461545, 0.000185842364963911, 0.000334230769230768, 0.000288343811874221, 0.000463076923076912, 0.000763621331853399, 0.00173153846153847, 0.00232145299327813, 0.00525999999999998 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 405, '2024-09-29 00:00:00', 0.000158374920314459, 0.000248846153846144, 0.000198995941203278, 0.000350769230769223, 0.000412099315886165, 0.000535384615384604, 0.000813966924294938, 0.00188307692307692, 0.00232608264288663, 0.0052626923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 420, '2024-09-29 00:00:00', 0.000174334779618456, 0.000256153846153838, 0.000253684540628408, 0.000330384615384606, 0.000376715358776967, 0.000537692307692312, 0.000799730050608425, 0.00196192307692308, 0.00234117068020385, 0.00529192307692306 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 435, '2024-09-29 00:00:00', 0.000130879274965073, 0.000224230769230769, 0.000330128180233994, 0.000423846153846151, 0.000333485324322466, 0.00059730769230769, 0.000868870885336022, 0.00199384615384615, 0.00240520183064828, 0.00534038461538459 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 450, '2024-09-29 00:00:00', 0.000268238986439629, 0.000331923076923074, 0.0002573294805079, 0.000407692307692305, 0.000292794493432879, 0.000596153846153849, 0.000873715056525862, 0.00199499999999999, 0.00244940649012085, 0.0053880769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 465, '2024-09-29 00:00:00', 0.00012228591968761, 0.000234615384615384, 0.000252793622120138, 0.000423846153846155, 0.000377316231378317, 0.000636538461538473, 0.000879007482246962, 0.00200307692307692, 0.0024817109792672, 0.00541576923076921 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 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 515840241626884300, 2, 480, '2024-09-29 00:00:00', 0.00023840269745507, 0.000320384615384613, 0.000225525028459245, 0.000411538461538467, 0.00040583228821012, 0.000650384615384615, 0.000882162465413603, 0.00202115384615384, 0.00250007962950105, 0.00542692307692306 where not exists (select 1 from powerstats_trumpet where symbolid = 515840241626884300 and enddate = '2024-09-29 00:00:00' and dayofweek = 2 and fromtime = 480); insert into powerstats[...];

[ Date: 2024-09-29 14:56:13 - 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;

[ Date: 2024-09-29 14:56:55 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.145 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

select updateageforrelevantresults ();

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

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

[ Date: 2024-09-29 14:41:49 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

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