store minute and hour interval metrics in timeseriestable