How to link disaggregate data to aggregate data when aggregation adds 0/NULL values?
It sounds to me like you want the TimeScaleDB extension with a hypertable and 15 min time buckets.


https://www.timescale.com/


It's a free and open source project, like Pg. And it's actively developed.


https://github.com/timescale/timescaledb