As an alternative to using influxdb as the long term monitoring solution there is TimescaleDB and the HA custom component LTSS (Custom component: Long Time State Storage (LTSS) utilizing TimescaleDB) for those preferring to rely on an sql-based solution for everything.