# ClickHouse® tips #9: Filling gaps in time-series on ClickHouse®

DevFeed: [ClickHouse® tips #9: Filling gaps in time-series on ClickHouse®](<https://devfeed.tech/articles/clickhouse-tips-9-filling-gaps-in-time-series-on-clickhouse-18726.md>)

Original publisher: [Read original article](<https://www.tinybird.co/blog/tips-9-filling-gaps-in-time-series-on-clickhouse>)

Author: Xoel López

Published: 2021-07-08T00:00:00Z

Content type: tutorial

Language: en

Sources: [Tinybird](<https://devfeed.tech/sources/tinybird.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Time Series](<https://devfeed.tech/topics/time-series.md>), [DateTime](<https://devfeed.tech/topics/datetime.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [the-data-base](<https://devfeed.tech/tags/the-data-base.md>), [time-series](<https://devfeed.tech/tags/time-series.md>), [tips](<https://devfeed.tech/tags/tips.md>)

## AI overview

A tutorial on filling date and datetime gaps in time-series data using ClickHouse. It is identified as Part 9 of a series.

## Source excerpt

This simple trick will teach you how to fill date and datetime gaps in time-series on ClickHouse®. Part 9.