September 2021 Summaries

QuestDB is highlighted as a cutting-edge, open-source database particularly suited for handling market data, offering high ingestion throughput, advanced SQL analytics, and efficient hardware usage. The text, written by Dean Markwick, details how QuestDB serves as a time series database for high-frequency trading and illustrates its application through the Julia programming language. Markwick shares insights on setting up and connecting to a QuestDB database using Julia to analyze BTCUSD trades from the CoinbasePro WebSocket feed, leveraging QuestDB's capabilities for calculating various financial metrics. Through this setup, he demonstrates how to calculate the limit order book, assess market impact, and perform ASOF joins to align trades with bid-offer data, ultimately enhancing the analysis of trading behaviors and market impact with larger datasets. The document emphasizes the ease of integrating QuestDB via the LibPQ.jl package and the benefits of using a database over traditional CSV files for managing large volumes of financial data.

QuestDB's latest release, version 6.0.5, introduces geospatial data support through the integration of geohash types, which enables efficient querying and storage of geographic information. Geohashes, which convert geographic locations into short alphanumeric strings, allow for precise spatial data representation and the execution of geospatial queries using new syntax and operators. This update opens up new possibilities for applications in asset tracking, machine learning, and computer vision, among other fields. Additionally, the release includes performance enhancements for the first() and last() functions, which improve efficiency in geospatial queries, particularly those involving "last-known location" scenarios. New functions for rounding timestamps, such as timestamp_floor() and timestamp_ceil(), have been added, providing more flexibility in handling temporal data. The release notes and changelog are available on GitHub, and the version can be accessed via Docker Hub, with the QuestDB team actively seeking community feedback and engagement on the update.