How to Analyze Financial Data With TimescaleDB | Episode 5: Downsampling Techniques
Timescale Community Templates is a webinar series dedicated to specific industries and designed to foster collaboration and expertise exchange. Join Timescale’s Developer Advocate, Jônatas Paganini for an in-depth conversation on downsampling techniques and query performance.
🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 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 ⇒ • How to Analyze Financial Data With Timesca...
✨ 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 (current)
✨ 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
⏱ 1:45 ⇒ Market data stream
⏱ 2:38 ⇒ Part 1: Methodology
⏱ 3:!7 ⇒ Part 2: Advantages
⏱ 6:52 ⇒ Part 3: Disadvantages
⏱ 7:46 ⇒ Part 4: What if I cannot downsample? (Tiered Storage and Timescale Cloud)
⏱ 16:36 ⇒ Part 5: Demo
⏱ 18:39 ⇒ Part 6: Downsampling functions
⏱ 19:05 ⇒ Part 7: Other strategies
⏱ 20:40 ⇒ Q&A + Outro