How to Analyze Cryptocurrency Market Data using TimescaleDB, PostgreSQL and Tableau: a Step-by-Step Tutorial
What's this blog post about?
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.
Company
Timescale
Date published
Jan. 4, 2024
Author(s)
Avthar Sewrathan
Word count
4234
Hacker News points
None found.
Language
English