Documentation Changelog

This page lists the most recently updated documentation pages, helping you stay informed about new content and improvements.

Demo data schema
Schema and structure of the FX market data and cryptocurrency trades available on demo.questdb.io
Grafana variable dropdown with name and value
Create Grafana variable dropdowns that display one value but use another in queries using regex filters
Multiple conditional aggregates
Calculate multiple conditional aggregates in a single query using CASE expressions
Consistent histogram buckets
Generate histogram data with fixed bucket boundaries for consistent distribution analysis
Find local minimum and maximum
Find the minimum and maximum values within a time range around each row
Pivot with "Others" column
Pivot specific values into columns while aggregating remaining values into an "Others" column using CASE statements
Access rows before and after current row
Use LAG and LEAD window functions to access values from surrounding rows
Sankey and funnel diagrams
Create session-based analytics for Sankey diagrams and conversion funnels
Top N plus others row
Group query results into top N rows plus an aggregated "Others" row using rank() and CASE expressions
Unpivoting query results
Convert wide-format data to long format using UNION ALL
Bollinger bands
Calculate Bollinger Bands using window functions for volatility analysis and mean reversion trading strategies
Liquidity comparison across instruments
Compare liquidity across multiple instruments using L2Price to calculate effective spreads at different order sizes

Interval Scan
Deep dive into interval scans - how to verify they're being used and edge cases to be aware of.
Designated timestamp
Complete guide to designated timestamp in QuestDB - why it exists, how it works, what it enables, limitations, best practices, and troubleshooting.
Time Partitions
Overview of QuestDB's partition system for time-series. This is an important feature that will help you craft more efficient queries.
Working with time zones
How to filter and convert timestamps by time zone in QuestDB using TICK syntax and conversion functions.

Time Series Optimizations
QuestDB is specifically designed for time series, and it provides several optimizations such as a designated timestamp, sequential reads, materialized views, and in-memory processing.
Deduplication
Deduplication prevents duplicate rows and reduces write amplification when reloading data.
Time To Live (TTL)
Automatic data retention in QuestDB - configure TTL to automatically drop old partitions.

Cookbook overview
Quick recipes and practical examples for common QuestDB tasks and queries