Videos / How To

Downsampling time series data with 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 for one of the bike stations using raw data, downsampling using the average function, and finally the Largest Triangle Three Buckets algorithm.

Follow us
Twitter imageSlack imageGitHub image
Telegram imageMeetup imageRss image