ClickHouse tips #8: Generating time-series on ClickHouse

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

果断的面包 · 领事表格下载· 1 月前 ·

酒量大的足球 · 小米手环怎么连接华为手机教程_教程_智家社· 5 月前 ·

爱吹牛的大熊猫 · WebBrowser.DocumentTex ...· 5 月前 ·

爱喝酒的四季豆 · 2024年商丘夏邑县特岗教师招聘面试公告_考 ...· 5 月前 ·

无邪的木瓜 · 巨齿鲨热映，这些科学疑点你发现了吗？-媒体看山大· 5 月前 ·

</noscript><div class="bg-white __variable_b91c43"><div class="relative z-10" id="container"><div class="sticky top-0 left-0 z-header transition-transform duration-300 translate-y-0"><div class="w-full sticky top-0 left-0 bg-brand text-text-default"><div class="w-full px-5 mx-auto max-w-7xl md:px-6 lg:px-8"><div class="flex gap-2 pt-5 pb-6 text-sm leading-5 md:justify-center md:gap-4 md:py-4"><span>🤩</span><span class=""><span class="font-semibold">Canva</span> designs user-facing analytics with Tinybird.<span class="ml-1"><a class="font-bold border-b" href="/case-studies/canva">Read their story.</a></span></span></div></div></div><div class="w-full h-[4.0625rem] lg:h-[4.5rem]"><div class="relative w-full h-full"><div class="w-full px-5 mx-auto max-w-7xl md:px-6 lg:px-8 flex items-center justify-between h-full"><div class="relative z-30 flex items-center"><a href="/" class="z-30"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 109 26" class="w-[109px] text-text-default"><g clip-path="url(#tinybird-logo_svg__a)" fill="currentColor"><path d="M40.385 8.93h-2.24V6.21h-2.68v2.72H33.85V11h1.615v6.32c-.015 2.14 1.54 3.19 3.55 3.13.76-.02 1.285-.17 1.575-.265l-.45-2.095c-.15.035-.45.105-.785.105-.675 0-1.215-.235-1.215-1.315V11h2.24V8.93h.005Zm2.235 11.36h2.68V8.93h-2.68v11.36Zm1.35-12.975c.85 0 1.545-.65 1.545-1.45 0-.805-.695-1.455-1.545-1.455-.86 0-1.555.65-1.555 1.455 0 .8.695 1.45 1.555 1.45Zm6.76 6.32c0-1.64.99-2.59 2.405-2.59 1.385 0 2.21.91 2.21 2.425v6.82h2.68v-7.235c.005-2.725-1.545-4.275-3.89-4.275-1.7 0-2.87.815-3.39 2.08h-.135V8.93h-2.56v11.365h2.68v-6.66ZM62.005 24.55c2.085 0 3.29-1.075 3.935-2.885L70.505 8.94l-2.865-.015-2.625 8.58h-.12l-2.62-8.58h-2.84l4.12 11.6-.23.615c-.495 1.295-1.28 1.385-2.45 1.045l-.62 2.085c.37.15 1.02.28 1.75.28Zm10.48-4.26h2.635V18.5h.155c.42.83 1.3 1.99 3.255 1.99 2.68 0 4.685-2.125 4.685-5.865 0-3.79-2.065-5.845-4.69-5.845-2.005 0-2.84 1.205-3.25 2.025h-.11V5.14h-2.68v15.15Zm2.625-5.68c0-2.205.945-3.635 2.67-3.635 1.785 0 2.7 1.515 2.7 3.635 0 2.13-.93 3.685-2.7 3.685-1.705 0-2.67-1.48-2.67-3.685Zm10.38 5.68h2.68V8.93h-2.68v11.36Zm1.345-12.975c.85 0 1.545-.65 1.545-1.45 0-.805-.695-1.455-1.545-1.455-.86 0-1.555.65-1.555 1.455 0 .8.695 1.45 1.555 1.45ZM90.92 20.29h2.68v-6.68c0-1.445 1.085-2.465 2.56-2.465.45 0 1.015.08 1.245.155V8.835a6.34 6.34 0 0 0-.96-.075c-1.3 0-2.39.74-2.805 2.055h-.12V8.92h-2.595l-.005 11.37Zm12.01.2c1.955 0 2.835-1.16 3.255-1.99h.16v1.79h2.635V5.14h-2.685v5.665h-.11c-.405-.82-1.245-2.025-3.25-2.025-2.625 0-4.69 2.055-4.69 5.845 0 3.745 2.005 5.865 4.685 5.865Zm.745-2.195c-1.77 0-2.7-1.555-2.7-3.685 0-2.115.915-3.635 2.7-3.635 1.725 0 2.67 1.43 2.67 3.635s-.96 3.685-2.67 3.685Z"/><path opacity="0.6" d="M25 2.64 17.195.5 14.45 6.635 25 2.64Zm-7.465 15.13-7.145-2.555L6.195 25.5l11.34-7.73Z"/><path d="m0 11.495 17.535 6.275L20.41 4.36 0 11.495Z"/></g><defs><clippath id="tinybird-logo_svg__a"><path fill="#fff" transform="translate(0 .5)" d="M0 0h108.98v25H0z"/></clippath></defs></svg></a><div class="ml-[4.5rem] items-center hidden lg:flex"><a class="mx-3 pb-1.5 pt-[0.4375rem] text-sm font-semibold border-b border-solid border-transparent transition-colors duration-200 ease-[cubic-bezier(0.55,0.085,0.68,0.53)] hover:border-code text-text-default" href="/product">Product</a><a class="mx-3 pb-1.5 pt-[0.4375rem] text-sm font-semibold border-b border-solid border-transparent transition-colors duration-200 ease-[cubic-bezier(0.55,0.085,0.68,0.53)] hover:border-code text-text-default" href="/pricing">Pricing</a><a class="mx-3 pb-1.5 pt-[0.4375rem] text-sm font-semibold border-b border-solid border-transparent transition-colors duration-200 ease-[cubic-bezier(0.55,0.085,0.68,0.53)] hover:border-code text-text-default" href="/use-cases">Use Cases</a><a class="mx-3 pb-1.5 pt-[0.4375rem] text-sm font-semibold border-b border-solid border-transparent transition-colors duration-200 ease-[cubic-bezier(0.55,0.085,0.68,0.53)] hover:border-code text-text-default" href="/docs">Docs</a><a class="mx-3 pb-1.5 pt-[0.4375rem] text-sm font-semibold border-b border-solid border-transparent transition-colors duration-200 ease-[cubic-bezier(0.55,0.085,0.68,0.53)] hover:border-code text-text-default" href="/blog">Blog</a></div></div><button class="relative z-30 flex flex-col items-center justify-center w-12 h-12 -right-4 lg:hidden" type="button"><div class="w-4 h-0.5 rounded-full transition-transform duration-200 bg-text-default"/><div class="w-4 h-0.5 my-[3px] rounded-full bg-text-default"/><div class="w-4 h-0.5 rounded-full transition-transform duration-200 bg-text-default"/></button><div class="absolute z-20 left-0 top-[4.0625rem] w-full h-[calc(100dvh-var(--header-height))] overflow-hidden lg:hidden ease-[cubic-bezier(0.25, 0.46, 0.45, 0.94)] scale-0 opacity-0" style="transition:opacity 0.4s ease-in-out, transform 0s 0.4s"><div class="relative flex flex-col w-full h-[calc(100dvh-var(--header-height))] pt-6 max-[375px]:pt-0 pb-8 px-5 z-10 md:px-6 overflow-y-auto bg-v-bg"><a class="mb-5 max-[375px]:mb-2 text-mobile-h1 border-b border-transparent transition-colors duration-200 ease-[cubic-bezier(0.55,0.085,0.68,0.53)] lg:hover:border-code" style="animation-delay:375ms" href="/product">Product</a><a class="mb-5 max-[375px]:mb-2 text-mobile-h1 border-b border-transparent transition-colors duration-200 ease-[cubic-bezier(0.55,0.085,0.68,0.53)] lg:hover:border-code" style="animation-delay:450ms" href="/pricing">Pricing</a><a class="mb-5 max-[375px]:mb-2 text-mobile-h1 border-b border-transparent transition-colors duration-200 ease-[cubic-bezier(0.55,0.085,0.68,0.53)] lg:hover:border-code" style="animation-delay:525ms" href="/use-cases">Use Cases</a><a class="mb-5 max-[375px]:mb-2 text-mobile-h1 border-b border-transparent transition-colors duration-200 ease-[cubic-bezier(0.55,0.085,0.68,0.53)] lg:hover:border-code" style="animation-delay:600ms" href="/docs">Docs</a><a class="mb-5 max-[375px]:mb-2 text-mobile-h1 border-b border-transparent transition-colors duration-200 ease-[cubic-bezier(0.55,0.085,0.68,0.53)] lg:hover:border-code" style="animation-delay:675ms" href="/blog">Blog</a><a class="!w-full !h-12 mt-auto UI-Button UI-Button--solid UI-Button--primary UI-Button--small UI-Button--link" href="https://app.tinybird.co/signup"><span class="UI-Button-inner">Start building</span></a></div></div><div class="relative z-30 hidden lg:block"><a class="mx-3 pb-1.5 pt-[0.4375rem] text-sm font-semibold border-b border-solid border-transparent transition-colors duration-200 ease-[cubic-bezier(0.55,0.085,0.68,0.53)] hover:border-code text-text-default" href="https://app.tinybird.co/login" target="_blank">Sign In</a><a class="ml-[1.1875rem] !px-[1.1875rem] !h-12 !border-2 !shadow-none UI-Button UI-Button--outline UI-Button--secondary UI-Button--small UI-Button--link" href="https://app.tinybird.co/signup"><span class="UI-Button-inner">Start building</span></a></div><div class="absolute top-0 left-0 w-full h-full transition-colors duration-300 z-20"/></div></div></div><div class="sticky top-0 w-full h-0.5 bg-text-02 lg:h-1"><div class="absolute top-0 bottom-0 right-0 w-full h-full bg-bg-dark will-change-transform dark:bg-brand" style="transform:translate3d(-100%,0,0)"/></div></div><div class="relative"><div class="relative w-full pt-4 mb-8 overflow-hidden lg:pt-8 lg:mb-12 min-[1440px]:mb-14"><div class="w-full px-5 mx-auto max-w-7xl md:px-6 lg:px-8"><div class="relative"><button class="flex items-center gap-1 text-body-3-regular leading-5 lg:absolute lg:left-0 lg:top-0" type="button"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg" class="inline w-4 h-4"><path d="M5.3 4.242a.665.665 0 1 1 .94.94l-2.15 2.15h9.245a.665.665 0 1 1 0 1.33h-9.28l2.185 2.184a.665.665 0 0 1-.94.94L1.998 8.485a.665.665 0 0 1 0-.94L5.3 4.242Z" fill="currentColor"/></svg>Back</button><div class="lg:max-w-[568px] lg:ml-[122px] min-[1200px]:max-w-[664px] min-[1440px]:max-w-[800px]"><div class="text-sm text-text-01 leading-[1.3125rem] mt-6 lg:mt-0">Jun 01, 2021</div><h1 class="text-mobile-h1 lg:text-h1 mt-4 lg:mt-5 min-[1200px]:mt-6">ClickHouse tips #8: Generating time-series on ClickHouse</h1><div class=" text-text-01 text-mobile-body-1-regular lg:text-body-1-regular mt-3 lg:mt-4 min-[1200px]:mt-5 min-[1440px]:mt-[26px] ">ClickHouse doesn't have a generate_series function yet, but you can achieve the same with other functions. Learn how here.</div><div class="flex gap-2 mt-5 lg:mt-6 min-[1200px]:mt-[26px] min-[1440px]:mt-[35px]"><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/clickhouse">ClickHouse</a></div><div class="flex flex-col gap-4 min-[640px]:flex-row xl:gap-6 mt-6 lg:mt-8"><div class="flex gap-3"><img alt="" src="https://tinybird-blog.ghost.io/content/images/2023/09/60648a046efaa06c0cfe1031_Xoel-Lo-pez.png" class="relative w-10 h-10 rounded-full" width="40" height="40"/><div class="flex-1 flex flex-col justify-center"><div class="text-mobile-body-3-semibold lg:text-body-3-semibold">Xoel López</div><div class="text-body-4-regular text-text-01 -mt-1">Founder at TheirStack</div></div></div></div></div></div></div></div><div class="blogPostContent" id="content"><p>You may be wondering if <code>generate_series</code> exists on ClickHouse like it does on Postgres. The bad news is that it doesn’t (yet); the good news is this post will teach you how to do on ClickHouse everything you can do on Postgres with <code>generate_series</code>, and more.</p><p>First, let’s see how the <a href="https://clickhouse.tech/docs/en/sql-reference/table-functions/numbers/" target="_blank" rel="noopener noreferrer"><code>numbers</code></a> function works on ClickHouse. It generates integers between a minimum value (0 by default) and a maximum value that you pass to it:</p><figure class="kg-card kg-embed-card"><div class="snippets-embed"><div class="Loader" style="width:50px;height:50px" data-testid="loader"><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/></div></div></figure><p>A similar result can be obtained with the <a href="https://clickhouse.tech/docs/en/sql-reference/functions/array-functions/#rangeend-rangestart-end-step" target="_blank" rel="noopener noreferrer"><code>range</code></a> function, that returns arrays. If we only provide an argument, it behaves like <code>numbers</code>. And with <code>range</code> we can also specify a <code>start</code>, <code>end</code> and <code>step</code>:</p><figure class="kg-card kg-embed-card"><div class="snippets-embed"><div class="Loader" style="width:50px;height:50px" data-testid="loader"><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/></div></div></figure><p>This, combined with <code>arrayJoin</code> lets us do the same as <code>generate_series</code>:</p><figure class="kg-card kg-embed-card"><div class="snippets-embed"><div class="Loader" style="width:50px;height:50px" data-testid="loader"><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/></div></div></figure><h2 id="generating-timestamp-ranges-on-postgres">Generating timestamp ranges on Postgres</h2><p>The <code>generate_series</code> on Postgres can produce results with other types different than integers, while ClickHouse’s <code>range</code> and <code>numbers</code> only output integers. But, with some smart logic, we can achieve the same results. For example, on Postgres you’d generate a time-series with a DateTime value for each hour in a day this way, as in described <a href="https://hakibenita.com/sql-for-data-analysis#generating-data" target="_blank" rel="noopener noreferrer">here</a>:</p><figure class="kg-card kg-embed-card"><div class="snippets-embed"><div class="Loader" style="width:50px;height:50px" data-testid="loader"><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/></div></div></figure><h3 id="generate-a-datetime-time-series-on-clickhouse-specifying-the-start-and-end-datetimes-and-the-step">Generate a DateTime time series on ClickHouse, specifying the start and end DateTimes, and the step</h3><p>On ClickHouse, you can achieve the same this way:</p><figure class="kg-card kg-embed-card"><div class="snippets-embed"><div class="Loader" style="width:50px;height:50px" data-testid="loader"><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/></div></div></figure><h2 id="generate-a-datetime-time-series-specifying-the-start-date-and-the-number-of-intervals">Generate a DateTime time series specifying the start date and the number of intervals</h2><p>Another way of doing the same thing:</p><figure class="kg-card kg-embed-card"><div class="snippets-embed"><div class="Loader" style="width:50px;height:50px" data-testid="loader"><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/></div></div></figure><p>More functions like <code>addHours</code> are available: <a href="https://clickhouse.tech/docs/en/sql-reference/functions/date-time-functions/#date_add" target="_blank" rel="noopener noreferrer"><code>dateAdd</code></a>, <a href="https://clickhouse.tech/docs/en/sql-reference/functions/date-time-functions/#timestamp_add" target="_blank" rel="noopener noreferrer"><code>timestampAdd</code></a> and <a href="https://clickhouse.tech/docs/en/sql-reference/functions/date-time-functions/#addyears-addmonths-addweeks-adddays-addhours-addminutes-addseconds-addquarters" target="_blank" rel="noopener noreferrer">addYears, addMonths, addWeeks, addDays, addHours, addMinutes, addSeconds, addQuarters</a>.</p><h3 id="generate-a-time-series-using-timeslots">Generate a time series using timeSlots</h3><p>Using the <a href="https://clickhouse.tech/docs/en/sql-reference/functions/date-time-functions/#timeslotsstarttime-duration-size" target="_blank" rel="noopener noreferrer"><code>timeSlots</code></a> function, we can specify the start (DateTime), duration (seconds) and step (seconds) and it generates an array of DateTime values.</p><figure class="kg-card kg-embed-card"><div class="snippets-embed"><div class="Loader" style="width:50px;height:50px" data-testid="loader"><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/></div></div></figure><h3 id="generate-a-date-time-series-specifying-the-start-and-end-date-and-the-step">Generate a Date time series specifying the start and end date and the step</h3><p>If you want to generate Date instead of DateTime objects, you’d change the <code>toDateTime</code> function by <code>toDate</code> from the first snippet. This is how you’d generate all the dates of January:</p><figure class="kg-card kg-embed-card"><div class="snippets-embed"><div class="Loader" style="width:50px;height:50px" data-testid="loader"><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/><div style="border-color:var(--secondary-color) transparent transparent transparent;border-width:1px"/></div></div></figure></div><div class="relative w-full bg-white mt-9 pb-12 lg:pb-[72px] lg:mt-12"><div class="w-full px-5 mx-auto max-w-7xl md:px-6 lg:px-8"><div class="lg:max-w-[568px] lg:ml-[122px] min-[1200px]:max-w-[664px] min-[1440px]:max-w-[800px]"><div class="text-text-default text-mobile-body-2-semibold lg:text-body-2-semibold">Do you like this post?</div><div class="flex gap-4 mt-4 lg:gap-6"><a target="_blank" rel="noopener noreferrer" href="http://www.facebook.com/share.php?u=https://www.tinybird.co/blog-posts/tips-8-generating-time-series-on-clickhouse"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24" width="32" height="32" class="inline text-text-02 hover:text-text-default w-6 h-6 xl:w-7 xl:h-7 2xl:w-8 2xl:h-8"><g clip-path="url(#facebook_svg__a)"><path d="M24 12.143C24 5.476 18.627.07 12 .07S0 5.476 0 12.143c0 6.027 4.388 11.02 10.125 11.926v-8.436H7.078v-3.49h3.047v-2.66c0-3.025 1.792-4.697 4.533-4.697 1.312 0 2.686.236 2.686.236v2.971H15.83c-1.491 0-1.956.93-1.956 1.886v2.263h3.328l-.532 3.491h-2.796v8.436C19.612 23.164 24 18.17 24 12.143Z" fill="currentColor"/></g><defs><clippath id="facebook_svg__a"><path fill="#fff" d="M0 0h24v24H0z"/></clippath></defs></svg></a><a target="_blank" rel="noopener noreferrer" href="https://twitter.com/intent/tweet?original_referer=https://www.tinybird.co/blog-posts/tips-8-generating-time-series-on-clickhouse&amp;utm_source=twitter&amp;url=https://www.tinybird.co/blog-posts/tips-8-generating-time-series-on-clickhouse&amp;utm_medium=social&amp;utm_source=twitter&amp;source=tweetbutton&amp;text="><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24" width="32" height="32" class="inline text-text-02 hover:text-text-default w-6 h-6 xl:w-7 xl:h-7 2xl:w-8 2xl:h-8"><path d="M23.953 4.573c-.898.395-1.85.656-2.825.774a4.957 4.957 0 0 0 2.163-2.722c-.951.555-2.005.96-3.127 1.184a4.92 4.92 0 0 0-8.384 4.48C7.69 8.097 4.067 6.132 1.64 3.165A4.82 4.82 0 0 0 .974 5.64c0 1.71.87 3.212 2.188 4.095a4.905 4.905 0 0 1-2.228-.616v.06a4.92 4.92 0 0 0 3.946 4.826 4.998 4.998 0 0 1-2.212.085 4.934 4.934 0 0 0 4.604 3.415A9.87 9.87 0 0 1 1.17 19.61c-.39 0-.779-.023-1.17-.067a13.998 13.998 0 0 0 7.557 2.208c9.053 0 13.998-7.493 13.998-13.98 0-.21 0-.42-.015-.63A9.933 9.933 0 0 0 24 4.593l-.047-.02Z" fill="currentColor"/></svg></a><a target="_blank" rel="noopener noreferrer" href="http://www.linkedin.com/shareArticle?mini=true&amp;url=https://www.tinybird.co/blog-posts/tips-8-generating-time-series-on-clickhouse&amp;utm_medium=social&amp;utm_source=linkedin"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24" width="32" height="32" class="inline text-text-02 hover:text-text-default w-6 h-6 xl:w-7 xl:h-7 2xl:w-8 2xl:h-8"><g clip-path="url(#linkedIn_svg__a)"><path d="M20.447 20.452h-3.554v-5.569c0-1.328-.027-3.037-1.852-3.037-1.853 0-2.136 1.445-2.136 2.939v5.667H9.351V9h3.414v1.561h.046c.477-.9 1.637-1.85 3.37-1.85 3.601 0 4.267 2.37 4.267 5.455v6.286h-.001ZM5.337 7.433a2.062 2.062 0 0 1-2.063-2.065 2.064 2.064 0 1 1 2.063 2.065Zm1.782 13.019H3.555V9h3.564v11.452ZM22.225 0H1.771C.792 0 0 .774 0 1.729v20.542C0 23.227.792 24 1.771 24h20.451C23.2 24 24 23.227 24 22.271V1.729C24 .774 23.2 0 22.222 0h.003Z" fill="currentColor"/></g><defs><clippath id="linkedIn_svg__a"><path fill="#fff" d="M0 0h24v24H0z"/></clippath></defs></svg></a><a target="_blank" rel="noopener noreferrer" href="https://news.ycombinator.com/submitlink?u=https://www.tinybird.co/blog-posts/tips-8-generating-time-series-on-clickhouse&amp;t=ClickHouse%20tips%20%238%3A%20Generating%20time-series%20on%20ClickHouse"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24" width="32" height="32" class="inline text-text-02 hover:text-text-default w-6 h-6 xl:w-7 xl:h-7 2xl:w-8 2xl:h-8"><g clip-path="url(#yCombinator_svg__a)"><path d="M0 0h24v24H0V0Z" fill="currentColor"/><path d="m11.191 13.569-4.12-7.717h1.883l2.424 4.883c.037.087.08.177.13.27.05.094.093.19.13.29a.564.564 0 0 1 .056.102c.013.03.025.059.038.084a6.261 6.261 0 0 1 .298.69c.1-.212.208-.439.326-.68.118-.243.24-.495.364-.756l2.46-4.883h1.752l-4.156 7.81v4.977H11.19v-5.07Z" fill="#fff"/></g><defs><clippath id="yCombinator_svg__a"><path fill="#fff" d="M0 0h24v24H0z"/></clippath></defs></svg></a></div></div></div></div></div></div><div class="relative w-full bg-bg-01 py-8 md:py-12 xl:py-16 overflow-clip z-20"><div class="w-full px-5 mx-auto max-w-7xl md:px-6 lg:px-8"><p class="text-mobile-h4 mb-6 md:text-h4">Related posts</p><div class="swiper style_wrapper__cG_Ql overflow-visible"><div class="swiper-wrapper items-stretch"><div class="swiper-slide h-auto w-[303px] sm:w-[320px] lg:w-[384px]"><div class="relative flex flex-col custom-border-gradient-gray rounded-asset overflow-clip bg-white text-text-default h-full"><a class="absolute z-10 w-full h-full" href="/blog-posts/tips-5-adding-and-subtracting-intervals"/><img alt="" loading="lazy" width="0" height="0" decoding="async" data-nimg="1" class="w-full aspect-video object-cover rounded-t-asset" style="color:transparent" sizes="(max-width: 768px) 100vw, (max-width: 990px) 50vw, 30vw" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eeb9891276a1b9367b9c_625660a77a5e47db00bfafeb_blogpost-cover-image-41-large-15.jpeg&amp;w=256&amp;q=75 256w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eeb9891276a1b9367b9c_625660a77a5e47db00bfafeb_blogpost-cover-image-41-large-15.jpeg&amp;w=384&amp;q=75 384w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eeb9891276a1b9367b9c_625660a77a5e47db00bfafeb_blogpost-cover-image-41-large-15.jpeg&amp;w=640&amp;q=75 640w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eeb9891276a1b9367b9c_625660a77a5e47db00bfafeb_blogpost-cover-image-41-large-15.jpeg&amp;w=750&amp;q=75 750w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eeb9891276a1b9367b9c_625660a77a5e47db00bfafeb_blogpost-cover-image-41-large-15.jpeg&amp;w=828&amp;q=75 828w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eeb9891276a1b9367b9c_625660a77a5e47db00bfafeb_blogpost-cover-image-41-large-15.jpeg&amp;w=1080&amp;q=75 1080w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eeb9891276a1b9367b9c_625660a77a5e47db00bfafeb_blogpost-cover-image-41-large-15.jpeg&amp;w=1200&amp;q=75 1200w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eeb9891276a1b9367b9c_625660a77a5e47db00bfafeb_blogpost-cover-image-41-large-15.jpeg&amp;w=1920&amp;q=75 1920w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eeb9891276a1b9367b9c_625660a77a5e47db00bfafeb_blogpost-cover-image-41-large-15.jpeg&amp;w=2048&amp;q=75 2048w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eeb9891276a1b9367b9c_625660a77a5e47db00bfafeb_blogpost-cover-image-41-large-15.jpeg&amp;w=3840&amp;q=75 3840w" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eeb9891276a1b9367b9c_625660a77a5e47db00bfafeb_blogpost-cover-image-41-large-15.jpeg&amp;w=3840&amp;q=75"/><div class="relative flex flex-col justify-between flex-1 p-5 lg:p-6"><div><div class="flex flex-wrap gap-2 mb-3"><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/clickhouse">ClickHouse</a></div><div class="mt-3 text-mobile-body-1-semibold lg:text-body-1-semibold">ClickHouse tips #5: Adding and subtracting intervals</div></div><div class="flex justify-between gap-2"><a class="z-20 flex mt-6 md:mt-8" href="/authors/alrocar"><img alt="" loading="lazy" width="40" height="40" decoding="async" data-nimg="1" class="w-10 h-10 me-3 rounded-full" style="color:transparent" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F606489ec9d055c47e218417c_Alberto-Romeu.png&amp;w=48&amp;q=75 1x, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F606489ec9d055c47e218417c_Alberto-Romeu.png&amp;w=96&amp;q=75 2x" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F606489ec9d055c47e218417c_Alberto-Romeu.png&amp;w=96&amp;q=75"/><div><p class="text-mobile-body-3-semibold md:text-body-3-semibold">Alberto Romeu</p><p class="-mt-1 text-body-4-regular text-text-01">Backend Developer</p></div></a><div class="mt-3 flex flex-col-reverse text-body-4-regular text-end text-text-01">Mar 24, 2021</div></div></div></div></div><div class="swiper-slide h-auto w-[303px] sm:w-[320px] lg:w-[384px]"><div class="relative flex flex-col custom-border-gradient-gray rounded-asset overflow-clip bg-white text-text-default h-full"><a class="absolute z-10 w-full h-full" href="/blog-posts/tips-9-filling-gaps-in-time-series-on-clickhouse"/><img alt="" loading="lazy" width="0" height="0" decoding="async" data-nimg="1" class="w-full aspect-video object-cover rounded-t-asset" style="color:transparent" sizes="(max-width: 768px) 100vw, (max-width: 990px) 50vw, 30vw" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-26.jpeg&amp;w=256&amp;q=75 256w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-26.jpeg&amp;w=384&amp;q=75 384w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-26.jpeg&amp;w=640&amp;q=75 640w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-26.jpeg&amp;w=750&amp;q=75 750w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-26.jpeg&amp;w=828&amp;q=75 828w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-26.jpeg&amp;w=1080&amp;q=75 1080w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-26.jpeg&amp;w=1200&amp;q=75 1200w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-26.jpeg&amp;w=1920&amp;q=75 1920w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-26.jpeg&amp;w=2048&amp;q=75 2048w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-26.jpeg&amp;w=3840&amp;q=75 3840w" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-26.jpeg&amp;w=3840&amp;q=75"/><div class="relative flex flex-col justify-between flex-1 p-5 lg:p-6"><div><div class="flex flex-wrap gap-2 mb-3"><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/clickhouse">ClickHouse</a></div><div class="mt-3 text-mobile-body-1-semibold lg:text-body-1-semibold">ClickHouse tips #9: Filling gaps in time-series on ClickHouse</div></div><div class="flex justify-between gap-2"><a class="z-20 flex mt-6 md:mt-8" href="/authors/xoel"><img alt="" loading="lazy" width="40" height="40" decoding="async" data-nimg="1" class="w-10 h-10 me-3 rounded-full" style="color:transparent" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F60648a046efaa06c0cfe1031_Xoel-Lo-pez.png&amp;w=48&amp;q=75 1x, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F60648a046efaa06c0cfe1031_Xoel-Lo-pez.png&amp;w=96&amp;q=75 2x" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F60648a046efaa06c0cfe1031_Xoel-Lo-pez.png&amp;w=96&amp;q=75"/><div><p class="text-mobile-body-3-semibold md:text-body-3-semibold">Xoel López</p><p class="-mt-1 text-body-4-regular text-text-01">Founder at TheirStack</p></div></a><div class="mt-3 flex flex-col-reverse text-body-4-regular text-end text-text-01">Jul 08, 2021</div></div></div></div></div><div class="swiper-slide h-auto w-[303px] sm:w-[320px] lg:w-[384px]"><div class="relative flex flex-col custom-border-gradient-gray rounded-asset overflow-clip bg-white text-text-default h-full"><a class="absolute z-10 w-full h-full" href="/blog-posts/coming-soon-on-clickhouse-window-functions"/><img alt="" loading="lazy" width="0" height="0" decoding="async" data-nimg="1" class="w-full aspect-video object-cover rounded-t-asset" style="color:transparent" sizes="(max-width: 768px) 100vw, (max-width: 990px) 50vw, 30vw" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-25.jpeg&amp;w=256&amp;q=75 256w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-25.jpeg&amp;w=384&amp;q=75 384w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-25.jpeg&amp;w=640&amp;q=75 640w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-25.jpeg&amp;w=750&amp;q=75 750w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-25.jpeg&amp;w=828&amp;q=75 828w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-25.jpeg&amp;w=1080&amp;q=75 1080w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-25.jpeg&amp;w=1200&amp;q=75 1200w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-25.jpeg&amp;w=1920&amp;q=75 1920w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-25.jpeg&amp;w=2048&amp;q=75 2048w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-25.jpeg&amp;w=3840&amp;q=75 3840w" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea8e38e249da876a2995_625653075a98a37c6f9f4636_blogpost-cover-image-09-large-25.jpeg&amp;w=3840&amp;q=75"/><div class="relative flex flex-col justify-between flex-1 p-5 lg:p-6"><div><div class="flex flex-wrap gap-2 mb-3"><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/clickhouse">ClickHouse</a></div><div class="mt-3 text-mobile-body-1-semibold lg:text-body-1-semibold">Coming soon on ClickHouse: Window functions</div></div><div class="flex justify-between gap-2"><a class="z-20 flex mt-6 md:mt-8" href="/authors/xoel"><img alt="" loading="lazy" width="40" height="40" decoding="async" data-nimg="1" class="w-10 h-10 me-3 rounded-full" style="color:transparent" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F60648a046efaa06c0cfe1031_Xoel-Lo-pez.png&amp;w=48&amp;q=75 1x, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F60648a046efaa06c0cfe1031_Xoel-Lo-pez.png&amp;w=96&amp;q=75 2x" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F60648a046efaa06c0cfe1031_Xoel-Lo-pez.png&amp;w=96&amp;q=75"/><div><p class="text-mobile-body-3-semibold md:text-body-3-semibold">Xoel López</p><p class="-mt-1 text-body-4-regular text-text-01">Founder at TheirStack</p></div></a><div class="mt-3 flex flex-col-reverse text-body-4-regular text-end text-text-01">Mar 16, 2021</div></div></div></div></div><div class="swiper-slide h-auto w-[303px] sm:w-[320px] lg:w-[384px]"><div class="relative flex flex-col custom-border-gradient-gray rounded-asset overflow-clip bg-white text-text-default h-full"><a class="absolute z-10 w-full h-full" href="/blog-posts/tinybird-tips-1-calculating-aggregations-after-and-before-a-date"/><img alt="" loading="lazy" width="0" height="0" decoding="async" data-nimg="1" class="w-full aspect-video object-cover rounded-t-asset" style="color:transparent" sizes="(max-width: 768px) 100vw, (max-width: 990px) 50vw, 30vw" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee06c7c36f54aa9f7114_625670bd69e584af47149797_blogpost-cover-image-43-large-11.jpeg&amp;w=256&amp;q=75 256w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee06c7c36f54aa9f7114_625670bd69e584af47149797_blogpost-cover-image-43-large-11.jpeg&amp;w=384&amp;q=75 384w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee06c7c36f54aa9f7114_625670bd69e584af47149797_blogpost-cover-image-43-large-11.jpeg&amp;w=640&amp;q=75 640w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee06c7c36f54aa9f7114_625670bd69e584af47149797_blogpost-cover-image-43-large-11.jpeg&amp;w=750&amp;q=75 750w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee06c7c36f54aa9f7114_625670bd69e584af47149797_blogpost-cover-image-43-large-11.jpeg&amp;w=828&amp;q=75 828w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee06c7c36f54aa9f7114_625670bd69e584af47149797_blogpost-cover-image-43-large-11.jpeg&amp;w=1080&amp;q=75 1080w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee06c7c36f54aa9f7114_625670bd69e584af47149797_blogpost-cover-image-43-large-11.jpeg&amp;w=1200&amp;q=75 1200w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee06c7c36f54aa9f7114_625670bd69e584af47149797_blogpost-cover-image-43-large-11.jpeg&amp;w=1920&amp;q=75 1920w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee06c7c36f54aa9f7114_625670bd69e584af47149797_blogpost-cover-image-43-large-11.jpeg&amp;w=2048&amp;q=75 2048w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee06c7c36f54aa9f7114_625670bd69e584af47149797_blogpost-cover-image-43-large-11.jpeg&amp;w=3840&amp;q=75 3840w" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee06c7c36f54aa9f7114_625670bd69e584af47149797_blogpost-cover-image-43-large-11.jpeg&amp;w=3840&amp;q=75"/><div class="relative flex flex-col justify-between flex-1 p-5 lg:p-6"><div><div class="flex flex-wrap gap-2 mb-3"><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/clickhouse">ClickHouse</a></div><div class="mt-3 text-mobile-body-1-semibold lg:text-body-1-semibold">Clickhouse Tips #1: Calculating Aggregations After a Given Date</div></div><div class="flex justify-between gap-2"><a class="z-20 flex mt-6 md:mt-8" href="/authors/javisantana"><img alt="" loading="lazy" width="40" height="40" decoding="async" data-nimg="1" class="w-10 h-10 me-3 rounded-full" style="color:transparent" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F606488f935df1788b3631373_Ellipse-66.png&amp;w=48&amp;q=75 1x, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F606488f935df1788b3631373_Ellipse-66.png&amp;w=96&amp;q=75 2x" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F606488f935df1788b3631373_Ellipse-66.png&amp;w=96&amp;q=75"/><div><p class="text-mobile-body-3-semibold md:text-body-3-semibold">Javier Santana</p><p class="-mt-1 text-body-4-regular text-text-01">Co-founder</p></div></a><div class="mt-3 flex flex-col-reverse text-body-4-regular text-end text-text-01">Jan 26, 2021</div></div></div></div></div><div class="swiper-slide h-auto w-[303px] sm:w-[320px] lg:w-[384px]"><div class="relative flex flex-col custom-border-gradient-gray rounded-asset overflow-clip bg-white text-text-default h-full"><a class="absolute z-10 w-full h-full" href="/blog-posts/tips-3-transform"/><img alt="" loading="lazy" width="0" height="0" decoding="async" data-nimg="1" class="w-full aspect-video object-cover rounded-t-asset" style="color:transparent" sizes="(max-width: 768px) 100vw, (max-width: 990px) 50vw, 30vw" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee1785bf3d314cf5ca12_6256698ad03fb7bbad38167c_blogpost-cover-image-68-large-11.jpeg&amp;w=256&amp;q=75 256w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee1785bf3d314cf5ca12_6256698ad03fb7bbad38167c_blogpost-cover-image-68-large-11.jpeg&amp;w=384&amp;q=75 384w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee1785bf3d314cf5ca12_6256698ad03fb7bbad38167c_blogpost-cover-image-68-large-11.jpeg&amp;w=640&amp;q=75 640w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee1785bf3d314cf5ca12_6256698ad03fb7bbad38167c_blogpost-cover-image-68-large-11.jpeg&amp;w=750&amp;q=75 750w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee1785bf3d314cf5ca12_6256698ad03fb7bbad38167c_blogpost-cover-image-68-large-11.jpeg&amp;w=828&amp;q=75 828w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee1785bf3d314cf5ca12_6256698ad03fb7bbad38167c_blogpost-cover-image-68-large-11.jpeg&amp;w=1080&amp;q=75 1080w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee1785bf3d314cf5ca12_6256698ad03fb7bbad38167c_blogpost-cover-image-68-large-11.jpeg&amp;w=1200&amp;q=75 1200w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee1785bf3d314cf5ca12_6256698ad03fb7bbad38167c_blogpost-cover-image-68-large-11.jpeg&amp;w=1920&amp;q=75 1920w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee1785bf3d314cf5ca12_6256698ad03fb7bbad38167c_blogpost-cover-image-68-large-11.jpeg&amp;w=2048&amp;q=75 2048w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee1785bf3d314cf5ca12_6256698ad03fb7bbad38167c_blogpost-cover-image-68-large-11.jpeg&amp;w=3840&amp;q=75 3840w" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ee1785bf3d314cf5ca12_6256698ad03fb7bbad38167c_blogpost-cover-image-68-large-11.jpeg&amp;w=3840&amp;q=75"/><div class="relative flex flex-col justify-between flex-1 p-5 lg:p-6"><div><div class="flex flex-wrap gap-2 mb-3"><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/clickhouse">ClickHouse</a></div><div class="mt-3 text-mobile-body-1-semibold lg:text-body-1-semibold">ClickHouse tips #3: the transform function</div></div><div class="flex justify-between gap-2"><a class="z-20 flex mt-6 md:mt-8" href="/authors/javisantana"><img alt="" loading="lazy" width="40" height="40" decoding="async" data-nimg="1" class="w-10 h-10 me-3 rounded-full" style="color:transparent" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F606488f935df1788b3631373_Ellipse-66.png&amp;w=48&amp;q=75 1x, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F606488f935df1788b3631373_Ellipse-66.png&amp;w=96&amp;q=75 2x" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F606488f935df1788b3631373_Ellipse-66.png&amp;w=96&amp;q=75"/><div><p class="text-mobile-body-3-semibold md:text-body-3-semibold">Javier Santana</p><p class="-mt-1 text-body-4-regular text-text-01">Co-founder</p></div></a><div class="mt-3 flex flex-col-reverse text-body-4-regular text-end text-text-01">Feb 25, 2021</div></div></div></div></div><div class="swiper-slide h-auto w-[303px] sm:w-[320px] lg:w-[384px]"><div class="relative flex flex-col custom-border-gradient-gray rounded-asset overflow-clip bg-white text-text-default h-full"><a class="absolute z-10 w-full h-full" href="/blog-posts/roll-up-data-with-materialized-views"/><img alt="" loading="lazy" width="0" height="0" decoding="async" data-nimg="1" class="w-full aspect-video object-cover rounded-t-asset" style="color:transparent" sizes="(max-width: 768px) 100vw, (max-width: 990px) 50vw, 30vw" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F631696bf7807fe32478c6ac2_629711af229e9cbdfd1b5afd_BlogImg_2_968x664-4.png&amp;w=256&amp;q=75 256w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F631696bf7807fe32478c6ac2_629711af229e9cbdfd1b5afd_BlogImg_2_968x664-4.png&amp;w=384&amp;q=75 384w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F631696bf7807fe32478c6ac2_629711af229e9cbdfd1b5afd_BlogImg_2_968x664-4.png&amp;w=640&amp;q=75 640w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F631696bf7807fe32478c6ac2_629711af229e9cbdfd1b5afd_BlogImg_2_968x664-4.png&amp;w=750&amp;q=75 750w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F631696bf7807fe32478c6ac2_629711af229e9cbdfd1b5afd_BlogImg_2_968x664-4.png&amp;w=828&amp;q=75 828w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F631696bf7807fe32478c6ac2_629711af229e9cbdfd1b5afd_BlogImg_2_968x664-4.png&amp;w=1080&amp;q=75 1080w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F631696bf7807fe32478c6ac2_629711af229e9cbdfd1b5afd_BlogImg_2_968x664-4.png&amp;w=1200&amp;q=75 1200w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F631696bf7807fe32478c6ac2_629711af229e9cbdfd1b5afd_BlogImg_2_968x664-4.png&amp;w=1920&amp;q=75 1920w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F631696bf7807fe32478c6ac2_629711af229e9cbdfd1b5afd_BlogImg_2_968x664-4.png&amp;w=2048&amp;q=75 2048w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F631696bf7807fe32478c6ac2_629711af229e9cbdfd1b5afd_BlogImg_2_968x664-4.png&amp;w=3840&amp;q=75 3840w" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F631696bf7807fe32478c6ac2_629711af229e9cbdfd1b5afd_BlogImg_2_968x664-4.png&amp;w=3840&amp;q=75"/><div class="relative flex flex-col justify-between flex-1 p-5 lg:p-6"><div><div class="flex flex-wrap gap-2 mb-3"><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/data-101">Data 101</a><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/tinybird-examples">Tinybird Examples</a></div><div class="mt-3 text-mobile-body-1-semibold lg:text-body-1-semibold">Roll up data with Materialized Views</div></div><div class="flex justify-between gap-2"><a class="z-20 flex mt-6 md:mt-8" href="/authors/alison"><img alt="" loading="lazy" width="40" height="40" decoding="async" data-nimg="1" class="w-10 h-10 me-3 rounded-full" style="color:transparent" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F60b7ecde436420ccd886157a_alison.jpg&amp;w=48&amp;q=75 1x, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F60b7ecde436420ccd886157a_alison.jpg&amp;w=96&amp;q=75 2x" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F60b7ecde436420ccd886157a_alison.jpg&amp;w=96&amp;q=75"/><div><p class="text-mobile-body-3-semibold md:text-body-3-semibold">Alison Davey</p><p class="-mt-1 text-body-4-regular text-text-01">Developer Advocate</p></div></a><div class="mt-3 flex flex-col-reverse text-body-4-regular text-end text-text-01">Jun 01, 2022</div></div></div></div></div><div class="swiper-slide h-auto w-[303px] sm:w-[320px] lg:w-[384px]"><div class="relative flex flex-col custom-border-gradient-gray rounded-asset overflow-clip bg-white text-text-default h-full"><a class="absolute z-10 w-full h-full" href="/blog-posts/simple-time-series-prediction"/><img alt="" loading="lazy" width="0" height="0" decoding="async" data-nimg="1" class="w-full aspect-video object-cover rounded-t-asset" style="color:transparent" sizes="(max-width: 768px) 100vw, (max-width: 990px) 50vw, 30vw" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea336605de27060cd9ea_6256ad534328bc1b076e8b68_blogpost-cover-image-59-large-11.jpeg&amp;w=256&amp;q=75 256w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea336605de27060cd9ea_6256ad534328bc1b076e8b68_blogpost-cover-image-59-large-11.jpeg&amp;w=384&amp;q=75 384w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea336605de27060cd9ea_6256ad534328bc1b076e8b68_blogpost-cover-image-59-large-11.jpeg&amp;w=640&amp;q=75 640w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea336605de27060cd9ea_6256ad534328bc1b076e8b68_blogpost-cover-image-59-large-11.jpeg&amp;w=750&amp;q=75 750w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea336605de27060cd9ea_6256ad534328bc1b076e8b68_blogpost-cover-image-59-large-11.jpeg&amp;w=828&amp;q=75 828w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea336605de27060cd9ea_6256ad534328bc1b076e8b68_blogpost-cover-image-59-large-11.jpeg&amp;w=1080&amp;q=75 1080w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea336605de27060cd9ea_6256ad534328bc1b076e8b68_blogpost-cover-image-59-large-11.jpeg&amp;w=1200&amp;q=75 1200w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea336605de27060cd9ea_6256ad534328bc1b076e8b68_blogpost-cover-image-59-large-11.jpeg&amp;w=1920&amp;q=75 1920w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea336605de27060cd9ea_6256ad534328bc1b076e8b68_blogpost-cover-image-59-large-11.jpeg&amp;w=2048&amp;q=75 2048w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea336605de27060cd9ea_6256ad534328bc1b076e8b68_blogpost-cover-image-59-large-11.jpeg&amp;w=3840&amp;q=75 3840w" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea336605de27060cd9ea_6256ad534328bc1b076e8b68_blogpost-cover-image-59-large-11.jpeg&amp;w=3840&amp;q=75"/><div class="relative flex flex-col justify-between flex-1 p-5 lg:p-6"><div><div class="flex flex-wrap gap-2 mb-3"><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/tech">Tech</a><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/tinybird-examples">Tinybird Examples</a></div><div class="mt-3 text-mobile-body-1-semibold lg:text-body-1-semibold">Simple Time Series Prediction Modeling Using Tinybird</div></div><div class="flex justify-between gap-2"><a class="z-20 flex mt-6 md:mt-8" href="/authors/javisantana"><img alt="" loading="lazy" width="40" height="40" decoding="async" data-nimg="1" class="w-10 h-10 me-3 rounded-full" style="color:transparent" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F606488f935df1788b3631373_Ellipse-66.png&amp;w=48&amp;q=75 1x, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F606488f935df1788b3631373_Ellipse-66.png&amp;w=96&amp;q=75 2x" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F606488f935df1788b3631373_Ellipse-66.png&amp;w=96&amp;q=75"/><div><p class="text-mobile-body-3-semibold md:text-body-3-semibold">Javier Santana</p><p class="-mt-1 text-body-4-regular text-text-01">Co-founder</p></div></a><div class="mt-3 flex flex-col-reverse text-body-4-regular text-end text-text-01">Apr 21, 2019</div></div></div></div></div><div class="swiper-slide h-auto w-[303px] sm:w-[320px] lg:w-[384px]"><div class="relative flex flex-col custom-border-gradient-gray rounded-asset overflow-clip bg-white text-text-default h-full"><a class="absolute z-10 w-full h-full" href="/blog-posts/the-one-cron-job-that-will-speed-up-your-analytical-queries-in-postgres-a-hundred-fold"/><img alt="" loading="lazy" width="0" height="0" decoding="async" data-nimg="1" class="w-full aspect-video object-cover rounded-t-asset" style="color:transparent" sizes="(max-width: 768px) 100vw, (max-width: 990px) 50vw, 30vw" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea3bbb851421370ea3fe_6256acc35e87f68ab187536c_blogpost-cover-image-28-large-11.jpeg&amp;w=256&amp;q=75 256w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea3bbb851421370ea3fe_6256acc35e87f68ab187536c_blogpost-cover-image-28-large-11.jpeg&amp;w=384&amp;q=75 384w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea3bbb851421370ea3fe_6256acc35e87f68ab187536c_blogpost-cover-image-28-large-11.jpeg&amp;w=640&amp;q=75 640w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea3bbb851421370ea3fe_6256acc35e87f68ab187536c_blogpost-cover-image-28-large-11.jpeg&amp;w=750&amp;q=75 750w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea3bbb851421370ea3fe_6256acc35e87f68ab187536c_blogpost-cover-image-28-large-11.jpeg&amp;w=828&amp;q=75 828w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea3bbb851421370ea3fe_6256acc35e87f68ab187536c_blogpost-cover-image-28-large-11.jpeg&amp;w=1080&amp;q=75 1080w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea3bbb851421370ea3fe_6256acc35e87f68ab187536c_blogpost-cover-image-28-large-11.jpeg&amp;w=1200&amp;q=75 1200w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea3bbb851421370ea3fe_6256acc35e87f68ab187536c_blogpost-cover-image-28-large-11.jpeg&amp;w=1920&amp;q=75 1920w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea3bbb851421370ea3fe_6256acc35e87f68ab187536c_blogpost-cover-image-28-large-11.jpeg&amp;w=2048&amp;q=75 2048w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea3bbb851421370ea3fe_6256acc35e87f68ab187536c_blogpost-cover-image-28-large-11.jpeg&amp;w=3840&amp;q=75 3840w" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256ea3bbb851421370ea3fe_6256acc35e87f68ab187536c_blogpost-cover-image-28-large-11.jpeg&amp;w=3840&amp;q=75"/><div class="relative flex flex-col justify-between flex-1 p-5 lg:p-6"><div><div class="flex flex-wrap gap-2 mb-3"><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/tech">Tech</a><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/tinybird-examples">Tinybird Examples</a></div><div class="mt-3 text-mobile-body-1-semibold lg:text-body-1-semibold">The cron job that will speed up your Postgres queries 100x</div></div><div class="flex justify-between gap-2"><a class="z-20 flex mt-6 md:mt-8" href="/authors/sancha"><img alt="" loading="lazy" width="40" height="40" decoding="async" data-nimg="1" class="w-10 h-10 me-3 rounded-full" style="color:transparent" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6064890bcbebddaafc37cba2_Ellipse-66-2.png&amp;w=48&amp;q=75 1x, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6064890bcbebddaafc37cba2_Ellipse-66-2.png&amp;w=96&amp;q=75 2x" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6064890bcbebddaafc37cba2_Ellipse-66-2.png&amp;w=96&amp;q=75"/><div><p class="text-mobile-body-3-semibold md:text-body-3-semibold">Jorge Sancha</p><p class="-mt-1 text-body-4-regular text-text-01">Co-founder &amp; CEO</p></div></a><div class="mt-3 flex flex-col-reverse text-body-4-regular text-end text-text-01">Oct 14, 2019</div></div></div></div></div><div class="swiper-slide h-auto w-[303px] sm:w-[320px] lg:w-[384px]"><div class="relative flex flex-col custom-border-gradient-gray rounded-asset overflow-clip bg-white text-text-default h-full"><a class="absolute z-10 w-full h-full" href="/blog-posts/tips-7-filling-null-values-on-clickhouse"/><img alt="" loading="lazy" width="0" height="0" decoding="async" data-nimg="1" class="w-full aspect-video object-cover rounded-t-asset" style="color:transparent" sizes="(max-width: 768px) 100vw, (max-width: 990px) 50vw, 30vw" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eec16e912d6ac997f268_62565d0d17b31b1259ed4b1b_blogpost-cover-image-33-large-11.jpeg&amp;w=256&amp;q=75 256w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eec16e912d6ac997f268_62565d0d17b31b1259ed4b1b_blogpost-cover-image-33-large-11.jpeg&amp;w=384&amp;q=75 384w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eec16e912d6ac997f268_62565d0d17b31b1259ed4b1b_blogpost-cover-image-33-large-11.jpeg&amp;w=640&amp;q=75 640w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eec16e912d6ac997f268_62565d0d17b31b1259ed4b1b_blogpost-cover-image-33-large-11.jpeg&amp;w=750&amp;q=75 750w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eec16e912d6ac997f268_62565d0d17b31b1259ed4b1b_blogpost-cover-image-33-large-11.jpeg&amp;w=828&amp;q=75 828w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eec16e912d6ac997f268_62565d0d17b31b1259ed4b1b_blogpost-cover-image-33-large-11.jpeg&amp;w=1080&amp;q=75 1080w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eec16e912d6ac997f268_62565d0d17b31b1259ed4b1b_blogpost-cover-image-33-large-11.jpeg&amp;w=1200&amp;q=75 1200w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eec16e912d6ac997f268_62565d0d17b31b1259ed4b1b_blogpost-cover-image-33-large-11.jpeg&amp;w=1920&amp;q=75 1920w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eec16e912d6ac997f268_62565d0d17b31b1259ed4b1b_blogpost-cover-image-33-large-11.jpeg&amp;w=2048&amp;q=75 2048w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eec16e912d6ac997f268_62565d0d17b31b1259ed4b1b_blogpost-cover-image-33-large-11.jpeg&amp;w=3840&amp;q=75 3840w" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6256eec16e912d6ac997f268_62565d0d17b31b1259ed4b1b_blogpost-cover-image-33-large-11.jpeg&amp;w=3840&amp;q=75"/><div class="relative flex flex-col justify-between flex-1 p-5 lg:p-6"><div><div class="flex flex-wrap gap-2 mb-3"><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/clickhouse">ClickHouse</a></div><div class="mt-3 text-mobile-body-1-semibold lg:text-body-1-semibold">ClickHouse tips #7: Forward and backfilling null values</div></div><div class="flex justify-between gap-2"><a class="z-20 flex mt-6 md:mt-8" href="/authors/alex"><img alt="" loading="lazy" width="40" height="40" decoding="async" data-nimg="1" class="w-10 h-10 me-3 rounded-full" style="color:transparent" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6064893f9cc69f4c4e037481_Ellipse-66-4.png&amp;w=48&amp;q=75 1x, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6064893f9cc69f4c4e037481_Ellipse-66-4.png&amp;w=96&amp;q=75 2x" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6064893f9cc69f4c4e037481_Ellipse-66-4.png&amp;w=96&amp;q=75"/><div><p class="text-mobile-body-3-semibold md:text-body-3-semibold">Alejandra Rodriguez</p><p class="-mt-1 text-body-4-regular text-text-01"/></div></a><div class="mt-3 flex flex-col-reverse text-body-4-regular text-end text-text-01">May 18, 2021</div></div></div></div></div><div class="swiper-slide h-auto w-[303px] sm:w-[320px] lg:w-[384px]"><div class="relative flex flex-col custom-border-gradient-gray rounded-asset overflow-clip bg-white text-text-default h-full"><a class="absolute z-10 w-full h-full" href="/blog-posts/announcing-time-series"/><img alt="" loading="lazy" width="0" height="0" decoding="async" data-nimg="1" class="w-full aspect-video object-cover rounded-t-asset" style="color:transparent" sizes="(max-width: 768px) 100vw, (max-width: 990px) 50vw, 30vw" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F633b0878de60e629f6838d66_time_series_968x664--1--4.jpg&amp;w=256&amp;q=75 256w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F633b0878de60e629f6838d66_time_series_968x664--1--4.jpg&amp;w=384&amp;q=75 384w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F633b0878de60e629f6838d66_time_series_968x664--1--4.jpg&amp;w=640&amp;q=75 640w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F633b0878de60e629f6838d66_time_series_968x664--1--4.jpg&amp;w=750&amp;q=75 750w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F633b0878de60e629f6838d66_time_series_968x664--1--4.jpg&amp;w=828&amp;q=75 828w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F633b0878de60e629f6838d66_time_series_968x664--1--4.jpg&amp;w=1080&amp;q=75 1080w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F633b0878de60e629f6838d66_time_series_968x664--1--4.jpg&amp;w=1200&amp;q=75 1200w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F633b0878de60e629f6838d66_time_series_968x664--1--4.jpg&amp;w=1920&amp;q=75 1920w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F633b0878de60e629f6838d66_time_series_968x664--1--4.jpg&amp;w=2048&amp;q=75 2048w, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F633b0878de60e629f6838d66_time_series_968x664--1--4.jpg&amp;w=3840&amp;q=75 3840w" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F633b0878de60e629f6838d66_time_series_968x664--1--4.jpg&amp;w=3840&amp;q=75"/><div class="relative flex flex-col justify-between flex-1 p-5 lg:p-6"><div><div class="flex flex-wrap gap-2 mb-3"><a class="relative z-20 text-body-4-regular whitespace-nowrap bg-bg-02 text-text-default border border-border-02 rounded-pill px-2 py-px" href="/blog-categories/product">Product</a></div><div class="mt-3 text-mobile-body-1-semibold lg:text-body-1-semibold">You can now explore and analyze time series data in Tinybird</div></div><div class="flex justify-between gap-2"><a class="z-20 flex mt-6 md:mt-8" href="/authors/mariana-racasan"><img alt="" loading="lazy" width="40" height="40" decoding="async" data-nimg="1" class="w-10 h-10 me-3 rounded-full" style="color:transparent" srcset="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6310d3d347635877cd5f50fc_mariana-racasan.jpg&amp;w=48&amp;q=75 1x, /_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6310d3d347635877cd5f50fc_mariana-racasan.jpg&amp;w=96&amp;q=75 2x" src="/_next/image?url=https%3A%2F%2Ftinybird-blog.ghost.io%2Fcontent%2Fimages%2F2023%2F09%2F6310d3d347635877cd5f50fc_mariana-racasan.jpg&amp;w=96&amp;q=75"/><div><p class="text-mobile-body-3-semibold md:text-body-3-semibold">Mariana Racasan</p><p class="-mt-1 text-body-4-regular text-text-01">Product Marketing Lead</p></div></a><div class="mt-3 flex flex-col-reverse text-body-4-regular text-end text-text-01">Oct 04, 2022</div></div></div></div></div></div><div class="swiper-button-prev"/><div class="swiper-button-next"/><div class="swiper-pagination"/></div></div></div><div class="relative w-full pt-8 pb-2 md:pt-24 bg-bg-darkest text-white z-20"><div class="grid grid-cols-4 gap-x-5 w-full px-5 mx-auto max-w-7xl md:grid-cols-12 md:gap-x-6 md:px-6 lg:gap-x-8 lg:px-8"><div class="col-span-full border border-brand rounded-asset overflow-hidden"><div class=" flex flex-col justify-between pt-8 ps-8 rounded-asset bg-bg-darkest bg-[radial-gradient(60%_32%_at_50%_100%,#22CD8C_0%,#161724_100%)] md:bg-[radial-gradient(65%_135%_at_107%_100%,#22CD8C_0%,#161724_100%)] md:gap-6 md:grid md:grid-cols-12 md:gap-x-6 lg:gap-x-8 xl:pt-16 xl:pl-0 "><div class="pe-8 md:col-span-5 md:pb-6 md:pe-0 md:flex md:flex-col md:justify-center lg:col-span-4 lg:col-start-2 lg:pb-16 lg:pt-6"><h3 class="text-mobile-h3 lg:text-h3">Build fast data <br class="hidden lg:block"/>products, faster.</h3><div class="mt-4 text-text-02 text-mobile-body-2-regular lg:mt-5 lg:text-body-2-regular">Try Tinybird and bring your data sources together and enable engineers to build with data in minutes. No credit card required, free to get started.</div><div class="flex items-center gap-6 mt-6 lg:mt-8"><a class="py-2 px-4 lg:py-3 lg:px-[23px] UI-Button UI-Button--solid UI-Button--primary UI-Button--large UI-Button--link" href="https://app.tinybird.co/signup"><span class="UI-Button-inner">Start building</span></a><a class="relative text-button text-white pb-1 custom-border-b-gradient-inverse" href="/contact-us">Request a demo</a></div></div><div class="flex items-end justify-end flex-1 md:col-span-6 md:col-start-7"><img alt="" loading="lazy" width="1184" height="768" decoding="async" data-nimg="1" class="hidden w-full md:inline-block rounded-br-asset" style="color:transparent" srcset="/_next/image?url=%2F_next%2Fstatic%2Fmedia%2Fasset.c78425e7.png&amp;w=1200&amp;q=75 1x, /_next/image?url=%2F_next%2Fstatic%2Fmedia%2Fasset.c78425e7.png&amp;w=3840&amp;q=75 2x" src="/_next/image?url=%2F_next%2Fstatic%2Fmedia%2Fasset.c78425e7.png&amp;w=3840&amp;q=75"/><img alt="" loading="lazy" width="606" height="450" decoding="async" data-nimg="1" class="w-full max-w-[306px] mt-6 md:hidden" style="color:transparent" srcset="/_next/image?url=%2F_next%2Fstatic%2Fmedia%2FassetMobile.930fcd6a.png&amp;w=640&amp;q=75 1x, /_next/image?url=%2F_next%2Fstatic%2Fmedia%2FassetMobile.930fcd6a.png&amp;w=1920&amp;q=75 2x" src="/_next/image?url=%2F_next%2Fstatic%2Fmedia%2FassetMobile.930fcd6a.png&amp;w=1920&amp;q=75"/></div></div></div><div class="mt-6 lg:mt-8 text-body-4-regular col-span-full text-text-02 md:text-end">Need more? <a class="relative text-brand after:absolute after:bottom-0 after:left-0 after:w-full after:h-px after:bg-brand" href="/contact-us">Contact sales</a> for Enterprise support.</div></div></div><div class="relative w-full bg-bg-darkest text-text-02 text-body-3-regular z-20"><div class="w-full px-5 mx-auto max-w-7xl md:px-6 lg:px-8 py-8 md:py-24"><div class="grid flex-wrap grid-cols-12 mb-8 md:mb-16 gap-x-5 gap-y-6 md:gap-8"><div class="col-span-12 lg:col-span-3"><img alt="Logo Tinybird" loading="lazy" width="109" height="26" decoding="async" data-nimg="1" class="max-md:w-30" style="color:transparent" src="/_next/static/media/logo.2763d05b.svg"/><div class="text-text-02 flex flex-wrap lg:flex-col gap-y-4 gap-x-6 max-lg:hidden mt-14"><p class="flex-auto">Spain<br/>Calle del Dr. Fourquet, 27<br/>28012 Madrid</p><p class="flex-auto">USA<br/>41 East 11th Street 11th floor<br/>New York, NY 10003</p></div></div><div class="flex flex-col col-span-6 sm:col-span-6 md:col-span-3 lg:col-span-2"><h4 class="mb-3 md:mb-5 text-white font-semibold">Company</h4><a class="transition-colors hover:text-white" href="/product">Product</a><a class="transition-colors hover:text-white mt-3" href="/pricing">Pricing</a><a class="transition-colors hover:text-white mt-3" href="/roi">ROI Calculator</a><a class="transition-colors hover:text-white mt-3" href="/security">Security</a><a class="transition-colors hover:text-white mt-3" href="/about">About Us</a><a class="transition-colors hover:text-white mt-3" href="https://shop.tinybird.co/">Shop</a><a class="transition-colors hover:text-white mt-3" href="/about#join-us">Careers</a><a class="transition-colors hover:text-white mt-3" href="/contact-us">Request a demo</a></div><div class="flex flex-col col-span-6 sm:col-span-6 md:col-span-3 lg:col-span-2"><h4 class="mb-3 md:mb-5 text-white font-semibold">Resources</h4><a class="transition-colors hover:text-white" href="/docs">Docs</a><a class="transition-colors hover:text-white mt-3" href="/blog">Blog</a><a class="transition-colors hover:text-white mt-3" href="/docs/community">Community</a><a class="transition-colors hover:text-white mt-3" href="/docs/live">Live Coding</a><a class="transition-colors hover:text-white mt-3" href="/customer-stories">Customer Stories</a><a class="transition-colors hover:text-white mt-3" href="/startups">Tinybird for Startups</a><a class="transition-colors hover:text-white mt-3" href="/blog-posts/rss.xml">RSS Feed</a></div><div class="flex flex-col col-span-6 sm:col-span-6 md:col-span-3 lg:col-span-2"><h4 class="mb-3 md:mb-5 text-white font-semibold">Integrations</h4><a class="transition-colors hover:text-white" href="/integrations/amazon-s3">Amazon S3</a><a class="transition-colors hover:text-white mt-3" href="/integrations/kafka-data">Kafka Data Streams</a><a class="transition-colors hover:text-white mt-3" href="/integrations/google-cloud-storage">Google Cloud Storage</a><a class="transition-colors hover:text-white mt-3" href="/integrations/google-bigquery">Google BigQuery</a><a class="transition-colors hover:text-white mt-3" href="/integrations/snowflake">Snowflake</a><a class="transition-colors hover:text-white mt-3" href="/integrations/confluent">Confluent</a></div><div class="flex flex-col col-span-6 sm:col-span-6 md:col-span-3"><a class="hover:opacity-80" href="/use-cases"><h4 class="mb-3 md:mb-5 text-white font-semibold">Use Cases</h4></a><a class="transition-colors hover:text-white" href="/use-cases/in-product-analytics">In-Product Analytics</a><a class="transition-colors hover:text-white mt-3" href="/use-cases/operational-analytics">Operational Intelligence</a><a class="transition-colors hover:text-white mt-3" href="/use-cases/realtime-personalization">Realtime Personalization</a><a class="transition-colors hover:text-white mt-3" href="/use-cases/anomaly-detection-alerts">Anomaly Detection &amp; Alerts</a><a class="transition-colors hover:text-white mt-3" href="/use-cases/usage-based-pricing">Usage Based Pricing</a><a class="transition-colors hover:text-white mt-3" href="/use-cases/sports-betting-gaming">Sports Betting/Gaming</a><a class="transition-colors hover:text-white mt-3" href="/use-cases/smart-inventory-management">Smart Inventory Management</a><a class="transition-colors hover:text-white mt-3" href="/clickhouse">Managed ClickHouse</a></div></div><div class="grid grid-cols-1 mb-8 gap-y-6 gap-x-5 sm:grid-cols-2 md:gap-x-8 lg:grid-cols-12 lg:mb-0 lg:items-center"><div class="lg:col-span-3"><a href="https://status.tinybird.co" target="_blank" class="inline-block" rel="noopener noreferrer"><div class="flex items-center justify-between w-full px-4 py-[10px] text-body-4-regular transition-colors duration-300 rounded-md text-white bg-white bg-opacity-10 hover:bg-opacity-20"><div class="flex items-center"><div class="relative flex w-[1.125rem] overflow-hidden"><div class="flex" style="transform:translateX(0px)"><div class="flex-none w-[0.125rem] h-3 mx-px rounded-sm bg-[#f8ac49]"/><div class="flex-none w-[0.125rem] h-3 mx-px rounded-sm bg-[#f8ac49]"/><div class="flex-none w-[0.125rem] h-3 mx-px rounded-sm bg-[#f8ac49]"/><div class="flex-none w-[0.125rem] h-3 mx-px rounded-sm bg-[#f8ac49]"/><div class="flex-none w-[0.125rem] h-3 mx-px rounded-sm bg-[#f8ac49]"/></div><div class="absolute left-0 w-1 h-3 bg-uptime-widget-gradient-dark-left"/><div class="absolute right-0 w-1 h-3 bg-uptime-widget-gradient-dark-right"/></div><div class="ml-2 font-semibold">Some outages detected</div></div></div></a></div><div class="flex lg:col-span-3 lg:order-3 lg:justify-end"><a href="https://twitter.com/@tinybirdco" class="flex justify-center w-10 h-10 mr-4 rounded-md items-center bg-white bg-opacity-10 hover:bg-opacity-20 lg:mr-0 lg:ml-4" target="_blank" rel="noopener noreferrer"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24" width="20" height="20" class="inline"><path d="M23.953 4.573c-.898.395-1.85.656-2.825.774a4.957 4.957 0 0 0 2.163-2.722c-.951.555-2.005.96-3.127 1.184a4.92 4.92 0 0 0-8.384 4.48C7.69 8.097 4.067 6.132 1.64 3.165A4.82 4.82 0 0 0 .974 5.64c0 1.71.87 3.212 2.188 4.095a4.905 4.905 0 0 1-2.228-.616v.06a4.92 4.92 0 0 0 3.946 4.826 4.998 4.998 0 0 1-2.212.085 4.934 4.934 0 0 0 4.604 3.415A9.87 9.87 0 0 1 1.17 19.61c-.39 0-.779-.023-1.17-.067a13.998 13.998 0 0 0 7.557 2.208c9.053 0 13.998-7.493 13.998-13.98 0-.21 0-.42-.015-.63A9.933 9.933 0 0 0 24 4.593l-.047-.02Z" fill="currentColor"/></svg></a><a href="https://www.linkedin.com/company/tinybird-co/" class="flex justify-center w-10 h-10 mr-4 rounded-md items-center bg-white bg-opacity-10 hover:bg-opacity-20 lg:mr-0 lg:ml-4" target="_blank" rel="noopener noreferrer"><svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 24 24" width="20" height="20" class="inline"><g clip-path="url(#linkedIn_svg__a)"><path d="M20.447 20.452h-3.554v-5.569c0-1.328-.027-3.037-1.852-3.037-1.853 0-2.136 1.445-2.136 2.939v5.667H9.351V9h3.414v1.561h.046c.477-.9 1.637-1.85 3.37-1.85 3.601 0 4.267 2.37 4.267 5.455v6.286h-.001ZM5.337 7.433a2.062 2.062 0 0 1-2.063-2.065 2.064 2.064 0 1 1 2.063 2.065Zm1.782 13.019H3.555V9h3.564v11.452ZM22.225 0H1.771C.792 0 0 .774 0 1.729v20.542C0 23.227.792 24 1.771 24h20.451C23.2 24 24 23.227 24 22.271V1.729C24 .774 23.2 0 22.222 0h.003Z" fill="currentColor"/></g><defs><clippath id="linkedIn_svg__a"><path fill="#fff" d="M0 0h24v24H0z"/></clippath></defs></svg></a><a href="/docs/community" class="flex justify-center w-10 h-10 mr-4 rounded-md items-center bg-white bg-opacity-10 hover:bg-opacity-20 lg:mr-0 lg:ml-4" target="_blank" rel="noopener noreferrer"><svg width="20" height="20" viewbox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg" class="inline"><g clip-path="url(#slack_svg__a)" fill="#fff"><path d="M4.201 12.64c0 1.156-.944 2.1-2.1 2.1C.943 14.74 0 13.797 0 12.64c0-1.156.944-2.1 2.1-2.1h2.101v2.1ZM5.26 12.638c0-1.156.944-2.1 2.1-2.1 1.157 0 2.101.944 2.101 2.1v5.26c0 1.157-.944 2.101-2.1 2.101-1.157 0-2.101-.944-2.101-2.1v-5.261ZM7.36 4.202c-1.156 0-2.1-.945-2.1-2.101C5.26.945 6.204 0 7.36 0c1.157 0 2.101.945 2.101 2.1v2.102h-2.1ZM7.36 5.262c1.157 0 2.102.944 2.102 2.1 0 1.157-.945 2.101-2.101 2.101H2.1C.943 9.463 0 8.52 0 7.363c0-1.157.944-2.101 2.1-2.101h5.26ZM15.797 7.363c0-1.157.944-2.101 2.1-2.101 1.157 0 2.101.944 2.101 2.1 0 1.157-.944 2.101-2.1 2.101h-2.101v-2.1ZM14.738 7.361c0 1.156-.944 2.101-2.1 2.101-1.157 0-2.101-.945-2.101-2.1V2.1c0-1.156.944-2.101 2.1-2.101 1.157 0 2.101.945 2.101 2.1v5.261ZM12.637 15.797c1.156 0 2.1.944 2.1 2.1 0 1.157-.944 2.102-2.1 2.102-1.156 0-2.1-.945-2.1-2.101v-2.101h2.1ZM12.638 14.739c-1.156 0-2.1-.945-2.1-2.101 0-1.156.944-2.1 2.1-2.1h5.26c1.157 0 2.101.944 2.101 2.1 0 1.156-.944 2.1-2.1 2.1h-5.261Z"/></g><defs><clippath id="slack_svg__a"><path fill="#fff" d="M0 0h20v20H0z"/></clippath></defs></svg></a><a href="https://instagram.com/tinybird_co" class="flex justify-center w-10 h-10 mr-4 rounded-md items-center bg-white bg-opacity-10 hover:bg-opacity-20 lg:mr-0 lg:ml-4" target="_blank" rel="noopener noreferrer"><svg width="20" height="20" viewbox="0 0 394 394" fill="none" xmlns="http://www.w3.org/2000/svg" class="inline"><path d="M196.963.086c-53.486 0-60.198.234-81.205 1.19-20.966.96-35.277 4.28-47.799 9.15-12.953 5.03-23.94 11.758-34.887 22.709-10.955 10.947-17.683 21.934-22.73 34.883-4.882 12.526-8.206 26.841-9.15 47.799C.258 136.824.012 143.54.012 197.026c0 53.485.238 60.177 1.19 81.184.964 20.966 4.283 35.277 9.15 47.799 5.034 12.953 11.762 23.94 22.713 34.887 10.943 10.955 21.93 17.7 34.875 22.73 12.53 4.87 26.845 8.19 47.807 9.15 21.007.956 27.715 1.189 81.197 1.189 53.489 0 60.181-.233 81.188-1.189 20.966-.96 35.293-4.28 47.823-9.15 12.949-5.03 23.92-11.775 34.863-22.73 10.955-10.947 17.683-21.934 22.73-34.883 4.841-12.526 8.165-26.841 9.15-47.799.943-21.007 1.189-27.703 1.189-81.188 0-53.486-.246-60.198-1.189-81.205-.985-20.966-4.309-35.277-9.15-47.8-5.047-12.952-11.775-23.94-22.73-34.886-10.955-10.955-21.91-17.684-34.875-22.71-12.555-4.87-26.874-8.19-47.84-9.15C257.095.32 250.408.086 196.906.086h.057Zm-17.667 35.49c5.243-.008 11.094 0 17.667 0 52.583 0 58.815.189 79.58 1.133 19.202.877 29.623 4.086 36.565 6.782 9.191 3.57 15.743 7.836 22.632 14.73 6.893 6.892 11.16 13.457 14.738 22.647 2.695 6.934 5.908 17.356 6.782 36.557.943 20.761 1.149 26.997 1.149 79.556 0 52.558-.206 58.794-1.149 79.555-.878 19.202-4.087 29.623-6.782 36.557-3.57 9.19-7.845 15.735-14.738 22.623-6.893 6.893-13.437 11.16-22.632 14.73-6.934 2.708-17.363 5.908-36.565 6.786-20.761.944-26.997 1.149-79.58 1.149-52.587 0-58.819-.205-79.58-1.149-19.202-.886-29.623-4.095-36.57-6.79-9.19-3.57-15.755-7.837-22.647-14.73-6.893-6.893-11.16-13.441-14.738-22.635-2.696-6.934-5.908-17.356-6.782-36.557-.944-20.761-1.133-26.998-1.133-79.589 0-52.591.19-58.794 1.133-79.555.878-19.202 4.086-29.623 6.782-36.565 3.57-9.19 7.845-15.756 14.738-22.648 6.892-6.893 13.457-11.16 22.648-14.738 6.942-2.708 17.367-5.908 36.569-6.79 18.168-.82 25.208-1.067 61.913-1.108v.05Zm122.792 32.7a23.635 23.635 0 0 0-23.178 28.247 23.63 23.63 0 0 0 32.227 17.218 23.635 23.635 0 0 0 14.584-21.84c0-13.047-10.586-23.633-23.633-23.633v.008ZM196.963 95.89c-55.853 0-101.137 45.284-101.137 101.137s45.284 101.116 101.137 101.116 101.125-45.263 101.125-101.116S252.816 95.889 196.963 95.889Zm0 35.49c36.253 0 65.647 29.389 65.647 65.647 0 36.253-29.394 65.646-65.647 65.646-36.257 0-65.647-29.393-65.647-65.646 0-36.258 29.39-65.647 65.647-65.647Z" fill="#fff"/></svg></a></div><div class="font-mono text-mobile-body-3-regular sm:col-span-2 lg:col-span-6 lg:order-2"><p>Copyright © 2024 Tinybird. All rights reserved</p><div class="flex flex-wrap underline underline-offset-2"><a href="/terms-and-conditions" class="mr-4 hover:text-white">Terms &amp; conditions</a><a href="/privacy#cookies" class="mr-4 hover:text-white">Cookies</a><a href="https://trust.tinybird.co/" class="mr-4 hover:text-white" target="_blank" rel="noopener noreferrer">Trust Center</a><a href="https://tinybird.factorialhr.co/complaints" class="mr-4 hover:text-white" target="_blank" rel="noopener noreferrer">Compliance Helpline</a></div></div></div><div class="text-text-02 flex flex-wrap lg:flex-col gap-y-4 gap-x-6 border-t border-border-03 pt-6 lg:hidden"><p class="flex-auto">Spain<br/>Calle del Dr. Fourquet, 27<br/>28012 Madrid</p><p class="flex-auto">USA<br/>41 East 11th Street 11th floor<br/>New York, NY 10003</p></div></div></div></div></body>