select powerstats_tdata_add ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

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

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

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

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

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

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

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

[ Date: 2025-07-06 14:18: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-06 14:20: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-06 14:26: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-06 14:31:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2025-07-06 14:33: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-06 14:35: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-06 14:41: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-06 14:46:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

[ Date: 2025-07-06 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-06 14:50:14 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select powerstats_tdata_add ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

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

[ Date: 2025-07-06 14:56:10 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840236501271300, 1, 900, '2025-07-06 00:00:00', 0.000478058412909812, 0.000810384615384604, 0.000470175908161387, 0.00100423076923076, 0.000870071261449324, 0.00143999999999999, 0.0028742863194459, 0.00361461538461539, 0.00315456175183715, 0.00572038461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 915, '2025-07-06 00:00:00', 0.000394531855007147, 0.000669230769230781, 0.000660389628581846, 0.00107769230769231, 0.000832052975384472, 0.00144807692307693, 0.00289488123843025, 0.00357576923076923, 0.0031349092490852, 0.00574 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 930, '2025-07-06 00:00:00', 0.000417250339908614, 0.000774615384615382, 0.000576702562985333, 0.00106461538461539, 0.000901585611788826, 0.00158615384615385, 0.00288642651041043, 0.003595, 0.00327819678388076, 0.00577692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 945, '2025-07-06 00:00:00', 0.000391144277925489, 0.000714615384615386, 0.000608263100968645, 0.00106000000000001, 0.000835125508761779, 0.00162115384615386, 0.00290826271165452, 0.00356000000000001, 0.00326614515198669, 0.00576807692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 960, '2025-07-06 00:00:00', 0.000367654729331751, 0.000755000000000001, 0.00065513169550981, 0.00110153846153847, 0.000591898120131673, 0.00165923076923076, 0.00291856371420023, 0.00356307692307693, 0.00321337569926322, 0.00577076923076922 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 975, '2025-07-06 00:00:00', 0.000451364427213578, 0.000774615384615386, 0.000573809939051134, 0.00123538461538462, 0.00172796509936265, 0.00195923076923078, 0.00293770431040714, 0.00353884615384616, 0.0032431996783803, 0.00573807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 990, '2025-07-06 00:00:00', 0.000450841947403364, 0.000942307692307704, 0.000538412624151917, 0.00126192307692308, 0.00234404778108297, 0.00206, 0.00295068526591055, 0.00345346153846154, 0.00326987209818082, 0.00573346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1005, '2025-07-06 00:00:00', 0.000451265059412047, 0.000948076923076917, 0.00141224709104102, 0.00153461538461538, 0.00215849990645213, 0.00206538461538461, 0.00294071077227154, 0.00334038461538461, 0.00324487297369011, 0.00572384615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1020, '2025-07-06 00:00:00', 0.00141869219299378, 0.00110346153846154, 0.00215407535044264, 0.00157615384615384, 0.00230760405215853, 0.00230730769230768, 0.00302519321696979, 0.003265, 0.0032352687440387, 0.00578038461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1035, '2025-07-06 00:00:00', 0.00177651863529164, 0.00121769230769231, 0.0022252158063018, 0.00166423076923077, 0.00250081316006182, 0.0022976923076923, 0.00296348113905562, 0.00315730769230769, 0.00315927628031872, 0.00591115384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1050, '2025-07-06 00:00:00', 0.000780792201253606, 0.00100269230769231, 0.00108456081150212, 0.00155192307692307, 0.00157851634332808, 0.00193538461538462, 0.00197430634362084, 0.00269153846153846, 0.00231530227300552, 0.00561615384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1065, '2025-07-06 00:00:00', 0.000662235491463464, 0.00113038461538462, 0.000967555603649644, 0.00138961538461538, 0.00136040265532502, 0.00174923076923078, 0.00160504684810612, 0.00246923076923077, 0.00206825177012261, 0.00550423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1080, '2025-07-06 00:00:00', 0.000732807037252054, 0.000906923076923074, 0.000951796439128917, 0.00117269230769231, 0.00127353783429649, 0.00152884615384616, 0.00127857522867629, 0.00226884615384615, 0.00196489389026481, 0.00542 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1095, '2025-07-06 00:00:00', 0.000519114779067381, 0.000728076923076932, 0.000661907383714204, 0.00100423076923078, 0.000833600900634388, 0.00133769230769232, 0.00101739100720345, 0.00214730769230769, 0.00193920332571432, 0.00540846153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1110, '2025-07-06 00:00:00', 0.000415916596668863, 0.00066884615384615, 0.000619439573013681, 0.000955769230769236, 0.000692577349193126, 0.00124076923076923, 0.000925668490252405, 0.00205692307692307, 0.00189670305043736, 0.0054376923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1125, '2025-07-06 00:00:00', 0.000522671392574111, 0.000664230769230761, 0.000541481159555747, 0.000924615384615378, 0.000625870102030286, 0.00128576923076923, 0.000937021795986554, 0.00201538461538461, 0.00186220679674575, 0.00546307692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1140, '2025-07-06 00:00:00', 0.000485321939144921, 0.000694230769230765, 0.000560359362717022, 0.000908846153846151, 0.000703814223739811, 0.00127769230769231, 0.000918013323181353, 0.00195269230769232, 0.00188398615869484, 0.00549961538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1155, '2025-07-06 00:00:00', 0.000354262831589981, 0.000586923076923075, 0.000456285504414121, 0.00086269230769231, 0.000661004829494761, 0.00121923076923077, 0.000887794154935972, 0.0018923076923077, 0.00187928533879645, 0.00549423076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1170, '2025-07-06 00:00:00', 0.000305773420387362, 0.000585769230769225, 0.000511939299286404, 0.00086538461538461, 0.000624006533496376, 0.00115807692307691, 0.000849800338541132, 0.00179384615384615, 0.00192718227951105, 0.00553653846153845 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1185, '2025-07-06 00:00:00', 0.000466741239462913, 0.000589230769230769, 0.000535397623626224, 0.000811153846153848, 0.000579232383285102, 0.000986923076923065, 0.000846282095175943, 0.00177576923076924, 0.0019483296593591, 0.00555730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1200, '2025-07-06 00:00:00', 0.000399318843108528, 0.000576538461538468, 0.000458759028416712, 0.000720384615384608, 0.000588700263291936, 0.000910000000000005, 0.000809969515095839, 0.00178884615384616, 0.00205457987470393, 0.0056576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1215, '2025-07-06 00:00:00', 0.000340238151887769, 0.000485, 0.000392364822386193, 0.000613076923076917, 0.000526178238300992, 0.000813461538461543, 0.000776765383844083, 0.00215269230769233, 0.00213751214121607, 0.00571692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1230, '2025-07-06 00:00:00', 0.000244695415065026, 0.000390384615384611, 0.000322648653873164, 0.000546923076923086, 0.000358263332458985, 0.000786153846153851, 0.000768156334248524, 0.0021219230769231, 0.00221453797924949, 0.00578230769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1245, '2025-07-06 00:00:00', 0.000296463514423987, 0.000438846153846164, 0.000340388239876395, 0.000598076923076926, 0.000396787290429211, 0.000838076923076918, 0.000759538422586107, 0.00213115384615387, 0.00226447171628309, 0.00580807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1260, '2025-07-06 00:00:00', 0.000290763451306018, 0.000439230769230769, 0.000296152767230806, 0.000612307692307698, 0.000438998160150344, 0.000889230769230775, 0.00080055067585716, 0.00215576923076925, 0.00227582816709737, 0.00584538461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1275, '2025-07-06 00:00:00', 0.000215099619139253, 0.000379615384615391, 0.000342768816461572, 0.000567692307692295, 0.000525266965090493, 0.000855769230769235, 0.000831658953769273, 0.00217384615384617, 0.00245033463962655, 0.00595961538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1290, '2025-07-06 00:00:00', 0.000279127486726321, 0.000438076923076902, 0.000404331356876814, 0.000669615384615377, 0.000611640039943048, 0.000846538461538461, 0.000844077010704585, 0.00219500000000001, 0.00254334827767225, 0.0060226923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1305, '2025-07-06 00:00:00', 0.000311361279149882, 0.000455384615384618, 0.000484404789406535, 0.000620000000000009, 0.000583391674738194, 0.000785384615384624, 0.000872684628911534, 0.00221769230769232, 0.00260942893841073, 0.00608076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1320, '2025-07-06 00:00:00', 0.000261978272733845, 0.000416153846153848, 0.000393283025900615, 0.000576538461538472, 0.000400529073178885, 0.000706538461538474, 0.000901789332383126, 0.00219000000000002, 0.00263441229761897, 0.00609192307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1335, '2025-07-06 00:00:00', 0.00033984725075563, 0.000431923076923084, 0.000358966036533563, 0.000523846153846161, 0.000429874400261289, 0.000700000000000004, 0.000894645954898023, 0.00219076923076925, 0.00270905742904171, 0.00614807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1350, '2025-07-06 00:00:00', 0.00031893597138948, 0.000388076923076942, 0.000332961536240118, 0.000509230769230792, 0.000465078487999598, 0.000715000000000004, 0.000940774476367543, 0.00221615384615387, 0.00276083599379161, 0.00618076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1365, '2025-07-06 00:00:00', 0.000253987280117602, 0.000391538461538469, 0.00038300190800891, 0.000557692307692319, 0.000639724459916442, 0.000840769230769243, 0.00095921354003403, 0.00220115384615387, 0.00278061567615186, 0.00620346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1380, '2025-07-06 00:00:00', 0.00029657350885379, 0.000390384615384615, 0.000311469963979735, 0.00050846153846153, 0.000697515591223599, 0.00106000000000001, 0.000997908582216594, 0.00215153846153847, 0.00277792365736601, 0.00620961538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1395, '2025-07-06 00:00:00', 0.000211239565058617, 0.000333076923076919, 0.000566858549714667, 0.000556153846153852, 0.00083941298169981, 0.00180692307692309, 0.00105011589104031, 0.00217923076923079, 0.0027746335586191, 0.00623076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1410, '2025-07-06 00:00:00', 0.000450262829228234, 0.000373846153846165, 0.000637785109699064, 0.000854615384615402, 0.000840272208641572, 0.00180423076923079, 0.00108188695556207, 0.00222076923076924, 0.00278299219159189, 0.00626153846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 1, 1425, '2025-07-06 00:00:00', 0.000548456435406191, 0.000707307692307684, 0.000834605388100361, 0.00172307692307693, 0.000811567239737648, 0.00177576923076925, 0.00107606526825209, 0.0022073076923077, 0.00278067897076622, 0.00626346153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 0, '2025-07-06 00:00:00', 0.000878976327676335, 0.00128076923076924, 0.000897252215634789, 0.00143846153846155, 0.000893502098486621, 0.00162500000000002, 0.00110462384826413, 0.00217461538461539, 0.0028643579761239, 0.00631115384615383 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 15, '2025-07-06 00:00:00', 0.000379633223803422, 0.000584230769230771, 0.000424998099543271, 0.000799230769230783, 0.000751996317503252, 0.00123769230769232, 0.00108542256925408, 0.00180692307692308, 0.0028795627873262, 0.00623461538461537 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 30, '2025-07-06 00:00:00', 0.000407124248659028, 0.000563076923076931, 0.00071740182925289, 0.00088423076923078, 0.000787975009365536, 0.00128615384615386, 0.00118979047929263, 0.00186423076923077, 0.00287140182864371, 0.00624269230769229 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 45, '2025-07-06 00:00:00', 0.000740703719445231, 0.000755000000000006, 0.000774541452433925, 0.00114769230769232, 0.000845976631792189, 0.00131269230769232, 0.00121647213759233, 0.00188269230769231, 0.00291009510814707, 0.00624846153846152 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 60, '2025-07-06 00:00:00', 0.000560642076963134, 0.000936538461538465, 0.000606625090150414, 0.00103500000000001, 0.000678239916707496, 0.00112576923076924, 0.00101153843229014, 0.001755, 0.00290261229823174, 0.0062030769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 75, '2025-07-06 00:00:00', 0.000285096744713369, 0.000378076923076923, 0.000378885003865075, 0.000575384615384619, 0.000427185601889322, 0.000683461538461545, 0.000787973056938836, 0.00153153846153846, 0.00298682473540045, 0.00629499999999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 90, '2025-07-06 00:00:00', 0.000305717818609563, 0.00038923076923077, 0.000334663321057973, 0.000476538461538462, 0.000373300662489898, 0.000645769230769243, 0.000723111652193795, 0.0014776923076923, 0.00299764399795264, 0.00629153846153845 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 105, '2025-07-06 00:00:00', 0.000155101951582226, 0.000293846153846166, 0.000243364873263298, 0.000432307692307698, 0.000329283838282178, 0.000609615384615394, 0.000684909876160017, 0.00143846153846153, 0.00300271018607164, 0.00629730769230768 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 120, '2025-07-06 00:00:00', 0.000199497831104458, 0.000350769230769236, 0.000247014481045451, 0.000488076923076935, 0.000552339917637121, 0.000709230769230757, 0.000688029516361474, 0.00144615384615384, 0.00300768451700741, 0.00631307692307691 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 135, '2025-07-06 00:00:00', 0.000227978406534817, 0.000346923076923078, 0.000234945492860331, 0.000439230769230764, 0.000547073894600949, 0.000795384615384621, 0.00070477623290057, 0.00141153846153845, 0.00301665267881726, 0.00630423076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 150, '2025-07-06 00:00:00', 0.000126853640680295, 0.000279615384615385, 0.000500287455830688, 0.000476538461538449, 0.000585228029193622, 0.000799615384615405, 0.000703701532010443, 0.00137961538461537, 0.00301775453964341, 0.00630230769230768 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 165, '2025-07-06 00:00:00', 0.000430897453444096, 0.000396153846153832, 0.000477764183865442, 0.000631153846153852, 0.000529636159583583, 0.000797692307692315, 0.000679048315942695, 0.00135884615384614, 0.00302179518727629, 0.00628692307692306 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 180, '2025-07-06 00:00:00', 0.000344410533207997, 0.000511153846153856, 0.000475404443201127, 0.000654230769230789, 0.000496970669309409, 0.000849615384615387, 0.000654736705742206, 0.00134192307692306, 0.00302417734522706, 0.00628384615384614 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 195, '2025-07-06 00:00:00', 0.000214407232943435, 0.000377692307692327, 0.000264710291567106, 0.000506538461538471, 0.000404138019074603, 0.000833461538461524, 0.000734169232219975, 0.00141730769230768, 0.0030208491164928, 0.00628423076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 210, '2025-07-06 00:00:00', 0.000203400703425141, 0.000389615384615392, 0.00034826360484773, 0.000616538461538457, 0.000414507678318045, 0.000816153846153834, 0.000734715957674488, 0.00139346153846153, 0.00301784021088949, 0.00627346153846152 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 225, '2025-07-06 00:00:00', 0.000296426148540341, 0.000457307692307686, 0.000314213058534882, 0.00060461538461537, 0.000360735360063304, 0.000754999999999989, 0.000730539947836267, 0.00138615384615384, 0.00301649965255196, 0.00626692307692306 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 240, '2025-07-06 00:00:00', 0.00023350835926399, 0.000443076923076918, 0.000298811234471133, 0.000551923076923072, 0.000384117770401824, 0.000722307692307689, 0.000740513750976057, 0.00137384615384614, 0.00302111179229409, 0.00627730769230768 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 255, '2025-07-06 00:00:00', 0.000259906492060872, 0.000379230769230773, 0.000336284906681134, 0.000556538461538469, 0.000511323621744424, 0.000779615384615385, 0.000692520480119261, 0.00137384615384615, 0.00303155804065271, 0.00626192307692306 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 270, '2025-07-06 00:00:00', 0.00026174121100518, 0.000382692307692308, 0.000293089642364818, 0.000471538461538455, 0.000480593863400738, 0.000762307692307686, 0.000683615839038723, 0.00137115384615383, 0.00300848921962758, 0.00625076923076921 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 285, '2025-07-06 00:00:00', 0.000158364720235881, 0.000330769230769233, 0.000329781512753304, 0.00053961538461538, 0.000338381668897952, 0.000733076923076926, 0.000641044340240089, 0.00133461538461538, 0.00298111512434783, 0.00625923076923075 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 300, '2025-07-06 00:00:00', 0.000285095665455535, 0.00040653846153846, 0.000336622363167701, 0.00056115384615385, 0.000332689737651246, 0.000722307692307693, 0.000601921538459571, 0.00134846153846153, 0.0029578290375518, 0.00626384615384614 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 315, '2025-07-06 00:00:00', 0.000183160711272499, 0.000350384615384618, 0.000163778462000924, 0.000449230769230766, 0.000271086701997709, 0.000649999999999992, 0.000545569004307945, 0.00135846153846153, 0.00289797024457835, 0.00622653846153844 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 330, '2025-07-06 00:00:00', 0.000136061072260288, 0.00033384615384615, 0.000225301165963738, 0.000486153846153841, 0.000284016521729605, 0.000665769230769211, 0.000612686392361241, 0.00147615384615384, 0.00289596780687588, 0.00623153846153844 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 345, '2025-07-06 00:00:00', 0.000206107141667022, 0.000331923076923069, 0.000291234243548677, 0.000495769230769221, 0.000358677914226465, 0.000654615384615369, 0.000793253960692187, 0.00167038461538461, 0.00290110867401783, 0.00621653846153845 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 360, '2025-07-06 00:00:00', 0.000235706466736772, 0.000371538461538453, 0.000251550270247393, 0.000488461538461527, 0.000296249634858602, 0.000640384615384605, 0.00073771414101002, 0.00175692307692307, 0.00289371169687226, 0.00620923076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 375, '2025-07-06 00:00:00', 0.000160712356520781, 0.000312692307692298, 0.000240843389906263, 0.000448461538461522, 0.00054055697771266, 0.000684615384615382, 0.000855423601767888, 0.00199153846153845, 0.00288543965454139, 0.00618499999999999 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 390, '2025-07-06 00:00:00', 0.000149697643987413, 0.000305769230769218, 0.000172680674612462, 0.000398846153846149, 0.000516877012599576, 0.000665384615384619, 0.00085405062000941, 0.00208230769230769, 0.00288285179319687, 0.00617769230769229 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 405, '2025-07-06 00:00:00', 0.00013743194119831, 0.000273461538461541, 0.000524617369723295, 0.000490769230769243, 0.00051221329691689, 0.000662307692307688, 0.00084517462920166, 0.00223807692307692, 0.00288274038960259, 0.00616807692307691 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 420, '2025-07-06 00:00:00', 0.000460401998258045, 0.000345000000000001, 0.000459540405857187, 0.000475769230769235, 0.000492083951561749, 0.000661153846153839, 0.000818981356038389, 0.00237230769230769, 0.00288421529122806, 0.00616461538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 435, '2025-07-06 00:00:00', 0.000254312043333829, 0.000348846153846155, 0.000305250716624895, 0.000484999999999992, 0.000417532679513307, 0.000691538461538461, 0.00091257513916136, 0.00251423076923077, 0.00289624172918044, 0.00615192307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 450, '2025-07-06 00:00:00', 0.000183833118301941, 0.000328846153846148, 0.000290490301704926, 0.00044615384615384, 0.000287156081921703, 0.000651153846153846, 0.00100384437960349, 0.00262346153846154, 0.00290076234011787, 0.00614692307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 465, '2025-07-06 00:00:00', 0.000162596243688286, 0.00031153846153844, 0.000214868832976358, 0.000483846153846147, 0.000282052095569933, 0.00063576923076922, 0.00112946713099584, 0.00268999999999999, 0.00290268257889941, 0.00614307692307691 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 480, '2025-07-06 00:00:00', 0.000144915890724994, 0.000333846153846155, 0.000193437328352113, 0.000504999999999995, 0.000277388092473631, 0.000701923076923085, 0.00131889516700095, 0.00275269230769231, 0.00291171059952471, 0.00613884615384614 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 495, '2025-07-06 00:00:00', 0.000167941839749553, 0.000367307692307682, 0.00020096230032981, 0.000485384615384605, 0.000315951554222143, 0.000854230769230776, 0.00140697695569122, 0.00278192307692308, 0.0029099158856466, 0.00613230769230768 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 510, '2025-07-06 00:00:00', 0.000194648796159023, 0.000358076923076916, 0.000275153663362025, 0.000548461538461545, 0.000497730850962653, 0.00103, 0.00144238952383242, 0.00287653846153846, 0.00291820969879716, 0.00611961538461537 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 525, '2025-07-06 00:00:00', 0.000240333422241178, 0.000411923076923081, 0.000280161766457548, 0.00073884615384616, 0.000808612486823046, 0.00130692307692306, 0.00147313694595527, 0.00297730769230769, 0.00291820969879716, 0.00611961538461537 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 540, '2025-07-06 00:00:00', 0.000243700951672644, 0.000613076923076934, 0.000522645342317486, 0.000886923076923072, 0.000761489633244244, 0.00143230769230768, 0.00149801982116906, 0.00303076923076924, 0.00291973837078703, 0.00611807692307691 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 555, '2025-07-06 00:00:00', 0.000425784524775711, 0.000597307692307685, 0.000788096831223572, 0.00105615384615383, 0.000811881480550923, 0.00162346153846152, 0.00142142317631093, 0.00308038461538462, 0.00287584593574722, 0.00607461538461537 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 570, '2025-07-06 00:00:00', 0.000665074316263867, 0.000749615384615389, 0.000630518711977574, 0.00100538461538461, 0.000685904792675622, 0.00159423076923078, 0.00128431011112522, 0.00305269230769232, 0.00289091531951653, 0.00601923076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 585, '2025-07-06 00:00:00', 0.0002821881532704, 0.000633076923076911, 0.000639449402581273, 0.00123346153846153, 0.000617525209700295, 0.00168576923076923, 0.00131874188294986, 0.00296807692307693, 0.0028934255450271, 0.00599076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 600, '2025-07-06 00:00:00', 0.000641129772055072, 0.00104076923076923, 0.000629889367575467, 0.00125615384615385, 0.000596529449914583, 0.00172923076923077, 0.0013262430453671, 0.00296615384615384, 0.00291845430638574, 0.00598346153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 615, '2025-07-06 00:00:00', 0.000301774495532416, 0.000779615384615381, 0.000528848386009278, 0.00122615384615383, 0.000571736491213045, 0.00163115384615385, 0.00118803729545186, 0.00291384615384616, 0.00295420201382056, 0.00601846153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 630, '2025-07-06 00:00:00', 0.000389157867906883, 0.000930384615384621, 0.000446398407772163, 0.00125653846153846, 0.000664591140939562, 0.00171576923076923, 0.00119140615047287, 0.00293615384615384, 0.00307373931630763, 0.00602423076923076 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 645, '2025-07-06 00:00:00', 0.000373394614933775, 0.00085346153846154, 0.000508402777938299, 0.00112423076923078, 0.000756143759225291, 0.00158576923076923, 0.00118521280140545, 0.00277423076923077, 0.00315838654038126, 0.00603846153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 660, '2025-07-06 00:00:00', 0.000382142140288942, 0.000716153846153841, 0.000542008799247324, 0.00108153846153846, 0.000803805563936571, 0.00142923076923076, 0.00114153937901683, 0.00269192307692307, 0.00314814301796129, 0.0059826923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 675, '2025-07-06 00:00:00', 0.000339560802304303, 0.000718461538461544, 0.000501953721434098, 0.000978461538461539, 0.000716135462046119, 0.001335, 0.00112658667596485, 0.00265846153846153, 0.00313928009875856, 0.00592653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 690, '2025-07-06 00:00:00', 0.000324174929035837, 0.00064576923076923, 0.000466104643252504, 0.00089846153846154, 0.000767505950866421, 0.00129423076923078, 0.00127402095140363, 0.00260423076923078, 0.00313011663582145, 0.00590692307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 705, '2025-07-06 00:00:00', 0.000280355817873264, 0.000600769230769238, 0.00045720236219862, 0.000885000000000012, 0.000761477511158397, 0.00134, 0.00130552465138911, 0.00261884615384616, 0.00319699483890733, 0.00591 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 720, '2025-07-06 00:00:00', 0.000320175913186194, 0.00067615384615386, 0.000558541094142711, 0.000961923076923093, 0.000684112114068572, 0.00133576923076924, 0.00118925497039761, 0.00264923076923077, 0.00311109629453127, 0.00586192307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 735, '2025-07-06 00:00:00', 0.000381881375056935, 0.000695769230769241, 0.000464750056895742, 0.000976153846153845, 0.000641328429001988, 0.00133307692307692, 0.00102562671272066, 0.00260307692307692, 0.00299472410441071, 0.00580269230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 750, '2025-07-06 00:00:00', 0.00026222509414623, 0.000654999999999987, 0.000406442918690737, 0.000859615384615384, 0.000576603449921658, 0.00119346153846154, 0.00097843273421561, 0.00253115384615384, 0.00292884676700839, 0.00571076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 765, '2025-07-06 00:00:00', 0.000370342253348691, 0.000614230769230762, 0.000551605349446929, 0.000902692307692286, 0.000646991618064846, 0.00119692307692307, 0.000991341282536715, 0.00254846153846153, 0.00292287708628648, 0.00568230769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 780, '2025-07-06 00:00:00', 0.000422845307229667, 0.000663076923076903, 0.000425297000296899, 0.000831538461538452, 0.000555992805708849, 0.00116, 0.000888236714811124, 0.0025626923076923, 0.00283527703164151, 0.00562961538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 795, '2025-07-06 00:00:00', 0.000247592717675938, 0.000566923076923076, 0.000371442924490237, 0.000794615384615385, 0.000447866738421848, 0.00115615384615385, 0.00100573256882731, 0.002735, 0.00280650376529507, 0.00557923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 810, '2025-07-06 00:00:00', 0.000285965032827463, 0.000590000000000001, 0.000346473442205668, 0.000810384615384621, 0.000384845223633926, 0.00116538461538461, 0.00101833718157819, 0.00285115384615384, 0.00280112200047383, 0.00554730769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 825, '2025-07-06 00:00:00', 0.000189910100189116, 0.000524615384615397, 0.000295623721334039, 0.000825769230769239, 0.000423473729999857, 0.001145, 0.000912294149594644, 0.00283384615384615, 0.00280830614154074, 0.00554076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 840, '2025-07-06 00:00:00', 0.000263047524223281, 0.000644999999999994, 0.000340022849910901, 0.000883461538461523, 0.000427233137579645, 0.00122807692307691, 0.000923949132798981, 0.002885, 0.00284870464489498, 0.00551307692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 855, '2025-07-06 00:00:00', 0.000258568842194582, 0.000585384615384607, 0.000303643515681436, 0.000810769230769222, 0.000417868584421166, 0.00118307692307691, 0.0010223854459058, 0.00290999999999999, 0.00291515108461875, 0.00548538461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 870, '2025-07-06 00:00:00', 0.000221720891767447, 0.000578076923076931, 0.000353567314883381, 0.00084538461538462, 0.000535279222606158, 0.0012896153846154, 0.000994201960600322, 0.00295846153846153, 0.00298210398105871, 0.00547807692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 885, '2025-07-06 00:00:00', 0.000298962565189386, 0.00065115384615385, 0.000340529903803776, 0.000913846153846158, 0.000583803444267378, 0.00133769230769232, 0.000920177909219395, 0.00293076923076923, 0.00312123466694734, 0.00545538461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 900, '2025-07-06 00:00:00', 0.000267449779613636, 0.000664230769230774, 0.000480012980593719, 0.000952692307692319, 0.000496338594106883, 0.00133, 0.000970999801948794, 0.00291384615384615, 0.00315204121898079, 0.00538961538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 915, '2025-07-06 00:00:00', 0.000359906184357073, 0.000682692307692309, 0.000429432720619257, 0.000997307692307693, 0.000505000380807166, 0.00132576923076923, 0.000941305231294041, 0.00287346153846153, 0.0031488119371256, 0.00536384615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 930, '2025-07-06 00:00:00', 0.000378251035892629, 0.000794615384615389, 0.000441161404267627, 0.00107923076923077, 0.000509809617557221, 0.00136538461538462, 0.00103359268870955, 0.00288461538461538, 0.00316248217994371, 0.00532846153846153 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 945, '2025-07-06 00:00:00', 0.000309445409625765, 0.0006973076923077, 0.000361053373424949, 0.000923461538461546, 0.000469778507547799, 0.00128038461538463, 0.000942193920918294, 0.00275423076923077, 0.00317787602023742, 0.0052 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 960, '2025-07-06 00:00:00', 0.000309194735749799, 0.000715769230769227, 0.000310139670768852, 0.000918846153846157, 0.000453954419941718, 0.00139115384615384, 0.00106392018208424, 0.00279692307692307, 0.00318283734087395, 0.00516153846153847 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 975, '2025-07-06 00:00:00', 0.000240316778120365, 0.000671923076923085, 0.000394879728525033, 0.00102500000000001, 0.000662196810158901, 0.00169384615384615, 0.00125401852519749, 0.0028823076923077, 0.00344241462661582, 0.0052023076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 990, '2025-07-06 00:00:00', 0.00035132299405796, 0.000800384615384619, 0.000380433760533746, 0.00112538461538461, 0.000771381577730208, 0.00187153846153846, 0.00145003639211627, 0.00286153846153846, 0.00374992488129891, 0.00526384615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1005, '2025-07-06 00:00:00', 0.000358384409001554, 0.000829230769230753, 0.000633914335391927, 0.00138923076923076, 0.0007553591097057, 0.00184076923076922, 0.00158241378425979, 0.00285423076923076, 0.00396871488597429, 0.00529461538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1020, '2025-07-06 00:00:00', 0.00047535460447964, 0.001075, 0.000669238028254179, 0.00146346153846154, 0.000751907932170917, 0.00187846153846154, 0.00170585868293768, 0.00284461538461538, 0.00396339070066956, 0.00530538461538462 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1035, '2025-07-06 00:00:00', 0.000491263520072317, 0.000930384615384621, 0.000581895576146151, 0.0012576923076923, 0.000696466355695228, 0.00169576923076924, 0.00190255180865474, 0.00276923076923077, 0.00417823880821352, 0.00532653846153847 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1050, '2025-07-06 00:00:00', 0.000370490942482449, 0.000886538461538462, 0.000637104507789857, 0.00131692307692308, 0.000655078738661342, 0.00161192307692308, 0.00181653499405197, 0.00265923076923076, 0.00394984385280462, 0.0052923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1065, '2025-07-06 00:00:00', 0.000613992232474043, 0.0010176923076923, 0.000595464395370401, 0.00123538461538462, 0.000553486988242565, 0.00152961538461539, 0.00172519202944528, 0.00256653846153846, 0.00385154572367231, 0.0053073076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1080, '2025-07-06 00:00:00', 0.000404731439922247, 0.000773461538461537, 0.000489367095181261, 0.00105807692307693, 0.000503983516213947, 0.00141076923076923, 0.00173990751301503, 0.00242692307692308, 0.00384175330565855, 0.00545269230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1095, '2025-07-06 00:00:00', 0.000258789192498152, 0.000669615384615377, 0.000333445647744865, 0.000944999999999999, 0.000393032392479881, 0.0012376923076923, 0.00164262215328467, 0.00233653846153846, 0.00367893674020924, 0.00537346153846155 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1110, '2025-07-06 00:00:00', 0.000244020175710628, 0.000684615384615382, 0.000378347012064921, 0.000997692307692298, 0.000436305644456512, 0.00120884615384615, 0.00177412270844364, 0.00233076923076924, 0.00367547974890561, 0.00541923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1125, '2025-07-06 00:00:00', 0.000301814257704708, 0.000639615384615369, 0.000338006827423086, 0.000826153846153844, 0.000417900245734093, 0.00111384615384616, 0.00174435621803135, 0.00224884615384617, 0.00362614582421358, 0.00545153846153847 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1140, '2025-07-06 00:00:00', 0.000305199052322372, 0.000637692307692309, 0.000378750374460341, 0.000839615384615389, 0.000551166176253738, 0.00112192307692308, 0.00169675708791349, 0.00218615384615385, 0.0037193623316163, 0.00552807692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1155, '2025-07-06 00:00:00', 0.000336922040743043, 0.000612692307692312, 0.000386832502015257, 0.000780769230769239, 0.000786618468753838, 0.00118384615384616, 0.00171803040180856, 0.00214269230769232, 0.00403478378030921, 0.00572192307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1170, '2025-07-06 00:00:00', 0.000242601604408414, 0.000503461538461553, 0.000418255166872318, 0.000754230769230783, 0.000850994350519095, 0.00113076923076925, 0.00164042925901916, 0.00205807692307694, 0.00399251068107045, 0.00571846153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1185, '2025-07-06 00:00:00', 0.000385417256409806, 0.000567692307692316, 0.000647107291068377, 0.000879615384615391, 0.0009392442952469, 0.00115038461538462, 0.00160474622963833, 0.00199769230769232, 0.0040477853393981, 0.00575307692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1200, '2025-07-06 00:00:00', 0.000474208165909641, 0.000634230769230769, 0.000603976693386317, 0.000829615384615388, 0.000810181366209967, 0.00110461538461537, 0.00156006710901018, 0.00201423076923078, 0.00401828130117649, 0.00580384615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1215, '2025-07-06 00:00:00', 0.000450220629674645, 0.000518846153846162, 0.000590906604620924, 0.000748846153846145, 0.000831711580925853, 0.00106192307692306, 0.00125391129608978, 0.00228846153846153, 0.00374966656979196, 0.00574923076923078 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1230, '2025-07-06 00:00:00', 0.000372746356325379, 0.000550384615384609, 0.000446747562517563, 0.000729230769230751, 0.000721376888585045, 0.00105615384615383, 0.00108074817389835, 0.00225615384615384, 0.00368129843314098, 0.00575692307692309 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1245, '2025-07-06 00:00:00', 0.000328213110880473, 0.000519615384615364, 0.000570855363602589, 0.000770384615384598, 0.000750503933264956, 0.00105192307692307, 0.00109739804152296, 0.00226230769230769, 0.00371472349110733, 0.00576884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1260, '2025-07-06 00:00:00', 0.000429752701696438, 0.000520769230769239, 0.000539415780836449, 0.000664230769230774, 0.000669413520582351, 0.000922307692307714, 0.00100413912612514, 0.00219923076923077, 0.00375294305025558, 0.00583153846153847 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1275, '2025-07-06 00:00:00', 0.000298264982859201, 0.000414999999999999, 0.000582449997853895, 0.000660000000000007, 0.000709139890723549, 0.000969230769230756, 0.00127001126584948, 0.00241615384615384, 0.00375478476285722, 0.00583615384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1290, '2025-07-06 00:00:00', 0.000596755844932866, 0.000568461538461552, 0.000596196792497762, 0.000738846153846165, 0.000835225994290459, 0.00102769230769232, 0.00128603170196598, 0.00243846153846153, 0.00375125892714188, 0.00584346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1305, '2025-07-06 00:00:00', 0.000200191062583875, 0.00045269230769231, 0.000335574822563413, 0.000642307692307686, 0.000497875022934015, 0.00086346153846155, 0.00110389464380228, 0.00231076923076922, 0.00357012150191861, 0.00583346153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1320, '2025-07-06 00:00:00', 0.000237832843691657, 0.0004426923076923, 0.000413928273236575, 0.000626153846153849, 0.000435131987049728, 0.000799615384615384, 0.00111598269906632, 0.00228423076923075, 0.00350363988753675, 0.00583269230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1335, '2025-07-06 00:00:00', 0.000239113748277658, 0.000369230769230771, 0.000356303457527646, 0.000508076923076929, 0.000472752984776808, 0.000750769230769234, 0.0011405917492519, 0.00224846153846152, 0.00350744599168902, 0.00584423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1350, '2025-07-06 00:00:00', 0.000281325707759085, 0.000378076923076932, 0.000331154623424434, 0.000549230769230776, 0.00052657047157855, 0.0007873076923077, 0.00114357011826323, 0.00224384615384614, 0.00367987936675187, 0.00589192307692309 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1365, '2025-07-06 00:00:00', 0.000215003398899787, 0.00041230769230769, 0.000290178989856001, 0.000569615384615388, 0.000460870247049414, 0.00076576923076923, 0.00114609927077086, 0.00223653846153844, 0.00367841947664399, 0.0058946153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1380, '2025-07-06 00:00:00', 0.000231961535272881, 0.000393076923076919, 0.000423478634462407, 0.000593076923076918, 0.000648864688987897, 0.000974230769230772, 0.0011341778452321, 0.00220923076923075, 0.00367506617418181, 0.00590923076923078 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1395, '2025-07-06 00:00:00', 0.000320936130717615, 0.000440000000000009, 0.000351363060095966, 0.000520000000000008, 0.000791026305115447, 0.00162115384615384, 0.00107727405269753, 0.00218076923076922, 0.00363386770005987, 0.0059623076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1410, '2025-07-06 00:00:00', 0.000224747379551771, 0.00031076923076923, 0.000504855958132158, 0.000746538461538459, 0.00076108707679314, 0.00156846153846153, 0.00105345154318846, 0.00216192307692307, 0.0036908272160129, 0.00604153846153847 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 2, 1425, '2025-07-06 00:00:00', 0.000404207296398203, 0.000623461538461532, 0.000736640711922404, 0.00140346153846152, 0.000702071331024244, 0.00152192307692306, 0.00102182672021916, 0.00215538461538461, 0.00369468674637596, 0.00603692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 0, '2025-07-06 00:00:00', 0.000477038943741651, 0.000853076923076922, 0.000510131808005007, 0.00108769230769231, 0.000710606349968364, 0.00131576923076922, 0.00104979265352002, 0.00213384615384614, 0.0036851456499762, 0.00608769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 15, '2025-07-06 00:00:00', 0.000480745094778761, 0.000669615384615386, 0.000568506410220256, 0.000856538461538454, 0.00104286122684734, 0.00153346153846153, 0.00107448305996598, 0.00195538461538461, 0.00361427632931068, 0.00607576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 30, '2025-07-06 00:00:00', 0.000449059187464341, 0.000576923076923082, 0.000616530241319521, 0.00077153846153846, 0.00109025416937801, 0.00146307692307693, 0.00111917448972962, 0.00191346153846154, 0.00361316424289761, 0.00609961538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 45, '2025-07-06 00:00:00', 0.0004161103773686, 0.000539615384615384, 0.000882809239782954, 0.00119807692307692, 0.000941779412356458, 0.00133730769230769, 0.00103001657940354, 0.00182692307692308, 0.00353433098880985, 0.00603653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 60, '2025-07-06 00:00:00', 0.00076828079802594, 0.00106076923076923, 0.000832255877812728, 0.00116461538461539, 0.000871967624663634, 0.00125653846153846, 0.000974202948371338, 0.00175923076923078, 0.00352532429495719, 0.00601076923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 75, '2025-07-06 00:00:00', 0.000443614524281902, 0.000494615384615392, 0.000511073229737042, 0.00062961538461538, 0.000699315379496275, 0.000855000000000003, 0.000920542315076388, 0.00152307692307693, 0.0034630997453371, 0.00597961538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 90, '2025-07-06 00:00:00', 0.000309566446204002, 0.000390769230769229, 0.000390845434726003, 0.000521923076923063, 0.000442980291278907, 0.000706538461538449, 0.000874545684253362, 0.00143307692307692, 0.00348457049555058, 0.00598653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 105, '2025-07-06 00:00:00', 0.000230876590411414, 0.000329999999999993, 0.000317731623568367, 0.000475769230769226, 0.000300177383455967, 0.000612307692307677, 0.00095713522877066, 0.00143961538461539, 0.00348034253398228, 0.00600807692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 120, '2025-07-06 00:00:00', 0.000257266398894231, 0.000395000000000009, 0.000251336121864422, 0.000484615384615391, 0.000253377492777396, 0.000651923076923073, 0.000935239089135054, 0.00143807692307692, 0.00348034253398228, 0.00600807692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 135, '2025-07-06 00:00:00', 0.000178338054095212, 0.000322692307692295, 0.000212624985868057, 0.000455769230769215, 0.000269795364047536, 0.000721538461538449, 0.000940630639517984, 0.001405, 0.00347986226517882, 0.00601423076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 150, '2025-07-06 00:00:00', 0.00023241474863833, 0.000346153846153842, 0.000261827012768714, 0.000504230769230772, 0.000366910594853008, 0.00078076923076923, 0.00093876219647921, 0.00141769230769232, 0.0034681897073479, 0.00600961538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 165, '2025-07-06 00:00:00', 0.000217481033655809, 0.000385000000000011, 0.000284187641153901, 0.000601153846153856, 0.000401197630179375, 0.000823461538461544, 0.000940154242664469, 0.00139500000000001, 0.00345574342441458, 0.00601115384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 180, '2025-07-06 00:00:00', 0.000267341613785697, 0.00047346153846154, 0.000351225546644018, 0.000619230769230761, 0.000425555926000157, 0.000834615384615378, 0.000950039675284875, 0.00137923076923076, 0.00345703536841345, 0.00600846153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 195, '2025-07-06 00:00:00', 0.000294224665597841, 0.000431923076923071, 0.000363075961537187, 0.000591923076923086, 0.000486366117240908, 0.000810000000000007, 0.00097303466615453, 0.0013173076923077, 0.00346071475498698, 0.00600115384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 210, '2025-07-06 00:00:00', 0.000251548129665998, 0.000422692307692323, 0.000377585242540828, 0.000591153846153855, 0.000565714252414256, 0.000783846153846156, 0.000981843478047611, 0.00128615384615384, 0.00346548114097618, 0.00600346153846155 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 225, '2025-07-06 00:00:00', 0.000338245472992618, 0.000424999999999992, 0.000444603366885757, 0.000611923076923076, 0.000670104584259912, 0.000808076923076922, 0.000969220543291602, 0.00125730769230769, 0.0034741379450935, 0.00600769230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 240, '2025-07-06 00:00:00', 0.000205576113548088, 0.000428461538461531, 0.000267290967932815, 0.000542692307692306, 0.000430135041406947, 0.000741923076923082, 0.000954884527855834, 0.00124269230769231, 0.00355788822412743, 0.00603384615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 255, '2025-07-06 00:00:00', 0.000259264047167826, 0.000345384615384632, 0.000417243149918414, 0.000540384615384628, 0.000526231303340441, 0.000719230769230767, 0.000950501729857201, 0.00121846153846154, 0.00359923521791035, 0.00605692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 270, '2025-07-06 00:00:00', 0.000311540341874654, 0.000425769230769236, 0.000343862450138687, 0.000555769230769242, 0.000453022668816394, 0.000688461538461531, 0.000937868614711859, 0.00121153846153845, 0.00360224880616796, 0.0060473076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 285, '2025-07-06 00:00:00', 0.00018968516425504, 0.00035730769230771, 0.000312441748416942, 0.000519615384615381, 0.000448428538170962, 0.000681923076923074, 0.000969717167330442, 0.00124923076923076, 0.00360290901697717, 0.00604576923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 300, '2025-07-06 00:00:00', 0.000297118727887587, 0.000406538461538456, 0.00032994171979539, 0.000498461538461525, 0.000436546058896954, 0.000692692307692302, 0.000942842592295312, 0.00128192307692307, 0.00360398010751789, 0.00604384615384616 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 315, '2025-07-06 00:00:00', 0.000213928816342126, 0.000311538461538457, 0.000315010134147126, 0.000459230769230772, 0.000465046730488951, 0.000632692307692315, 0.000994168922343615, 0.00136038461538462, 0.00359143984410796, 0.00603807692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 330, '2025-07-06 00:00:00', 0.000206528820860798, 0.000333076923076923, 0.000326933538294169, 0.000491538461538466, 0.000542937877165997, 0.000641538461538484, 0.00101061169595449, 0.00149, 0.00359143984410796, 0.00603807692307693 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 345, '2025-07-06 00:00:00', 0.000211601948515105, 0.00032076923076924, 0.000342753780206947, 0.000448076923076934, 0.000447774668607053, 0.000606923076923086, 0.00117261102475825, 0.00159384615384616, 0.00359143528197509, 0.00603923076923078 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 360, '2025-07-06 00:00:00', 0.000183128370276143, 0.000299999999999993, 0.000283463469359869, 0.000433461538461551, 0.000418329277741085, 0.000620769230769232, 0.00123836641775178, 0.00169076923076924, 0.00359201338441914, 0.00604192307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 375, '2025-07-06 00:00:00', 0.000206404010098193, 0.000321153846153858, 0.000272210608508583, 0.000438846153846151, 0.000476984115200754, 0.000625384615384605, 0.00144625330263568, 0.00192615384615385, 0.00359595986971705, 0.00606923076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 390, '2025-07-06 00:00:00', 0.000269548054799416, 0.000328076923076912, 0.00039500886066011, 0.000459999999999986, 0.000656279959023115, 0.000670769230769223, 0.00147712985731946, 0.00211384615384616, 0.00359789778364235, 0.00606269230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 405, '2025-07-06 00:00:00', 0.0002781800744952, 0.000321923076923064, 0.000401384526933377, 0.000458461538461527, 0.00063483650227077, 0.000674230769230758, 0.00157995584164194, 0.00228269230769232, 0.0036018500588106, 0.00607961538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 420, '2025-07-06 00:00:00', 0.00036406951998843, 0.000348846153846142, 0.000608639339965663, 0.000534615384615386, 0.000703716288986269, 0.000696153846153838, 0.00154968205175722, 0.0023523076923077, 0.0036018500588106, 0.00607961538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 435, '2025-07-06 00:00:00', 0.000376318400375982, 0.000343461538461542, 0.000477852890140258, 0.000460769230769226, 0.000765927190755403, 0.000692692307692307, 0.00153300755179033, 0.00238192307692309, 0.0036018500588106, 0.00607961538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 450, '2025-07-06 00:00:00', 0.00043869965194356, 0.000325769230769221, 0.000611131611155769, 0.000475384615384613, 0.000763015979266094, 0.000724230769230757, 0.00157017784392039, 0.00251769230769231, 0.0036018500588106, 0.00607961538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 465, '2025-07-06 00:00:00', 0.000261183107004671, 0.000336153846153854, 0.000420651692203718, 0.000519615384615381, 0.000576381417519279, 0.00072346153846153, 0.00147928907041395, 0.00257192307692308, 0.0036018500588106, 0.00607961538461539 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 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 515840236501271300, 3, 480, '2025-07-06 00:00:00', 0.000354300176946913, 0.000416153846153823, 0.00041389798074106, 0.000536538461538454, 0.000477176471146034, 0.000784230769230757, 0.00144349831472551, 0.00263923076923077, 0.00360272315809114, 0.00607692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840236501271300 and enddate = '2025-07-06 00:00:00' and dayofweek = 3 and fromtime = 480); insert into powerstats_trumpet(symbolid, dayofweek[...];

[ Date: 2025-07-06 14:56:22 - Database: acaweb_fx - User: pgperfstats - Remote: 192.168.3.100 - Application: [unknown] ]

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

[ Date: 2025-07-06 14:51:09 - Database: acaweb_fx - User: postgres - Remote: 192.168.1.20 - Application: PostgreSQL JDBC Driver - Bind query: yes ]

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