Home / Companies / QuestDB / Blog / Post Details
Content Deep Dive

Demo of live crypto data streamed with QuestDB and Grafana

Blog post from QuestDB

Post Details
Company
Date Published
Author
Nicolas Hourcard
Word Count
779
Language
English
Hacker News Points
-
Summary

QuestDB is an advanced open-source database designed for high-performance market data analysis, particularly suitable for handling tick data with premium ingestion throughput and efficient SQL analytics. The platform showcases its capabilities through a live demo featuring historical NYC taxi rides and a geospatial dataset of 250,000 ships, along with a new real-time dataset of cryptocurrency market data from the Coinbase Exchange. Utilizing the Cryptofeed Python library for data ingestion and Grafana for visualization, QuestDB processes columns such as price, side, amount, and timestamp for BTC-USD and ETH-USD trades, offering rapid query responses in milliseconds despite the large volume of data. The demo includes example SQL queries that utilize QuestDB's time-series extensions, such as LATEST ON and SAMPLE BY, to extract insights like the latest cryptocurrency prices, candle charts, volume-weighted average prices, and implied BTC-ETH exchange rates. The platform encourages users to explore these queries and join the community for further development and collaboration.