Investigate having configurable time period for sql summaries

[gm3dmo]

In #18 there are time series summaries by hour. Can there be 5,10,15 minute summaries?

[gm3dmo]

SELECT strftime('%Y-%m-%d %H:%M:%S', datetime(strftime('%s', now) / 300 * 300, 'unixepoch')) AS bucket,
status, COUNT(*) AS count
FROM unicorn
GROUP BY bucket, status
ORDER BY bucket ASC;

SELECT strftime('%Y-%m-%d %H:%M:%S', datetime(strftime('%s', now) / 600 * 600, 'unixepoch')) AS bucket,
SUM(CASE WHEN status = '200' THEN 1 ELSE 0 END) AS status_200,
SUM(CASE WHEN status = '404' THEN 1 ELSE 0 END) AS status_404,
SUM(CASE WHEN status = '500' THEN 1 ELSE 0 END) AS status_500
FROM unicorn
GROUP BY bucket
ORDER BY bucket ASC;