Скачать или смотреть How to Analyze Financial Data With TimescaleDB | Episode #2: Hierarchical Continuous Aggregates

Timescale Community Templates is a webinar series dedicated to specific industries and designed to foster collaboration and expertise exchange. Join us for a live session with Timescale's Developer Advocate, Jônatas Paganini, as we deep-dive into the world of hierarchical continuous aggregates (an advanced version of Postgres materialized views) for finance market data.

In this session, we'll explore the intricacies of rolling up candlesticks across multiple timeframes and creating efficient processing pipelines powered by PostgreSQL. Discover the significance of hierarchy dimensions, the role of data density, optimal chunk sizing strategies, and the advantages of data compression. Jônatas will expertly guide you through the materialization engine, highlighting the crucial aspects of backfills during refresh cycles and their impact on your data.

Further, we'll examine how watermarks can be utilized to optimize the minimal window needed for refreshes, alongside an insightful comparison between materialized-only and real-time data processing options. Whether you're a financial analyst, a database engineer, or simply keen on the latest in database technology, this webinar is designed to provide valuable insights into improving your processing pipelines for financial market data.

🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌More on Timescale Community Templates ⇒ https://tsdb.co/templates-blog
📌 GitHub Templates ⇒ https://github.com/timescale/templates
📌 Office Hours ⇒ https://tsdb.co/officehours

📹 Other Finance Sessions
✨ Episode 1 - Framework Walkthrough ⇒    • How to Analyze Financial Data With Timesca...  
✨ Episode 2 - Hierarchical Continuous Aggregates ⇒ (current)
✨ Episode 3 - Tracking the last price and the trigger side effects ⇒    • How to Analyze Financial Data With Timesca...  
✨ Episode 4 - Tracking pair correlation ⇒    • How to Analyze Financial Data With Timesca...  
✨ Episode 5 - Downsampling Techniques ⇒    • How to Analyze Financial Data With Timesca...  
✨ Episode 6 - Compression and Eide Effects ⇒    • How to Analyze Financial Data With Timesca...  

🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
Timescale is a mature, PostgreSQL cloud, specialized for demanding workloads like time series, events, analytics, vectors, and AI. Timescale is dedicated to serving software developers and businesses worldwide, enabling them to build the next wave of computing.

💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!
🔍 Website ⇒ https://tsdb.co/website
🔍 Slack ⇒ https://slack.timescale.com (#finance-market-data-discussion)
🔍 GitHub ⇒ https://github.com/timescale
🔍 Twitter ⇒   / timescaledb  
🔍 LinkedIn ⇒   / timescaledb  
🔍 Timescale Blog ⇒ https://tsdb.co/blogs
🔍 Timescale Documentation ⇒ https://tsdb.co/doc


📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀
⏱ 0:00 ⇒ Introduction
⏱ 2:54 ⇒ Market Data Stream
⏱ 3:58 ⇒ Hierarchical Continuous Aggregation Overview
⏱ 4:45 ⇒ Part 1: Interval & Granularity
⏱ 6:52 ⇒ Part 2: Watermarks
⏱ 19:02 ⇒ Part 3: Invalidation Logs
⏱ 21:57 ⇒ Part 4: Materialized only strategies
⏱ 23:39 ⇒ Part 5: Toolkit Aggregations
⏱ 27:32 ⇒ Part 5: Retention Policies
⏱ 28:54 ⇒ Part 6: Compression Policies
⏱ 31:28⇒ Q&A
⏱ 50:53 ⇒ Outro