Interesting. I'm not familiar with ClickHouse. I've been manually triggering compression and continuous aggregates have been a huge boon. The database has been the least of my concerns. Can you tell me more about it?
replyYou can take a look at this:
https://github.com/ClickHouse/stockhouse
The database schema is optimised for stock data
reply