mysql> SELECT itemid,round(10*(mod( CAST(clock AS UNSIGNED) +378000,864000))/(864000),0) as i, sum(num) as count,avg(value_avg) as avg,min(value_min) as min, max(value_max) as max,max(clock) as clock FROM trends  WHERE itemid=22857 AND clock>=1364742000 AND clock<=1365606000 GROUP BY itemid,round(10*(mod( CAST(clock AS UNSIGNED) +378000,864000))/(864000),0) ORDER BY clock ASC'
+--------+------+-------+------------+--------+--------+------------+
| itemid | i    | count | avg        | min    | max    | clock      |
+--------+------+-------+------------+--------+--------+------------+
|  22857 |    1 |   288 | 0.02429583 | 0.0104 | 1.0568 | 1364868000 | 
|  22857 |    2 |   288 | 0.02717083 | 0.0104 | 0.9040 | 1364954400 | 
|  22857 |    3 |   288 | 0.03162083 | 0.0084 | 0.8904 | 1365040800 | 
|  22857 |    4 |   288 | 0.03020000 | 0.0104 | 0.9417 | 1365127200 | 
|  22857 |    5 |   288 | 0.02592917 | 0.0104 | 1.0032 | 1365213600 | 
|  22857 |    6 |   288 | 0.03989583 | 0.0083 | 1.9121 | 1365300000 | 
|  22857 |    7 |   288 | 0.03157917 | 0.0083 | 0.8790 | 1365386400 | 
|  22857 |    8 |   288 | 0.03436250 | 0.0083 | 0.8985 | 1365472800 | 
|  22857 |    9 |   288 | 0.03193750 | 0.0104 | 0.8927 | 1365559200 | 
|  22857 |   10 |   144 | 0.03187500 | 0.0104 | 0.8506 | 1365602400 | 
|  22857 |    0 |   156 | 0.03200769 | 0.0083 | 0.9073 | 1365606000 | 
+--------+------+-------+------------+--------+--------+------------+