We have a blog that does well. We need more examples. Window functions. How to replicate rate in SQL, how to encode and optimal schema choices https://clickhouse.com/blog/working-with-time-series-data-and-functions-ClickHouse