SENSOR  TEMP    TIMESTAMP   TIMESTAMPMYSQL          WATT    WATTSECONDS
    0   18.9    1474972478  2016-09-27 20:34:38     1194    0
    0   18.9    1474972484  2016-09-27 20:34:44     1093    6558
    0   18.9    1474972490  2016-09-27 20:34:50     1204    7224
    0   18.9    1474972497  2016-09-27 20:34:57     1186    8302
    0   18.9    1474972503  2016-09-27 20:35:03     1181    7086
    0   18.9    1474972510  2016-09-27 20:35:10     1181    8267

SELECT
    DATE_FORMAT(TIMESTAMPMYSQL, '%d/%m/%Y') as 'Date',
    sum(WATTSECONDS)*0.00000028 as 'KWh'
FROM
    CurrentCostDataSamples_MySQL_Samples
WHERE
    TIMESTAMPMYSQL >= ( CURDATE() - INTERVAL 7 DAY )
GROUP BY
    date(TIMESTAMPMYSQL)
ORDER BY
    TIMESTAMPMYSQL DESC