drop table if exists tmp_1min_code_day;
select date(trademin) as tradeday, unique_id, 
       min(diff_ratio) as min_diff_ratio, 
	   max(diff_ratio) as max_diff_ratio, 
	   avg(diff_ratio) as avg_diff_ratio
  into tmp_1min_code_day
  from cb_data_1min_fcst_cmp 
 group by unique_id, date(trademin)
 order by unique_id,tradeday;

drop table if exists tmp_5min_code_day;
select date(trademin) as tradeday, unique_id, 
       min(diff_ratio) as min_diff_ratio, 
	   max(diff_ratio) as max_diff_ratio, 
	   avg(diff_ratio) as avg_diff_ratio
  into tmp_5min_code_day
  from cb_data_5min_fcst_cmp 
 group by unique_id, date(trademin)
 order by unique_id,tradeday;
 


select unique_id, min(diff_ratio), max(diff_ratio), avg(diff_ratio) 
  from cb_data_5min_fcst_cmp 
group by unique_id order by unique_id;

select date(trademin) as tradeday, avg(diff_ratio) 
  from cb_data_5min_fcst_cmp 
group by date(trademin) order by date(trademin);




select * from tmp_1min_code_day;




select '1min' as quanlity, min(tradeday),max(tradeday), count(distinct unique_id) from tmp_1min_code_day
 union 
select '5min' as quanlity, min(tradeday),max(tradeday), count(distinct unique_id) from tmp_5min_code_day;


select