adding daily and monthly rollup of data for use in regressions