Clickhouse is a data warehouse, not a timeseries database. Timeseries databases are designed with different bottlenecks in the mind:

https://questdb.io/blog/2020/11/26/why-timeseries-data/