Real Time Crypto Dashboard

Created2025-07-24|Updated2025-08-12|Showcase

|Post Views:

💹 Real-Time Crypto Dashboard

Live Bitcoin & Ethereum tracking with predictions

“Watch crypto markets move in real time — and see tomorrow’s trend today.”

📎 Demo Video:

📌 One-Line Summary

A live dashboard that tracks Bitcoin (BTC) and Ethereum (ETH) prices in real time, predicts short-term trends, and displays everything visually.
Built entirely with open-source tools on AWS.

1️⃣ How It Works

Data Flow:
Live Prices → Kafka (data streaming) → PostgreSQL (storage) → Grafana (dashboard)

1. Live Price Collection

Uses the CryptoCompare API to fetch BTC and ETH prices
Updates every 5 seconds
Includes both current market prices and short-term history

2. Real-Time Streaming

Apache Kafka moves live data instantly from the producer (data collector) to the consumer (data inserter)
Ensures zero delays between data collection and dashboard updates

3. Database Storage

PostgreSQL stores:
- Current prices
- Predicted prices (using a Simple Moving Average)
Keeps historical records for trend analysis

4. AI-Style Predictions

A Simple Moving Average (SMA) model predicts prices 5 minutes ahead
Predictions are stored alongside actual prices for comparison

5. Visual Dashboard

Grafana shows:
- Real-time price charts
- Overlay of predicted vs. actual prices
- 24-hour high/low values
- 24-hour % change bar charts

🛠 Technologies Used

Step	Technology
Data Source	CryptoCompare API
Streaming	Apache Kafka
Storage	PostgreSQL
Prediction	Python (SMA)
Visualization	Grafana
Environment	AWS EC2 (Ubuntu 22.04)

💡 Key Benefits

Watch BTC & ETH prices update instantly
Compare AI-predicted vs. actual prices in real time
Access from anywhere via AWS-hosted Grafana
Fully open-source — no paid tools required

🔗 GitHub Repository

📂 View Project on GitHub

Author: Danny Ki

Link: https://kish191919.github.io/2025/07/24/Real-Time-Crypto-Dashboard/

Copyright Notice: All articles on this blog are licensed under CC BY-NC-SA 4.0 unless otherwise stated.

Python Kafka PostgreSQL Grafana AWS

Related Articles

News Keyword Trend Analyzer

📰 Real-Time News Keyword Trend AnalyzerTracking trending keywords in news articles using real-time datapipelines “See the world’s breaking news trends — live.” 📌 One-Line SummaryA real-time news keyword trend analyzer that collects live newsheadlines, processes them to extract popular keywords, and visualizestheir trends in real time using Kafka, Apache Flink, Elasticsearch,and Kibana. 1️⃣ How It Works1. Data Collection — Kafka Producer (news_producer.py) Fetches top news headline...

[Algorithm] Bubble Sort — Can Life Be Sorted Too?

🫧 What’s the Big Deal About Bubble Sort? “It’s the little differences that make the big difference.” – Napoleon Hill In the programming world, there are moments when small changes lead to big outcomes—just as Napoleon Hill said.One of the best examples of this is Bubble Sort. At first glance, it’s so simple that it’s easy to dismiss. But behind its simplicity lies a surprisingly meaningful lesson. Bubble Sort works by scanning a list from start to finish, comparing two neighboring e...

[Algorithm] Dynamic Programming — Trusting Your Past Self

🔁 What’s the Big Deal About Dynamic Programming? “Memory is the treasury and guardian of all things.” – William Shakespeare In life, there are moments when we need to remember and refer to past experiencesto avoid making the same mistakes again. Whether in studying, exercising, or love—the ability to remember and use what we’ve learned shapes our future. There’s an algorithm in programming that reflects this very philosophy:Dynamic Programming (DP). 🧠 The Philosophy Behind ItDyn...

[Algorithm] Insertion Sort — Quiet but Steady Growth

🧩 What’s the Big Deal About Insertion Sort? “It does not matter how slowly you go as long as you do not stop.” – Confucius In life, there are those who don’t seek the spotlight but quietly find their own place.In the world of algorithms, there’s a counterpart to such people — Insertion Sort. As its name suggests, Insertion Sort works by inserting each new elementinto the correct position within an already sorted portion of the list. It doesn’t sort everything in one flashy move,but in...

[Algorithm] Quick Sort — Divide and Conquer!

⚡ Quick Sort: Divide and Conquer! “Divide each difficulty into as many parts as is feasible and necessary to resolve it.”— René Descartes In life, as in sorting algorithms, you don’t have to solve a complex problem all at once.Break it down into smaller pieces, and it becomes much easier to handle.Quick Sort is an algorithm built exactly on that philosophy. Imagine organizing your bookshelf.You pick one book in the middle as a reference point —thinner books go to the left, thicker book...

[Algorithm] Selection Sort — The Power of Choosing

🔍 What’s the Big Deal About Selection Sort? “Destiny is not a matter of chance, it is a matter of choice.” – William Jennings Bryan In life, we constantly face moments of choice.Who will you walk with? What will you do first?Ultimately, these choices shape the course of your life. In programming, there’s an algorithm that embodies this same idea —Selection Sort. Selection Sort repeatedly finds the smallest value in the list,and moves it to the front, step by step, until the entire lis...