select date_format(data_hora,"%Y-%m-%d") as dataFormat,
date_format((sec_to_time(time_to_sec(data_hora)- time_to_sec(data_hora)%(15*60))),"%H:%i") AS intervals, eq_id, sum(online_status), data_hora from tb_status
where (data_hora between '2019-08-15 16:00:00' and '2019-08-16 17:00:00') group by dataFormat ,intervals ,eq_id order by 3,2,1;