select powerstats_tdata_add ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

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

select updateageforrelevantresults ();

[ Date: 2025-08-31 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-08-31 14:01:19 - 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-08-31 14:03:24 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

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

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

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

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

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

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

[ Date: 2025-08-31 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-08-31 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-08-31 14:41:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

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

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

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

[ Date: 2025-08-31 14:48: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-08-31 14:50:15 - Database: acaweb_fx - User: postgres - Remote: [local] - Application: psql ]

select powerstats_tdata_add ();

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

select updateageforrelevantresults ();

[ Date: 2025-08-31 14:02:31 - 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 ('500' = 0 OR ar.patternlengthbars <= '500') 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-08-31 14:41:54 - 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 = '689' 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 ('310' = 0 OR coalesce(bim.code, s.symbol) in ('#AAPL', '#ADS', '#AIG', '#ALV', '#AMZN', '#AXP', '#BA', '#BABA', '#BAC', '#BAS', '#BAYN', '#BEI', '#BIDU', '#BMW', '#C', '#CAT', '#CBK', '#CL', '#CSCO', '#CVX', '#DAI', '#DB1', '#DBK', '#DIS', '#DPW', '#DTE', '#EBAY', '#EON', '#F', '#FB', '#FDX', '#FME', '#GE', '#GM', '#GOOG', '#GS', '#HPQ', '#IBM', '#IFX', '#INTC', '#JD', '#JNJ', '#JPM', '#KO', '#LHA', '#LMT', '#MA', '#MCD', '#META', '#MMM', '#MSFT', '#MUV2', '#NFLX', '#NKE', '#NTES', '#ORCL', '#PFE', '#PG', '#QCOM', '#RACE', '#RWE', '#SAP', '#SIE', '#T', '#UBER', '#V', '#VOW', '#WB', '#XOM', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'AUS200', 'BRENT', 'BTCUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'CHI50', 'ESP35', 'ETHUSD', 'EU50', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'EURUSD', 'FRA40', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'GER30', 'HK50', 'HKCH50', 'IT40', 'JP225', 'LTCUSD', 'NAS100', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'SPX500', 'UK100', 'US30', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'WTI', 'XAGUSD', 'XAUUSD', '#ADS', '#ALV', '#BAS', '#BAYN', '#BEI', '#BMW', '#CBK', '#DAI', '#DB1', '#DBK', '#DPW', '#DTE', '#EON', '#FME', '#IFX', '#LHA', '#MUV2', '#RWE', '#SAP', '#SIE', '#VOW', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'AUDUSD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'EURUSD', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'GBPUSD', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDJPY', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'XAGUSD', 'XAUUSD', 'BTCUSD', 'ETHUSD', 'LTCUSD', 'AUDCAD', 'AUDCHF', 'AUDJPY', 'AUDNZD', 'CADCHF', 'CADJPY', 'CHFJPY', 'EURAUD', 'EURCAD', 'EURCHF', 'EURGBP', 'EURHUF', 'EURJPY', 'EURNZD', 'EURPLN', 'GBPAUD', 'GBPCAD', 'GBPCHF', 'GBPJPY', 'GBPNZD', 'NZDCAD', 'NZDCHF', 'NZDJPY', 'USDCNH', 'USDCZK', 'USDDKK', 'USDHKD', 'USDHUF', 'USDMXN', 'USDNOK', 'USDPLN', 'USDSEK', 'USDSGD', 'USDTRY', 'USDX', 'USDZAR', 'XAGUSD', 'XAUUSD', 'BRENT', 'WTI', 'AUS200', 'CHI50', 'ESP35', 'EU50', 'FRA40', 'GER30', 'HK50', 'HKCH50', 'IT40', 'JP225', 'NAS100', 'SPX500', 'UK100', 'US30', 'AUDUSD', 'EURUSD', 'GBPUSD', 'NZDUSD', 'USDCAD', 'USDCHF', 'USDJPY', '#AAPL', '#AIG', '#AMZN', '#AXP', '#BA', '#BABA', '#BAC', '#BIDU', '#C', '#CAT', '#CL', '#CSCO', '#CVX', '#DIS', '#EBAY', '#F', '#FB', '#FDX', '#GE', '#GM', '#GOOG', '#GS', '#HPQ', '#IBM', '#INTC', '#JD', '#JNJ', '#JPM', '#KO', '#LMT', '#MA', '#MCD', '#MMM', '#MSFT', '#NFLX', '#NKE', '#NTES', '#ORCL', '#PFE', '#PG', '#QCOM', '#RACE', '#T', '#UBER', '#V', '#WB', '#XOM')) AND ('0' = 0 OR ar.pattern in ('')) AND ('0' = 0 OR ('0' = 1 AND ar.breakout >= 0) OR ('0' = 2 AND ar.breakout < 0)) AND ('700' = 0 OR ar.patternlengthbars <= '700') 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-08-31 14:42:07 - Database: acaweb_fx - User: postgres - Remote: 192.168.0.74 - 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 515840238057457300, 5, 885, '2025-08-31 00:00:00', 0.260541117381027, 0.300923076923078, 0.355187112118929, 0.418269230769232, 0.411631463251369, 0.541307692307693, 0.578560235544967, 1.27611538461538, 1.3019641546525, 2.3895 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 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 515840238057457300, 5, 900, '2025-08-31 00:00:00', 0.201530929101751, 0.260346153846154, 0.245147804709416, 0.343384615384616, 0.27254889469598, 0.470499999999999, 0.573259351965048, 1.24573076923077, 1.27498776404385, 2.37796153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 900); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 915, '2025-08-31 00:00:00', 0.120399028874183, 0.218615384615383, 0.164043526118951, 0.31603846153846, 0.207519344788719, 0.512961538461537, 0.55969987149708, 1.24611538461538, 1.26847310756491, 2.38676923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 915); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 930, '2025-08-31 00:00:00', 0.15807135681759, 0.252923076923076, 0.171217216963177, 0.338153846153845, 0.230932317756992, 0.568153846153844, 0.557074556534817, 1.25330769230769, 1.26074501539612, 2.39907692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 930); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 945, '2025-08-31 00:00:00', 0.130731386379154, 0.222153846153845, 0.188221199656149, 0.429499999999999, 0.260686218690949, 0.641230769230769, 0.569860637484154, 1.24888461538462, 1.26258524525612, 2.38830769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 945); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 960, '2025-08-31 00:00:00', 0.157047004232688, 0.345807692307691, 0.198480690787252, 0.445230769230768, 0.33980229546017, 0.691, 0.582647201605277, 1.24080769230769, 1.38871635028125, 2.45330769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 960); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 975, '2025-08-31 00:00:00', 0.141692109329186, 0.275576923076921, 0.236749786775958, 0.462307692307693, 0.464242352159368, 0.744807692307693, 0.534955965118049, 1.23173076923077, 1.47854464202524, 2.49146153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 975); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 990, '2025-08-31 00:00:00', 0.191626238768639, 0.343846153846156, 0.254833354295583, 0.47096153846154, 0.42644794073116, 0.699615384615385, 0.515580628626972, 1.17576923076923, 1.48993242851428, 2.45580769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 990); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1005, '2025-08-31 00:00:00', 0.145830908404747, 0.304423076923077, 0.36915730439017, 0.523653846153846, 0.379083560912165, 0.652884615384615, 0.496278302816226, 1.13692307692308, 1.5037540756387, 2.447 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1005); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1020, '2025-08-31 00:00:00', 0.302623941551227, 0.424, 0.305814758745661, 0.523199999999999, 0.386353357260768, 0.7078, 0.498596613840621, 1.1356, 1.5165244343564, 2.45812 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1020); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1035, '2025-08-31 00:00:00', 0.166100988743411, 0.298461538461535, 0.192744250637591, 0.422884615384614, 0.511214090331875, 0.689615384615384, 0.51173430606126, 1.065, 1.50421714471732, 2.41146153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1035); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1050, '2025-08-31 00:00:00', 0.141112203037704, 0.300576923076923, 0.327062449929438, 0.474615384615386, 0.53044600247194, 0.675192307692309, 0.520747576529683, 1.02903846153846, 1.49922382585123, 2.413 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1050); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1065, '2025-08-31 00:00:00', 0.267595849111189, 0.32346153846154, 0.505559552909904, 0.512692307692307, 0.506164954869914, 0.675192307692309, 0.51861579821082, 0.982115384615386, 1.49124479340119, 2.39692307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1065); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1080, '2025-08-31 00:00:00', 0.350234426985917, 0.356923076923075, 0.375727243540392, 0.465192307692307, 0.370777405750923, 0.606730769230769, 0.464189492142362, 0.913269230769231, 1.49512773830404, 2.39507692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1080); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1095, '2025-08-31 00:00:00', 0.171645430600858, 0.288076923076922, 0.253372028083972, 0.419230769230769, 0.279139681053165, 0.545192307692308, 0.42156795236538, 0.841538461538461, 1.49905188497469, 2.37707692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1095); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1110, '2025-08-31 00:00:00', 0.189932477880551, 0.292115384615385, 0.193852937915477, 0.380192307692307, 0.20978083801911, 0.495, 0.413658024868928, 0.815192307692308, 1.49983661058848, 2.37453846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1110); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1125, '2025-08-31 00:00:00', 0.110833902061388, 0.243076923076923, 0.181941241571601, 0.351153846153846, 0.183036461268912, 0.437115384615384, 0.415620603620473, 0.768384615384616, 1.59509427789852, 2.40934615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1125); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1140, '2025-08-31 00:00:00', 0.193048917674731, 0.276730769230769, 0.186837753555984, 0.342884615384615, 0.215908189177359, 0.432115384615385, 0.41655203017889, 0.756076923076923, 1.6078140133543, 2.39569230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1140); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1155, '2025-08-31 00:00:00', 0.094544250933707, 0.191153846153845, 0.118490668246654, 0.295961538461538, 0.228615313438233, 0.470192307692308, 0.424347056800663, 0.723769230769231, 1.69035440662602, 2.4565 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1155); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1170, '2025-08-31 00:00:00', 0.0955141954814132, 0.215192307692308, 0.163549569056178, 0.302307692307694, 0.218206412512414, 0.454038461538463, 0.40225001984032, 0.69896153846154, 1.78842424884202, 2.51257692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1170); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1185, '2025-08-31 00:00:00', 0.14590663505765, 0.220884615384616, 0.206024867804463, 0.358384615384616, 0.242521370985353, 0.463846153846156, 0.379693035936218, 0.662807692307693, 1.79615728324494, 2.50488461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1185); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1200, '2025-08-31 00:00:00', 0.140621536994397, 0.258399999999999, 0.151794817654182, 0.309999999999999, 0.253349560883773, 0.451200000000002, 0.354610457638614, 0.62892, 1.89323741951892, 2.51148 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1200); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1215, '2025-08-31 00:00:00', 0.12210163799065, 0.220319999999998, 0.188684419070573, 0.333319999999999, 0.243938127401191, 0.41732, 1.1888882383695, 1.21808, 1.91592732116853, 2.5042 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1215); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1230, '2025-08-31 00:00:00', 0.121020659393344, 0.2172, 0.170961009199954, 0.283800000000001, 0.185493872315682, 0.37468, 1.16106010036805, 1.17584, 1.99859940291528, 2.51936 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1230); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1245, '2025-08-31 00:00:00', 0.0945572665989594, 0.182920000000001, 0.153550827632634, 0.265240000000001, 0.170050267078102, 0.363520000000001, 1.15922410545445, 1.16512, 2.00372906684844, 2.52656 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1245); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1260, '2025-08-31 00:00:00', 0.138193982020443, 0.21208, 0.156151294156233, 0.28932, 0.197522724431055, 0.36232, 1.15828107987656, 1.16168, 2.00251747557918, 2.52436 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1260); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1275, '2025-08-31 00:00:00', 0.125925149725277, 0.219679999999999, 0.141807063763881, 0.282919999999999, 0.206431788572724, 0.3458, 1.1504190874054, 1.14892, 2.00045844912277, 2.52444 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1275); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1290, '2025-08-31 00:00:00', 0.0857861099867964, 0.172440000000001, 0.140724589180427, 0.227920000000002, 0.178140796375602, 0.283320000000002, 1.14178450535408, 1.10624, 2.00489860757762, 2.52052 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1290); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1305, '2025-08-31 00:00:00', 0.102736037169696, 0.123880000000001, 0.125463367827692, 0.17184, 0.18025761195208, 0.260159999999999, 1.13005033073753, 1.0926, 2.00489860757762, 2.52052 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1305); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1320, '2025-08-31 00:00:00', 0.0971698341393399, 0.122319999999999, 0.114992579470736, 0.168719999999999, 0.198338910285737, 0.276359999999998, 1.12557447850716, 1.08436, 2.04309077788205, 2.53452 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1320); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1335, '2025-08-31 00:00:00', 0.0759584754981305, 0.11224, 0.107374469342888, 0.18488, 0.160471056580307, 0.24528, 1.12859905782937, 1.0954, 2.13023721527283, 2.55852 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1335); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1350, '2025-08-31 00:00:00', 0.0940633120119998, 0.127639999999999, 0.15721224507016, 0.185239999999998, 0.157021888070846, 0.213959999999999, 1.11892765181669, 1.09456, 2.16097196341523, 2.56292 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1350); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1365, '2025-08-31 00:00:00', 0.0869544900124964, 0.127199999999999, 0.133435527502985, 0.16396, 0.140151073250737, 0.20336, 1.11630817429597, 1.09624, 2.1619213738401, 2.56212 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1365); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1380, '2025-08-31 00:00:00', 0.0962181029397976, 0.0995600000000016, 0.10009708620468, 0.133480000000001, 0.123752777746602, 0.197400000000002, 1.08184517992795, 1.08708, 2.23834664279984, 2.58212 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1380); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1395, '2025-08-31 00:00:00', 0.0698372632148023, 0.0840799999999999, 0.0735379720507272, 0.1236, 1.09807299848416, 0.952320000000001, 1.07160790403953, 1.0978, 2.50413230680809, 2.64712 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1395); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1410, '2025-08-31 00:00:00', 0.0547726208976712, 0.0899599999999998, 0.109332184953319, 0.145880000000001, 1.0967062687885, 0.967840000000001, 1.06236227028888, 1.09548, 2.50536128665441, 2.64352 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1410); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 5, 1425, '2025-08-31 00:00:00', 0.0830389183246123, 0.103375000000001, 1.09253144335078, 0.969458333333335, 1.08146110823422, 1.01904166666667, 1.04446961437962, 1.15641666666667, 2.49851200355012, 2.74866666666667 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 5 and fromtime = 1425); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 60, '2025-08-31 00:00:00', 0.415365092418707, 0.536, 0.446571589574825, 0.58223076923077, 0.552030067464279, 0.665346153846155, 0.713210967817647, 0.89226923076923, 2.40323225805452, 2.66161538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 60); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 75, '2025-08-31 00:00:00', 0.154916056673879, 0.207230769230769, 0.22242354606955, 0.302076923076923, 0.290548661355347, 0.36826923076923, 0.426083653758272, 0.679999999999999, 2.13019995341716, 2.52319230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 75); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 90, '2025-08-31 00:00:00', 0.130141751120137, 0.177653846153847, 0.167237081828349, 0.237807692307692, 0.170757592465505, 0.269346153846155, 0.373413196586054, 0.634846153846152, 2.1716189111777, 2.51915384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 90); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 105, '2025-08-31 00:00:00', 0.109249615383939, 0.142961538461538, 0.127013851455417, 0.184961538461539, 0.145910536341227, 0.235730769230769, 0.361228810930349, 0.631576923076921, 2.16847669220017, 2.51126923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 105); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 120, '2025-08-31 00:00:00', 0.120990603576669, 0.146615384615385, 0.139287886711716, 0.182653846153847, 0.162604853745325, 0.249461538461539, 0.361393254800618, 0.632730769230767, 2.16843551437436, 2.5105 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 120); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 135, '2025-08-31 00:00:00', 0.0619826278391474, 0.109615384615385, 0.12104137881161, 0.170846153846154, 0.209960553071651, 0.320923076923078, 0.36916871273381, 0.629461538461537, 2.16833520116595, 2.51676923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 135); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 150, '2025-08-31 00:00:00', 0.100484097478924, 0.119576923076923, 0.154060427704895, 0.193846153846154, 0.22108550730082, 0.347807692307694, 0.352642132828954, 0.618923076923075, 2.16314694689153, 2.50792307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 150); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 165, '2025-08-31 00:00:00', 0.104442932522245, 0.133615384615384, 0.158064431847852, 0.257269230769232, 0.198665009888117, 0.345115384615385, 0.316581560763391, 0.597730769230768, 2.15020349269552, 2.4935 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 165); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 180, '2025-08-31 00:00:00', 0.125407992629594, 0.205730769230771, 0.1510935319086, 0.264153846153849, 0.178643990619933, 0.332653846153847, 0.309051265351534, 0.587730769230769, 2.14823755347351, 2.48711538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 180); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 195, '2025-08-31 00:00:00', 0.0961679060489835, 0.146884615384617, 0.128734742187778, 0.200076923076924, 0.242233685645779, 0.366038461538461, 0.304611389251188, 0.562461538461539, 2.1229385541309, 2.48823076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 195); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 210, '2025-08-31 00:00:00', 0.0767609676453217, 0.132384615384615, 0.111986956658078, 0.197038461538461, 0.240626518776425, 0.373807692307692, 0.28141585161192, 0.539192307692307, 2.12080868901102, 2.48115384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 210); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 225, '2025-08-31 00:00:00', 0.0814871863452245, 0.141192307692308, 0.211062221959452, 0.313692307692307, 0.219188534933179, 0.392576923076923, 0.265370234838917, 0.530807692307693, 2.11725607949389, 2.47588461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 225); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 240, '2025-08-31 00:00:00', 0.148368175107115, 0.258653846153846, 0.165589116141779, 0.301346153846154, 0.216209887342405, 0.387346153846154, 0.255119160695247, 0.514884615384615, 2.11845461090427, 2.47046153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 240); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 255, '2025-08-31 00:00:00', 0.115818478663812, 0.160000000000001, 0.144352778343143, 0.266269230769231, 0.192059221635891, 0.350230769230769, 0.249218260844711, 0.473692307692308, 2.10541182560197, 2.45234615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 255); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 270, '2025-08-31 00:00:00', 0.0865214691009378, 0.19026923076923, 0.145658441356693, 0.244692307692307, 0.154835918114826, 0.305192307692306, 0.229069814685393, 0.4405, 2.08004604238982, 2.44553846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 270); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 285, '2025-08-31 00:00:00', 0.103377872948637, 0.153769230769232, 0.111681001758786, 0.218384615384616, 0.143443502681503, 0.271961538461539, 0.221386678773728, 0.438692307692308, 2.03092970487751, 2.43011538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 285); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 300, '2025-08-31 00:00:00', 0.0775286051427754, 0.14873076923077, 0.116631919367661, 0.194269230769231, 0.130617168149461, 0.250730769230769, 0.225655479403039, 0.447653846153847, 2.02988786844533, 2.42703846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 300); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 315, '2025-08-31 00:00:00', 0.0896329952983506, 0.115076923076922, 0.105693613808972, 0.175500000000001, 0.12032091064508, 0.225192307692308, 0.204879390411492, 0.465730769230769, 2.02338845010047, 2.4205 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 315); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 330, '2025-08-31 00:00:00', 0.0559651539937009, 0.12146153846154, 0.0645819336490181, 0.156115384615385, 0.0929526678559484, 0.227038461538463, 0.205561463763556, 0.494346153846153, 1.99940325443522, 2.41357692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 330); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 345, '2025-08-31 00:00:00', 0.0540792011775326, 0.112, 0.0852789540273566, 0.1655, 0.112476657407386, 0.231961538461539, 0.280038208931459, 0.520038461538462, 1.99940656311201, 2.40973076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 345); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 360, '2025-08-31 00:00:00', 0.0875639282950551, 0.122807692307693, 0.0955153471357436, 0.171307692307693, 0.12112973972627, 0.211576923076924, 0.272482987471766, 0.523538461538462, 1.99767426774237, 2.404 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 360); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 375, '2025-08-31 00:00:00', 0.0699936810334721, 0.124653846153846, 0.0994722999710902, 0.166461538461539, 0.160850183520137, 0.202692307692307, 0.452302289999134, 0.626807692307692, 1.99762126540543, 2.403 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 375); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 390, '2025-08-31 00:00:00', 0.0874811716006107, 0.113653846153845, 0.0906591333597363, 0.139961538461539, 0.16943724048018, 0.187461538461537, 0.471454828572807, 0.651846153846153, 1.99648813708934, 2.40219230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 390); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 405, '2025-08-31 00:00:00', 0.0443458436175691, 0.0820769230769231, 0.141265298694991, 0.129730769230768, 0.145182458147829, 0.186884615384615, 0.480569854043493, 0.690769230769231, 1.99705415395931, 2.40142307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 405); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 420, '2025-08-31 00:00:00', 0.120907879745762, 0.091653846153846, 0.139442295757614, 0.127076923076923, 0.15049405815002, 0.197692307692307, 0.484394507051369, 0.739038461538461, 1.99740950079, 2.40592307692307 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 420); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 435, '2025-08-31 00:00:00', 0.0773676537459537, 0.0820769230769217, 0.0921229947073264, 0.134384615384615, 0.14214359478521, 0.19780769230769, 0.533246226861043, 0.806538461538461, 1.99672901901701, 2.41015384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 435); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 450, '2025-08-31 00:00:00', 0.070300454096355, 0.0980769230769246, 0.0940222559577505, 0.141769230769231, 0.158429814598915, 0.208615384615385, 0.519442045334741, 0.820038461538461, 1.97568064376656, 2.40438461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 450); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 465, '2025-08-31 00:00:00', 0.067704789059108, 0.0925384615384631, 0.0989351302622089, 0.132999999999999, 0.166792090755113, 0.234807692307692, 0.49618672043744, 0.858692307692308, 1.9575143280741, 2.39323076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 465); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 480, '2025-08-31 00:00:00', 0.0759425795230546, 0.101653846153845, 0.114154962155027, 0.151653846153846, 0.170575735491487, 0.263192307692307, 0.490499588331985, 0.879615384615383, 1.95527336825708, 2.38976923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 480); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 495, '2025-08-31 00:00:00', 0.0829752882582433, 0.105538461538461, 0.143370273713262, 0.193653846153845, 0.163345353822462, 0.31276923076923, 0.492597362496453, 0.891192307692307, 1.95667031301805, 2.38707692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 495); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 510, '2025-08-31 00:00:00', 0.104318484238637, 0.147884615384615, 0.13811856667928, 0.203538461538461, 0.158835202453556, 0.333307692307692, 0.456744677035212, 0.893499999999999, 1.95682884122402, 2.38592307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 510); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 525, '2025-08-31 00:00:00', 0.0765040773171847, 0.127923076923078, 0.0824962190275775, 0.224884615384616, 0.18283447326854, 0.329269230769231, 0.430644418731527, 0.888846153846154, 1.96069186729112, 2.37496153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 525); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 540, '2025-08-31 00:00:00', 0.0748005758924763, 0.166615384615385, 0.116048458048286, 0.22773076923077, 0.186055760872504, 0.325884615384617, 0.411713679449873, 0.913076923076923, 1.96215511070393, 2.37003846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 540); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 555, '2025-08-31 00:00:00', 0.0834783435757687, 0.152076923076922, 0.184381998954512, 0.219192307692307, 0.354192257657639, 0.429346153846154, 0.39056595030604, 0.941192307692308, 1.96058081229478, 2.37819230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 555); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 570, '2025-08-31 00:00:00', 0.128544682443949, 0.146846153846154, 0.140684043160553, 0.222000000000001, 0.32109989099967, 0.446500000000001, 0.376407839369028, 0.955307692307692, 1.95758924307818, 2.37473076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 570); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 585, '2025-08-31 00:00:00', 0.100684335348728, 0.165846153846155, 0.288619430019212, 0.362153846153847, 0.310309545206321, 0.490576923076923, 0.361931935802639, 0.959384615384614, 1.93784980326134, 2.3815 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 585); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 600, '2025-08-31 00:00:00', 0.297806114004499, 0.315192307692308, 0.30411604060596, 0.380384615384615, 0.336864684086377, 0.529153846153846, 0.37846408832787, 0.985884615384615, 1.93515150669041, 2.38507692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 600); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 615, '2025-08-31 00:00:00', 0.129873382125113, 0.210846153846155, 0.167719344327179, 0.33046153846154, 0.330476450924095, 0.502269230769231, 0.385122000649944, 0.964346153846154, 1.91991908643608, 2.39753846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 615); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 630, '2025-08-31 00:00:00', 0.126907385976485, 0.225269230769232, 0.191558647376242, 0.337346153846154, 0.308685463513615, 0.509653846153846, 0.379770094419486, 0.961269230769232, 1.9195245521102, 2.38888461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 630); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 645, '2025-08-31 00:00:00', 0.11736465199736, 0.217307692307692, 0.251987179161041, 0.358461538461538, 0.249217544758357, 0.509230769230769, 0.338722550406443, 0.936615384615385, 1.91016768857123, 2.36503846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 645); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 660, '2025-08-31 00:00:00', 0.190565962736912, 0.275115384615385, 0.196193781756709, 0.356, 0.225629870499315, 0.501961538461538, 0.329358173048499, 0.929384615384617, 1.90885282867445, 2.37419230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 660); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 675, '2025-08-31 00:00:00', 0.101320360168205, 0.242153846153846, 0.150798005495889, 0.370961538461539, 0.186038044082799, 0.478076923076923, 0.333466510831527, 0.922076923076923, 1.90867578743444, 2.37569230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 675); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 690, '2025-08-31 00:00:00', 0.135341732719012, 0.272769230769232, 0.152389177891548, 0.352692307692307, 0.198155960332727, 0.451769230769231, 0.324898538008407, 0.8815, 1.91572439522535, 2.35696153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 690); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 705, '2025-08-31 00:00:00', 0.080550223224634, 0.209461538461536, 0.119659079825208, 0.273846153846153, 0.151150302170237, 0.398423076923075, 0.329976754426032, 0.825461538461538, 1.92873422701562, 2.32696153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 705); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 720, '2025-08-31 00:00:00', 0.0659694218209061, 0.191730769230771, 0.109785637283964, 0.273384615384616, 0.135946256349282, 0.419230769230769, 0.391634900621249, 0.841846153846153, 1.92649078338349, 2.33146153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 720); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 735, '2025-08-31 00:00:00', 0.0912481316984695, 0.188692307692308, 0.133258343655645, 0.295884615384615, 0.199753309397828, 0.458769230769231, 0.417135683515015, 0.86853846153846, 1.92970754739197, 2.33253846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 735); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 750, '2025-08-31 00:00:00', 0.128705561412325, 0.214192307692306, 0.123363278415979, 0.307461538461538, 0.214985437789489, 0.444538461538462, 0.412505716510506, 0.860615384615383, 1.93779740030154, 2.31926923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 750); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 765, '2025-08-31 00:00:00', 0.0822821132072219, 0.202115384615384, 0.15893525048319, 0.306576923076923, 0.176542228550393, 0.384038461538461, 0.382689044284501, 0.901769230769231, 1.91613272384369, 2.31915384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 765); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 780, '2025-08-31 00:00:00', 0.121970141365071, 0.205653846153845, 0.161559896013831, 0.266, 0.188320271387297, 0.37326923076923, 0.508625679196856, 1.00119230769231, 1.91261957494467, 2.32703846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 780); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 795, '2025-08-31 00:00:00', 0.0726532756421786, 0.159461538461538, 0.0787537642567983, 0.225653846153845, 0.202297058802148, 0.3655, 0.785512305147705, 1.16269230769231, 1.89637530568187, 2.3105 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 795); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 810, '2025-08-31 00:00:00', 0.0741530745251918, 0.16703846153846, 0.144111628741272, 0.262807692307691, 0.179207644926215, 0.364500000000001, 0.782621603232466, 1.16957692307692, 1.89645949479144, 2.31415384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 810); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 825, '2025-08-31 00:00:00', 0.118968644867203, 0.179461538461538, 0.156238658665319, 0.252961538461539, 0.156322551156254, 0.340500000000001, 0.773627865220839, 1.23692307692308, 1.89736297164086, 2.32338461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 825); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 840, '2025-08-31 00:00:00', 0.104566416141203, 0.183153846153847, 0.106966651884522, 0.246230769230771, 0.130346945318432, 0.317615384615385, 0.761420603467371, 1.28384615384615, 1.8963407617344, 2.32626923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 840); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 855, '2025-08-31 00:00:00', 0.0800840712098143, 0.176461538461539, 0.127662294897366, 0.254692307692308, 0.149755518711717, 0.346653846153846, 0.767461683333191, 1.33634615384615, 1.89849592937308, 2.32007692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 855); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 870, '2025-08-31 00:00:00', 0.0725257301822031, 0.164692307692307, 0.0879802512805261, 0.211730769230769, 0.163467352656778, 0.346153846153844, 0.772211716684366, 1.34384615384615, 1.84004154468149, 2.32238461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 870); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 885, '2025-08-31 00:00:00', 0.0797154651533522, 0.156346153846153, 0.113645846653269, 0.235461538461537, 0.237738136483109, 0.391692307692306, 0.762674376529974, 1.35673076923077, 1.82154199934688, 2.31584615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 00:00:00' and dayofweek = 1 and fromtime = 885); insert into powerstats_trumpet(symbolid, dayofweek, fromtime, enddate, stddev_15, ave_15, stddev_30, ave_30, stddev_60, ave_60, stddev_240, ave_240, stddev_1440, ave_1440) select 515840238057457300, 1, 900, '2025-08-31 00:00:00', 0.0798773771766157, 0.168346153846153, 0.125798942150377, 0.260423076923075, 0.256386166073456, 0.413115384615383, 0.771557929426909, 1.36396153846154, 1.81361966838102, 2.30969230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 915, '2025-08-31 00:00:00', 0.120634757078483, 0.20076923076923, 0.210955150173242, 0.318653846153845, 0.259525190714476, 0.524730769230768, 0.777362943645918, 1.38911538461539, 1.81051383484188, 2.32011538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 930, '2025-08-31 00:00:00', 0.139386744762135, 0.223769230769231, 0.194278455989177, 0.310961538461538, 0.220882234546966, 0.540192307692309, 0.772676427451014, 1.38630769230769, 1.81293084428332, 2.32261538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 945, '2025-08-31 00:00:00', 0.163891976618747, 0.2185, 0.223942616276169, 0.444846153846154, 0.258813996173669, 0.632269230769233, 0.816709179950479, 1.42673076923077, 1.806413763404, 2.30973076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 960, '2025-08-31 00:00:00', 0.170346366604589, 0.353269230769231, 0.155342797114591, 0.415769230769232, 0.442181132395034, 0.753076923076925, 0.821223688256644, 1.41711538461539, 1.8218636379775, 2.33434615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 975, '2025-08-31 00:00:00', 0.129213597760275, 0.271923076923077, 0.232600433229309, 0.475192307692308, 0.791108788590175, 0.901346153846154, 0.926105493243285, 1.45576923076923, 1.82217404091503, 2.31634615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 990, '2025-08-31 00:00:00', 0.181212688467279, 0.360961538461539, 0.476425795336, 0.57346153846154, 0.799593055151277, 0.874576923076925, 1.03865482531679, 1.46861538461538, 1.8109981323526, 2.28865384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1005, '2025-08-31 00:00:00', 0.478839783708016, 0.388461538461539, 0.779619039117083, 0.679615384615385, 0.783205567867377, 0.835192307692307, 1.05619893231123, 1.38976923076923, 1.80903854999959, 2.26734615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1020, '2025-08-31 00:00:00', 0.503515793045414, 0.468076923076924, 0.51269415834394, 0.5365, 0.548600071510694, 0.725961538461538, 1.09008772053516, 1.32803846153846, 1.8090440862936, 2.21388461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1035, '2025-08-31 00:00:00', 0.509273940187251, 0.361115384615384, 0.559994677172506, 0.515961538461537, 0.657334038721211, 0.715961538461537, 1.14439620962995, 1.28726923076923, 1.81290520945292, 2.20946153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1050, '2025-08-31 00:00:00', 0.2352873856503, 0.346923076923077, 0.244496735859916, 0.444423076923077, 0.390400238414177, 0.637884615384615, 1.12608059897354, 1.20534615384615, 1.78701404970587, 2.12042307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1065, '2025-08-31 00:00:00', 0.140983905246171, 0.27269230769231, 0.266008747687277, 0.425576923076923, 0.302645578447541, 0.567115384615386, 1.09174287265821, 1.1465, 1.75345967337542, 2.08111538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1080, '2025-08-31 00:00:00', 0.242374614690057, 0.313423076923076, 0.283078149035808, 0.414961538461538, 0.323732567692248, 0.562153846153846, 1.09430721674281, 1.12073076923077, 1.74820427296126, 2.0865 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1095, '2025-08-31 00:00:00', 0.170481783371534, 0.289038461538462, 0.213021793756847, 0.402269230769232, 0.271919954285193, 0.542307692307693, 1.09722472840134, 1.09323076923077, 1.7458939473475, 2.09165384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1110, '2025-08-31 00:00:00', 0.145987170142289, 0.299576923076923, 0.221301951745016, 0.398923076923075, 0.244993061126228, 0.524, 1.09331478752251, 1.04423076923077, 1.74367460134757, 2.07234615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1125, '2025-08-31 00:00:00', 0.108777748007296, 0.230961538461537, 0.143936422930939, 0.323576923076923, 0.483120020125594, 0.540076923076922, 1.09163939946373, 1.00046153846154, 1.74986954239012, 2.07715384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1140, '2025-08-31 00:00:00', 0.113628984655528, 0.238884615384617, 0.15206656943083, 0.319807692307694, 0.492518488524503, 0.507307692307691, 1.15093156984312, 0.985961538461538, 1.78680244700285, 2.09176923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1155, '2025-08-31 00:00:00', 0.129708578685511, 0.217653846153847, 0.50473066694411, 0.418615384615384, 0.706117581187113, 0.575961538461539, 1.26887910620116, 0.972884615384616, 1.78581902778529, 2.086 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1170, '2025-08-31 00:00:00', 0.511694122874804, 0.329653846153846, 0.504180102130791, 0.364846153846153, 0.89566347131395, 0.599576923076923, 1.31340709079624, 0.952884615384616, 1.78416386148117, 2.07926923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1185, '2025-08-31 00:00:00', 0.13841309408934, 0.189769230769229, 0.405416594855977, 0.396153846153845, 0.601894911604496, 0.545730769230769, 0.969247428916649, 0.868461538461539, 1.4508884710358, 2.03265384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1200, '2025-08-31 00:00:00', 0.377025249103477, 0.330961538461537, 0.554619370518057, 0.439384615384614, 0.642688848031935, 0.553346153846154, 1.03756175423256, 0.848076923076924, 1.43685147297298, 2.04534615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1215, '2025-08-31 00:00:00', 0.309896409490954, 0.228230769230769, 0.327861462300068, 0.312461538461539, 0.439303289311611, 0.457500000000001, 1.13350963756888, 0.810461538461539, 1.24338032797692, 1.954 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1230, '2025-08-31 00:00:00', 0.183836018066268, 0.208192307692307, 0.264624288088137, 0.305423076923077, 0.423503005165978, 0.496346153846153, 0.9829745970581, 0.771461538461539, 1.15068408282271, 1.94653846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1245, '2025-08-31 00:00:00', 0.159953036376786, 0.218576923076924, 0.225673600241927, 0.327576923076924, 0.33555717155891, 0.487153846153845, 0.857958343080557, 0.73496153846154, 1.05820921662677, 1.94411538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1260, '2025-08-31 00:00:00', 0.188252857777879, 0.25753846153846, 0.271325626111165, 0.396346153846152, 0.287706380774675, 0.461192307692307, 0.848897316432413, 0.721423076923077, 1.05258458823252, 1.95065384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1275, '2025-08-31 00:00:00', 0.268686835153149, 0.303846153846153, 0.294457780701045, 0.374230769230769, 0.291617684385146, 0.438076923076923, 0.855746516206755, 0.694500000000001, 1.06300782615254, 1.95296153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1290, '2025-08-31 00:00:00', 0.131894932932746, 0.21276, 0.161137105182721, 0.2662, 0.15784789091612, 0.306040000000001, 0.883843298705527, 0.617680000000003, 1.0147597383946, 1.92992 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1305, '2025-08-31 00:00:00', 0.11368277500718, 0.157760000000001, 0.107915352630354, 0.20516, 0.131805955859361, 0.249320000000001, 0.898542397441546, 0.585760000000001, 1.04637495351014, 1.92572 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1320, '2025-08-31 00:00:00', 0.0675315481830519, 0.119519999999998, 0.103225432912631, 0.158359999999999, 0.182984134102751, 0.24912, 0.948653496629128, 0.578960000000002, 1.05659355477875, 1.92224 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1335, '2025-08-31 00:00:00', 0.0952432499795485, 0.110880000000001, 0.109927430607651, 0.152960000000002, 0.284902468691774, 0.2798, 0.940678349206927, 0.613560000000002, 1.05672246908385, 1.92172 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1350, '2025-08-31 00:00:00', 0.0840094240745235, 0.0976000000000019, 0.180209350478825, 0.19192, 0.323635994083888, 0.27056, 0.938634570355615, 0.613760000000002, 1.05666401629531, 1.92252 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1365, '2025-08-31 00:00:00', 0.174233626681725, 0.158240000000001, 0.286759527595279, 0.217880000000001, 0.323836213745982, 0.25932, 0.937616191910814, 0.616960000000002, 1.05756142453603, 1.9294 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1380, '2025-08-31 00:00:00', 0.127542711800139, 0.11832, 0.163292426850318, 0.1546, 0.249490647787314, 0.2118, 0.795168011596712, 0.573000000000002, 0.983188364455155, 1.90188 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1395, '2025-08-31 00:00:00', 0.0717489837326382, 0.087999999999999, 0.0798306123405455, 0.11752, 0.525353493690994, 0.308280000000001, 0.748507013995194, 0.619200000000002, 0.946731540617509, 1.93888 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1410, '2025-08-31 00:00:00', 0.0671598094100914, 0.0777599999999984, 0.162563033928381, 0.137639999999999, 0.52819425088377, 0.306000000000001, 0.747879965859052, 0.62612, 0.955964063132083, 1.96204 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 1, 1425, '2025-08-31 00:00:00', 0.152100821825526, 0.111920000000001, 0.53165183782873, 0.27952, 0.555922431639523, 0.324800000000002, 0.748279856292642, 0.63192, 0.995264884339844, 1.97876 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 60, '2025-08-31 00:00:00', 0.527153167057224, 0.224692307692306, 0.524783801637911, 0.241038461538462, 0.610937117499389, 0.326192307692308, 0.730934621931719, 0.618692307692308, 0.980261240690461, 1.9595 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 75, '2025-08-31 00:00:00', 0.134092734845932, 0.0866923076923068, 0.25918267985817, 0.156692307692309, 0.387244387157019, 0.210153846153848, 0.599622060455265, 0.586153846153846, 0.940421235404646, 1.9345 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 90, '2025-08-31 00:00:00', 0.229259426448259, 0.111730769230771, 0.358641668178482, 0.156384615384617, 0.452059900727938, 0.218076923076924, 0.597950628268048, 0.592923076923076, 0.964207207223394, 1.94353846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 105, '2025-08-31 00:00:00', 0.179288444005311, 0.0888846153846168, 0.217668060623015, 0.120769230769232, 0.317698938280592, 0.176153846153847, 0.548657052755603, 0.576192307692307, 0.969772395977531, 1.9445 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 120, '2025-08-31 00:00:00', 0.144064755739058, 0.0855769230769226, 0.258390878619673, 0.129615384615384, 0.352184610680252, 0.185000000000001, 0.569728896392501, 0.587153846153845, 0.969772395977531, 1.9445 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 135, '2025-08-31 00:00:00', 0.166206544349539, 0.0858461538461522, 0.202462247193055, 0.120192307692307, 0.429576507021294, 0.292846153846155, 0.567177709228911, 0.592923076923076, 0.970159752903535, 1.94411538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 150, '2025-08-31 00:00:00', 0.120101623635986, 0.0820000000000002, 0.270891406002765, 0.143076923076924, 0.340225445618277, 0.294076923076925, 0.505998183335141, 0.576192307692307, 0.970159752903535, 1.94411538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 165, '2025-08-31 00:00:00', 0.219726840907943, 0.108269230769231, 0.283663571045811, 0.241307692307693, 0.281103115490494, 0.285807692307693, 0.463797139009984, 0.560115384615384, 0.976606703768797, 1.94642307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 180, '2025-08-31 00:00:00', 0.240627541744818, 0.219576923076923, 0.239911522152519, 0.249461538461539, 0.312708753659672, 0.311730769230768, 0.422645872860666, 0.546423076923075, 1.02947205663127, 1.96334615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 195, '2025-08-31 00:00:00', 0.122772187404153, 0.112479999999999, 0.122964927248927, 0.14996, 0.329843154645762, 0.35956, 0.386136560472242, 0.523879999999998, 1.049795119694, 1.97828 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 210, '2025-08-31 00:00:00', 0.0796825367735428, 0.101839999999999, 0.262796924132177, 0.205159999999998, 0.322762544295339, 0.370079999999998, 0.384123452377835, 0.524079999999999, 1.05014083658653, 1.97512 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 225, '2025-08-31 00:00:00', 0.234880254270455, 0.164576923076923, 0.276885213650823, 0.308307692307692, 0.294257754619733, 0.355884615384615, 0.377000952865557, 0.507961538461538, 1.03222583471165, 1.94942307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 240, '2025-08-31 00:00:00', 0.139085894877397, 0.228615384615384, 0.157371275846447, 0.259961538461537, 0.188274120939085, 0.31276923076923, 0.326404800586869, 0.495423076923076, 1.02914968112216, 1.94288461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 255, '2025-08-31 00:00:00', 0.095205591303163, 0.146230769230768, 0.121152161160444, 0.196384615384615, 0.208753958967525, 0.305846153846153, 0.283313351934946, 0.453153846153846, 1.02529012254318, 1.92865384615384 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 270, '2025-08-31 00:00:00', 0.103262749259428, 0.144346153846155, 0.123168852206417, 0.201615384615384, 0.279096531411899, 0.315923076923076, 0.279412705509251, 0.4325, 1.02674785534791, 1.91896153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 285, '2025-08-31 00:00:00', 0.11555347080631, 0.143730769230768, 0.203035597485156, 0.228423076923077, 0.282048648286072, 0.294999999999998, 0.295942707553076, 0.424615384615385, 1.03257584411323, 1.91892307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 300, '2025-08-31 00:00:00', 0.135815757554124, 0.162000000000001, 0.21399093079273, 0.210038461538461, 0.236552667741, 0.267730769230767, 0.324816985156493, 0.426076923076925, 1.03237152525331, 1.91738461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 315, '2025-08-31 00:00:00', 0.147005494402812, 0.131153846153845, 0.156183821677683, 0.174115384615384, 0.25885080942207, 0.257692307692307, 0.346637571757372, 0.440615384615384, 1.03772856092229, 1.91661538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 330, '2025-08-31 00:00:00', 0.132869259048133, 0.139999999999999, 0.228436653397357, 0.203769230769229, 0.264213293790046, 0.250769230769231, 0.452604845482065, 0.484115384615385, 1.03621527908798, 1.91276923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 345, '2025-08-31 00:00:00', 0.190380655125866, 0.140076923076923, 0.210262930636857, 0.188500000000001, 0.255158725864149, 0.235153846153849, 0.518606653966627, 0.520692307692309, 1.03531257858901, 1.90584615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 360, '2025-08-31 00:00:00', 0.103905141651113, 0.123961538461539, 0.159737423966284, 0.157269230769232, 0.15277589922699, 0.192653846153848, 0.427310004563429, 0.499000000000001, 1.02193632196622, 1.88938461538461 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 375, '2025-08-31 00:00:00', 0.0926059393343641, 0.1015, 0.0918615345967057, 0.137307692307693, 0.122641572823473, 0.166653846153847, 0.413976567527121, 0.53396153846154, 1.02138211037036, 1.88784615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 390, '2025-08-31 00:00:00', 0.0631436944899985, 0.104615384615383, 0.0835870803414018, 0.125999999999999, 0.0935078524057653, 0.15803846153846, 0.408573317024759, 0.561346153846153, 1.02156174556411, 1.889 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 405, '2025-08-31 00:00:00', 0.0470368104622489, 0.0676923076923087, 0.0538047753099447, 0.0950769230769248, 0.100528296820041, 0.145461538461539, 0.457923327475411, 0.628576923076923, 1.02141427442542, 1.887 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 420, '2025-08-31 00:00:00', 0.0493143137279776, 0.0696923076923084, 0.0641759600329727, 0.0989230769230768, 0.112525579997822, 0.149384615384615, 0.473060360435521, 0.663230769230769, 1.0214799437016, 1.88665384615385 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 435, '2025-08-31 00:00:00', 0.0466595690573265, 0.0713461538461543, 0.08153904208792, 0.103846153846154, 0.0888738431710938, 0.161000000000002, 0.471304652411385, 0.704653846153846, 1.02138770533788, 1.88626923076923 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 450, '2025-08-31 00:00:00', 0.0619206067352525, 0.0721923076923072, 0.0786442916897658, 0.10626923076923, 0.0999783745847847, 0.174653846153847, 0.468116251176335, 0.709769230769231, 1.0202623652013, 1.88842307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 465, '2025-08-31 00:00:00', 0.0622343461936738, 0.0779230769230779, 0.0607046823691425, 0.126538461538464, 0.132500891143592, 0.230615384615386, 0.453506117336403, 0.745038461538461, 1.01199624201187, 1.90592307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 480, '2025-08-31 00:00:00', 0.0457001767375823, 0.0988846153846164, 0.0746279077516219, 0.141269230769232, 0.175693881509857, 0.250500000000001, 0.4411958365101, 0.776384615384615, 1.01190907466265, 1.90884615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 495, '2025-08-31 00:00:00', 0.055897598682428, 0.0943076923076925, 0.108817362867966, 0.175461538461539, 0.189047311945574, 0.284615384615383, 0.426544767242008, 0.79903846153846, 1.00682074792961, 1.91046153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 510, '2025-08-31 00:00:00', 0.0629537559214316, 0.136153846153847, 0.116858441648925, 0.183153846153846, 0.269771313409082, 0.324807692307691, 0.41605836868623, 0.816615384615384, 1.00583351734538, 1.92623076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 525, '2025-08-31 00:00:00', 0.076587165022304, 0.111923076923078, 0.110841848525796, 0.202346153846153, 0.290906437509751, 0.347653846153845, 0.410066157889376, 0.833423076923076, 1.00500174358823, 1.93123076923077 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 540, '2025-08-31 00:00:00', 0.0758056726109609, 0.159499999999998, 0.18753288942312, 0.234769230769229, 0.236305942501534, 0.350461538461537, 0.410486474995031, 0.845115384615384, 1.00577031481042, 1.93361538461538 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 555, '2025-08-31 00:00:00', 0.175784430919936, 0.154615384615386, 0.233264999517714, 0.245000000000001, 0.252445153220685, 0.365346153846154, 0.410069354359254, 0.849653846153846, 1.0051404953461, 1.92684615384615 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 570, '2025-08-31 00:00:00', 0.163193646180991, 0.184615384615385, 0.220272013655843, 0.266, 0.317070487188816, 0.419576923076922, 0.407111190632807, 0.855807692307692, 1.00453820159391, 1.92596153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 585, '2025-08-31 00:00:00', 0.182745543984396, 0.178423076923076, 0.231839629585094, 0.295576923076923, 0.407357510718118, 0.482692307692307, 0.400854803945461, 0.858576923076923, 0.986878382344278, 1.93669230769231 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 600, '2025-08-31 00:00:00', 0.115367299726368, 0.219423076923075, 0.200664806618859, 0.307730769230766, 0.378862347642965, 0.485961538461537, 0.315427351138346, 0.831576923076922, 0.975264240327479, 1.93453846153846 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 615, '2025-08-31 00:00:00', 0.118540645414914, 0.186730769230766, 0.234719957527132, 0.321538461538461, 0.299261449880562, 0.470153846153847, 0.238257843522517, 0.777, 0.938577050646347, 1.918 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 630, '2025-08-31 00:00:00', 0.158899837827288, 0.218038461538461, 0.200782530652906, 0.313230769230769, 0.22191896303346, 0.448884615384616, 0.219732508711423, 0.762153846153846, 0.919547595288029, 1.9155 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 645, '2025-08-31 00:00:00', 0.151181627902946, 0.231730769230769, 0.203906905606078, 0.338115384615386, 0.224654990185806, 0.46423076923077, 0.222549285811895, 0.772769230769232, 0.913224223035317, 1.92880769230769 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 660, '2025-08-31 00:00:00', 0.188288240574024, 0.247307692307693, 0.205517058996233, 0.335307692307692, 0.228472348099619, 0.474576923076923, 0.20965436758187, 0.765076923076922, 0.91852216840213, 1.92342307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 675, '2025-08-31 00:00:00', 0.138216802941555, 0.22473076923077, 0.166556643171671, 0.333653846153847, 0.176414394144975, 0.464038461538462, 0.229407628469502, 0.7535, 0.90155197213557, 1.92496153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 690, '2025-08-31 00:00:00', 0.107649180925105, 0.252884615384614, 0.157354421120456, 0.338423076923076, 0.153145044370964, 0.44326923076923, 0.24988792564791, 0.764846153846154, 0.905053685615473, 1.91957692307692 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 705, '2025-08-31 00:00:00', 0.119117840813205, 0.2265, 0.133339358838209, 0.310769230769231, 0.137427239490016, 0.405615384615386, 0.260468657497331, 0.730807692307692, 0.900427861544805, 1.89742307692308 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 720, '2025-08-31 00:00:00', 0.0973542302822339, 0.217384615384616, 0.110325727524662, 0.275384615384615, 0.11168954224167, 0.373923076923078, 0.256281302778503, 0.708115384615385, 0.88915877010888, 1.88896153846154 where not exists (select 1 from powerstats_trumpet where symbolid = 515840238057457300 and enddate = '2025-08-31 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 515840238057457300, 2, 735, '2025-08-31 00:00:00', 0.0853356089440162, 0.181384615384615, 0.100041222272[...];

[ Date: 2025-08-31 14:41:56 - Database: acaweb_fx - User: pgperfstats - Remote: 192.168.3.100 - Application: [unknown] ]