I would try first with these columns based databases but I think you should consider saving less data. Doing what you want is definitely possible but it may be expensive, and if it's only because one non technical co-worker would love to query so much data for his reports, perhaps you should try to show him the cost once you tried a few technologies.

Querying less data but saving everything is also an alternative. With Clickhouse you can specify a sampling rate for example.