How to Analyze Cryptocurrency Market Data using TimescaleDB, PostgreSQL and Tableau: a Step-by-Step Tutorial

This tutorial guides you through creating a cryptocurrency market dataset using Python, CryptoCompare API, and PostgreSQL. The steps covered include setting up a TimescaleDB instance in the cloud, defining a schema for cryptocurrency data, fetching historical prices of Bitcoin (BTC) and Ethereum (ETH), loading the data into TimescaleDB, querying the data using SQL, and visualizing the results with Tableau. The final dataset can be used to analyze various aspects of the cryptocurrency market such as price trends, trading volumes, and more.