Timescale seems to be a good extension for this use case. You can also use continuous aggregates to create some results beforehand. Also for the same amount of money a Postgres cluster on EC2 will give better performance.