select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

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

[ Date: 2025-07-27 14:01:16 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

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

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

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

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

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

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

[ Date: 2025-07-27 14:16:16 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

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

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

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

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

[ Date: 2025-07-27 14:26:16 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2025-07-27 14:31:16 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2025-07-27 14:33:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

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

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

[ Date: 2025-07-27 14:41:16 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2025-07-27 14:46:17 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

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

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

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

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

[ Date: 2025-07-27 14:56:16 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

SELECT datetimeupdate FROM latest_candle_datetime_per_receng WHERE recognitionengine ILIKE 'IQFEED_FX - 1';

[ Date: 2025-07-27 14:02:02 - Database: acaweb_fx - User: postgres - Remote: 127.0.0.1 - Application: [unknown] ]

select powerstats_tdata_add ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

[ Date: 2025-07-27 14:17:29 - 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 515840243188450300, 1, 900, '2025-07-27 00:00:00', 0.000760586514575338, 0.00128961538461538, 0.00120122245425875, 0.00186076923076923, 0.00172281741521086, 0.00241038461538462, 0.00561262214874789, 0.00633076923076925, 0.00558241546837374, 0.0105923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 900); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 915, '2025-07-27 00:00:00', 0.00103210561475076, 0.00133499999999999, 0.00146143222690833, 0.00179192307692306, 0.00169475171769064, 0.00230076923076924, 0.00562713016076168, 0.00638461538461542, 0.00559548620283831, 0.0106353846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 915); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 930, '2025-07-27 00:00:00', 0.000790013534450768, 0.00128576923076921, 0.000942121337930828, 0.00166615384615386, 0.00163531093256109, 0.00238538461538462, 0.00561094733534364, 0.00640500000000004, 0.00592049864064222, 0.0107519230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 930); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 945, '2025-07-27 00:00:00', 0.00057927381595076, 0.00115692307692311, 0.0010156023601027, 0.00163807692307694, 0.00129716827684828, 0.0026515384615385, 0.00565331490230425, 0.00639576923076927, 0.00591006433649741, 0.0107726923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 945); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 960, '2025-07-27 00:00:00', 0.000580762893495752, 0.00111153846153847, 0.000928895125321569, 0.00162692307692308, 0.00160022806066942, 0.00288538461538464, 0.00587809525664171, 0.00646038461538464, 0.00595103927575164, 0.0107673076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 960); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 975, '2025-07-27 00:00:00', 0.000594710142713373, 0.00122192307692305, 0.00110040384195288, 0.00215384615384614, 0.00310859968474554, 0.00368000000000001, 0.00590883021092486, 0.0064723076923077, 0.00596101586592808, 0.0107530769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 975); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 990, '2025-07-27 00:00:00', 0.00100494477460208, 0.00169500000000001, 0.00152194435357692, 0.00244115384615387, 0.00446472940001797, 0.00404384615384617, 0.00587200089079852, 0.00645230769230772, 0.00591981778565733, 0.0107011538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 990); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1005, '2025-07-27 00:00:00', 0.00105639947281028, 0.00187038461538465, 0.00246081978210515, 0.00303500000000001, 0.00378783518445765, 0.00417923076923079, 0.00583070545936307, 0.00628692307692309, 0.00592458486698892, 0.0106353846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1005); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1020, '2025-07-27 00:00:00', 0.00230152417724898, 0.00221153846153845, 0.00365797491264477, 0.00295730769230768, 0.0041017187391854, 0.00421384615384617, 0.00593301419049505, 0.00589423076923076, 0.00597391524752533, 0.0105907692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1020); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1035, '2025-07-27 00:00:00', 0.00298456369701479, 0.00192730769230769, 0.00365337889967841, 0.00292423076923077, 0.00424548672574319, 0.00397846153846155, 0.00586621525215497, 0.00560423076923075, 0.00571342203802726, 0.0106907692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1035); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1050, '2025-07-27 00:00:00', 0.00138923864040703, 0.00189000000000001, 0.00198593442451193, 0.00272346153846156, 0.003107288924696, 0.00348269230769231, 0.00401081838953674, 0.00485192307692307, 0.00400526745481689, 0.0102092307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1050); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1065, '2025-07-27 00:00:00', 0.00121272331805479, 0.0018146153846154, 0.00204037492783892, 0.0024646153846154, 0.00294500651690539, 0.00311923076923075, 0.00365465791306634, 0.0045226923076923, 0.0038040682676071, 0.0100907692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1065); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1080, '2025-07-27 00:00:00', 0.00146118876788201, 0.00168615384615386, 0.00221288395190876, 0.00226923076923077, 0.00260398076915975, 0.00286961538461539, 0.0031097952690466, 0.00410115384615384, 0.00350326302839992, 0.00993038461538464 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1080); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1095, '2025-07-27 00:00:00', 0.00123773092639466, 0.00143538461538462, 0.00136091349411397, 0.00175846153846151, 0.00160888762336449, 0.00239076923076921, 0.00220778137853018, 0.00367115384615383, 0.00314636192842073, 0.00987576923076925 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1095); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1110, '2025-07-27 00:00:00', 0.000832604070649162, 0.00114846153846152, 0.00105292069976805, 0.001655, 0.00135030463799273, 0.00208115384615385, 0.00216378475397589, 0.00359730769230769, 0.00310446140504027, 0.00989384615384619 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1110); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1125, '2025-07-27 00:00:00', 0.000719253886917674, 0.00113692307692308, 0.000989355345667105, 0.00148999999999998, 0.00130193465510137, 0.00193538461538461, 0.00218495094118487, 0.00343884615384616, 0.00314384500009389, 0.00996576923076926 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1125); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1140, '2025-07-27 00:00:00', 0.000810013959993668, 0.00115884615384615, 0.0010746872174659, 0.00148615384615385, 0.0016798505428025, 0.00207461538461538, 0.00211759489842748, 0.00329807692307692, 0.00313606831263901, 0.00998730769230773 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1140); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1155, '2025-07-27 00:00:00', 0.000705873490517507, 0.00104423076923076, 0.000725888421177774, 0.00135499999999999, 0.00154823969521714, 0.00208692307692305, 0.00195968380495031, 0.00316384615384615, 0.00320745046127581, 0.0100923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1155); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1170, '2025-07-27 00:00:00', 0.000398298110233246, 0.000905769230769238, 0.00121348734581844, 0.00140346153846154, 0.0014519302801655, 0.00204153846153848, 0.00189137150074914, 0.00304307692307693, 0.0032834239164909, 0.0101838461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1170); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1185, '2025-07-27 00:00:00', 0.00100120020283349, 0.00108461538461538, 0.00128255082370429, 0.00157384615384614, 0.00130343616880681, 0.00189538461538461, 0.00176676444818898, 0.00294615384615386, 0.00328320903057684, 0.0102284615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1185); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1200, '2025-07-27 00:00:00', 0.000962991892289558, 0.00110423076923073, 0.000988497928094035, 0.00135192307692308, 0.00102789463692315, 0.00163076923076922, 0.00185706074628285, 0.00334884615384618, 0.00355876711581626, 0.0104107692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1200); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1215, '2025-07-27 00:00:00', 0.00059742073822519, 0.000846538461538465, 0.000604216466559393, 0.00110153846153844, 0.000809808334398645, 0.00141153846153846, 0.00160226282296199, 0.00448692307692308, 0.00386960003896247, 0.0105126923076924 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1215); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1230, '2025-07-27 00:00:00', 0.000391602035038285, 0.000768076923076933, 0.000489740276535963, 0.000968461538461555, 0.000719195704616245, 0.00128230769230773, 0.00166934851410315, 0.00456269230769232, 0.00397374787245568, 0.010628076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1230); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1245, '2025-07-27 00:00:00', 0.000466192598033812, 0.000746538461538442, 0.000690470519617993, 0.0010584615384615, 0.00073445448096894, 0.00128923076923076, 0.00167071463290872, 0.00456076923076924, 0.0041165540667669, 0.0107242307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1245); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1260, '2025-07-27 00:00:00', 0.000606555470226371, 0.000758461538461511, 0.000673003828998131, 0.000923076923076924, 0.000727945475557469, 0.00136615384615385, 0.00166626583898059, 0.00454538461538462, 0.00410762248284068, 0.0107623076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1260); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1275, '2025-07-27 00:00:00', 0.000455235695504586, 0.000633461538461529, 0.000493353360646848, 0.000911538461538455, 0.000807285289387565, 0.00150153846153846, 0.00165685954095735, 0.00454653846153847, 0.00448793543419892, 0.0109573076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1275); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1290, '2025-07-27 00:00:00', 0.000355756398937008, 0.000698846153846146, 0.000629546967759666, 0.00113423076923075, 0.00103310026321076, 0.00157192307692307, 0.00162898326005467, 0.00456230769230768, 0.00453372865734831, 0.0110434615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1290); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1305, '2025-07-27 00:00:00', 0.000513808704300911, 0.000850769230769228, 0.000707893951205853, 0.00113461538461538, 0.00108371419735021, 0.0014873076923077, 0.00161878952877186, 0.00458653846153846, 0.00451053972550785, 0.0111161538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1305); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1320, '2025-07-27 00:00:00', 0.000381680696192709, 0.000731923076923064, 0.000748527580294516, 0.00106153846153845, 0.000896993954185946, 0.00134307692307691, 0.00154588923874301, 0.00457153846153847, 0.0045586423248763, 0.0111503846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1320); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1335, '2025-07-27 00:00:00', 0.000605763599485434, 0.000731538461538437, 0.000674732539603649, 0.000949999999999981, 0.000980938091044224, 0.00131653846153846, 0.00151437664251155, 0.00460384615384615, 0.00496764437287779, 0.0112688461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1335); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1350, '2025-07-27 00:00:00', 0.00057100828499982, 0.000687692307692287, 0.000688948362472712, 0.000985384615384623, 0.00106718299202221, 0.00133653846153848, 0.00151220287609219, 0.00462153846153847, 0.00503274479323618, 0.0112919230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1350); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1365, '2025-07-27 00:00:00', 0.000460830187312471, 0.00074730769230772, 0.00076356542211269, 0.000998076923076937, 0.00111122115779823, 0.0014773076923077, 0.0013412540630091, 0.00452230769230771, 0.00501147317508685, 0.0112592307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1365); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1380, '2025-07-27 00:00:00', 0.000399604612277974, 0.000620384615384589, 0.000508181221461519, 0.000808076923076914, 0.00123260674370027, 0.00212923076923077, 0.00114068946761968, 0.0044026923076923, 0.00502828793313005, 0.0112865384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1380); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1395, '2025-07-27 00:00:00', 0.000281395697304569, 0.000513461538461537, 0.000601830029672315, 0.000930769230769231, 0.000914794722664829, 0.00357423076923075, 0.00104755686462141, 0.00447076923076925, 0.00505176765712143, 0.0113173076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1395); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1410, '2025-07-27 00:00:00', 0.000463398150788127, 0.00066538461538461, 0.000975831006807104, 0.00170692307692308, 0.000803031659496606, 0.00353961538461536, 0.00103403317905407, 0.00449615384615386, 0.00509118351058585, 0.0113815384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1410); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 1, 1425, '2025-07-27 00:00:00', 0.000825256044183584, 0.00148653846153848, 0.000681723156082063, 0.00321230769230769, 0.000644845717982226, 0.00335500000000001, 0.00105910121547253, 0.00455076923076926, 0.00509962690943017, 0.0114111538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 1 and fromtime = 1425); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 0, '2025-07-27 00:00:00', 0.000806468560119696, 0.00185653846153845, 0.000723953355913539, 0.00212269230769229, 0.000717991214859465, 0.00238076923076922, 0.00127325826735375, 0.00463115384615389, 0.00519683388819945, 0.0115523076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 0); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 15, '2025-07-27 00:00:00', 0.00066976873161277, 0.00103692307692309, 0.000633419170971227, 0.00139038461538462, 0.000684491164184168, 0.00284807692307692, 0.00156353017731819, 0.00446115384615387, 0.00505318964006512, 0.0118484615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 15); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 30, '2025-07-27 00:00:00', 0.000528715860872817, 0.000992692307692303, 0.000750008410209239, 0.00144384615384613, 0.000769122977062921, 0.00302307692307689, 0.0018154077736463, 0.00452423076923079, 0.00523752150720751, 0.0118634615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 30); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 45, '2025-07-27 00:00:00', 0.000761776567283029, 0.00114346153846153, 0.000811349493128568, 0.00246999999999999, 0.000759235242758212, 0.00298692307692308, 0.00185137836385592, 0.00438538461538464, 0.00563301050812219, 0.0119992307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 45); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 60, '2025-07-27 00:00:00', 0.000930194685991119, 0.00213692307692309, 0.000919500616973876, 0.00249423076923076, 0.000885483961545229, 0.00275538461538464, 0.0019048298127089, 0.00426615384615388, 0.00579123666878205, 0.0120169230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 60); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 75, '2025-07-27 00:00:00', 0.000350897968953024, 0.000795769230769217, 0.000460208146887401, 0.00110346153846155, 0.000503968405603142, 0.00143807692307691, 0.00173236330352058, 0.00325884615384618, 0.00674160200089424, 0.0120215384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 75); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 90, '2025-07-27 00:00:00', 0.000441066713949075, 0.000780384615384621, 0.000552115511882726, 0.000986538461538468, 0.00051262221807249, 0.00132846153846151, 0.00175658252121733, 0.00316307692307694, 0.00678449072971128, 0.0119776923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 90); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 105, '2025-07-27 00:00:00', 0.000321159437998329, 0.000620769230769241, 0.000423585428673634, 0.000986153846153833, 0.000519139080223578, 0.00119423076923076, 0.00169581348756735, 0.00309923076923081, 0.00685474627258649, 0.0119876923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 105); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 120, '2025-07-27 00:00:00', 0.00034934422081291, 0.000775769230769206, 0.000427654785293697, 0.000953846153846143, 0.00054463551679432, 0.00117038461538461, 0.0016855450613514, 0.0030769230769231, 0.00685633488096956, 0.01198 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 120); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 135, '2025-07-27 00:00:00', 0.000330468432101104, 0.000645769230769234, 0.000392358744792802, 0.000805769230769215, 0.000799839599304363, 0.00143076923076923, 0.00159384069274383, 0.0030819230769231, 0.00686006661775233, 0.011965 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 135); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 150, '2025-07-27 00:00:00', 0.000284314289800246, 0.000598846153846166, 0.000383419432917089, 0.000842307692307685, 0.000887692254366077, 0.00147846153846156, 0.00159365800790315, 0.00310538461538465, 0.00686151891684004, 0.0119653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 150); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 165, '2025-07-27 00:00:00', 0.000329912808994238, 0.000637692307692309, 0.000744443726240243, 0.00120730769230771, 0.000840538746647281, 0.00158423076923079, 0.00173865593535308, 0.00317730769230775, 0.00691433522028413, 0.0119765384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 165); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 180, '2025-07-27 00:00:00', 0.000605311871301429, 0.00103769230769229, 0.000723958456096641, 0.00125038461538463, 0.000956200574388845, 0.00173653846153849, 0.00175287197303345, 0.00319192307692311, 0.00691555763367029, 0.0119642307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 180); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 195, '2025-07-27 00:00:00', 0.000267905838797036, 0.000718461538461574, 0.000440978631960958, 0.00105692307692311, 0.0011760112506003, 0.00178230769230771, 0.00177660250521562, 0.00322269230769233, 0.00691788599323411, 0.0119488461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 195); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 210, '2025-07-27 00:00:00', 0.000324579965256879, 0.000751923076923084, 0.000721909540465707, 0.00119576923076925, 0.00125761385782149, 0.00189615384615388, 0.00175036211638092, 0.00317346153846155, 0.00708444988364277, 0.0119730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 210); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 225, '2025-07-27 00:00:00', 0.000492702594019837, 0.000900384615384638, 0.000887865894239599, 0.00132538461538463, 0.0010587731652175, 0.00186384615384616, 0.0016941412619332, 0.00314884615384616, 0.00728826670330206, 0.0120134615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 225); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 240, '2025-07-27 00:00:00', 0.000554427216559172, 0.00102846153846156, 0.000818192003044607, 0.00141307692307697, 0.000887131331878222, 0.00183500000000001, 0.00174390265254069, 0.00319269230769233, 0.00728826670330206, 0.0120134615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 240); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 255, '2025-07-27 00:00:00', 0.000623800880459097, 0.000943461538461562, 0.00073101331146462, 0.0012573076923077, 0.000969058623296169, 0.00180884615384615, 0.00172262112446745, 0.00309653846153846, 0.00729957808053631, 0.0119719230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 255); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 270, '2025-07-27 00:00:00', 0.000527985431034419, 0.00092384615384616, 0.000663439058705011, 0.00129076923076922, 0.000995720149130577, 0.00179884615384613, 0.00178057419433686, 0.00311269230769231, 0.00729925918264207, 0.0119338461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 270); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 285, '2025-07-27 00:00:00', 0.000458003862932988, 0.000903461538461522, 0.000677612096885934, 0.00129692307692307, 0.000905646645305898, 0.00172961538461538, 0.00172913215226596, 0.00304499999999999, 0.00731562223022653, 0.0118938461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 285); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 300, '2025-07-27 00:00:00', 0.000464644115260445, 0.000923076923076932, 0.000676845283991489, 0.00125346153846153, 0.000755380698720851, 0.00161000000000001, 0.00150981914352476, 0.00294461538461537, 0.00733377119904895, 0.01182 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 300); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 315, '2025-07-27 00:00:00', 0.000382907098594232, 0.000835384615384588, 0.000468036980787433, 0.00117884615384616, 0.000824854299488458, 0.00161384615384617, 0.00141982236158666, 0.00290653846153844, 0.00736363932806639, 0.0118180769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 315); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 330, '2025-07-27 00:00:00', 0.00034412005954988, 0.000868846153846175, 0.000446673861403967, 0.00111153846153848, 0.000718201600152441, 0.00147153846153849, 0.00121704130515832, 0.00288153846153847, 0.00738970793635414, 0.0117692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 330); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 345, '2025-07-27 00:00:00', 0.000353054582836041, 0.000766538461538462, 0.00055653225768695, 0.00106192307692309, 0.000831449614551876, 0.00139269230769232, 0.00127549929891727, 0.00290230769230769, 0.00742994788262081, 0.0117484615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 345); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 360, '2025-07-27 00:00:00', 0.00038880269862942, 0.000776538461538493, 0.000486414827709203, 0.000990769230769265, 0.000667534729721703, 0.00135884615384617, 0.00140001648341942, 0.00301307692307692, 0.00741461177986776, 0.0117196153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 360); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 375, '2025-07-27 00:00:00', 0.000256235468631136, 0.000633846153846173, 0.000460564369509343, 0.000906538461538474, 0.000688407862110387, 0.00141423076923079, 0.00150604367083474, 0.00329346153846153, 0.00741305239737004, 0.0117146153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 375); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 390, '2025-07-27 00:00:00', 0.000331979841834726, 0.000661153846153831, 0.000401307095147077, 0.000910769230769236, 0.000613489514674363, 0.00135423076923076, 0.00144403409292799, 0.00362230769230766, 0.00741838503055337, 0.0116973076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 390); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 405, '2025-07-27 00:00:00', 0.000296176662457772, 0.000656153846153849, 0.000634661023999949, 0.00102115384615383, 0.000604364128650953, 0.00127999999999998, 0.0014567471138966, 0.00389192307692306, 0.00741937734273207, 0.0116919230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 405); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 420, '2025-07-27 00:00:00', 0.000512530524419352, 0.000733461538461501, 0.000482200724244117, 0.000948461538461518, 0.000623513740518494, 0.00129423076923076, 0.00165898768947996, 0.00428192307692306, 0.00742022819470792, 0.0116876923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 420); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 435, '2025-07-27 00:00:00', 0.00028290389778971, 0.000678846153846135, 0.000371448723037428, 0.00095692307692306, 0.000647578685447641, 0.00132692307692307, 0.00209584012895873, 0.00457538461538461, 0.00758601750185572, 0.0117384615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 435); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 450, '2025-07-27 00:00:00', 0.000312383639874954, 0.00068653846153845, 0.000518980213050995, 0.000942692307692292, 0.00071904209783675, 0.00144153846153846, 0.00220240138170901, 0.00466961538461537, 0.0081121870426775, 0.0118711538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 450); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 465, '2025-07-27 00:00:00', 0.000312153068960626, 0.00064653846153847, 0.000458989693197501, 0.000966538461538465, 0.000743558698732982, 0.00152346153846153, 0.00236278010956454, 0.00480461538461537, 0.00812801930645799, 0.0118846153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 465); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 480, '2025-07-27 00:00:00', 0.000317634768490206, 0.000689615384615385, 0.000693721846275544, 0.001135, 0.000708193367770278, 0.00155538461538458, 0.00236514484838586, 0.00492307692307693, 0.00813943237484134, 0.0118892307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 480); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 495, '2025-07-27 00:00:00', 0.000535930535108352, 0.000811538461538449, 0.000543849102374745, 0.00109038461538461, 0.000775337643571139, 0.00169730769230768, 0.00237867231875263, 0.004995, 0.00813278512233994, 0.0118746153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 495); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 510, '2025-07-27 00:00:00', 0.000536172188186415, 0.000853846153846154, 0.000546805126305388, 0.00114038461538461, 0.000943484295250649, 0.00189115384615386, 0.00239662416423925, 0.00505923076923077, 0.00811695771920644, 0.0118511538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 510); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 525, '2025-07-27 00:00:00', 0.000298639221495435, 0.000815769230769246, 0.000681082509403539, 0.00135423076923076, 0.00135390404159458, 0.00209192307692308, 0.00256572715738715, 0.00516961538461536, 0.00809816758000514, 0.0117969230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 525); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 540, '2025-07-27 00:00:00', 0.000597809848852128, 0.00111384615384615, 0.000848986816967487, 0.00149115384615387, 0.00141647710345608, 0.00227923076923077, 0.00270648602719184, 0.00520884615384615, 0.0080304023943626, 0.0117588461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 540); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 555, '2025-07-27 00:00:00', 0.000500214108003919, 0.00101692307692306, 0.000971733740043245, 0.00161769230769231, 0.00125931483202325, 0.00256538461538461, 0.00272537051821189, 0.0051273076923077, 0.00793856988670843, 0.0116903846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 555); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 570, '2025-07-27 00:00:00', 0.000604095891522055, 0.0012096153846154, 0.000781788974084416, 0.00161499999999999, 0.00111409356049591, 0.0027226923076923, 0.00273394907386031, 0.00509153846153848, 0.00784052664047512, 0.011625 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 570); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 585, '2025-07-27 00:00:00', 0.000459390398747655, 0.00101653846153843, 0.000951514501284029, 0.00190038461538461, 0.00114606027496206, 0.00284692307692308, 0.00267467415700566, 0.00501461538461539, 0.00784072857682146, 0.0115861538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 585); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 600, '2025-07-27 00:00:00', 0.000859536279271884, 0.00160115384615387, 0.000938804886749407, 0.00219884615384616, 0.00158055009897964, 0.00312115384615387, 0.00256929718016427, 0.00496000000000002, 0.00782693453108215, 0.0115280769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 600); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 615, '2025-07-27 00:00:00', 0.00053637257430031, 0.00142653846153845, 0.00073964284520406, 0.00200653846153846, 0.00172859320302334, 0.00303769230769232, 0.00230946906985466, 0.00478076923076925, 0.0077844778590771, 0.0115065384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 615); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 630, '2025-07-27 00:00:00', 0.000595819926332956, 0.00141423076923077, 0.000984640816979245, 0.00213846153846155, 0.00154479592876808, 0.00285769230769233, 0.00225634871827507, 0.0046515384615385, 0.0077805030982282, 0.0115126923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 630); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 645, '2025-07-27 00:00:00', 0.000873833288095981, 0.00159615384615385, 0.0013541187313015, 0.00222153846153845, 0.00156001365871734, 0.00271884615384618, 0.00218099162344529, 0.00452730769230771, 0.00778835090671665, 0.0115046153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 645); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 660, '2025-07-27 00:00:00', 0.000816583219179868, 0.0013580769230769, 0.000839724588549955, 0.00178423076923077, 0.000999144865141438, 0.0023123076923077, 0.00194558644510714, 0.00421115384615385, 0.00782557853354086, 0.0112807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 660); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 675, '2025-07-27 00:00:00', 0.000740330071917005, 0.00137384615384617, 0.00100772645861103, 0.00175615384615386, 0.000946349748324547, 0.00233461538461539, 0.00198053236821277, 0.00420730769230771, 0.00781663619369711, 0.0112857692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 675); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 690, '2025-07-27 00:00:00', 0.000747574642530017, 0.00127961538461541, 0.000740606404343024, 0.00168538461538461, 0.000958322251886874, 0.00228846153846154, 0.00228516082585015, 0.00443000000000001, 0.00782569762926064, 0.0112492307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 690); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 705, '2025-07-27 00:00:00', 0.000627637327908914, 0.00123384615384616, 0.000701374474760939, 0.00170692307692308, 0.00123167128481838, 0.00239692307692307, 0.00231017734916942, 0.00450923076923077, 0.00770055143879571, 0.0111873076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 705); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 720, '2025-07-27 00:00:00', 0.000441859880331058, 0.00118807692307692, 0.00068312415810347, 0.00157115384615384, 0.00121906250234159, 0.00223423076923076, 0.00214516490311083, 0.00433269230769231, 0.00750709584326721, 0.01109 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 720); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 735, '2025-07-27 00:00:00', 0.00049465963434077, 0.00105192307692308, 0.0007745414524339, 0.00156230769230769, 0.00117649499001844, 0.0020226923076923, 0.00198761414766549, 0.004365, 0.00733892702281156, 0.0109546153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 735); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 750, '2025-07-27 00:00:00', 0.000485665918729486, 0.00107076923076923, 0.000724426988411162, 0.00136769230769231, 0.000909890356877408, 0.00183269230769231, 0.00186179950172285, 0.00425576923076924, 0.00719221875469487, 0.0109088461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 750); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 765, '2025-07-27 00:00:00', 0.000501928128474443, 0.000980384615384616, 0.000665256457199916, 0.00134692307692306, 0.00104470599471078, 0.00184884615384616, 0.00189660332010841, 0.00428807692307694, 0.00714964489704533, 0.0109269230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 765); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 780, '2025-07-27 00:00:00', 0.000561132371603671, 0.00104846153846153, 0.00067977654699626, 0.00135807692307692, 0.0010102581543653, 0.00189846153846156, 0.00181602765990458, 0.00434269230769235, 0.00707194088254093, 0.0109103846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 780); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 795, '2025-07-27 00:00:00', 0.000343054155850298, 0.000876923076923066, 0.000615066350392071, 0.00122115384615386, 0.00085490476302695, 0.00185307692307693, 0.00221781638970894, 0.00476153846153848, 0.00706113075494723, 0.0108965384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 795); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 810, '2025-07-27 00:00:00', 0.000432553064774881, 0.000946923076923097, 0.000560088042529583, 0.00131884615384618, 0.000836700571383734, 0.00193961538461541, 0.0022467686540041, 0.00497423076923081, 0.0070698041317662, 0.0108623076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 810); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 825, '2025-07-27 00:00:00', 0.000317585361026719, 0.000917307692307698, 0.000618166519761342, 0.00143538461538461, 0.000781979441004566, 0.00191038461538462, 0.0022081140229756, 0.00493653846153849, 0.00705669096564497, 0.0108292307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 825); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 840, '2025-07-27 00:00:00', 0.000502097753277364, 0.00112307692307693, 0.000677040732782155, 0.00148192307692311, 0.000788949545037828, 0.00189423076923076, 0.00208596706958297, 0.00496115384615387, 0.00705665172291091, 0.0107715384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 840); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 855, '2025-07-27 00:00:00', 0.000570921522291275, 0.000939230769230773, 0.000590439210705423, 0.0012476923076923, 0.000710581127290581, 0.00181153846153844, 0.002117189029023, 0.00502576923076925, 0.00707745225780707, 0.0107123076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 855); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 870, '2025-07-27 00:00:00', 0.000426375241018796, 0.00091038461538461, 0.000668797428224703, 0.00135499999999998, 0.00111385180619054, 0.00227538461538461, 0.00209287318150101, 0.0050869230769231, 0.00706597159740857, 0.0106988461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 870); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 885, '2025-07-27 00:00:00', 0.000450262829228229, 0.00107384615384614, 0.000555788144474562, 0.0014673076923077, 0.00131343425357403, 0.00257846153846153, 0.00215365981886289, 0.00511884615384619, 0.00706749492122481, 0.0106826923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 885); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 900, '2025-07-27 00:00:00', 0.000477383896476831, 0.00113076923076923, 0.00107064380344083, 0.00189692307692307, 0.00117779872905088, 0.0025753846153846, 0.00214870010793646, 0.00517807692307696, 0.00698603416715202, 0.0106957692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 900); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 915, '2025-07-27 00:00:00', 0.00100210002571524, 0.00139730769230768, 0.00117648008254086, 0.00195423076923075, 0.00125744362161428, 0.0025273076923077, 0.00228551536016243, 0.00522269230769233, 0.00697221819906581, 0.0106088461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 915); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 930, '2025-07-27 00:00:00', 0.000923956792196544, 0.00146807692307691, 0.00101186925272752, 0.00184076923076924, 0.00107153060906063, 0.00238538461538463, 0.00229031757959119, 0.00525115384615386, 0.00689906357079321, 0.0107069230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 930); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 945, '2025-07-27 00:00:00', 0.000736510796829306, 0.00121807692307695, 0.00098806703291754, 0.00181269230769235, 0.00112029281886479, 0.00225000000000005, 0.0022619041671871, 0.00520769230769234, 0.00688201674377056, 0.0106976923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 945); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 960, '2025-07-27 00:00:00', 0.000787106091959659, 0.00139, 0.000797134965891081, 0.00166192307692307, 0.00103887224357067, 0.00257346153846156, 0.00259396838839642, 0.00532000000000003, 0.00689832114469778, 0.0107188461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 960); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 975, '2025-07-27 00:00:00', 0.000372606825157363, 0.00112038461538462, 0.000612825109949508, 0.00170115384615386, 0.00142047511011689, 0.00336153846153846, 0.00311662788677369, 0.00542423076923079, 0.00690460364818006, 0.0106965384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 975); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 990, '2025-07-27 00:00:00', 0.000588494297730693, 0.00137153846153847, 0.0008782907351126, 0.00215115384615386, 0.00135852363304376, 0.00358769230769233, 0.00333634982486042, 0.00545307692307695, 0.00688125991370765, 0.010705 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 990); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1005, '2025-07-27 00:00:00', 0.000754739384464286, 0.00165653846153847, 0.00135407584153007, 0.00281576923076924, 0.00144149345632065, 0.0033592307692308, 0.0035188262028912, 0.0053746153846154, 0.00689395722019262, 0.0106630769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1005); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1020, '2025-07-27 00:00:00', 0.00110693561761217, 0.0021376923076923, 0.00115911239250621, 0.00276846153846156, 0.00121642104299707, 0.00316807692307693, 0.00348625761438336, 0.00519807692307694, 0.00690641045584574, 0.0105457692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1020); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1035, '2025-07-27 00:00:00', 0.000795885283577571, 0.00171576923076928, 0.000904134860600897, 0.0021296153846154, 0.00113976819505612, 0.00281346153846155, 0.00401126682464049, 0.00509153846153847, 0.00690544899670931, 0.0105946153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1035); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1050, '2025-07-27 00:00:00', 0.000801613085260907, 0.00163346153846153, 0.00105428714523859, 0.00226576923076925, 0.00133279007522391, 0.00284576923076924, 0.00411883689706393, 0.00499576923076923, 0.00687591051313316, 0.0105442307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1050); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1065, '2025-07-27 00:00:00', 0.00106177094444213, 0.00164846153846153, 0.00113566876265112, 0.00210346153846154, 0.00130795795039446, 0.00274500000000001, 0.00410747004296393, 0.00487692307692309, 0.0068724821179497, 0.0105223076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1065); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1080, '2025-07-27 00:00:00', 0.000759986740775043, 0.00129038461538461, 0.00105088504824049, 0.00186076923076923, 0.00137736543388513, 0.00259653846153849, 0.00408831620408884, 0.00458576923076925, 0.00682571793913397, 0.0105742307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1080); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1095, '2025-07-27 00:00:00', 0.000489083286913843, 0.0011223076923077, 0.000581360870319353, 0.00158730769230769, 0.00138463346996736, 0.00230461538461539, 0.00431553351724458, 0.00429846153846155, 0.00664310363054452, 0.0104946153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1095); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1110, '2025-07-27 00:00:00', 0.00045785520048963, 0.00115923076923079, 0.000942713024283558, 0.00177038461538464, 0.00146963480550047, 0.00231230769230769, 0.00411526914719389, 0.00418192307692311, 0.00641343450530572, 0.0105269230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1110); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1125, '2025-07-27 00:00:00', 0.000829421763361954, 0.00121730769230772, 0.0011806902804976, 0.00164153846153847, 0.00146091267574547, 0.00230538461538463, 0.00406545060422389, 0.00404384615384619, 0.00632831925675251, 0.0105938461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1125); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1140, '2025-07-27 00:00:00', 0.000688843847438478, 0.00124538461538461, 0.000907433998447515, 0.0017173076923077, 0.00160164588422706, 0.00227846153846155, 0.00380070633111588, 0.00387384615384619, 0.00593979999663288, 0.01046 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1140); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1155, '2025-07-27 00:00:00', 0.000750993700680332, 0.00124346153846151, 0.000937743035164744, 0.00164499999999998, 0.00220702026758669, 0.0021976923076923, 0.00379087138348871, 0.00375461538461539, 0.00590092243115102, 0.0104815384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1155); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1170, '2025-07-27 00:00:00', 0.000571028357102697, 0.00109423076923079, 0.00124942380566155, 0.00155038461538463, 0.00210845098080595, 0.00208153846153846, 0.0035784231378983, 0.00361807692307692, 0.00569268140145409, 0.0104315384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1170); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1185, '2025-07-27 00:00:00', 0.000887605681681824, 0.00109038461538461, 0.00149015440604192, 0.00143192307692308, 0.00195371220618988, 0.00208923076923077, 0.00323069654313835, 0.00352807692307692, 0.00544821473935764, 0.0103703846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1185); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1200, '2025-07-27 00:00:00', 0.000910626496091894, 0.00101384615384614, 0.00116989736564959, 0.00150038461538461, 0.00139598016296241, 0.00196615384615383, 0.00274491686857444, 0.00381384615384613, 0.00505389526846523, 0.0102042307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1200); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1215, '2025-07-27 00:00:00', 0.00085358573991406, 0.00102615384615386, 0.00111017392954712, 0.00141692307692308, 0.00163579503135795, 0.00192576923076923, 0.00215914798010695, 0.00492999999999999, 0.00488975966060311, 0.0101384615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1215); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1230, '2025-07-27 00:00:00', 0.000863681565250646, 0.00105538461538462, 0.000889395646146652, 0.00131615384615385, 0.0014617860519031, 0.00184769230769232, 0.00206505608044541, 0.00497615384615382, 0.00563780122169846, 0.0103588461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1230); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1245, '2025-07-27 00:00:00', 0.000748895494403905, 0.00094730769230769, 0.00126648198383737, 0.00138615384615385, 0.00142408729205224, 0.00176384615384616, 0.0026013933840274, 0.00507346153846153, 0.00603036272668441, 0.0104111538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1245); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1260, '2025-07-27 00:00:00', 0.0009764396865851, 0.0010176923076923, 0.00111127653554886, 0.00129653846153847, 0.00121289050809022, 0.00161076923076924, 0.00264040803956214, 0.00499884615384613, 0.00768971484916954, 0.0108176923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1260); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1275, '2025-07-27 00:00:00', 0.000555879483341491, 0.000834999999999979, 0.000750416909765222, 0.00114153846153846, 0.00124614784898842, 0.0015873076923077, 0.00323827762861682, 0.00538499999999997, 0.00873349703506784, 0.0111776923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1275); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1290, '2025-07-27 00:00:00', 0.000761508725138201, 0.000906538461538448, 0.000862582259176589, 0.00118807692307691, 0.00136042691263273, 0.00161576923076921, 0.00325211183458004, 0.00538076923076919, 0.00874590215252485, 0.0111873076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1290); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1305, '2025-07-27 00:00:00', 0.000384415640440626, 0.000749230769230776, 0.000837765985316795, 0.00110038461538462, 0.000913329328084017, 0.00136769230769232, 0.00323454272121806, 0.00525115384615382, 0.00874650375864553, 0.01121 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1305); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1320, '2025-07-27 00:00:00', 0.000554030823913391, 0.000783076923076929, 0.000624161837987544, 0.001035, 0.000669482923318702, 0.00126923076923077, 0.00322461153295427, 0.00521653846153845, 0.00875658539878155, 0.0111996153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1320); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1335, '2025-07-27 00:00:00', 0.000422953716325841, 0.000664615384615392, 0.000464352816790775, 0.000856538461538462, 0.000752971549161139, 0.00124692307692306, 0.0032746985298709, 0.00524230769230768, 0.00875743207883367, 0.0112461538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1335); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1350, '2025-07-27 00:00:00', 0.000439515817515322, 0.000656923076923085, 0.000601723677958068, 0.000960769230769214, 0.000936543563404211, 0.0013953846153846, 0.00328591354818626, 0.00522038461538458, 0.00877958327379716, 0.0112823076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1350); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1365, '2025-07-27 00:00:00', 0.000381575075786585, 0.000743461538461533, 0.000525099843985767, 0.000965384615384594, 0.000859725627073056, 0.00138192307692307, 0.00327904657812886, 0.0053076923076923, 0.00877958327379716, 0.0112823076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1365); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1380, '2025-07-27 00:00:00', 0.000311089400951932, 0.000656153846153832, 0.000619300846488655, 0.000971538461538472, 0.00100167459786101, 0.00194000000000001, 0.00327169803007554, 0.00532, 0.00877958327379716, 0.0112823076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1380); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1395, '2025-07-27 00:00:00', 0.000416609944857112, 0.000669615384615399, 0.000581972904471051, 0.000952692307692315, 0.00103896287044043, 0.00343961538461542, 0.00332043604643452, 0.00537653846153846, 0.00877108897721111, 0.0113253846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1395); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1410, '2025-07-27 00:00:00', 0.000414567986444477, 0.000701153846153871, 0.00088829378369651, 0.00163461538461538, 0.00111033937985712, 0.00349153846153846, 0.00334554098189494, 0.0053926923076923, 0.00867251404416011, 0.0114196153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1410); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 2, 1425, '2025-07-27 00:00:00', 0.000901283870589407, 0.00143615384615384, 0.000976745695586165, 0.00312807692307694, 0.0017158113577502, 0.00359384615384616, 0.00336779035068304, 0.00547961538461537, 0.00863223786832737, 0.0114588461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 2 and fromtime = 1425); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 0, '2025-07-27 00:00:00', 0.00106350827272467, 0.00152538461538462, 0.00110234770446462, 0.00202230769230769, 0.0020258608426657, 0.00269192307692306, 0.0030615615924909, 0.00537076923076922, 0.00867378668970259, 0.0115734615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 0); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 15, '2025-07-27 00:00:00', 0.000858694268150098, 0.0011703846153846, 0.00155246786167651, 0.0017726923076923, 0.00279493530955822, 0.00386923076923074, 0.00309014602592472, 0.00502230769230766, 0.00921240301900735, 0.0117257692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 15); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 30, '2025-07-27 00:00:00', 0.00115730057261914, 0.00114615384615383, 0.00152685740606693, 0.00159846153846151, 0.00235293309591371, 0.00379692307692306, 0.0026654328844558, 0.0047126923076923, 0.00916490924039163, 0.0117457692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 30); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 45, '2025-07-27 00:00:00', 0.00106602879164466, 0.00116423076923077, 0.00195707446499577, 0.00328730769230768, 0.00190428977271359, 0.00365653846153844, 0.00249557898322984, 0.0046076923076923, 0.00915269733256481, 0.0117426923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 45); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 60, '2025-07-27 00:00:00', 0.00189921084826141, 0.00264461538461537, 0.00187814151183065, 0.00292653846153844, 0.00192806830392894, 0.0030707692307692, 0.00271109730835776, 0.00414615384615383, 0.00921720405629522, 0.0116511538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 60); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 75, '2025-07-27 00:00:00', 0.00111308199988208, 0.00120346153846153, 0.00116736942936474, 0.00143923076923077, 0.00135512207795231, 0.00173038461538462, 0.00228344870754742, 0.00321499999999998, 0.0092696140239951, 0.0115580769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 75); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 90, '2025-07-27 00:00:00', 0.000911434794494576, 0.000915769230769252, 0.000969994528136817, 0.00107576923076922, 0.00115361772097774, 0.00142538461538464, 0.00224735263057534, 0.00306538461538463, 0.00928000093667107, 0.0115757692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 90); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 105, '2025-07-27 00:00:00', 0.000413143297919023, 0.00064076923076921, 0.000669266418148673, 0.000948461538461569, 0.000677731623761341, 0.00131807692307694, 0.00207051639786944, 0.00299692307692308, 0.00926951393630675, 0.0115761538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 105); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 120, '2025-07-27 00:00:00', 0.000657745800793555, 0.000831538461538478, 0.000679629423911419, 0.00102192307692309, 0.000667843832505327, 0.00144923076923078, 0.00211611054677064, 0.00300961538461539, 0.00926658483269532, 0.0116123076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 120); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 135, '2025-07-27 00:00:00', 0.000370480145839914, 0.000686538461538476, 0.000461893760678663, 0.000994615384615402, 0.000866648451485123, 0.00158346153846154, 0.00200153325843353, 0.00289923076923078, 0.00929786817584467, 0.0117138461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 135); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 150, '2025-07-27 00:00:00', 0.000356450018073531, 0.000733846153846162, 0.000533816591954732, 0.00105192307692308, 0.00100268838628957, 0.00157999999999999, 0.00201843095954796, 0.00283653846153846, 0.0092969903484118, 0.0117315384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 150); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 165, '2025-07-27 00:00:00', 0.000451170273161494, 0.000778846153846166, 0.000872913864814075, 0.00122884615384614, 0.00132749741416523, 0.00167423076923075, 0.0020597046838359, 0.00286923076923077, 0.00928501124642046, 0.0117653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 165); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 180, '2025-07-27 00:00:00', 0.000779139663593522, 0.00103115384615381, 0.00102109262745656, 0.0013030769230769, 0.00125896618149728, 0.00169961538461536, 0.00211511123548187, 0.00291346153846153, 0.00927299549975422, 0.0117915384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 180); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 195, '2025-07-27 00:00:00', 0.000646852854507576, 0.000908846153846173, 0.000880142383586083, 0.00124884615384616, 0.000869927317918875, 0.00167153846153848, 0.0020707118434156, 0.00290653846153848, 0.00926276599327406, 0.0118253846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 195); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 210, '2025-07-27 00:00:00', 0.000485915630536815, 0.000815000000000002, 0.000530242905149634, 0.00106153846153846, 0.000798510247513831, 0.00156884615384617, 0.00263433144343045, 0.0030269230769231, 0.00926740014160476, 0.0118142307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 210); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 225, '2025-07-27 00:00:00', 0.000438670894687773, 0.000818076923076919, 0.000639393462587775, 0.00123, 0.00120615861949605, 0.00175884615384618, 0.00264830514741907, 0.00306807692307694, 0.00926536159782563, 0.0118284615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 225); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 240, '2025-07-27 00:00:00', 0.000515107307715134, 0.000936538461538465, 0.000678505597732134, 0.00119461538461541, 0.00119199748321884, 0.00171500000000003, 0.00267344272427898, 0.00309, 0.00925650444074538, 0.0118376923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 240); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 255, '2025-07-27 00:00:00', 0.000456569313972727, 0.000816538461538439, 0.00100115756079576, 0.0013126923076923, 0.00131515100039736, 0.00183692307692305, 0.00261254126209597, 0.00305038461538461, 0.00922675671828742, 0.0117965384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 255); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 270, '2025-07-27 00:00:00', 0.000853380247107865, 0.00107538461538461, 0.000916308983829257, 0.00128307692307693, 0.00118196088702698, 0.00175346153846153, 0.00258965400124303, 0.0029803846153846, 0.0091833910612919, 0.0118107692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 270); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 285, '2025-07-27 00:00:00', 0.000541948195083103, 0.000870384615384638, 0.000909484131040988, 0.00136576923076924, 0.00116226992760523, 0.00167076923076924, 0.0026844192324197, 0.00299115384615385, 0.00917853292282515, 0.0117911538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 285); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 300, '2025-07-27 00:00:00', 0.000625859286224812, 0.00100961538461535, 0.00067299879986177, 0.00120076923076921, 0.000906992748677632, 0.0015103846153846, 0.00259562140181086, 0.00290230769230768, 0.0091802807146623, 0.011765 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 300); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 315, '2025-07-27 00:00:00', 0.000308720685310318, 0.000717307692307677, 0.000446572071881612, 0.00100115384615383, 0.000975717487485299, 0.00138384615384613, 0.00254216757905534, 0.00290000000000001, 0.0091822351225698, 0.0117546153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 315); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 330, '2025-07-27 00:00:00', 0.000374280848890469, 0.000743076923076915, 0.00063918373426886, 0.00102961538461536, 0.00116938044082526, 0.00134884615384614, 0.00253116999398729, 0.00292153846153846, 0.0091864105403245, 0.0117388461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 330); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 345, '2025-07-27 00:00:00', 0.000429266995989872, 0.000726923076923048, 0.000810846850758271, 0.00103384615384615, 0.00123601070445953, 0.0014023076923077, 0.00234552421564006, 0.00300961538461537, 0.00918884249846187, 0.0117223076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 345); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 360, '2025-07-27 00:00:00', 0.000477503282308495, 0.000715769230769214, 0.000692792454213666, 0.000995769230769221, 0.00109835765507485, 0.00137846153846153, 0.00218375498766549, 0.0030953846153846, 0.00918884249846187, 0.0117223076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 360); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 375, '2025-07-27 00:00:00', 0.00039198665597383, 0.000678461538461517, 0.000631411605361076, 0.000956153846153825, 0.00114900733076593, 0.00143538461538461, 0.00242619730949801, 0.00349423076923079, 0.00919768991900436, 0.0117003846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 375); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 390, '2025-07-27 00:00:00', 0.000499145731764263, 0.00068230769230767, 0.000808115471566142, 0.000961153846153832, 0.00157537824517944, 0.00157384615384616, 0.00249547479681491, 0.0037576923076923, 0.00919902821790686, 0.0116980769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 390); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 405, '2025-07-27 00:00:00', 0.000517795920594771, 0.000716153846153849, 0.000838223120654637, 0.001085, 0.00150764656131542, 0.00159692307692308, 0.00253950101094987, 0.00388576923076923, 0.00919902821790686, 0.0116980769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 405); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 420, '2025-07-27 00:00:00', 0.000848920400363812, 0.000874615384615393, 0.00154801550379834, 0.00134000000000003, 0.0015210241489005, 0.00163230769230771, 0.00287255940555831, 0.00405846153846155, 0.00919314578284364, 0.0117057692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 420); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 435, '2025-07-27 00:00:00', 0.000863676666707727, 0.000805769230769232, 0.000828718380299459, 0.000983076923076907, 0.00146228298850175, 0.00151346153846155, 0.00302275269351529, 0.00427461538461539, 0.00920556995268879, 0.011686923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 435); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 450, '2025-07-27 00:00:00', 0.000737697874367367, 0.000676923076923054, 0.00102073435103583, 0.000981153846153843, 0.00139418004576166, 0.001465, 0.00311532848002606, 0.00452653846153846, 0.00915245537463119, 0.0116807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 450); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 465, '2025-07-27 00:00:00', 0.000492909103806544, 0.00067076923076921, 0.000986432265989217, 0.00109615384615385, 0.00119391482752525, 0.00148615384615384, 0.0029350351590084, 0.00462076923076922, 0.00915100358514764, 0.0116811538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 465); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 480, '2025-07-27 00:00:00', 0.000946074724646718, 0.000914230769230806, 0.000941132623695842, 0.00110884615384616, 0.00110306851729446, 0.00156192307692308, 0.00296142709880532, 0.0046623076923077, 0.00915501544761963, 0.0116396153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 480); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840243188450300, 3, 495, '2025-07-27 00:00:00', 0.000507301306310772, 0.000798846153846135, 0.000774037168656369, 0.00108153846153844, 0.00112904288942174, 0.00174538461538462, 0.00286072570136698, 0.00461653846153847, 0.00915768987497143, 0.0116296153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840243188450300 and enddate = '2025-07-27 00:00:00' and dayofweek = 3 and fromtime = 495); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, e[...];

[ Date: 2025-07-27 14:51:07 - 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 = '529' 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 ('183' = 0 OR coalesce(bim.code, s.symbol) in ('AUDUSD', 'EURUSD', 'GBPUSD', 'USDCAD', 'USDCHF', 'USDJPY', 'XAGAUD', 'XAGEUR', 'XAGUSD', 'XAUAUD', 'XAUCHF', 'XAUEUR', 'XAUGBP', 'XAUJPY', 'XAUUSD', 'XPDUSD', 'XPTUSD', 'AUS200', 'CA60', 'CHINAH', 'CN50', 'EUSTX50', 'FRA40', 'GER40', 'GERTEC30', 'HK50', 'JPN225', 'MidDE50', 'NAS100', 'NETH25', 'NOR25', 'SA40', 'SCI25', 'SPA35', 'SWI20', 'UK100', 'US2000', 'US30', 'US500', 'VIX', 'AUDCAD', 'AUDCHF', 'AUDNZD', 'AUDSGD', 'EURAUD', 'EURCHF', 'EURGBP', 'GBPAUD', 'GBPCHF', 'NZDUSD', 'CHFSGD', 'EURCZK', 'EURHUF', 'EURMXN', 'EURNOK', 'EURPLN', 'EURSEK', 'EURSGD', 'EURTRY', 'EURZAR', 'GBPMXN', 'GBPNOK', 'GBPSEK', 'GBPSGD', 'GBPTRY', 'NOKJPY', 'NOKSEK', 'NZDCAD', 'NZDCHF', 'SEKJPY', 'SGDJPY', 'USDCNH', 'USDCZK', 'USDHKD', 'USDHUF', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTHB', 'USDTRY', 'USDZAR', 'ZARJPY', 'ADAUSD', 'AVAXUSD', 'BCHUSD', 'BNBUSD', 'BTCUSD', 'Crypto10', 'Crypto20', 'Crypto30', 'DOGEUSD', 'DOTUSD', 'EOSUSD', 'ETHUSD', 'LINKUSD', 'LTCUSD', 'MATICUSD', 'SOLUSD', 'UNIUSD', 'XLMUSD', 'XRPUSD', 'XTZUSD', 'EURX', 'JPYX', 'USDX', 'Gasoline', 'NatGas', 'SpotBrent', 'SpotCrude', 'AAPL.US', 'ABNB.US', 'AMD.US', 'AMZN.US', 'AXP.US', 'BA.US', 'BABA.US', 'BIDU.US', 'BYND.US', 'C.US', 'COIN.US', 'CRM.US', 'DIS.US', 'EA.US', 'GOOG.US', 'GS.US', 'IBM.US', 'JPM.US', 'LMT.US', 'MA.US', 'MCD.US', 'META.US', 'MRNA.US', 'MSFT.US', 'NFLX.US', 'NKE.US', 'NVDA.US', 'ORCL.US', 'PFE.US', 'PG.US', 'PLTR.US', 'PTON.US', 'PYPL.US', 'QCOM.US', 'SNAP.US', 'SPCE.US', 'SPY.US', 'T.US', 'TMUS.US', 'TSLA.US', 'UBER.US', 'V.US', 'WMT.US', 'ZM.US', 'Cattle', 'Cocoa', 'Coffee', 'Corn', 'Cotton', 'LDSugar', 'LeanHogs', 'LondonSugar', 'Lumber', 'OJ', 'Oats', 'RghRice', 'SoyMeal', 'SoyOil', 'Soybeans', 'Sugar', 'Wheat', 'AUDJPY', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURCAD', 'EURJPY', 'EURNZD', 'GBPCAD', 'GBPJPY', 'GBPNZD', 'NZDJPY')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('400' = 0 OR ar.patternlengthbars <= '400') and newLevels.filtered = false AND ar.patternstarttime >= coalesce(au.earliestpricedatetime, '1900-01-01'::timestamp without time zone) -- To make sure patternstarttime is in our t-tables ), results AS ( SELECT DISTINCT ON (symbolid) * FROM all_results WHERE (FALSE = 't' OR relevant = 1) AND ('10' = 0 OR age <= '10') ORDER BY symbolid, resultuid ) SELECT * from results ORDER BY identified DESC, length DESC;

[ Date: 2025-07-27 14:06:31 - 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 = '529' 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 ('183' = 0 OR coalesce(bim.code, s.symbol) in ('AUDUSD', 'EURUSD', 'GBPUSD', 'USDCAD', 'USDCHF', 'USDJPY', 'XAGAUD', 'XAGEUR', 'XAGUSD', 'XAUAUD', 'XAUCHF', 'XAUEUR', 'XAUGBP', 'XAUJPY', 'XAUUSD', 'XPDUSD', 'XPTUSD', 'AUS200', 'CA60', 'CHINAH', 'CN50', 'EUSTX50', 'FRA40', 'GER40', 'GERTEC30', 'HK50', 'JPN225', 'MidDE50', 'NAS100', 'NETH25', 'NOR25', 'SA40', 'SCI25', 'SPA35', 'SWI20', 'UK100', 'US2000', 'US30', 'US500', 'VIX', 'AUDCAD', 'AUDCHF', 'AUDNZD', 'AUDSGD', 'EURAUD', 'EURCHF', 'EURGBP', 'GBPAUD', 'GBPCHF', 'NZDUSD', 'CHFSGD', 'EURCZK', 'EURHUF', 'EURMXN', 'EURNOK', 'EURPLN', 'EURSEK', 'EURSGD', 'EURTRY', 'EURZAR', 'GBPMXN', 'GBPNOK', 'GBPSEK', 'GBPSGD', 'GBPTRY', 'NOKJPY', 'NOKSEK', 'NZDCAD', 'NZDCHF', 'SEKJPY', 'SGDJPY', 'USDCNH', 'USDCZK', 'USDHKD', 'USDHUF', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTHB', 'USDTRY', 'USDZAR', 'ZARJPY', 'ADAUSD', 'AVAXUSD', 'BCHUSD', 'BNBUSD', 'BTCUSD', 'Crypto10', 'Crypto20', 'Crypto30', 'DOGEUSD', 'DOTUSD', 'EOSUSD', 'ETHUSD', 'LINKUSD', 'LTCUSD', 'MATICUSD', 'SOLUSD', 'UNIUSD', 'XLMUSD', 'XRPUSD', 'XTZUSD', 'EURX', 'JPYX', 'USDX', 'Gasoline', 'NatGas', 'SpotBrent', 'SpotCrude', 'AAPL.US', 'ABNB.US', 'AMD.US', 'AMZN.US', 'AXP.US', 'BA.US', 'BABA.US', 'BIDU.US', 'BYND.US', 'C.US', 'COIN.US', 'CRM.US', 'DIS.US', 'EA.US', 'GOOG.US', 'GS.US', 'IBM.US', 'JPM.US', 'LMT.US', 'MA.US', 'MCD.US', 'META.US', 'MRNA.US', 'MSFT.US', 'NFLX.US', 'NKE.US', 'NVDA.US', 'ORCL.US', 'PFE.US', 'PG.US', 'PLTR.US', 'PTON.US', 'PYPL.US', 'QCOM.US', 'SNAP.US', 'SPCE.US', 'SPY.US', 'T.US', 'TMUS.US', 'TSLA.US', 'UBER.US', 'V.US', 'WMT.US', 'ZM.US', 'Cattle', 'Cocoa', 'Coffee', 'Corn', 'Cotton', 'LDSugar', 'LeanHogs', 'LondonSugar', 'Lumber', 'OJ', 'Oats', 'RghRice', 'SoyMeal', 'SoyOil', 'Soybeans', 'Sugar', 'Wheat', 'AUDJPY', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURCAD', 'EURJPY', 'EURNZD', 'GBPCAD', 'GBPJPY', 'GBPNZD', 'NZDJPY')) 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;