March 2022 Summaries

QuestDB is an open-source database designed for high throughput ingestion and enhanced SQL analytics, making it particularly suitable for market data and tick data analysis. The text explores how QuestDB, in conjunction with the Julia programming language, can be used to analyze Bitcoin's intraday trading volume profiles. By importing CSV files into QuestDB using its REST API, users can efficiently manage large datasets and perform complex queries to identify trading patterns, such as daily volume trends and intraday volume profiles. The analysis reveals that Bitcoin trading volumes peak in the afternoons when the U.S. markets open and that weekends exhibit less extreme trading activity, with Sunday trading extending into the early hours of Monday. The document also discusses the use of LOESS smoothing to interpret trading data more effectively, emphasizing the importance of understanding trading volumes for algorithmic trading strategies. The insights gained from this analysis can help traders optimize their strategies by avoiding trading during illiquid periods, thus minimizing potential costs.

QuestDB is an advanced open-source database optimized for handling market data, offering high ingestion throughput and SQL analytics, which is particularly useful for tick data. The tutorial by Tancrede Collard demonstrates how to use Python to fetch cryptocurrency data from Coinbase, store it in QuestDB, and visualize it using Grafana. The tutorial highlights the importance of efficient data storage and querying in analyzing streaming data and how data visualization can aid in plotting trends and creating actionable reports. By leveraging QuestDB's capabilities, users can control the database to create custom metrics and dashboards, particularly useful for analyzing derivative features in cryptocurrency trading, which are often overlooked. The integration with Grafana enables users to set up monitoring and alert systems for various market metrics. The tutorial also provides detailed instructions on setting up QuestDB and Grafana using Homebrew for macOS users and configuring them to work together, including the steps for creating time series visualizations and calculating derived metrics like bid-offer spreads. Lastly, it suggests further exploration, such as deriving forward curves and plotting volatility smiles, encouraging community feedback on the project.

Gábor Boros's tutorial delves into the process of generating mock time series data using QuestDB's built-in SQL functions, offering developers an efficient way to create dummy data for testing and prototyping. The tutorial distinguishes between regular and irregular time series data and underscores the importance of understanding data types and use cases before data generation. By utilizing QuestDB's generator functions, such as long_sequence and various random value generators, developers can effortlessly produce large volumes of test data that mimic real-world scenarios. The tutorial provides detailed instructions on setting up QuestDB using Docker or Homebrew, and demonstrates how to generate complex and realistic data sets, including sequentially increasing timestamps for time series analysis. Through practical examples, it illustrates the utility of these functions in creating tables populated with diverse types of data for comprehensive testing, while also highlighting best practices for data generation to ensure consistency and reliability in testing environments.

QuestDB is an open-source time-series database designed for high-demand workloads, offering ultra-low latency, high ingestion throughput, and a versatile storage engine with native support for Parquet and SQL. The company has a strong connection to Ukraine, with co-founder Vlad and engineers Alex and Eugene being Ukrainian. Due to the ongoing conflict in Ukraine, Eugene and his family have been forced to seek shelter in a bunker, yet he remains committed to his work, joining meetings amidst the turmoil. QuestDB expresses solidarity with its Ukrainian employees and urges its community to support Ukraine through donations and other means. The company is actively providing logistical support and security updates to its staff, while a fellow Y Combinator founder is raising funds on the ground in Moldova and Romania. QuestDB appreciates the support from its stakeholders and hopes for a swift restoration of peace in the region.