How to Analyze Financial Data With TimescaleDB | Episode #1: Framework Walkthrough

Timescale Community Templates is a webinar series dedicated to specific industries and designed to foster collaboration and expertise exchange. In this pilot episode, dedicated to finance, Jônatas Paganini, developer advocate at Timescale, will take us on a deep dive into the suggested schema of the finance framework. The goal is to provide guidance to anyone looking to build a scalable database for finance market data, whether you’re processing financial transactions, managing trading systems (including cryptocurrency), or leveraging time-series analysis to examine financial records.

To provide practical examples, we use PostgreSQL and TimescaleDB, our supercharged PostgreSQL for demanding workloads. This detailed exploration covers crucial parameters such as chunk size and compression settings, and we provide a step-by-step guide on constructing hierarchical continuous aggregates (an advanced version of Postgres materialized views). Tune in to discover how you can leverage the data definition language of the finance framework to optimize your financial data management and analysis.

🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌More on Timescale Community Templates ⇒
📌 GitHub Templates ⇒
📌 Office Hours ⇒

📹 Other Finance Sessions
✨ Episode 1 – Framework Walkthrough (current)
✨ Episode 2 – Hierarchical Continuous Aggregates ⇒
✨ Episode 3 – Tracking the last price and the trigger side effects ⇒
✨ Episode 4 – Tracking pair correlation (coming soon)
✨ Episode 5 – Downsampling Techniques (coming soon)
✨ Episode 6 – Compression and Eide Effects (coming soon)

🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
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 ⇒
🔍 Slack ⇒ (#finance-market-data-discussion)
🔍 GitHub ⇒
🔍 Twitter ⇒
🔍 LinkedIn ⇒
🔍 Timescale Blog ⇒
🔍 Timescale Documentation ⇒

📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀
⏱ 0:00 ⇒ Introduction
⏱ 7:15 ⇒ Part 1: Table structure
⏱ 8:16 ⇒ Part 2: Chunk time interval
⏱ 16:25 ⇒ Part 3: Compression
⏱ 10:10 ⇒ Part 4: Compression Policies
⏱ 21:30 ⇒ Part 5: Hierarchical Continuous Aggregates
⏱ 26:47 ⇒ What else?
⏱ 31:23 ⇒ Coming Soon: Hierarchical Continuous Aggregation
⏱ 33:10 ⇒ Outro

[ad_2]

source