A few years ago we ignored the purpose built time-series databases like InfluxDB and TimescaleDB and instead looked at the fully FOSS Apache Cassandra but we instead decided to squeeze a few years more out of the SQLServer database.
What are you using to store a lot of time-series data where the most recent month gets queried intensely and the rest gets queied a lot?