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.

Recent videos

YouTube Video: IyI0YQBCy8U

How to

CDC ClickPipes: The Fastest Way to Replicate Your Database to ClickHouse

Marta Paes, Senior Product Manager at ClickHouse

YouTube Video: Mgsm11T7tO8

How to

Under-the-Hood: ClickHouse Incremental Materialized Views and Dictionaries

Maruthi Lokanathan, Solution Architect at ClickHouse Derek Chia, Principal TAM Architect at ClickHouse

YouTube Video: -piPcapMtc0

ClickHouse Cloud, How to

LogHouse, Observability for ClickHouse Cloud

Get an insider’s look at LogHouse, the ClickHouse-powered logging platform that drives observability for ClickHouse Cloud.

Follow us

XBlueskySlackGithubTelegramMeetupRSS