Data Engineering Podcast

MarketStore: Managing Timeseries Financial Data with Hitoshi Harada and Christopher Ryan - Episode 24

Listen Later
Summary

The data that is used in financial markets is time oriented and multidimensional, which makes it difficult to manage in either relational or timeseries databases. To make this information more manageable the team at Alapaca built a new data store specifically for retrieving and analyzing data generated by trading markets. In this episode Hitoshi Harada, the CTO of Alapaca, and Christopher Ryan, their lead software engineer, explain their motivation for building MarketStore, how it operates, and how it has helped to simplify their development workflows.

Preamble
  • Hello and welcome to the Data Engineering Podcast, the show about modern data management
  • When you’re ready to build your next pipeline you’ll need somewhere to deploy it, so check out Linode. With private networking, shared block storage, node balancers, and a 40Gbit network, all controlled by a brand new API you’ve got everything you need to run a bullet-proof data platform. Go to dataengineeringpodcast.com/linode to get a $20 credit and launch a new server in under a minute.
  • For complete visibility into the health of your pipeline, including deployment tracking, and powerful alerting driven by machine-learning, DataDog has got you covered. With their monitoring, metrics, and log collection agent, including extensive integrations and distributed tracing, you’ll have everything you need to find and fix performance bottlenecks in no time. Go to dataengineeringpodcast.com/datadog today to start your free 14 day trial and get a sweet new T-Shirt.
  • Go to dataengineeringpodcast.com to subscribe to the show, sign up for the newsletter, read the show notes, and get in touch.
  • Your host is Tobias Macey and today I’m interviewing Christopher Ryan and Hitoshi Harada about MarketStore, a storage server for large volumes of financial timeseries data
    • Interview
    • Introduction
    • How did you get involved in the area of data management?
    • What was your motivation for creating MarketStore?
    • What are the characteristics of financial time series data that make it challenging to manage?
    • What are some of the workflows that MarketStore is used for at Alpaca and how were they managed before it was available?
    • With MarketStore’s data coming from multiple third party services, how are you managing to keep the DB up-to-date and in sync with those services?
      • What is the worst case scenario if there is a total failure in the data store?
      • What guards have you built to prevent such a situation from occurring?


      • Since MarketStore is used for querying and analyzing data having to do with financial markets and there are potentially large quantities of money being staked on the results of that analysis, how do you ensure that the operations being performed in MarketStore are accurate and repeatable?

      • What were the most challenging aspects of building MarketStore and integrating it into the rest of your systems?

      • Motivation for open sourcing the code?

      • What is the next planned major feature for MarketStore, and what use-case is it aiming to support?

        • Contact Info
        • Christopher
          • Email


          • Hitoshi

            • Email


              • Parting Question
              • From your perspective, what is the biggest gap in the tooling or technology for data management today?
                • Links
                • MarketStore
                  • GitHub
                  • Release Announcement


                  • Alpaca

                  • IBM

                  • DB2

                  • GreenPlum

                  • Algorithmic Trading

                  • Backtesting

                  • OHLC (Open-High-Low-Close)

                  • HDF5

                  • Golang

                  • C++

                  • Timeseries Database List

                  • InfluxDB

                  • JSONRPC

                  • Slait

                  • CircleCI

                  • GDAX

                    • The intro and outro music is from The Hug by The Freak Fandango Orchestra / CC BY-SA

                    Support Data Engineering Podcast

                    ...more
                    View all episodesView all episodes
                    Download on the App Store
                    Data Engineering PodcastBy Tobias Macey
                    • 4.6
                    • 4.6
                    • 4.6
                    • 4.6
                    • 4.6

                    4.6

                    135 ratings

                    More shows like Data Engineering Podcast

                    View all
                    Software Engineering Radio - the podcast for professional software developers by se-radio@computer.org

                    Software Engineering Radio - the podcast for professional software developers

                    272 Listeners

                    The Changelog: Software Development, Open Source by Changelog Media

                    The Changelog: Software Development, Open Source

                    283 Listeners

                    The Cloudcast by Massive Studios

                    The Cloudcast

                    153 Listeners

                    Thoughtworks Technology Podcast by Thoughtworks

                    Thoughtworks Technology Podcast

                    41 Listeners

                    Data Skeptic by Kyle Polich

                    Data Skeptic

                    483 Listeners

                    Talk Python To Me by Michael Kennedy

                    Talk Python To Me

                    592 Listeners

                    Software Engineering Daily by Software Engineering Daily

                    Software Engineering Daily

                    624 Listeners

                    The TWIML AI Podcast (formerly This Week in Machine Learning & Artificial Intelligence) by Sam Charrington

                    The TWIML AI Podcast (formerly This Week in Machine Learning & Artificial Intelligence)

                    444 Listeners

                    Super Data Science: ML & AI Podcast with Jon Krohn by Jon Krohn

                    Super Data Science: ML & AI Podcast with Jon Krohn

                    298 Listeners

                    Python Bytes by Michael Kennedy and Brian Okken

                    Python Bytes

                    213 Listeners

                    DataFramed by DataCamp

                    DataFramed

                    266 Listeners

                    Practical AI by Practical AI LLC

                    Practical AI

                    190 Listeners

                    The Stack Overflow Podcast by The Stack Overflow Podcast

                    The Stack Overflow Podcast

                    64 Listeners

                    The Real Python Podcast by Real Python

                    The Real Python Podcast

                    140 Listeners

                    Latent Space: The AI Engineer Podcast by swyx + Alessio

                    Latent Space: The AI Engineer Podcast

                    77 Listeners