If you have timeseries data TimescaleDB has this with continuous aggregates