ClickHouse for Analytics-Scale Storage

Which scraping workload is the strongest fit for ClickHouse?

• AMaintaining the current state of 10k products with frequent updates
• BAppend-only price observation events across hundreds of millions of rows, queried via aggregation
• CTransactional writes to a small set of rows
• DRandom per-row reads by primary key