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 create a table that is capable of storing 1-min candlestick data.

  2. Fetch and ingest stock data

    You 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 can 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!


Get started: create a virtual environment

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

mkdir intraday-stock-analysis
cd intraday-stock-analysis
virtualenv env
source env/bin/activate

Install Pandas within the virtual environment:

pip install pandas

Found an issue on this page?

Report an issue!


Related Content