Downsampling time series data with Plot.ly and ClickHouse

Mark Needham Principal Product Marketing Manager, ClickHouse

ClickHouse recently added support for the Largest Triangle Three Buckets (LTTB) algorithm, a powerful technique for downsampling time series data. And in this video, we'll learn how to use it with help from the SF Bay Area bike share dataset from Kaggle. Once we've imported the data, we'll learn how to visualise the number of free docks in Plot.ly for one of the bike stations using raw data, downsampling using the average function, and finally the Largest Triangle Three Buckets algorithm.