This is a description of a scheme I've used a few times for representing time series data on a fairly small scale. In a nutshell, it uses a single table to house multiple data series on multiple scales and is designed to make it easy to display those series.
series | timescale | timestamp | value |
---|---|---|---|
active-users | weekly | 2016-03-05 | 487 |
active-users | daily | 2016-03-05 | 75 |
active-users | daily | 2016-03-06 | 43 |