index.md

title	excerpt	products	keywords	tags	layout_components	content_group
Ingest real-time financial data using WebSocket	Ingest time-series data into Timescale Cloud using a websocket connection	cloud	finance analytics websockets data pipeline	tutorials intermediate	next_prev_large	Ingest real-time financial websocket data

import CandlestickIntro from "versionContent/_partials/_candlestick_intro.mdx"; import FinancialIndustry from "versionContent/_partials/_financial-industry-data-analysis.mdx";

Ingest real-time financial data using WebSocket

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 Timescale.

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 Timescale account.
• 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.

Steps in this tutorial

This tutorial covers:

1. Setting up your dataset: Load data from Twelve Data into your TimescaleDB database.

2. Querying your dataset: Create candlestick views, query the aggregated data, and visualize the data in Grafana.

   This tutorial shows you how to ingest real-time time-series data into a Timescale database using a websocket connection. To create candlestick views, query the aggregated data, and visualize the data in Grafana.

About OHLCV data and candlestick charts

TimescaleDB is well suited to storing and analyzing financial candlestick data, and many Timescale community members use it for exactly this purpose.