Real-time stock price dashboard using QuestDB, Python and Plotly

QuestDB is a next-generation open-source database designed for market data, offering high ingestion throughput, advanced SQL analytics, and cost-efficient hardware usage. Gábor Boros provides a tutorial on building real-time stock price tracking dashboards using Plotly and QuestDB, demonstrating the combination of various technologies such as Celery, Redis, Plotly, and Dash to efficiently handle large datasets and visualize data through interactive charts. The project involves setting up a backend to fetch stock data from Finnhub and a frontend to display it using Dash, requiring Python and SQL skills. By utilizing Docker and Docker Compose, the tutorial guides users in setting up the necessary environment without affecting their host machine, detailing the creation of database tables, periodic tasks with Celery, and interactive data visualization with Plotly. This comprehensive guide illustrates how to integrate these tools to create a real-time data streaming dashboard, enhancing the understanding of system states through dynamic visual representations.