As for question - I saw a lot of great reviews on ClickHouse DB
Not if you assume that some hours will have more web traffic than others.
Clickhouse seems very suitable as database. Does anybody know open source analytics tools that use it? Two parts would be needed: the client javascript tracker which injects into the database, and a GUI for reports.
Not if you assume that some hours will have more web traffic than others.