select DATE_FORMAT(CONCAT( DATE( event_time ), ' ', HOUR ( event_time ), ':', FLOOR( MINUTE ( event_time ) / 5 ) * 5 ) 粒度, min(f1), max(f2), f3,... from table group by 粒度