• There is shit loads of data. 1 reading every minute means 1440 data points per day.
• Sometimes there are some data points missing - either due to a false reading which is discarded or a reboot of the RPi every few hours for stability. These aren't added to the DB as empty or anything, they just don't exist in the DB so I'd like to account for that. Essentially having the y-axis as a set length of time with the data points plotted based on matching up what is determined by the y-axis
• The large amount of data means the current y-axis labels are pointless, as you can see. I'd like to show just the day and hour.

options = {
        xaxes: [{
            tickFormatter: xTickFormatter,
            mode: "time",
            timezone: "browser"
        }],

and xTickFormatter looks like this:

function xTickFormatter (val, axis) {
    var d = new Date(val),
        h, m;

    h = d.getHours();
    m = d.getMinutes();
    m = m < 10 ? "0" + m : m;
    return [
        d.getDate(), " ", months[d.getMonth()],
        "<br>",
        h, ":", m
    ].join("");
}

months[] is an array defined earlier:
 

months = ["Jan", "Feb" . . . "Nov", "Dec"];

SELECT UNIX_TIMESTAMP(datetime_column) as unix_timestamp FROM table ORDER BY datetime_column DESC.