Skip to main content
This tutorial shows you how to ingest real-time time-series data into TimescaleDB using a websocket connection. The tutorial sets up a data pipeline to ingest real-time data from our data partner, Twelve Data. Twelve Data provides a number of different financial APIs, including stock, cryptocurrencies, foreign exchanges, and ETFs. It also supports websocket connections in case you want to update your database frequently. With websockets, you need to connect to the server, subscribe to symbols, and you can start receiving data in real-time during market hours. When you complete this tutorial, you’ll have a data pipeline set up that ingests real-time financial data into your . This tutorial uses Python and the API wrapper library provided by Twelve Data.

​
Prerequisites

Before you begin, make sure you have:
  • Signed up for a free .
  • Downloaded the file that contains your credentials such as <HOST>, <PORT>, and <PASSWORD>. Alternatively, you can find these details in the Connection Info section for your service.
  • Installed Python 3
  • Signed up for Twelve Data. The free tier is perfect for this tutorial.
  • Made a note of your Twelve Data API key.