Analyze historical intraday stock data

This tutorial is a step-by-step guide on how to collect, store, and analyze intraday stock data with TimescaleDB.

This tutorial has a few main steps:

  1. Design database schema

    You will create a table that will be capable of storing 1-min candlestick data.

  2. Fetch and ingest stock data

    You will learn how to fetch data from the Alpha Vantage API and ingest it into the database in a fast manner.

  3. Explore stock market data

    After all the plumbing work is done, you will see several ways to explore stock price points, lows and highs, price changes over time, symbols with the most daily gains, candlestick charts, and more!

Prerequisites

Get started: create a virtual environment

It’s recommended to create a new Python virtual environment to isolate the packages used throughout this tutorial.

  1. mkdir intraday-stock-analysis
  2. cd intraday-stock-analysis
  3. virtualenv env
  4. source env/bin/activate