Which AWS solution is the closest to PI AF?

I'm looking for an AWS solution as close as possible as PI AF by Osisoft.

The solutions needs to:

• Allow old data ingestion (could be of few years old);
• Allow aggregation on data (could be summing two timeseries sensor values);
• Allow aggregation on old data and on the upcoming one.

I've already done some research and I came out with a couple of solutions, but they still don't satisfy me completly.

AWS IoT SiteWise has assets concept and it could possibly be the best choice, but we have found that we couldn't ingest data that is older than 7 days, and it's unacceptable since we'd like to upload all the old data.

Amazon Timestream with some SQL queries could do all the aggregation we needed but just to sum two series it's needed a pretty long query, and in case of dozens of series it would require a very long, not much manteinable and hard to write query.

Thanks in advance.