To analyze financial data, you can chart the open, high, low, close, and volume (OHLCV) information for a financial asset. Using this data, you can create candlestick charts that make it easier to analyze the price changes of financial assets over time. You can use candlestick charts to examine trends in stock, cryptocurrency, or NFT prices.

In this tutorial, you use real raw financial data provided by Twelve Data, create an aggregated candlestick view, query the aggregated data, and visualize the data in Grafana.

Before you begin, make sure you have:

Run all tutorials free

Your Timescale trial is completely free for you to use for the first thirty days. This gives you enough time to complete all the tutorials and run a few test projects of your own.

Try for free

This tutorial covers:

  1. Set up up your dataset: Load data from Twelve Data into your TimescaleDB database.
  2. Query your dataset: Create candlestick views, query the aggregated data, and visualize the data in Grafana.

The financial sector regularly uses candlestick charts to visualize the price change of an asset. Each candlestick represents a time period, such as one minute or one hour, and shows how the asset's price changed during that time.

Candlestick charts are generated from the open, high, low, close, and volume data for each financial asset during the time period. This is often abbreviated as OHLCV:

  • Open: opening price
  • High: highest price
  • Low: lowest price
  • Close: closing price
  • Volume: volume of transactions


TimescaleDB is well suited to storing and analyzing financial candlestick data, and many Timescale community members use it for exactly this purpose. Check out these stories from some Timescale community members:


Found an issue on this page?

Report an issue!