# QuestDB QuestDB is the open-source time-series database for demanding workloads—from trading floors to mission control. It delivers ultra-low latency, high ingestion throughput, and a multi-tier storage engine. Native support for Parquet and SQL keeps your data portable, AI-ready—no vendor lock-in. ## Docs The official QuestDB documentation. Learn how to accelerate your time-series, capital markets, and heavy industry use cases. - [Full Documentation Content](https://questdb.com/docs/llms-full.txt) - [Compact Documentation Content](https://questdb.com/docs/llms.txt) ## About us - [About QuestDB](https://questdb.com/about-us): QuestDB is building the next generation open source time-series database, backed by leading enterprise VCs and open source founders. Join us in our mission to deliver breakthrough performance for time-series applications. ## Careers - [Careers at QuestDB](https://questdb.com/careers): Join QuestDB in building breakthrough technology for time-series data. We are a remote-first company offering competitive equity, flexible hours, and a culture of ownership and autonomy. ## Customers - [Customers](https://questdb.com/customers): QuestDB Customers - High-performance time-series database for capital markets, IoT, and industrial applications. Trusted by industry leaders like Mizuho, Airbus, OKX, and B3 Exchange. ## Enterprise - [Enterprise](https://questdb.com/enterprise): QuestDB Enterprise - Enterprise-grade time-series database with premium support, security features, and compliance capabilities for mission-critical applications. ## Download - [Download QuestDB](https://questdb.com/download): Download QuestDB - High-performance open-source time-series database. Available as Docker image, binary download, or cloud deployment. Get started in minutes. ## Market Data - [Market Data](https://questdb.com/capital-markets): QuestDB for Market Data - Ultra-low latency database for financial market data, tick data, and real-time analytics. Trusted by trading firms and exchanges worldwide. ## Contributors - [Contributors](https://questdb.com/contributors): QuestDB Contributors - Meet the open source community building the fastest time-series database. Contribute code, documentation, or join our community. ## Compare - [QuestDB vs kdb+](https://questdb.com/compare/questdb-vs-kdb): QuestDB vs kdb+ for capital markets. Compare architecture, programming models, and operational characteristics for time-series analytics workloads. ## Blog - [Streaming 500 million rows into Apache Arrow in 2.3 seconds](https://questdb.com/blog/2026-08-07-streaming-arrow-egress-qwp): We built a naive parallel reader to see how fast QuestDB's new QWP protocol can stream query results into Arrow, compared it against ClickHouse and TimescaleDB, and stripped out three measurement artifacts before the numbers meant anything. - [QuestDB 10.0: QWP, one binary streaming protocol for writes and Arrow reads](https://questdb.com/blog/2026-08-06-questdb-10-0-release): QuestDB 10.0 ships QWP, a binary columnar protocol that both writes data in and streams Arrow back out, from a single client. It also brings live views in beta, notebooks driven by coding agents, and the storage work that QuestDB Enterprise 4.0 builds cold storage on. - [Introducing QuestDB's new binary ingestion protocol: QWP](https://questdb.com/blog/2026-08-05-qwp-vs-ilp-ingestion-benchmark): QuestDB's new binary Wire Protocol vs InfluxDB Line Protocol in TSBS: 33M rows/s on one machine even at a million series, about 3.6x faster than ILP over a network. - [Transaction Cost Analysis with QuestDB and Polars: VWAP, Slippage and Markout](https://questdb.com/blog/2026-07-20-transaction-cost-analysis-questdb-polars): A transaction cost analysis pipeline on live market data: VWAP, arrival slippage and markout curves in QuestDB SQL, with Polars via ConnectorX on top. - [The Most Expensive Instruction Might Be… cmov](https://questdb.com/blog/2026-07-15-cmov-vs-branch-perf): A trip through HotSpot's C2 branch-to-cmov heuristic: it measures branch bias, not predictability, and in a tight loop that mismatch is worth up to 2.9x. - [The Best Time-Series Databases in 2026 (and How to Choose)](https://questdb.com/blog/2026-07-07-best-time-series-databases): The best time-series database is the one that fits your workload. A 2026 guide comparing QuestDB, InfluxDB, TimescaleDB, ClickHouse, kdb+ and more. - [The mask that compiles to nothing: how HotSpot's JIT learned to reason about bits](https://questdb.com/blog/2026-07-02-jvm-jit-known-bits): A deep dive into the known-bits abstraction that recently landed in HotSpot's C2 JIT compiler: the same tristate-bit abstraction LLVM and GCC use, and why it lets the JVM delete redundant masks and shifts. - [Lies, Damn Lies and Database Benchmarks](https://questdb.com/blog/2026-06-18-lies-damn-lies-and-database-benchmarks): We tweak one fair-but-different thing in each ClickBench scenario and watch the hot-run rankings reshuffle, a reminder to read benchmarks closely. - [QuestDB Enterprise 3.3.1: storage policies, custom CA, and finer-grained access control](https://questdb.com/blog/2026-06-12-questdb-enterprise-3-3-1): QuestDB Enterprise 3.3.1 brings the new storage policy engine for tiering data to Parquet, posting indexes, a custom root CA for replication object stores, and column-level GRANT/REVOKE with EXCLUDE, on top of the QuestDB 9.4.2 engine. - [QuestDB 9.4.2: shareable queries, new aggregates, and a hardening pass](https://questdb.com/blog/2026-06-09-questdb-9-4-2-release): QuestDB 9.4.2 adds shareable Web Console queries, the array_agg and regr_r2 aggregates, and hardens Parquet and posting-index paths under heavy ingestion. - [Aeron and QuestDB: building open infrastructure for capital markets data](https://questdb.com/blog/2026-06-05-aeron-questdb-open-infrastructure-capital-markets): How capital markets firms pair Aeron and QuestDB for exactly-once semantics, deterministic replay, and regulatory-grade history on open formats. - [QuestDB 9.4.0: Posting index, cross-column fill, and smarter Web Console](https://questdb.com/blog/2026-05-19-QuestDB-9-4-0-release): QuestDB 9.4.0 adds a posting index for SYMBOL columns with optional covering data, cross-column FILL(PREV) for SAMPLE BY, and Web Console autocompletion. - [How we made WINDOW JOIN parallel and vectorized](https://questdb.com/blog/2026-05-12-window-join-performance): WINDOW JOIN aggregates one table over a time window around each row of another, made parallel and vectorized, then benchmarked vs Timescale, DuckDB, ClickHouse. - [Sparklines for traders: candlesticks and depth charts in SQL](https://questdb.com/blog/2026-05-04-sparklines-candlesticks-depth-charts-sql): QuestDB's bar(), sparkline(), ohlc_bar(), and depth_chart() functions render candlesticks and order book depth right inside SQL results, no notebook needed. - [Code review turned a 3x speedup into 8.9x (off-heap HdrHistogram in QuestDB)](https://questdb.com/blog/2026-04-21-code-review-tripled-histogram-speedup): A community PR ports HdrHistogram off-heap for QuestDB's approx_percentile(): fast in parallel but regressing single-threaded, until review reached 8.9x. - [QuestDB 9.3.5: Lateral Joins, UNNEST & Window Stats](https://questdb.com/blog/2026-04-13-questdb-9-3-5-and-enterprise-3-2-5): QuestDB 9.3.5 and Enterprise 3.2.5 add lateral joins, SQL-standard UNNEST, statistical window functions, multi-table HORIZON JOIN, and DST-correct SAMPLE BY. - [Zero-Shot Time-Series Forecasting with QuestDB and Google's TimesFM](https://questdb.com/blog/2026-04-09-zero-shot-forecasting-questdb-timesfm): Three ways to load QuestDB data into Python, then forecast crypto trading volume and volatility with Google's TimesFM, no model training required. - [QuestDB 9.3.4: Dynamic WINDOW JOIN & Parquet Bloom Filters](https://questdb.com/blog/2026-04-01-questdb-9-3-4-and-enterprise-3-2-4): QuestDB 9.3.4 adds dynamic WINDOW JOIN ranges, Parquet bloom filters, and array analytics, plus Enterprise 3.2.4's COPY PERMISSIONS and permission cleanup. - [Building a real-time multi-exchange charting platform with QuestDB](https://questdb.com/blog/2026-03-23-arden-charts-real-time-charting-questdb): How Arden Charts streams 15,000+ tickers across 8 exchanges and uses QuestDB materialized views to power real-time candlestick charts on small hardware. - [From 3 Seconds to 38 Milliseconds: Why SAMPLE BY Order Matters](https://questdb.com/blog/2026-03-17-sample-by-window-function-order): When combining SAMPLE BY with window functions, the order of operations can mean an 80x performance difference. Here's a real example from building cookbook recipes for realized volatility. - [QuestDB and the Modern Data Stack: Bridging Time Series, OLAP, and the Lakehouse](https://questdb.com/blog/2026-03-11-questdb-and-the-modern-data-stack-lakehouse): How the database landscape evolved from OLTP bottlenecks to open formats, and where QuestDB's three-tier storage engine fits in today's data ecosystem. - [QuestDB Enterprise 3.2.3: WAL cleaner, TLS metrics, and HORIZON JOIN](https://questdb.com/blog/2026-03-04-questdb-enterprise-3-2-3): QuestDB Enterprise 3.2.3 ships the object store WAL cleaner, TLS certificate expiration metrics, faster ASOF and WINDOW joins, HORIZON JOIN for post-trade analysis, and JIT compilation on ARM64. - [QuestDB Wins Best Trading Analytics Platform at TradingTech Insight Awards Europe 2026](https://questdb.com/blog/2026-03-03-tradingtech-best-trading-analytics-platform): QuestDB has been named Best Trading Analytics Platform at the TradingTech Insight Awards Europe 2026, voted by the practitioners who run analytics at market scale every day. - [QuestDB 9.3.3: HORIZON JOIN, twap(), and JIT on ARM64](https://questdb.com/blog/2026-02-27-QuestDB-9-3-3-release): QuestDB 9.3.3 adds HORIZON JOIN for markout analysis, the twap() function, named WINDOW definitions, JIT on ARM64, and faster Parquet, GROUP BY, and UNION. - [The Windows DLL loader lock: how a Rust thread can hang your JVM](https://questdb.com/blog/2026-02-26-windows-dll-loader-lock): Debugging sporadic Windows CI hangs through process dumps and WinDbg, uncovering a DLL loader-lock deadlock between Rust thread teardown and JVM safepoints. - [QuestDB 9.3.2: TICK, arg_max, and Exponential Moving Averages](https://questdb.com/blog/2026-02-04-QuestDB-9-3-2-release): QuestDB 9.3.2 introduces TICK, a temporal interval syntax that turns complex time-range filters into one-liners. Alongside new aggregate and window functions for time-series analytics, a 6x speedup on Parquet queries, and improved LLM integration. - [Building Real-Time Bollinger Bands Charts with SQL and Grafana](https://questdb.com/blog/2026-01-29-building-real-time-bollinger-bands-charts): Calculate Bollinger Bands with QuestDB SQL and visualize them in Grafana, overlaying the volatility bands on candlestick charts for real-time FX analysis. - [Building the Market Depth Chart Grafana Never Made](https://questdb.com/blog/2026-01-22-visualizing-market-depth-grafana-plotly): Learn how to build interactive market depth charts in Grafana using the Plotly plugin and QuestDB, including a technique for highlighting order book walls without visual clutter. - [How a 40-Line Fix Eliminated a 400x Performance Gap](https://questdb.com/blog/2026-01-13-jvm-current-thread-user-time): How a 40-line OpenJDK fix swapped slow /proc parsing for a single clock_gettime syscall, closing a 400x thread CPU-time gap hidden for 20 years. - [QuestDB 9.3: Window joins, views, PIVOT, and AI in the console](https://questdb.com/blog/2026-01-12-QuestDB-9-3-release): QuestDB 9.3 introduces window joins for range-based time alignment, views for reusable query logic, PIVOT for wide-schema aggregations, and AI-assisted workflows directly inside the Web Console. - [QuestDB 2025: Year in Review](https://questdb.com/blog/2025-12-30-questdb-2025-capital-markets): 16 open-source releases and 15 enterprise releases: arrays, nanosecond timestamps, DECIMAL, optimized joins, and enterprise replication. From capital markets to crypto, fintech, and high-cardinality sensor workloads. - [Benchmark and comparison: QuestDB vs. ClickHouse](https://questdb.com/blog/2025-12-22-clickhouse-vs-questdb): Benchmarks and an overview of ClickHouse versus QuestDB to compare features, functionality, performance, and ease of use. - [How to Build Market Depth Charts from Order Book Data with QuestDB](https://questdb.com/blog/2025-12-17-analizing-market-depth-with-questdb): Learn how to model FX order book data in QuestDB using SQL arrays and build real-time market depth charts for trading and market microstructure analysis. - [How a Kernel Bug Froze My Machine: Debugging an Async-profiler Deadlock](https://questdb.com/blog/2025-12-11-async-profile-kernel-bug): How I investigated and worked around a kernel bug that caused async-profiler to freeze my machine whenever I tried to use a profiler. - [InfluxDB 3 Core Benchmarks: QuestDB Comparison](https://questdb.com/blog/2025-12-04-influxdb3-core-benchmarks): Performance benchmarks comparing InfluxDB 3 Core against QuestDB 9.2.2 using the industry-standard TSBS benchmark suite. - [Benchmark and comparison: QuestDB vs. InfluxDB v1/v2 ](https://questdb.com/blog/2025-12-02-questdb-versus-influxdb): Benchmarks and an overview of InfluxDB versus QuestDB to compare features, functionality, performance, and ease of use. - [TimescaleDB vs QuestDB: 2026 Benchmark Results (Clear Winner)](https://questdb.com/blog/2025-12-02-timescaledb-vs-questdb): Compare QuestDB and TimescaleDB with up-to-date performance benchmarks and architectural comparisons. - [We finally benchmarked InfluxDB 3 OSS Core (Alpha)](https://questdb.com/blog/2025-12-01-we-finally-benchmarked-influxdb3-oss-core-alpha): We benchmark InfluxDB 3 OSS Core (Alpha) ingestion against QuestDB, take an initial look at its strengths and weaknesses, and flag key caveats. - [QuestDB 9.2: Exact arithmetic and smarter temporal joins](https://questdb.com/blog/2025-11-21-QuestDB-9-2-release): QuestDB 9.2 introduces a native DECIMAL type for exact arithmetic, a new Dense ASOF JOIN algorithm for long distance temporal matches, and quality of life improvements like symbol auto scaling enabled by default. - [Building an FX Liquidity Stress Analysis Workflow with QuestDB](https://questdb.com/blog/2025-11-05-liquidity_stress_analysis_workflow): Build an FX liquidity stress pipeline with QuestDB: ingest L2 order book data, engineer features, label stress, and train an XGBoost model - [The Mystery of the Phantom Quote in My CI Builds](https://questdb.com/blog/2025-10-25-stdout-stderr-azure-pipelines-race): How a phantom single quote from bash's set -x caused random CI build failures through a race condition between stdout and stderr in Azure Pipelines. - [Order Book Imbalance Analysis with QuestDB Arrays](https://questdb.com/blog/2025-10-17-Order-Imbalance-Analysis-With-QuestDB-Arrays): Analyze order book imbalance with QuestDB array types, using synthetic Bitcoin data for metrics, queries, and Grafana views to spot spoofing and price pressure. - [QuestDB 9.1: Precision, Profiling, and Power](https://questdb.com/blog/2025-10-06-QuestDB-9-1-release): QuestDB 9.1 brings nanosecond timestamps, continuous profiling, dynamic symbol map scaling, and major JOIN and performance improvements. It is our most precise and introspective release yet. - [QuestDB + Hacktoberfest 2025: Build Something That Lasts](https://questdb.com/blog/2025-09-29-hacktoberfest-2025): Join QuestDB for Hacktoberfest 2025. Contribute meaningful pull requests, connect with our community, and earn exclusive swag. - [From Rust to Reality: The Hidden Journey of fetch_max](https://questdb.com/blog/2025-09-23-journey-from-rust-llvm-asm): Tracing Rust AtomicU64::fetch_max from macro expansion and rustc intrinsics through LLVM atomicrmw umax down to the final x86-64 CAS loop. - [Why Parquet Matters for Time Series and Financial Services](https://questdb.com/blog/2025-09-17-why-parquet-matters-for-time-series-and-finance): Why Parquet fits time-series and financial data: an open columnar format that frees billions of ticks, quotes, and trades from vendor lock-in. - [Immutable images when embedding QuestDB Java library and noexec /tmp](https://questdb.com/blog/2025-09-10-embeddeed-questdb-library-in-immutable-image): A guide on how to run QuestDB’s Java library in hardened environments where /tmp is mounted with noexec, by pre-bundling native libraries and using the questdb.libs.dir system property. - [Highly Available Reads with QuestDB](https://questdb.com/blog/2025-09-03-highly-available-reads-in-questdb): Learn how to get highly available reads across multiple QuestDB instances using open-source or enterprise deployments. - [Leveraging LLMs to Interact with QuestDB Data](https://questdb.com/blog/2025-08-27-leveraging-llms-to-interact-with-questdb-data): Query and ingest QuestDB data with LLMs like Claude via REST APIs and PostgreSQL MCP servers, using natural language, autonomous agents, and AI assistance. - [When AI Optimizations Miss the Mark: A Case Study in Array Shape Calculation](https://questdb.com/blog/2025-08-20-when-ai-optimizations-miss-the-mark): A database engineer at QuestDB discovers that an AI-suggested optimization for array shape calculation in their Parquet reader actually made the code slower, and achieves a 5x average speedup by applying a few simple optimizations. - [Ingesting L2 order book data with multidimensional arrays](https://questdb.com/blog/2025-07-31-ingesting-level-2-order-book-data-into-questdb-using-cryptofeed): Learn how to ingest level-2 (L2) order book data into QuestDB's new multi-dimensional array type. - [Order book analytics using the N-Dimensional array](https://questdb.com/blog/2025-07-30-ndim-arrays): QuestDB's new N-dimensional arrays are a great match for storing and analyzing a market order book. This blog provides a cookbook with ready-made examples of analytical order book queries. - [Real-Time Order Book and FX Market Data Dashboard](https://questdb.com/blog/2025-07-18-dashboards-fx-orderbook): Real-time order book and foreign exchange market data dashboards powered by QuestDB and Grafana. - [Don't get stale! Fine-tuning ASOF JOIN with TOLERANCE in QuestDB](https://questdb.com/blog/2025-07-17-asof-join-tolerance): QuestDB's new TOLERANCE clause for ASOF JOIN ensures you only join with relevant, recent data, preventing stale joins in time-series analyses. This synergises perfectly with recent upgrades to our ASOF JOIN algorithm, helping to bring you accurate results with low latency. - [QuestDB 9.0: Armed with Arrays](https://questdb.com/blog/2025-07-14-release-9-0-0-armed-with-arrays): QuestDB 9.0 synthesizes key feedback from leading firms into the most polished and robust version of QuestDB yet. Highlights include the much anticipated N-dimensional arrays, new types of materialized view with improved efficiency, and a refreshed Web Console, now supporting multi-line execution. One the performance side, we've sped up data deduplication and further optimised our time-series joins. - [Streaming market data from Arroyo into QuestDB](https://questdb.com/blog/2025-05-30-streaming-market-data-from-arroyo-into-questdb): Learn how to connect Arroyo to QuestDB using the HTTP ILP endpoint and standard SQL. We'll explore the pros and cons of other approaches like Kafka Connect and Debezium, and walk through a working example using Arroyo's webhook sink. - [How to create a materialized view](https://questdb.com/blog/2025-05-21-how-to-create-materialized-views): What a materialized view is, its benefits and trade-offs, and how to create one in QuestDB to speed up aggregation queries with incremental refresh. - [Real-time analytics with an all-in-one system: Are we there yet?](https://questdb.com/blog/2025-04-30-realtime-analytics-using-tsdb): Explore how modern databases are evolving into unified real-time analytics platforms. Compare TimescaleDB, ClickHouse, InfluxDB, and QuestDB's approaches to handling both historical and streaming data through materialized views. - [K-line candlestick charts with QuestDB & Grafana](https://questdb.com/blog/2025-04-09-building-kline-charts-with-questdb-and-grafana): Stream real-time crypto data from polygon.io, aggregate OHLC tables with QuestDB materialized views, and plot k-line candlestick charts in Grafana. - [Why AI needs a database](https://questdb.com/blog/2025-03-11-why-ai-needs-a-database): AI won't replace databases — but it will transform how we use them. This article explores why AI and databases work better together, breaking down LLM tokenization, real-time data access, and retrieval strategies like RAG, vector search, and direct SQL querying. - [Design by Decision Fatigue](https://questdb.com/blog/2025-02-25-design-by-decision-fatigue): An essay on how the decisions we make writing software shape our enjoyment of the craft - [Automating Workflows in QuestDB: Bash scripts, Dagster, and Apache Airflow](https://questdb.com/blog/2025-02-14-workflow-automation-apache-airflow-dagster-bash): Learn how to automate tasks in QuestDB using workflow tools like Apache Airflow and Dagster, or just using the API from bash scripts. - [QuestDB 8.2.2 - New real-time monitoring, Table TTL and more](https://questdb.com/blog/2025-01-29-questdb-8-2-2): QuestDB 8.2.2 adds built-in real-time monitoring, automatic data cleanup with table TTL, new window functions, and simpler SQL through the DECLARE syntax. - [Exploring high resolution foreign exchange (FX) data](https://questdb.com/blog/2025-01-08-high-resolution-fx-analysis): Ingest high-frequency FX top-of-book data from TrueFX and analyze it with QuestDB SQL functions in this hands-on tutorial using free, high-resolution data. - [Build candlestick charts in minutes with QuestDB and React](https://questdb.com/blog/2025-01-06-creating-candlestick-charts-questdb-echarts): Build interactive candlestick charts with QuestDB and Apache ECharts: fetch market data, store OHLC bars, and render a real-time React component. - [Analyzing Bitcoin Options Data with QuestDB](https://questdb.com/blog/2024-12-13-analyzing-bitcoin-options-data): Bitcoin is booming. Learn how to use Python and QuestDB to analyze Bitcoin options data. Get ahead of the next price movement in minutes. - [Scaling a trading bot with a time-series database](https://questdb.com/blog/2024-11-27-scaling-trading-bot-with-time-series-database): Scale a trading bot beyond SQLite with QuestDB, handling growing tick-data volumes. We compare options and build a proof-of-concept with code examples. - [Making a trading Gameboy: A pocket exchange and algo trading platform](https://questdb.com/blog/2024-11-11-trading-gameboy): An exchange and algo trading station in your pocket! - [Revealing the stories in French real estate data](https://questdb.com/blog/2024-11-07-french-real-estate): Using time series of real estate transactions to understand underlying trends in the French real estate market - [Time-series and analytical databases walk into a bar](https://questdb.com/blog/2024-10-28-time-series-analytic-database-p99-andrei): Explore the evolution of QuestDB and how it improved its time-series database capabilities for analytical queries, presented at P99 CONF 2024. - [Monitoring QuestDB with simple curl commands](https://questdb.com/blog/2024-10-24-questdb-monitoring-tips-and-tricks): This post explores useful curl commands for monitoring QuestDB load and state, designed to output single numbers that can be fed into monitoring tools. - [QuestDB and Raspberry Pi 5 benchmark, a pocket-sized powerhouse](https://questdb.com/blog/2024-10-22-raspberry-pi-5-benchmark): How does the Raspberry Pi 5 handle rigorous data benchmarking? We see how well QuestDB and the RPi5 ingest and query billions of data points. - [The future of fast databases: Lessons from a decade of QuestDB](https://questdb.com/blog/2024-10-10-the-future-of-fast-databases): Explore lessons from a decade of QuestDB and a look at the future of fast databases, presented at Big Data London 2024. - [QuestDB 8.1.2 - Tabs & Balance](https://questdb.com/blog/2024-10-08-questdb-8-2-1): Upgrade to QuestDB 8.1.2 for enhanced reliability, new features like Web Console UI tabs and financial functions, performance boosts, and critical bug fixes. - [QuestDB + Hacktoberfest 2024: Embrace the Season of Open Source!](https://questdb.com/blog/2024-10-04-hacktoberfest-2024): Contribute your open source PRs to the QuestDB project for Hacktoberfest 2024. We've got swag! - [Combine Java and Rust Code Coverage in a Polyglot Project](https://questdb.com/blog/2024-09-10-rust-java-coverage): This tutorial guides you through the steps needed to create a joint code coverage report that includes code covered by JUnit and Rust tests, as well as Rust code covered by JUnit tests via JNI. - [Building a new vector based storage model](https://questdb.com/blog/2024-08-22-building-vector-based-storage-from-scratch): The detailed story of how to build a vector-based storage model from scratch. - [Calibrating VWAP executions with QuestDB and Grafana](https://questdb.com/blog/2024-08-16-calibrating-vwap-executions): Calibrate VWAP (volume weighted average price) executions with QuestDB and Grafana to build accurate trading benchmarks and intraday volume predictions. - [The story of our SAMPLE BY enhancements](https://questdb.com/blog/2024-08-07-sample-by-from-to): Explore bug-fixing and feature development for our time-series extension, SAMPLE BY. - [A cloud engineer's first QuestDB Pull Request](https://questdb.com/blog/2024-08-05-my-first-questdb-pull-request): A story about how a QuestDB cloud engineer grew professionally and leveled up his systems programming skills while working on his first major Pull Request to the QuestDB core database - [Tracking data changes (CDC) in QuestDB](https://questdb.com/blog/2024-08-01-tracking-data-changes-in-questdb): Tracking data changes in QuestDB is crucial for various applications like real-time integrations, machine learning updates, and continuous table materialization. By leveraging the wal_transactions table, you can monitor and react to data changes efficiently. This post explores how to utilize these features, including practical examples and a sample repository for hands-on learning. - [Unpacking time-series data for developers](https://questdb.com/blog/2024-08-01-what-is-time-series-data): What is time-series data? Is all data time-series data? How often does data exist outside of time? We answer these questions and explain why time-series data will continue to grow in popularity. - [Debugging distributed database mysteries with Rust, packet capture and Polars](https://questdb.com/blog/2024-07-29-debugging-distributed-databases-with-rust-pcap-and-polars): Unravel a mysterious network bandwidth issue in QuestDB's primary-replica replication was identified and resolved. Learn about the tools and techniques used, including Rust for packet capture and Python with Polars for data analysis, to optimize network performance. - [QuestDB 8.1.0 - Parquet, smarter snapshots, improved SAMPLE BY, and more](https://questdb.com/blog/2024-07-24-questdb-release-8-1-0): QuestDB 8.1.0 opens up Parquet files. This release marks a big step towards QuestDB's next generation architecture. Lots of other goodies, too. - [Why we opened a public Discourse forum (and you should too)](https://questdb.com/blog/2024-07-18-why-switch-to-public-discourse): Feeling pushed out by Slack? Check out the top 3 public Slack alternatives in this article, which will help you measure the pros and cons and decide which alternative to choose. - [QuestDB 8.0.3 - JSON support, smarter Web Console, and more](https://questdb.com/blog/2024-07-16-questdb-release-8-0-3): QuestDB 8.0.3 contains lots of goodies. JSON support, a more helpful Web Console, performance improvements (naturally), and much more. - [5 Best InfluxDB Alternatives (2026), Benchmarked](https://questdb.com/blog/2024-07-09-top-five-compelling-influxdb-alternatives): Moving off InfluxDB? We benchmark and compare the five best time-series database alternatives for finance, observability, and IoT to find your fit. - [Weather data visualization and forecasting with QuestDB, Kafka and Grafana](https://questdb.com/blog/2024-07-04-visualizing-weather-kafka-grafana): In this tutorial, we’ll use Kafka to stream weather data from the OpenWeatherMap API, store and process it with QuestDB, and create insightful visualizations with Grafana. Example code and easy-to-follow instructions. - [Multi-stream market data with Databento & Grafana](https://questdb.com/blog/2024-07-02-databento-market-data): Source live market-data from exchanges via Databento, build dashboards in Grafana, and derive analytics to better understand the markets. - [ASOF Join — The "Do What I Mean" of the Database World](https://questdb.com/blog/2024-06-24-asof-join): ASOF JOIN correlates events across time-series tables by matching each row to the most recent prior record, doing what you mean with a single SQL keyword. - [Analyzing the beautiful charts and history behind ECB FX rates](https://questdb.com/blog/2024-06-20-analyzing-ecb-historical-fx-rates): In this post, we look at beautiful charts that track the European Central Bank FX rates, and then look at historical events that made a big impact. Made with Grafana and QuestDB. - [Mastering Grafana Map Markers and Geomaps](https://questdb.com/blog/2024-06-17-working-with-grafana-maps-markers): Plot static and moving objects on Grafana Geomap panels backed by QuestDB, with hands-on tips for markers, layers, and realtime location data. - [Fluid real-time dashboards with Grafana and QuestDB](https://questdb.com/blog/2024-06-11-grafana-tutorial): Use Grafana with QuestDB to build a monitoring dashboard for visualization of time series data. - [QuestDB 8.0: Major Release](https://questdb.com/blog/2024-05-23-questdb-8-release): QuestDB 8.0 brings major performance improvements, compression to open source, and implements the VARCHAR type. We also have new functions for finance! Learn about our latest. - [How to upgrade and benchmark a Raspberry Pi5](https://questdb.com/blog/2024-05-08-how-to-benchmark-raspberry-pi): Just how powerful is a Raspberry Pi 5? In this article, we'll show you how to upgrade and prepare your Raspberry Pi for benchmarking and how to properly install an NVMe 2.0 SSD (pictures!). We'll put it through the paces in disk writes and assess overall hardware utilization. - [Build your own resource monitor with QuestDB and Grafana](https://questdb.com/blog/2024-05-06-build-resource-monitor-grafana): Learn how to build a resource monitor with QuestDB and Grafana, and visualize system resource usage data. Also learn how to correlate application events with resource utilization! - [Does "vpmovzxbd" Scare You? Here's Why it Doesn't Have To](https://questdb.com/blog/2024-04-12-does-vpmovzxbd-scare-you): Learn about SIMD, its mnemonics, registers and instructions. We'll demonstrate how these parallel processing techniques enhance database query speeds through an accessible walkthrough. Impress your programmer friends! - [Create an ADS-B flight radar with QuestDB and a Raspberry Pi](https://questdb.com/blog/2024-04-08-create-flight-radar-raspberry-pi-questdb): Build a real-time ADS-B flight radar with QuestDB and a Raspberry Pi, tracking live aircraft positions on minimal hardware step by step. - [Build a temperature IoT sensor with Raspberry Pi Pico & QuestDB](https://questdb.com/blog/2024-04-05-build-temperature-sensor-raspberry-pi-pico-questdb): Build a robust IoT temperature sensor with a Raspberry Pi Pico and QuestDB: wire the onboard sensor, connect WiFi, and stream readings for real-time analysis. - [Create an IoT server with QuestDB and a Raspberry Pi](https://questdb.com/blog/2024-04-04-raspberry-pi-questdb): Build an IoT server with QuestDB on a Raspberry Pi, ingesting time-series sensor data at over 1 million rows per second on minimal hardware. - [Maximize your SQL efficiency: SELECT best practices](https://questdb.com/blog/2024-03-11-sql-select-statement-best-practices): Practical SQL SELECT best practices to write faster, more efficient queries and cut database resource usage, for developers and DBAs alike. - [1BRC merykitty’s Magic SWAR: 8 Lines of Code Explained in 3,000 Words](https://questdb.com/blog/2024-03-07-1brc-merykitty): A deep dive into merykitty's 8-line SWAR temperature parser from the One Billion Row Challenge, using bitwise tricks and ALU magic with no loops or branches. - [The Billion Row Challenge (1BRC): 71s → 1.7s](https://questdb.com/blog/2024-02-20-billion-row-challenge-step-by-step): A step-by-step walkthrough of the Billion Row Challenge, taking a Parallel Java Streams aggregation from 71 seconds down to 1.7 with SIMD and tuning. - [Replace InfluxDB with QuestDB](https://questdb.com/blog/2024-02-01-replace-influxdb): Migrate from InfluxDB to QuestDB using InfluxDB Line Protocol over HTTP, with example code, for better performance, lower costs, and easier time-series storage. - [How crypto exchanges like Coinbase make money](https://questdb.com/blog/2024-01-29-how-crypto-exchanges-make-money-coinbase): How Coinbase and other crypto exchanges earn revenue: fee structures and trading strategies analyzed with QuestDB window functions for real-time insight. - [Tracking sea faring ships with AIS data and Grafana](https://questdb.com/blog/2024-01-24-tracking-sea-fraing-ships-ais-data-grafana): Track sea-faring ships with historical AIS data, converting raw feeds into QuestDB and visualizing vessel movements as heatmaps and time series in Grafana. - [US Bitcoin ETFs: Understanding fair value](https://questdb.com/blog/2024-01-16-us-bitcoin-etf-understanding-fair-value): How US Bitcoin ETFs are priced: the role of market makers, how fair value is set, and what premium and discount mean before you trade. - [Visualizing real-time NYC cab data and geodata](https://questdb.com/blog/2024-01-15-realtime-nyc-cab-data): Explore a simulated real-time dashboard of NYC's taxi industry using historical data, showcasing dynamic visualizations of taxi flows, fares, tips, and hotspots for effective business management and analysis. Created with Grafana and QuestDB, a high performance time series database. - [Visualizing yield curves with Grafana and QuestDB](https://questdb.com/blog/2024-01-12-visualizing-yield-curves-grafana): Explore the significance of the yield curve in finance, its impact on investments, and market responses during events like the COVID pandemic, with a deep dive into time-bound SQL query analysis using QuestDB and Grafana for financial insights. - [NYC Taxi Data Analytics Dashboards](https://questdb.com/blog/2024-01-09-dashboards-taxi): New York City taxi trip analytics dashboards powered by QuestDB and Grafana. - [Normalizing Grafana charts with window functions](https://questdb.com/blog/2024-01-09-normalize-grafana-charts-with-window-functions): Discover how to use the first_value() window function in SQL to normalize and compare time series data in Grafana. This article provides a step-by-step guide to creating more effective Grafana visualizations, with simplified queries and improved performance for data analysis. - [How to increase Grafana refresh rate frequency](https://questdb.com/blog/2024-01-08-increase-grafana-refresh-rate-frequency): Quick and easy example. Learn how to increase the refresh rate frequency of Grafana. - [OLAP vs Time-Series Databases: The SQL Perspective](https://questdb.com/blog/2023-12-21-sql-extensions-for-time-series-vs-olap-oltp): Dive into the world of SQL in time-series analytics with our in-depth comparison across QuestDB, TimeScale, DuckDB, ClickHouse, and PostgreSQL. This blog post explores their unique SQL extensions and capabilities, demonstrating their effectiveness in scenarios like latest record queries, time-interval filtering, approximate time ASOF JOINs, and linear interpolation downsampling. Discover the optimal database choice for your specific analytical needs in time-series data analytics. - [Tracking correlations across financial market assets](https://questdb.com/blog/2023-12-14-tracking-correlations-across-financial-assets): Learn how to use Grafana and QuestDB to analyze and visualize the dynamic, correlated relationships between assets like ETH-USDT and BTC-USDT. Examples and sample data included! - [Crypto Market Data Real-Time Dashboards](https://questdb.com/blog/2023-12-13-dashboards-crypto): Real-time cryptocurrency market data dashboards powered by QuestDB and Grafana. - [Build your own custom trading dashboard](https://questdb.com/blog/2023-12-12-build-your-custom-trading-dashboard): Build a custom trade-watch dashboard with QuestDB and Grafana: aggregate market data across pairs and visualize it for sharper financial analysis. - [Managing large lists of symbols with Grafana variables and QuestDB](https://questdb.com/blog/2023-12-11-manage-large-symbol-lists-grafana): Learn how to manage large lists of symbols efficiently with Grafana variables and QuestDB. This tutorial guides you through creating dynamic dashboards for real-time financial data analysis, making your data monitoring scalable and automated. - [Moving average signals with QuestDB, Grafana and Coinbase](https://questdb.com/blog/2023-12-08-moving-average-signals): Discover how to use QuestDB, Grafana, and Coinbase for moving average signals in trading. Learn to define moving averages, build indicators, and extract signals for profitable trading strategies. - [Building a faster hash table for high performance SQL joins](https://questdb.com/blog/2023-11-23-building-faster-hash-table-high-performance-sql-joins): How the QuestDB team designed FastMap, a hash table specialized for SQL execution that powers fast hash joins and GROUP BY aggregation in the database engine. - [Solving duplicate data with performant deduplication](https://questdb.com/blog/2023-11-16-solving-duplicate-data-performant-deduplication): Duplicate data is costly and frustrating. See how QuestDB's data deduplication works and how its performance compares with ClickHouse and TimescaleDB. - [QuestDB + Hacktoberfest 2023: 10 Years of Hacking](https://questdb.com/blog/2023-10-03-hacktoberfest-2023): Join the QuestDB team for Hacktoberfest 2023. We've got t-shirts! - [Time-series IoT tracker using QuestDB, Node.js, and Grafana](https://questdb.com/blog/2023-09-20-time-series-iot-tracker-nodejs-grafana): Learn with step-by-step examples how to use time-series data and build a real-time IoT tracker. - [Our Website Source Is Now Private, A Cautionary Tale](https://questdb.com/blog/2023-09-01-why-were-making-our-website-private-a-cautionary-tale): Trying to decide whether to make your website open or closed source? Read our cautionary tale before you decide. - [Leveraging Rust in our high-performance Java database](https://questdb.com/blog/2023-08-29-leveraging-rust-in-our-high-performance-java-database): A guide to adding Rust to a Java codebase with JNI and the rust-maven-plugin. - [Navigating Access Control Design: Pursuing Clarity and Simplicity](https://questdb.com/blog/2023-08-22-navigating-access-control-design-clarity-simplicity): Many consider access control lists a solved problem. But there still room for innovation. Read the article to found out where. - [QuestDB Enterprise: Role-based Access Control Walkthrough](https://questdb.com/blog/2023-08-18-enterprise-rbac-acl-tutorial): Role-based access control is now available in QuestDB Enterprise. This article presents a walkthrough of a basic implementation. - [Concurrent Data Structure Design Walkthrough](https://questdb.com/blog/2023-08-17-lock-free-map-design-walkthrough): How to design a lock-free data structure? A detective story for curious developers. - [Fuzz Testing Is the Best Thing To Happen to Our Application Tests](https://questdb.com/blog/2023-08-16-fuzz-testing): Fuzz tests have helped us catch many critical bugs. Should your team consider fuzz testing? They're the best thing to happen to our application tests so far. - [Visualizing IoT Data with MQTT, QuestDB, and Grafana](https://questdb.com/blog/2023-07-06-visualizing-iot-data-questdb): Learn how to visualize your IoT data using QuestDB and Grafana. - [Max Open Files Limit on MacOS for the JVM](https://questdb.com/blog/2023-06-08-max-open-file-limit-macos-jvm): A story about finding out the correct way to set the max open file limit on macOS. - [Exploring Financial Tick Data with Jupyter Notebook and Pandas](https://questdb.com/blog/2023-05-22-exploring-financial-tick-data-jupyter-notebook-pandas): Visualizing financial tick data by ingesting data into QuestDB and analyzing trends with Pandas, Jupyter Notebook, matplotlib, and seaborn. records on the fly. - [Time-Series Data Visualization with Apache Superset and QuestDB](https://questdb.com/blog/2023-05-19-time-series-dashboards-apache-superset-and-questdb): A tutorial to create your first batch and real-time charts and dashboards for time series data using Apache Superset - [Optimizing the Optimizer: the Time-Series Benchmark Suite](https://questdb.com/blog/2023-05-18-optimizing-optimizer-questdb-time-series-benchmark-suite): The story of how QuestDB optimizes the Time-Series Benchmark Suite. - [Investigating Linux Phantom Disk Reads](https://questdb.com/blog/2023-05-02-investigating-linux-phantom-disk-reads): An investigation of weird hardware utilization highlighting some interesting Linux kernel behaviors. - [Exploring Query Plan Scan Nodes with SQL EXPLAIN](https://questdb.com/blog/2023-04-25-exploring-database-scan-modes-sql-explain): A tour of scan nodes available in QuestDB. - [Ingesting Financial Tick Data Using a Time-Series Database](https://questdb.com/blog/2023-04-18-ingesting-market-data-crypto-exchanges-using-time-series-database): An overview of three methods to ingest live market data into QuestDB. - [Integrate Apache Spark and QuestDB for Time-Series Analytics](https://questdb.com/blog/2023-04-06-integrate-apache-spark-questdb-time-series-analytics): Tutorial demonstrating the process to integrate Apache Spark with QuestDB to assist time-series data engineering. - [Comparing InfluxDB, TimescaleDB, and QuestDB Time-Series Databases](https://questdb.com/blog/2023-04-04-comparing-questdb-timescaledb-influxdb): This comparison has been superseded by our 2026 roundup of the best time-series databases. - [Processing Time-Series Data with QuestDB and Apache Kafka](https://questdb.com/blog/2023-03-31-processing-time-series-data-with-questdb-apache-kafka): Streaming market data to QuestDB using Golang and Apache Kafka - [The Inner Workings of Distributed Databases](https://questdb.com/blog/2023-03-28-inner-workings-distributed-databases): Comparison of replication options of time-series databases. - [Migrating from Relational Databases to Time-series Databases](https://questdb.com/blog/2023-03-24-migrating-relational-databases-time-series-databases): The unique characteristics of time-series data and some options to consider when migrating from a relational database to a time-series database. - [MongoDB Time Series Benchmark and Review](https://questdb.com/blog/2023-03-20-mongodb-vs-questdb): A comparison between MongoDB and QuestDB focusing on performance and user experience. - [Loading Pandas DataFrames into QuestDB](https://questdb.com/blog/2023-03-09-loading-pandas-dataframes-to-questdb): Learn how to use the QuestDB Python package to ingest Pandas DataFrames. - [Running Databases on Kubernetes](https://questdb.com/blog/2023-03-02-dbs-on-k8s): Things to consider when running a database on Kubernetes. - [Unstable CI builds and open-source infrastructure](https://questdb.com/blog/2023-03-01-maven-troubleshooting): A story about troubleshooting and fixing an issue in Apache Maven - [QuestDB with Python, Pandas, and SQL in a Jupyter notebook](https://questdb.com/blog/2023-02-22-questdb-play): Interactive Jupyter Lab environment with QuestDB, Python, and time-series energy data. - [UUID: Coordination-Free Unique Keys and Why They are Useful](https://questdb.com/blog/2023-02-10-uuid): Introduction to the UUID data type and coordination-free unique IDs - [Data Integration for Time-Series: ETL, ELT, and CDC](https://questdb.com/blog/2023-02-06-data-integration-strategies-for-tsdb): An overview of popular data integration strategies with a highlight on CDC. - [EXPLAIN Your SQL Query Plan](https://questdb.com/blog/2023-01-26-introducing-explain): Introduction to EXPLAIN command, which can help with performance tuning - [Three SQL Keywords for Finding Missing Data](https://questdb.com/blog/2023-01-24-finding-missing-data-with-questdb): How to use QuestDB's SQL keywords to identify gaps in your database - [Using QuestDB to collect infrastructure metrics](https://questdb.com/blog/2023-01-19-questdb-cloud-metrics): An article with a hands-on example of how QuestDB is using our own database to monitor our Cloud Platform. - [Realtime crypto tracker with QuestDB Kafka Connector](https://questdb.com/blog/2023-01-12-realtime-crypto-tracker-with-kafka-and-questdb): Send real-time cryptocurrency metrics to Kafka topics, ingest to QuestDB, and calculate moving averages with Pandas. - [Change Data Capture with QuestDB and Debezium](https://questdb.com/blog/2023-01-03-change-data-capture-with-questdb-and-debezium): A tutorial demonstrating how to stream data into QuestDB with change data capture via Debezium and Kafka Connect. - [Using Prometheus, Loki, and Grafana to monitor QuestDB in Kubernetes](https://questdb.com/blog/2022-12-13-using-prometheus-loki-grafana-monitor-questdb-kubernetes): How to monitor a QuestDB instance using Loki and Prometheus - [Listen to Your CPU - Full-table Scans Are Fast](https://questdb.com/blog/2022-11-30-full-table-scan-are-fast): Demonstrating the raw speed of modern hardware - [QuestDB 6.6.1 - Dynamic Commits](https://questdb.com/blog/2022-11-25-questdb-6.6.1-dynamic-commits): The detailed story of how QuestDB 6.6.1 increases data freshness - [SQL Extensions for Time Series Data in QuestDB - Part II](https://questdb.com/blog/2022-11-23-sql-extensions-time-series-data-questdb-part-ii): SQL extensions for time series data in QuestDB part II - [QuestDB at Devoxx Belgium 2022](https://questdb.com/blog/2022-11-08-questdb-devoxx-belgium-2022): An overview of QuestDB's participation at Devoxx Belgium this year. - [Data Lifecycle with QuestDB](https://questdb.com/blog/2022-11-02-data-lifecycle-questdb): This tutorial shows ways to downsample data and detach or drop partitions when old data is no longer necessary using QuestDB. - [QuestDB at Big Data LDN 2022](https://questdb.com/blog/2022-10-20-questdb-big-data-ldn): Big Data LDN (London) is the UK’s leading free to attend data & analytics conference and exhibition. This year, Javier Ramirez, Developer Advocate at QuestDB, delivered a talk on "Ingesting A Million Time Series Per Second On A Single Instance". - [DevStories #1: Time-series for sports prediction markets](https://questdb.com/blog/2022-10-03-athletex-interview): This is a brand-new series for which we interviewed different developers in our community. For the post of this series, we interviewed Kevin Kamto, Co-founder at AthleteX. - [Join Hacktoberfest 2022 and contribute to QuestDB!](https://questdb.com/blog/2022-09-30-hacktoberfest-questdb): Hacktoberfest 2022 is starting! We are super excited to meet with other open source contributors and maintainers. To celebrate this, we put together some hints for you to get started. - [Importing 300k rows/sec with io_uring](https://questdb.com/blog/2022-09-12-importing-300k-rows-with-io-uring): QuestDB 6.5 introduces a new `COPY` commands allowing importing large CSV files. This article reveals the story behind it and highlights the exciting benchmark results using this new SQL command. - [Setting up Basic Authentication for QuestDB open source using Nginx](https://questdb.com/blog/2022-08-05-setting-basic-auth-nginx): How to implement Nginx Basic Authentication for QuestDB open source. - [Time Series Forecasting with TensorFlow and QuestDB](https://questdb.com/blog/2022-06-20-forecasting-with-questdb-and-tensorflow): Timeseries is a type of data used to train machine learning models. You may have numerical data for predicting housing prices or classification data for categorizing dog and cat breeds. It's also the special type of data used for training machine learning algorithms where time is the crucial component. - [4Bn rows/sec query benchmark: Clickhouse vs QuestDB vs Timescale](https://questdb.com/blog/2022-05-26-query-benchmark-questdb-versus-clickhouse-timescale): QuestDB 6.3 brings parallel filter execution optimization to our SQL engine allowing us to reduce both cold and hot query execution times quite dramatically. - [How to build a real-time crypto tracker with Redpanda and QuestDB](https://questdb.com/blog/2022-05-25-how-to-build-a-real-time-crypto-tracker-with-redpanda-and-questdb): Analyze cryptocurrency price trends in real-time with Redpanda and QuestDB. - [Enabling Machine Learning in QuestDB with MindsDB](https://questdb.com/blog/2022-04-18-enabling-machine-learning-in-questdb-with-mindsdb): Combine MindsDB and QuestDB for machine learning predictions with SQL. - [Demo of live crypto data streamed with QuestDB and Grafana](https://questdb.com/blog/2022-04-12-demo-live-crypto-data-streamed-with-questdb-and-grafana): Demo of live crypto data streamed with QuestDB and Grafana - [Crypto Volume Profiles with QuestDB and Julia](https://questdb.com/blog/2022-03-29-crypto-volumes-julia-questdb): Build Bitcoin volume curves using Julia and QuestDB to better understand the flow of trading throughout the day. - [Crypto Data Visualization Dashboards with Grafana](https://questdb.com/blog/2022-03-15-cryptocurrency-grafana-questdb): Learn how to using Python to fetch cryptocurrency data from Coinbase, store it in QuestDB, and visualize the data using Grafana. - [How to generate time-series data in QuestDB](https://questdb.com/blog/2022-03-14-mock-sql-timeseries-data-questdb): Learn how to mock timeseries data using built-in SQL functions in QuestDB to generate dummy data for testing and rapid prototyping according to your schemas. - [Calling on our community members to help us support Ukraine](https://questdb.com/blog/2022-03-07-calling-on-our-community-members): We thank all our stakeholders, users and community members for your support during these challenging times. - [Order Flow Imbalance - A High Frequency Trading Signal](https://questdb.com/blog/2022-02-02-order-flow-imbalance): Calculate order flow imbalance and build high-frequency trading signals with QuestDB. - [QuestDB 6.2 January release, SQL JIT compiler](https://questdb.com/blog/2022-01-27-release-sql-jit-compiler): We've released version 6.2 and here are the highlights including SQL JIT compiler, JDK 17 support, SQL and ILP improvements and autocomplete in the Web Console. - [How we built a SIMD JIT compiler for SQL in QuestDB](https://questdb.com/blog/2022-01-12-jit-sql-compiler): QuestDB 6.2.0 brings a brand new JIT (Just-in-Time) compiler as a part of the SQL engine. This post describes our storage model, how we built a JIT compiler for SQL and our plans for improving it in future. - [Our two-year journey to raise $15m in venture capital](https://questdb.com/blog/2022-01-03-two-year-journey-raising-15m-venture-capital): We've raised over $15 million in venture capital to fund development of the fastest open source time series database. This post describes our two-year journey to raising our $12.5m Series A, what we learned along the way, and the pitch deck we used. - [Analyzing Financial Time-Series Data via the Julia Language and QuestDB](https://questdb.com/blog/2021-11-22-high-frequency-finance-introduction-julia-lang): Dean Markwick explores high-frequency finance in Julia and QuestDB: trade prices, returns, autocorrelation, and empirical price impact on crypto data. - [Why I joined QuestDB as a core database engineer](https://questdb.com/blog/2021-11-09-miguel-arregui-working-at-questdb): The story of how Miguel Arregui joined as a software engineer building the fastest open source time series database. - [How we built inter-thread messaging from scratch](https://questdb.com/blog/2021-11-03-interthread): Detailed explanation of QuestDB's thread messaging system. A benchmark also shows the capabilities of this system. - [Real-time stock price dashboard using QuestDB, Python and Plotly](https://questdb.com/blog/2021-11-01-plotly-finnhub-realtime-dashboard): How to schedule tasks in Python, store stock market data in QuestDB, and create beautiful real-time dashboards using Plotly and Dash. - [Demo geospatial and timeseries queries on 250k unique devices](https://questdb.com/blog/2021-10-04-geospatial-timeseries-demo): We now support geospatial data in our time series database by adding geohashes to our type system along with language features to support common operations using this type. - [Join Hacktoberfest 2021 and contribute to QuestDB!](https://questdb.com/blog/2021-10-01-hacktoberfest-questdb): Hacktoberfest 2021 is starting! We are super excited to meet with other open source contributors and maintainers. To celebrate this, we put together some hints for you to get started. - [High frequency finance with Julia and QuestDB](https://questdb.com/blog/2021-09-17-high-frequency-finance-julia-lang): Learn how to use QuestDB as a time series database for high-frequency trading, calculate the limit order book, price impact, trade sign distribution, and other concepts via the Julia programming language. - [Launch a QuestDB droplet in 1-click via the DigitalOcean marketplace](https://questdb.com/blog/2021-08-24-digitalocean-droplet): QuestDB can now be launched on DigitalOcean via 1-Click apps which allows you to get started with a high-performance time series database on the cloud quickly and easily. - [Using Telegraf and QuestDB to store metrics in a time series database](https://questdb.com/blog/2021-07-09-telegraf-and-questdb-for-storing-metrics-in-a-timeseries-database): How to use the Telegraf agent to collect system metrics from DigitalOcean droplets, store the metrics in QuestDB, and perform basic data visualization and SQL queries using a time series database. - [How databases handle 10 million devices in high-cardinality benchmarks](https://questdb.com/blog/2021-06-16-high-cardinality-time-series-data-performance): Most open source time-series databases struggle with high-cardinality data. See what high cardinality means and how to benchmark database performance with it. - [Streaming on-chain Ethereum data to QuestDB](https://questdb.com/blog/2021-04-12-stream-ethereum-data): Learn how to use Infura, Blockchain ETL, and QuestDB to stream Ethereum data to a time series database for visualization and analysis. - [Automating ETL jobs on time series data with QuestDB on Google Cloud Platform](https://questdb.com/blog/2021-03-31-automating-etl-jobs-on-time-series-data-on-gcp): Learn how to build an ETL job using Cloud Functions to extract data, remove personally-identifiable information, and load the transformed time series data into QuestDB. - [Running QuestDB and Prometheus on GKE Autopilot](https://questdb.com/blog/2021-03-18-questdb-and-prometheus-on-gke-autopilot): Learn how Google Kubernetes Engine in Autopilot can run QuestDB and Prometheus with automated backups for a production-ready time series database deployment. - [Real-time stock price alerts using Python, Grafana and QuestDB](https://questdb.com/blog/2021-03-09-realtime-stock-alerts-python-grafana-questdb): Use Python to query stock prices via REST API, stream the results to QuestDB, and configure Slack alerts based on changes in time series data using Grafana. - [Stream heart rate data into QuestDB via Google IoT Core](https://questdb.com/blog/2021-02-05-streaming-heart-rate-data-with-iot-core-and-questdb): An end-to-end demo of a simple IoT system to stream and visualize heart rate data in Grafana via Google Cloud Platform - [A low-code bitcoin ticker built with QuestDB and n8n.io](https://questdb.com/blog/2021-01-18-low-code-bitcoin-ticker-workflow-with-time-series-database): This tutorial shows how to build a bitcoin ticker for ingesting real-time data into QuestDB using n8n.io - [Monitoring the uptime of an application with Python, Nuxt.js and QuestDB](https://questdb.com/blog/2021-01-13-application-uptime-monitoring-with-python-nuxtjs-questdb): This detailed tutorial shows how to use QuestDB in a robust application status page and includes a repository with the example code ready to deploy. - [Building a garbage-free network stack for Kafka streams](https://questdb.com/blog/2020-12-10-garbage-free-stack-for-kafka-streams): Our database's network stack handles multiple TCP connections on a single thread without garbage collection for reliably ingesting time series data. - [Community contribution from Alex Pelagenko improving our HTTP server](https://questdb.com/blog/2020-11-16-http-server-contribution): One of QuestDB’s major contributors, Alex Pelagenko, shares his experience on improving QuestDB’s HTTP server. - [Authentication for InfluxDB line protocol](https://questdb.com/blog/2020-10-20-authentication-for-influx-line-protocol): QuestDB has added authentication for InfluxDB line protocol over TCP - [NYC taxi meter and options pricing](https://questdb.com/blog/2020-10-16-taxi-drivers-are-options-traders): An experiment analyzing the NYC taxi dataset through the eyes of an options trader. - [Why performance matters in time-series data](https://questdb.com/blog/2020-09-24-why-performance-matters): Thoughts on why speed and performance are crucial to time series database ingestion and analytics. - [Fast IoT Stack with QuestDB, MQTT, and Telegraf](https://questdb.com/blog/2020-08-25-fast-iot-stack-with-questdb-mqtt): How to create a simple IoT stack that uses a Mosquitto MQTT Broker, Telegraf and QuestDB. - [Re-examining our approach to memory mapping](https://questdb.com/blog/2020-08-19-memory-mapping-deep-dive): What we learned by re-examining our approach to memory mapping. A low level implementation, as close as possible to the kernel, enabled even greater performance. - [My journey making QuestDB](https://questdb.com/blog/2020-08-06-my-journey-writing-questdb): The detailed story of how the open source time series database QuestDB came to life. - [Demo launch on HackerNews retrospective](https://questdb.com/blog/2020-07-01-we-put-a-sql-database-on-the-internet): What happens when you put a SQL database on the internet? Demo launch on HackerNews retrospective. - [Sending IoT sensor data from Arduino to QuestDB](https://questdb.com/blog/2020-06-05-iot-on-questdb): See how to build an IoT application using Arduino, which sends temperature and humidity sensor data to QuestDB. - [Things we learned about sums](https://questdb.com/blog/2020-05-12-interesting-things-we-learned-about-sums): What we learned implementing Kahan and Neumaier compensated sum algorithms, benchmark and comparison with Clickhouse. - [Aggregating billions of rows per second with SIMD](https://questdb.com/blog/2020-04-02-using-simd-to-aggregate-billions-of-rows-per-second): How SIMD instructions make aggregations faster in QuestDB, including benchmark results and a comparison with Postgres. - [How Airtel XStream Play uses QuestDB for real-time data](https://questdb.com/blog/airtel-xstream-play-case-study): Learn how Airtel XStream Play uses QuestDB to track engagement and device metrics for their rich video media streaming service. - [Aquis Exchange (SIX Group) runs exchange-wide surveillance on QuestDB](https://questdb.com/blog/aquis-case-study): QuestDB is used by Aquis Exchange to store their infrastructure and business metrics in a single place and analyze them in real time across multiple dimensions. - [Copenhagen Atomics trusts QuestDB for real-time monitoring](https://questdb.com/blog/copenhagen-atomics-case-study): Copenhagen Atomics, manufacturer of next generation molten salt reactors, uses QuestDB to monitor their thorium reactors in real time. - [Energetech powers commodity trading strategies with QuestDB](https://questdb.com/blog/energetech-case-study): Energetech uses QuestDB as the backbone of their trading strategies, managing real-time commodity prices and forecasts for energy markets. - [HDFC Bank uses QuestDB for mule account detection across all major 25+ banking channels](https://questdb.com/blog/hdfc-bank-case-study): HDFC Bank, the largest private bank in India, uses QuestDB inside its in-house Real-Time Streaming Platform (RTSP) for real-time mule account detection, sustaining 5,000 to 7,000 transactions per second on a single instance with sub-second query latency. - [OKX relies on QuestDB for exchange-wide analytics](https://questdb.com/blog/okx-case-study): OKX is one of the world's largest cryptocurrency exchanges, handling billions of dollars in daily trading volume and serving millions of users worldwide. - [One Trading runs a regulated 24/7 futures exchange on QuestDB](https://questdb.com/blog/one-trading-case-study): One Trading runs a regulated 24/7 futures exchange on QuestDB: 1.8M orders/sec, 5M+ rows/sec ingestion, real-time surveillance, room to scale. - [Reflexivity switched from InfluxDB to QuestDB](https://questdb.com/blog/reflexivity-case-study): Reflexivity is a SaaS company that uses QuestDB to provide state-of-the-art AI technology to help investors turn Big Data into investment insights. - [Virtual Global Trading leverages QuestDB for efficient energy data management](https://questdb.com/blog/virtual-global-trading-case-study): Virtual Global Trading uses QuestDB to manage time-series data for energy production and consumption, enabling dynamic pricing and efficient energy distribution across smart meters, power plants, and grid infrastructure. - [XRP Ledger uses QuestDB for real-time blockchain analytics](https://questdb.com/blog/xrp-ledger-case-study): The Inclusive Financial Technology Foundation needs fast, modern tooling to keep up with XRP Ledger and the Xahau network as a rapidly evolving L1 blockchain with over 1500 applications. ## Glossary - [ACID Table](https://questdb.com/glossary/acid-table): Comprehensive overview of ACID tables in data systems. Learn how these database tables guarantee data consistency and reliability through Atomicity, Consistency, Isolation, and Durability properties. - [Adaptive Trading Algorithms](https://questdb.com/glossary/adaptive-trading-algorithms): Comprehensive overview of adaptive trading algorithms in financial markets. Learn how these sophisticated systems dynamically adjust their strategies based on changing market conditions. - [AI-Augmented Portfolio Optimization](https://questdb.com/glossary/ai-augmented-portfolio-optimization): Comprehensive overview of AI-augmented portfolio optimization in financial markets. Learn how artificial intelligence enhances modern portfolio theory and improves investment outcomes through advanced data analysis and adaptive strategies. - [Alert Thresholding](https://questdb.com/glossary/alert-thresholding): Comprehensive overview of alert thresholding in time-series monitoring. Learn how this critical technique helps detect anomalies and trigger notifications based on predefined conditions in time-series data. - [Algorithmic Execution Strategies](https://questdb.com/glossary/algorithmic-execution-strategies): Algorithmic execution strategies split large orders into smaller pieces executed by rules over time, cutting market impact and transaction costs across venues. - [Algorithmic Portfolio Rebalancing](https://questdb.com/glossary/algorithmic-portfolio-rebalancing): Comprehensive overview of algorithmic portfolio rebalancing in financial markets. Learn how automated systems maintain target allocations, manage risk, and optimize trading costs across multiple asset classes. - [Algorithmic Risk Controls](https://questdb.com/glossary/algorithmic-risk-controls): Algorithmic risk controls are automated guardrails that monitor trading, block erroneous orders, enforce position limits, and keep automated systems compliant. - [Algorithmic Trading](https://questdb.com/glossary/algorithmic-trading): Comprehensive overview of algorithmic trading in financial markets. Learn how automated trading strategies execute orders using predefined rules, mathematical models, and real-time market data analysis. - [Anomaly Detection in Industrial Systems](https://questdb.com/glossary/anomaly-detection-in-industrial-systems): Comprehensive overview of anomaly detection in industrial systems. Learn how organizations leverage time-series data analysis to identify equipment failures, process deviations, and operational irregularities. - [Anomaly Detection in Time Series Data](https://questdb.com/glossary/anomaly-detection-in-time-series-data): Comprehensive overview of anomaly detection in time series data. Learn how organizations identify unusual patterns and outliers in sequential data to detect anomalies, prevent system failures, and maintain market integrity. - [Anomaly Score](https://questdb.com/glossary/anomaly-score): Comprehensive overview of anomaly scores in time-series analysis. Learn how these numerical metrics quantify the degree of abnormality in data points and their crucial role in anomaly detection systems. - [Apache Iceberg](https://questdb.com/glossary/apache-iceberg): Comprehensive overview of Apache Iceberg, an open table format for huge analytic datasets. Learn how Iceberg manages large-scale data lake tables with atomic transactions, schema evolution, and time travel capabilities. - [Apache Parquet, What It Is and Why to Use It](https://questdb.com/glossary/apache-parquet): Apache Parquet is a columnar storage format. See how it works, its compression and query benefits, and who gains most, with clear examples. - [Append-only Log](https://questdb.com/glossary/append-only-log): Append-only logs add records only at the end, never editing or deleting them, giving time-series databases and event streams durable, ordered data. - [Append-only Storage](https://questdb.com/glossary/append-only-storage): Append-only storage writes new records sequentially without modifying old ones, giving time-series databases fast ingestion, immutability, and simple recovery. - [Atomic Transactions in Financial Systems](https://questdb.com/glossary/atomic-transactions): Comprehensive overview of atomic transactions in financial markets and trading systems. Learn how atomic operations ensure data consistency and reliability in critical financial operations. - [Autocorrelation Function](https://questdb.com/glossary/autocorrelation-function): Comprehensive overview of autocorrelation function (ACF) in time-series analysis. Learn how this statistical tool measures serial correlation and helps identify patterns in sequential data. - [Avro](https://questdb.com/glossary/avro): Comprehensive overview of Apache Avro data serialization. Learn how this compact binary format enables efficient data exchange and schema evolution in time-series systems. - [Backfill](https://questdb.com/glossary/backfill): Comprehensive overview of backfill in time-series databases. Learn how backfilling enables historical data loading, supports data corrections, and maintains data completeness in time-series systems. - [Backpressure Handling](https://questdb.com/glossary/backpressure-handling): Comprehensive overview of backpressure handling in data systems. Learn how this flow control mechanism prevents system overload and ensures reliable data processing in high-volume time-series applications. - [Backtesting](https://questdb.com/glossary/backtesting): Backtesting evaluates trading strategies by simulating their performance on historical market data, gauging viability before risking real capital live. - [BASE Model](https://questdb.com/glossary/base-model): Comprehensive overview of the BASE model in distributed databases. Learn how this consistency model prioritizes availability and scalability over strict consistency, making it particularly relevant for time-series systems. - [Batch Ingestion](https://questdb.com/glossary/batch-ingestion): Comprehensive overview of batch ingestion in time-series databases. Learn how batch processing enables efficient loading of historical data, the tradeoffs between batch and streaming ingestion, and best practices for optimizing batch operations. - [Batch vs. Stream Processing](https://questdb.com/glossary/batch-vs.-stream-processing): Comprehensive overview of batch and stream processing in time-series data systems. Learn how these fundamental data processing paradigms differ and their implications for financial markets and real-time analytics. - [Bayesian Inference in Quant Trading](https://questdb.com/glossary/bayesian-inference-in-quant-trading): Bayesian inference in quant trading updates market beliefs as new data arrives, combining prior knowledge with live data for more robust trading decisions. - [Benchmark Index](https://questdb.com/glossary/benchmark-index): Comprehensive overview of benchmark indices in financial markets. Learn how these standardized market measures serve as performance yardsticks and underlie countless financial products. - [Binomial Option Pricing Model](https://questdb.com/glossary/binomial-option-pricing-model): The Binomial Option Pricing Model values options using a discrete-time tree of up and down price moves, discounting payoffs under risk-neutral probabilities. - [Black-Scholes Model for Option Pricing](https://questdb.com/glossary/black-scholes-model-for-option-pricing): The Black-Scholes Model prices European options with a closed-form formula using underlying price, strike, time, risk-free rate, and volatility. - [Black-Scholes Model Limitations](https://questdb.com/glossary/black-scholes-model-limitations): Black-Scholes model limitations expose gaps between its assumptions and real markets, from constant volatility to frictionless trading, skewing option prices. - [Block Trade Reporting](https://questdb.com/glossary/block-trade-reporting): Comprehensive overview of block trade reporting in financial markets. Learn how large trades are reported to market participants while managing information leakage and market impact. - [Buy-Side vs Sell-Side Trading](https://questdb.com/glossary/buy-side-vs-sell-side-trading): Buy-side firms invest for clients while sell-side firms provide market making, trading, and research. See how their roles shape market structure. - [Capital Asset Pricing Model (CAPM)](https://questdb.com/glossary/capital-asset-pricing-model-capm): Comprehensive overview of the Capital Asset Pricing Model (CAPM). Learn how this fundamental model determines expected returns based on systematic risk and its applications in modern portfolio management. - [Capital Markets Infrastructure](https://questdb.com/glossary/capital-markets-infrastructure): Comprehensive overview of capital markets infrastructure and its critical components. Learn how trading systems, market data networks, and post-trade infrastructure enable modern financial markets. - [Cardinality Estimation](https://questdb.com/glossary/cardinality-estimation): Comprehensive overview of cardinality estimation in databases and time-series systems. Learn how these algorithms approximate distinct value counts efficiently while managing memory usage. - [What Is Change Data Capture (CDC)?](https://questdb.com/glossary/change-data-capture): Want to learn about Change Data Capture (CDC)? Read our glossary on this popular data integration technique and deepen your technical knowledge. - [Clock Drift](https://questdb.com/glossary/clock-drift): Clock drift is the gradual desynchronization of system clocks, skewing timestamps and temporal ordering in time-series and distributed systems. - [Cloud-native Database](https://questdb.com/glossary/cloud-native-database): Comprehensive overview of cloud-native databases. Learn how these modern database systems leverage cloud infrastructure for scalability, resilience, and automated operations. - [Cluster Rebalancing](https://questdb.com/glossary/cluster-rebalancing): Comprehensive overview of cluster rebalancing in distributed databases. Learn how this critical process redistributes data across nodes to maintain optimal performance and reliability. - [Cold Start Query](https://questdb.com/glossary/cold-start-query): Comprehensive overview of cold start queries in database systems. Learn how these initial queries impact performance and strategies for optimization in time-series databases. - [Cold vs Hot Storage](https://questdb.com/glossary/cold-vs-hot-storage): Cold vs hot storage tiers data in time-series databases, keeping recent data on fast media and older data on cheap storage to balance speed and cost. - [Column Pruning](https://questdb.com/glossary/column-pruning): Comprehensive overview of column pruning in time-series databases. Learn how this optimization technique improves query performance by reading only necessary columns from storage. - [What Is a Columnar Database?](https://questdb.com/glossary/columnar-database): What is a columnar database? How is it different than a relational database? Read our glossary and deepen your technical knowledge. - [Columnar File Format](https://questdb.com/glossary/columnar-file-format): Comprehensive overview of columnar file formats in data storage and analytics. Learn how these specialized formats optimize query performance and compression for large-scale data processing. - [Common Table Expression](https://questdb.com/glossary/common-table-expression): Comprehensive overview of Common Table Expressions (CTEs) in databases. Learn how these temporary result sets enhance query readability, enable recursive queries, and improve performance in time-series analysis. - [Compaction](https://questdb.com/glossary/compaction): Comprehensive overview of compaction in time-series databases. Learn how this critical process optimizes storage, improves query performance, and manages data lifecycle in database systems. - [Compression Ratio](https://questdb.com/glossary/compression-ratio): Comprehensive overview of compression ratio in time-series databases and data systems. Learn how compression techniques reduce storage requirements while maintaining data accessibility and query performance. - [Concurrency Control](https://questdb.com/glossary/concurrency-control): Comprehensive overview of concurrency control in database systems. Learn how these mechanisms ensure data consistency when multiple users or processes access and modify data simultaneously. - [Consensus Algorithm](https://questdb.com/glossary/consensus-algorithm): Comprehensive overview of consensus algorithms in distributed systems. Learn how these protocols enable agreement across nodes and ensure data consistency in distributed databases and time-series systems. - [Continuous Auditing](https://questdb.com/glossary/continuous-auditing): Comprehensive overview of continuous auditing in financial systems and time-series databases. Learn how real-time monitoring and automated controls enable ongoing verification of transactions and data integrity. - [Continuous Query Processing](https://questdb.com/glossary/continuous-query-processing): Comprehensive overview of continuous query processing in time-series databases and streaming systems. Learn how these persistent queries enable real-time analytics and monitoring of streaming market data. - [Convexity Adjustments in Interest Rate Derivatives](https://questdb.com/glossary/convexity-adjustments-in-interest-rate-derivatives): Convexity adjustments correct interest rate derivative prices for the non-linear link between bond prices and yields, sharpening fixed-income valuation. - [Convexity Hedging](https://questdb.com/glossary/convexity-hedging): Convexity hedging manages the non-linear link between price and yield in fixed income and options, protecting portfolios against large market moves. - [Copy-on-write](https://questdb.com/glossary/copy-on-write): Copy-on-write (CoW) copies only modified data on change, giving databases consistent point-in-time views while cutting memory and storage overhead. - [Cost-based Optimizer](https://questdb.com/glossary/cost-based-optimizer): Comprehensive overview of cost-based optimizers in database systems. Learn how these sophisticated components evaluate query execution plans to minimize resource usage and improve performance. - [Coupon Bond Pricing Formula](https://questdb.com/glossary/coupon-bond-pricing-formula): The coupon bond pricing formula discounts a bond's coupon payments and principal using yield-curve factors to compute its fair present value. - [Credit Default Swap (CDS) Pricing](https://questdb.com/glossary/credit-default-swap-cds-pricing): Credit Default Swap (CDS) pricing values credit protection using default probability, recovery rates, and interest rates to set the spread. - [Cross-asset Correlation](https://questdb.com/glossary/cross-asset-correlation): Cross-asset correlation measures how stocks, bonds, commodities, and currencies move together, guiding portfolio management, risk, and trading strategy. - [Cross-asset Trading Strategies](https://questdb.com/glossary/cross-asset-trading-strategies): Cross-asset trading strategies trade equities, bonds, currencies, and commodities together, exploiting market correlations to generate returns and manage risk. - [Cross-Border Payment Settlement (Examples)](https://questdb.com/glossary/cross-border-payment-settlement): Cross-border payment settlement completes transactions between parties in different countries, moving and settling funds across currencies and intermediaries. - [Cross-Chain Liquidity Aggregation](https://questdb.com/glossary/cross-chain-liquidity-aggregation): Cross-chain liquidity aggregation pools trading liquidity across multiple blockchains through bridges and routers, cutting fragmentation and improving prices. - [Cross-correlation](https://questdb.com/glossary/cross-correlation): Comprehensive overview of cross-correlation in time-series analysis and financial markets. Learn how this mathematical tool measures relationships between different time series at various time lags. - [Crossed Market](https://questdb.com/glossary/crossed-market): A crossed market occurs when the bid price exceeds the ask price, an anomalous condition signaling market disruption, data issues, or structure inefficiencies. - [Cumulative Sum Control Chart](https://questdb.com/glossary/cumulative-sum-control-chart): A CUSUM control chart accumulates deviations from a target to detect small, persistent shifts in process means, making it ideal for time-series monitoring. - [Dark Pools](https://questdb.com/glossary/dark-pools): Dark pools are private trading venues that match large block orders without public quotes, cutting market impact and information leakage. - [Data Archiving for Time-series Databases](https://questdb.com/glossary/data-archiving-for-time-series-databases): Comprehensive overview of data archiving strategies for time-series databases. Learn how organizations manage historical data retention, optimize storage costs, and maintain data accessibility while ensuring regulatory compliance. - [Data Compression Techniques for Time Series](https://questdb.com/glossary/data-compression-techniques-for-time-series): Data compression techniques for time series cut storage costs while preserving analytical precision, exploiting temporal and numerical patterns in the data. - [Data Integrity Verification](https://questdb.com/glossary/data-integrity-verification): Comprehensive overview of data integrity verification in time-series databases and financial systems. Learn how organizations ensure data accuracy, consistency, and reliability through verification methods and controls. - [Data Lake Query Engine](https://questdb.com/glossary/data-lake-query-engine): Comprehensive overview of data lake query engines. Learn how these specialized systems enable SQL-like querying of raw data stored in data lakes while optimizing for performance and scalability. - [Data Partitioning Strategies](https://questdb.com/glossary/data-partitioning-strategies): Comprehensive overview of data partitioning strategies in time-series databases and financial systems. Learn how partitioning optimizes performance, enables efficient data distribution, and supports high-frequency trading systems. - [Data Retention Policy](https://questdb.com/glossary/data-retention-policy): Comprehensive overview of data retention policies in time-series databases and financial systems. Learn how organizations manage data lifecycle, storage costs, and regulatory compliance through structured retention strategies. - [Data Sharding](https://questdb.com/glossary/data-sharding): Comprehensive overview of data sharding in time-series databases and financial systems. Learn how sharding enables scalable data distribution and high-performance processing across multiple nodes. - [Data Streaming](https://questdb.com/glossary/data-streaming): Comprehensive overview of data streaming in financial systems and time-series databases. Learn how streaming enables real-time data processing, analysis, and decision-making in financial markets. - [What Is Database Partitioning?](https://questdb.com/glossary/database-partitioning): Curious about database partitioning? Visit our glossary page to learn from those who build a database and deepen your technical knowledge. - [Deduplication Key](https://questdb.com/glossary/deduplication-key): A deduplication key combines timestamp and identifying fields to detect and drop duplicate records during time-series ingestion, keeping data accurate. - [Deep Learning for Order Flow Prediction](https://questdb.com/glossary/deep-learning-for-order-flow-prediction): Deep learning for order flow prediction uses neural networks on market microstructure data to forecast order submissions, cancellations, and executions. - [Delta Hedging vs Gamma Hedging](https://questdb.com/glossary/delta-hedging-vs-gamma-hedging): Delta hedging neutralizes directional risk while gamma hedging tames delta's rate of change, giving options portfolios fuller protection from price moves. - [Delta Hedging](https://questdb.com/glossary/delta-hedging): Comprehensive overview of delta hedging in financial markets. Learn how this dynamic hedging strategy neutralizes directional risk in options portfolios using underlying assets or derivatives. - [Delta-Neutral Hedging Strategies](https://questdb.com/glossary/delta-neutral-hedging-strategies): Delta-neutral hedging combines options and underlyings to hold zero directional exposure, rebalancing continuously as prices and Greeks shift. - [Derivatives Pricing Models](https://questdb.com/glossary/derivatives-pricing-models): Derivatives pricing models value options, futures, and swaps using underlying prices, rates, volatility, and time to expiration to gauge fair value and risk. - [Dickey-Fuller Test](https://questdb.com/glossary/dickey-fuller-test): The Dickey-Fuller test checks a time series for a unit root to determine stationarity, a key step in mean-reversion and statistical arbitrage strategies. - [Distributed SQL](https://questdb.com/glossary/distributed-sql): Comprehensive overview of Distributed SQL databases. Learn how these modern systems combine the benefits of traditional relational databases with distributed architecture for scalable, consistent data management. - [Downsampling Strategy](https://questdb.com/glossary/downsampling-strategy): Comprehensive overview of downsampling strategies in time-series data management. Learn how these techniques reduce data volume while preserving essential patterns and insights. - [Downsampling (data Processing)](https://questdb.com/glossary/downsampling): Learn about downsampling, a data reduction technique for summarizing time-series data. Discover how downsampling optimizes storage space, improves query performance, and reveals trends by condensing heart rate and sensor data into manageable intervals for efficient trend analysis and data science applications - [Dynamic Hedging](https://questdb.com/glossary/dynamic-hedging): Dynamic hedging continuously rebalances positions as markets move, keeping risk exposure on target and shielding portfolios from price swings. - [Edge Buffering](https://questdb.com/glossary/edge-buffering): Comprehensive overview of edge buffering in time-series data systems. Learn how this technique manages data flow between edge devices and central systems, optimizing network usage and ensuring data reliability. - [Energy Market Forecasting](https://questdb.com/glossary/energy-market-forecasting): Comprehensive overview of energy market forecasting in commodity markets. Learn how time-series analysis and predictive modeling help traders and utilities anticipate energy price movements and demand patterns. - [Event Batch](https://questdb.com/glossary/event-batch): Comprehensive overview of event batching in time-series databases and streaming systems. Learn how batch processing of events optimizes throughput, reduces system overhead, and manages high-volume data ingestion. - [Event Envelope](https://questdb.com/glossary/event-envelope): Comprehensive overview of event envelope in time-series data processing. Learn how this metadata wrapper structure enables reliable data handling, tracking, and processing across distributed systems. - [Event Sourcing](https://questdb.com/glossary/event-sourcing): Comprehensive overview of event sourcing in time-series systems. Learn how this architectural pattern captures state changes as an immutable sequence of events, enabling robust audit trails and system reconstruction. - [Event Time](https://questdb.com/glossary/event-time): Comprehensive overview of event time in time-series data processing. Learn how event time differs from processing time and its critical role in data analysis, streaming systems, and financial applications. - [Exchange Co-Location Strategies](https://questdb.com/glossary/exchange-co-location-strategies): Exchange co-location places trading servers inside exchange data centers to cut latency, giving HFT firms ultra-low-latency market access and an edge. - [Execution Algorithms](https://questdb.com/glossary/execution-algorithms): Execution algorithms split large orders into smaller pieces executed over time across venues, minimizing market impact and trading costs for optimal prices. - [Execution Slippage Measurement (Examples)](https://questdb.com/glossary/execution-slippage-measurement): Comprehensive overview of execution slippage measurement in financial markets. Learn how traders and institutions quantify trading costs and execution quality through precise slippage analysis. - [Exponential Moving Average](https://questdb.com/glossary/exponential-moving-average): Comprehensive overview of exponential moving average (EMA) in time-series analysis. Learn how this weighted moving average prioritizes recent data and its applications in financial markets and technical analysis. - [Fair Value Models in Trading](https://questdb.com/glossary/fair-value-models-in-trading): Fair value models estimate the theoretical true price of an instrument from market and statistical inputs, powering market making and mispricing signals. - [Fama-French Three-Factor Model](https://questdb.com/glossary/fama-french-three-factor-model): The Fama-French Three-Factor Model extends CAPM with size (SMB) and value (HML) factors to better explain expected returns and portfolio performance. - [Fault Tolerant Systems](https://questdb.com/glossary/fault-tolerant-systems): Comprehensive overview of fault tolerant systems in financial markets and time-series databases. Learn how these critical systems maintain continuous operation despite hardware, software, or network failures. - [Federated Query Engines](https://questdb.com/glossary/federated-query-engines): Federated query engines query and join data across multiple heterogeneous sources through one unified interface, vital for time-series and financial systems. - [File Compaction](https://questdb.com/glossary/file-compaction): Comprehensive overview of file compaction in data lake systems. Learn how this critical process optimizes storage and query performance by consolidating small files into larger ones. - [Fill Probability](https://questdb.com/glossary/fill-probability): Comprehensive overview of fill probability in financial markets. Learn how traders and algorithms estimate the likelihood of order execution and optimize trading strategies based on fill probability analysis. - [Filter Clause](https://questdb.com/glossary/filter-clause): Comprehensive overview of filter clauses in database queries. Learn how these essential query components enable precise data selection and improve query performance through predicate evaluation. - [Financial Instrument Reference Data](https://questdb.com/glossary/financial-instrument-reference-data): Comprehensive overview of financial instrument reference data and its critical role in capital markets. Learn how this foundational data supports trading operations, risk management, and regulatory compliance. - [Financial Risk Modeling](https://questdb.com/glossary/financial-risk-modeling): Financial risk modeling uses statistical methods, models, and historical data to measure potential losses and guide risk management in capital markets. - [Comprehensive Overview of Finite Difference Methods for Option Pricing](https://questdb.com/glossary/finite-difference-methods-for-option-pricing): Comprehensive overview of finite difference methods in options pricing. Learn how these numerical techniques solve partial differential equations for complex derivatives valuation. - [First-Write-Wins (Examples)](https://questdb.com/glossary/first-write-wins): Comprehensive overview of First-Write-Wins in distributed databases. Learn how this concurrency control mechanism resolves write conflicts and ensures data consistency in distributed systems. - [Fixed Income Analytics](https://questdb.com/glossary/fixed-income-analytics): Comprehensive overview of fixed income analytics in financial markets. Learn how quantitative models and time-series analysis help evaluate bond investments, manage risk, and optimize fixed income portfolios. - [Fixed Income Trading Platforms](https://questdb.com/glossary/fixed-income-trading-platforms): Comprehensive overview of fixed income trading platforms in capital markets. Learn how these specialized systems enable electronic bond trading, price discovery, and liquidity aggregation across multiple venues. - [Flash Crashes in Financial Markets](https://questdb.com/glossary/flash-crash): A flash crash is a sudden, severe price drop followed by rapid recovery, driven by algorithmic trading, liquidity vacuums, and cascading order book imbalances. - [Flash Loan Arbitrage](https://questdb.com/glossary/flash-loan-arbitrage): Flash loan arbitrage uses uncollateralized DeFi loans borrowed and repaid in one atomic transaction to exploit price gaps across markets and tighten pricing. - [Forecast Horizon](https://questdb.com/glossary/forecast-horizon): Forecast horizon is how far ahead a time-series model predicts, with longer horizons adding uncertainty that shapes accuracy and model choice. - [What Is Forecasting in Time Series or Statistical Analysis?](https://questdb.com/glossary/forecasting): There ways to perform statistical or time series analysis. This article explains forecasting as a form of time series and statistical analysis. - [Fourier Transform in High Frequency Trading Signal Processing](https://questdb.com/glossary/fourier-transform-in-high-frequency-trading-signal-processing): The Fourier Transform decomposes high-frequency market data into frequency components, letting HFT traders detect cycles, filter noise, and find signals. - [Front Running](https://questdb.com/glossary/front-running): Comprehensive overview of front running in financial markets. Learn how this manipulative trading practice exploits advance knowledge of orders to gain unfair advantages and its impact on market integrity. - [Full Table Scan](https://questdb.com/glossary/full-table-scan): Comprehensive overview of full table scans in database systems. Learn how these operations read entire tables sequentially and their impact on query performance. - [Futures Basis and Cost of Carry Models](https://questdb.com/glossary/futures-basis-and-cost-of-carry-models): Futures basis and cost of carry models link spot and futures prices through financing, storage, and income, explaining futures pricing and arbitrage. - [Gamma Scalping Strategies](https://questdb.com/glossary/gamma-scalping-strategies): Gamma scalping profits from rebalancing delta-hedged option positions as the underlying moves, capturing gains during high-volatility periods. - [GARCH Models and Applications](https://questdb.com/glossary/garch-generalized-autoregressive-conditional-heteroskedasticity-models): GARCH models forecast financial volatility by capturing clustering and persistence in time series, making them essential for risk management and asset pricing. - [Gas Fees Optimization Strategies](https://questdb.com/glossary/gas-fees-optimization-strategies): Gas fee optimization cuts blockchain transaction costs by timing trades, batching operations, and using Layer 2 while keeping execution reliable. - [Geometric Brownian Motion for Asset Prices](https://questdb.com/glossary/geometric-brownian-motion-for-asset-prices): Geometric Brownian Motion (GBM) models asset prices as a continuous stochastic process with log-normal returns, underpinning derivatives pricing. - [Geospatial Time Series Data](https://questdb.com/glossary/geospatial-time-series-data): Geospatial time series data records when and where events occur, enabling spatiotemporal analytics for finance, industry, and tracking use cases. - [Graph Laplacian](https://questdb.com/glossary/graph-laplacian): Comprehensive overview of the Graph Laplacian matrix in network analysis. Learn how this mathematical tool enables structural analysis of interconnected systems and its applications in financial networks. - [Hash Join](https://questdb.com/glossary/hash-join): Comprehensive overview of hash joins in database systems. Learn how this join algorithm optimizes query performance through hash tables and memory utilization. - [Heartbeat Event](https://questdb.com/glossary/heartbeat-event): Comprehensive overview of heartbeat events in time-series systems. Learn how these periodic signals help monitor system health, detect failures, and maintain data quality in streaming architectures. - [Heatmap Aggregation](https://questdb.com/glossary/heatmap-aggregation): Comprehensive overview of heatmap aggregation in time-series data visualization. Learn how this technique condenses large datasets into color-coded visual representations for pattern detection and analysis. - [Hedging Strategies with Futures Contracts](https://questdb.com/glossary/hedging-strategies-with-futures-contracts): Hedging with futures contracts offsets price risk through long and short positions, weighing hedge ratios, basis risk, and cross-hedging across asset classes. - [Hidden Markov Models in Order Flow Prediction](https://questdb.com/glossary/hidden-markov-models-in-order-flow-prediction): Hidden Markov Models infer latent market states from observable order flow, modeling temporal dependencies to predict trading activity and patterns. - [Hidden Orders](https://questdb.com/glossary/hidden-orders): Comprehensive overview of hidden orders in financial markets. Learn how these specialized order types help institutional investors minimize market impact and execute large trades efficiently. - [High Availability](https://questdb.com/glossary/high-availability): Comprehensive overview of high availability (HA) in time-series databases and data systems. Learn how organizations achieve continuous system uptime through redundancy, fault tolerance, and automated failover mechanisms. - [What Is High Cardinality?](https://questdb.com/glossary/high-cardinality): What does high cardinality mean? What is special about high cardinality data? Visit our glossary page to learn more and deepen your technical knowledge. - [High Frequency Data Sampling](https://questdb.com/glossary/high-frequency-data-sampling): Comprehensive overview of high frequency data sampling in financial markets. Learn how high-frequency sampling captures market microstructure and enables sophisticated trading strategies. - [High Frequency Mean Reversion Strategies](https://questdb.com/glossary/high-frequency-mean-reversion-strategies): High-frequency mean reversion strategies trade short-lived price deviations back toward a statistical average using fast execution and statistical models. - [High-frequency Sensor Data](https://questdb.com/glossary/high-frequency-sensor-data): Comprehensive overview of high-frequency sensor data in industrial and financial systems. Learn how organizations capture, process, and analyze rapidly generated sensor measurements across time series applications. - [High-Frequency Trading Risk](https://questdb.com/glossary/high-frequency-trading-risk): High-frequency trading risk covers the operational, technical, and financial hazards of ultra-fast algorithmic trading and how firms control them. - [Histogram Binning](https://questdb.com/glossary/histogram-binning): Histogram binning groups continuous numerical data into discrete intervals to reveal distribution patterns and simplify analysis of large datasets. - [Historical Data Replay](https://questdb.com/glossary/historical-data-replay): Comprehensive overview of historical data replay in financial markets and time-series systems. Learn how this technique enables backtesting, strategy validation, and system testing using recorded market data. - [What Is HyperLogLog (HLL)?](https://questdb.com/glossary/hyperloglog): HyperLogLog (HLL) is a probabilistic data structure that estimates the cardinality of huge datasets within 1-2% error using minimal memory. - [Iceberg Catalog](https://questdb.com/glossary/iceberg-catalog): Comprehensive overview of Iceberg catalogs in data lake architectures. Learn how these metadata management systems enable reliable table tracking and data governance across distributed storage systems. - [Iceberg Orders (Examples)](https://questdb.com/glossary/iceberg-order): Comprehensive overview of iceberg orders in financial markets. Learn how these specialized order types help traders minimize market impact when executing large trades while maintaining price discovery. - [Idempotency](https://questdb.com/glossary/idempotency): Comprehensive overview of idempotency in database operations. Learn how this critical property ensures consistent data states through repeated operations and its importance for reliable data systems. - [Idempotent Write](https://questdb.com/glossary/idempotent-write): Comprehensive overview of idempotent writes in database systems. Learn how idempotency ensures data consistency when handling duplicate write operations, especially critical for time-series data and financial transactions. - [Immutable Data Pattern](https://questdb.com/glossary/immutable-data-pattern): Comprehensive overview of the immutable data pattern in database systems. Learn how this architectural approach optimizes time-series data storage, ensures data integrity, and enables high-performance analytics. - [Implementation Shortfall Analysis (Examples)](https://questdb.com/glossary/implementation-shortfall-analysis): Implementation shortfall measures the gap between a trade's decision-time value and executed value, capturing explicit and implicit costs to gauge execution. - [Implied Volatility Calculation](https://questdb.com/glossary/implied-volatility-calculation): Implied volatility calculation solves the Black-Scholes equation backwards from an option's market price to find the volatility the market expects ahead. - [Implied Volatility Skew](https://questdb.com/glossary/implied-volatility-skew): Implied volatility skew is how options at different strikes show varying implied volatility, revealing tail-risk pricing the Black-Scholes model ignores. - [Implied Volatility Term Structure](https://questdb.com/glossary/implied-volatility-term-structure): The implied volatility term structure maps option implied vol against time to expiration, revealing market expectations of future volatility across horizons. - [Index Scan](https://questdb.com/glossary/index-scan): An index scan retrieves rows by traversing a database index instead of the full table, speeding up queries that match specific criteria in time-series data. - [Indexing Strategy](https://questdb.com/glossary/indexing-strategy): Comprehensive overview of indexing strategies in time-series databases. Learn how different indexing approaches optimize query performance, manage data organization, and balance read/write operations. - [Industrial Data Historian](https://questdb.com/glossary/industrial-data-historian): Comprehensive overview of industrial data historians. Learn how these specialized time-series databases capture, store, and analyze real-time process data in manufacturing and industrial environments. - [Industrial Process Control Data](https://questdb.com/glossary/industrial-process-control-data): Comprehensive overview of industrial process control data in manufacturing and automation systems. Learn how this time-series data enables real-time monitoring, quality control, and process optimization in industrial operations. - [Information Ratio in Quant Trading Performance](https://questdb.com/glossary/information-ratio-in-quant-trading-performance): Comprehensive overview of Information Ratio in quantitative trading performance measurement. Learn how this key metric evaluates trading strategy effectiveness by comparing risk-adjusted excess returns against a benchmark. - [Ingestion Buffer](https://questdb.com/glossary/ingestion-buffer): Comprehensive overview of ingestion buffers in time-series databases and streaming systems. Learn how these temporary storage mechanisms manage data flow and ensure reliable ingestion under varying loads. - [Ingestion Latency](https://questdb.com/glossary/ingestion-latency): Ingestion latency is the delay between when a time-series database receives data and when it becomes queryable, a key metric for real-time streaming systems. - [Ingestion Rate](https://questdb.com/glossary/ingestion-rate): Comprehensive overview of ingestion rate in time-series databases and data systems. Learn how this metric measures data intake velocity and its impact on system performance. - [Ingestion Schema](https://questdb.com/glossary/ingestion-schema): Comprehensive overview of ingestion schema in time-series databases. Learn how these data contracts define structure, validation rules, and expectations for incoming data streams. - [Ingestion Timestamp](https://questdb.com/glossary/ingestion-timestamp): Comprehensive overview of ingestion timestamps in time-series databases. Learn how these metadata markers track when data points enter a system and their critical role in data lineage and processing. - [Inter-Dealer Brokers (Examples)](https://questdb.com/glossary/inter-dealer-brokers): Comprehensive overview of inter-dealer brokers (IDBs) in financial markets. Learn how these specialized intermediaries facilitate trading between dealers and their critical role in market liquidity. - [Interest Rate Swaps and Hedging](https://questdb.com/glossary/interest-rate-swaps-and-hedging): Interest rate swaps exchange fixed for floating payments to manage rate risk. See how these derivatives are priced, executed, and used for hedging. - [Intertemporal Capital Asset Pricing Model (ICAPM)](https://questdb.com/glossary/intertemporal-capital-asset-pricing-model-icapm): The Intertemporal CAPM (ICAPM), from Robert Merton, extends CAPM with multiple risk factors and time-varying investment opportunities for dynamic asset pricing. - [IoT Time-Series Data Storage](https://questdb.com/glossary/iot-time-series-data-storage): Comprehensive overview of IoT time-series data storage. Learn how specialized architectures capture, organize, and retain high-frequency device and sensor data across consumer and industrial IoT, from edge to cloud. - [Irregular Time Intervals](https://questdb.com/glossary/irregular-time-intervals): Comprehensive overview of irregular time intervals in time-series data. Learn how these non-uniform sampling patterns impact data analysis and storage strategies. - [Ito's Lemma in Stochastic Calculus](https://questdb.com/glossary/itos-lemma-in-stochastic-calculus): Ito's Lemma computes the differential of a function of a stochastic process, underpinning Black-Scholes and continuous-time derivatives pricing. - [Join Strategy](https://questdb.com/glossary/join-strategy): Comprehensive overview of join strategies in database systems. Learn how query optimizers select and execute different join methods for optimal query performance. - [JSON Ingestion](https://questdb.com/glossary/json-ingestion): Comprehensive overview of JSON ingestion in time-series databases. Learn how systems efficiently process and store JSON data streams while maintaining high performance and data integrity. - [JSON Lines](https://questdb.com/glossary/json-lines): JSON Lines (JSONL) stores one valid JSON object per line, pairing JSON flexibility with line-oriented parsing for streaming time-series ingestion. - [Jump-Diffusion Models & Merton's Model](https://questdb.com/glossary/jump-diffusion-models-mertons-model): Jump-diffusion models like Merton's add sudden price jumps to Black-Scholes diffusion, capturing real market shocks for options pricing and risk. - [Kalman Filter for Time Series Forecasting](https://questdb.com/glossary/kalman-filter-for-time-series-forecasting): The Kalman filter recursively estimates a system's state from noisy measurements, powering state estimation and signal processing for financial time series. - [Ladders in Financial Markets](https://questdb.com/glossary/ladders): Comprehensive overview of ladders in financial markets. Learn how price ladders display order book depth and enable efficient trading across price levels. - [Lag Function](https://questdb.com/glossary/lag-function): Comprehensive overview of the LAG function in time-series analysis and databases. Learn how this window function accesses previous rows and enables temporal analysis across ordered data sets. - [Lag Operator Notation in Time Series Modeling](https://questdb.com/glossary/lag-operator-notation-in-time-series-modeling): Comprehensive overview of lag operator notation in time series modeling and financial analysis. Learn how this mathematical tool helps express time relationships and develop forecasting models. - [Lakehouse Architecture](https://questdb.com/glossary/lakehouse-architecture): Comprehensive overview of lakehouse architecture in data systems. Learn how this modern paradigm combines data lake storage with database-like performance and reliability. - [Laplace Approximation in Bayesian Statistics](https://questdb.com/glossary/laplace-approximation-in-bayesian-statistics): Comprehensive overview of Laplace Approximation in Bayesian statistics. Learn how this mathematical technique approximates posterior distributions and enables efficient statistical inference in financial modeling. - [Late Arriving Data](https://questdb.com/glossary/late-arriving-data): Late arriving data is time-series points that reach a system after their event timestamp, challenging real-time processing, ordering, and consistency. - [Latency Arbitrage Models](https://questdb.com/glossary/latency-arbitrage-models): Latency arbitrage models are trading strategies that exploit tiny speed advantages and market fragmentation to capture price discrepancies across venues. - [Latency Arbitrage](https://questdb.com/glossary/latency-arbitrage): Latency arbitrage exploits microsecond price gaps across trading venues, using ultra-low-latency data feeds to act before discrepancies resolve. - [Latency Measurement Techniques](https://questdb.com/glossary/latency-measurement-techniques): Comprehensive overview of latency measurement techniques in financial markets and time-series systems. Learn how organizations measure and analyze system response times, network delays, and processing latencies across trading infrastructure. - [Latency Sensitivity in Trading Systems](https://questdb.com/glossary/latency-sensitivity): Comprehensive overview of latency sensitivity in financial markets. Learn how different trading strategies and market participants have varying requirements for execution speed and system responsiveness. - [Layer 1 vs Layer 2 Scaling Tradeoffs](https://questdb.com/glossary/layer-1-vs-layer-2-scaling-tradeoffs): Comprehensive overview of Layer 1 and Layer 2 scaling solutions in blockchain networks. Understand the fundamental tradeoffs between performance, security, and decentralization across different scaling approaches. - [Layer 3 Scaling Solutions](https://questdb.com/glossary/layer-3-scaling-solutions): Layer 3 scaling solutions build on Layer 2 rollups to add app-specific execution, privacy, and cross-chain liquidity while inheriting base-layer security. - [Lead Function](https://questdb.com/glossary/lead-function): Comprehensive overview of the LEAD function in time-series analysis and databases. Learn how this window function accesses future row values for advanced analytics and pattern detection. - [Leader Election](https://questdb.com/glossary/leader-election): Comprehensive overview of leader election in distributed systems. Learn how databases and time-series systems maintain consistency and coordinate operations through automated leadership selection processes. - [Limit Order Book](https://questdb.com/glossary/limit-order-book): A limit order book (LOB) organizes outstanding buy and sell orders by price, driving price discovery and shaping market microstructure in electronic trading. - [Limit Orders in Financial Markets](https://questdb.com/glossary/limit-order): Comprehensive overview of limit orders in financial markets. Learn how limit orders allow traders to specify maximum buying or minimum selling prices, providing price control and liquidity to markets. - [Line Protocol](https://questdb.com/glossary/line-protocol): Comprehensive overview of line protocol in time-series databases. Learn how this text-based format enables efficient ingestion of time-series data through its simple yet powerful structure. - [Liquidity Adjusted Capital Asset Pricing Model](https://questdb.com/glossary/liquidity-adjusted-capital-asset-pricing-model): Comprehensive overview of the Liquidity Adjusted Capital Asset Pricing Model (LCAPM). Learn how this extension of CAPM incorporates trading costs and liquidity risk into asset pricing. - [Liquidity Aggregation](https://questdb.com/glossary/liquidity-aggregation): Liquidity aggregation unifies order books and quotes from many venues so traders reach the best available prices and cut execution costs. - [Locked and Crossed Markets](https://questdb.com/glossary/locked-and-crossed-markets): Comprehensive overview of locked and crossed markets in financial trading. Learn how these market conditions occur, their impact on price discovery, and regulatory implications. - [Log-likelihood Function](https://questdb.com/glossary/log-likelihood-function): Comprehensive overview of log-likelihood functions in statistical analysis. Learn how this mathematical tool enables parameter estimation and model evaluation in time-series and financial applications. - [Log-structured Merge Tree](https://questdb.com/glossary/log-structured-merge-tree): Comprehensive overview of Log-structured Merge Trees (LSM trees) in database systems. Learn how this storage structure optimizes write performance while maintaining efficient reads. - [Low Latency Trading Networks](https://questdb.com/glossary/low-latency-trading-networks): Comprehensive overview of low latency trading networks in financial markets. Learn how specialized network infrastructure enables ultra-fast trading execution and market data distribution. - [Machine Learning for Market Prediction](https://questdb.com/glossary/machine-learning-for-market-prediction): Machine learning for market prediction applies ML models to market data to forecast price moves, spot patterns, and generate trading signals. - [Maker-Taker Model](https://questdb.com/glossary/maker-taker-model): The maker-taker model is an exchange fee structure that rebates liquidity providers and charges liquidity takers to encourage tighter, deeper markets. - [Market Data Feed Handlers](https://questdb.com/glossary/market-data-feed-handlers): Market data feed handlers decode, normalize, and sequence raw exchange feeds into low-latency standardized data for trading systems. - [Market Data Replay System](https://questdb.com/glossary/market-data-replay-system): Comprehensive overview of market data replay systems in trading infrastructure. Learn how these platforms reconstruct exchange feeds from recorded ticks and order books for backtesting, latency analysis, and regulatory trade reconstruction. - [Market Data Time-Series Database](https://questdb.com/glossary/market-data-time-series-database): A market data time-series database stores tick, quote, and order book data keyed by symbol, exchange, and timestamp for trading and surveillance. - [Market Depth Heatmap](https://questdb.com/glossary/market-depth-heatmap): Market depth heatmaps use color gradients to show order book liquidity across price levels, helping traders read support, resistance, and real-time flow. - [Market Depth](https://questdb.com/glossary/market-depth): Market depth shows the volume of buy and sell orders at each price level in the order book, helping traders gauge liquidity and the price impact of trades. - [Market Fragmentation](https://questdb.com/glossary/market-fragmentation): Comprehensive overview of market fragmentation in financial markets. Learn how the proliferation of trading venues affects liquidity, price discovery, and execution strategies. - [Market Impact Cost](https://questdb.com/glossary/market-impact-cost): Market impact cost is the price movement a trade causes itself, the gap between the expected price before execution and prices actually obtained. - [Market Impact Models](https://questdb.com/glossary/market-impact-models): Market impact models estimate how trading moves asset prices, helping traders and algorithms balance execution speed against price deterioration. - [Market Liquidity Risk](https://questdb.com/glossary/market-liquidity-risk): Comprehensive overview of market liquidity risk in financial markets. Learn how this critical risk factor impacts trading costs, execution, and portfolio management across different asset classes. - [Market Making Algorithms (Examples)](https://questdb.com/glossary/market-making-algorithms): Market making algorithms continuously quote two-sided prices to supply liquidity, earning the bid-ask spread while managing inventory and risk across venues. - [Market-Making in Derivatives](https://questdb.com/glossary/market-making-in-derivatives): Comprehensive overview of market-making in derivatives markets. Learn how market makers provide liquidity, manage risk, and contribute to price discovery in options, futures, and other derivative instruments. - [Market Regime Change Detection with ML](https://questdb.com/glossary/market-regime-change-detection-with-ml): Market regime change detection with ML spots shifts in volatility states and trading patterns, letting strategies adapt and risk systems react in time. - [Market Regime Detection Using Hidden Markov Models](https://questdb.com/glossary/market-regime-detection-using-hidden-markov-models): Hidden Markov Models detect market regimes by modeling hidden states and transitions, identifying volatility and trend phases to inform trading strategies. - [Market Replay Systems](https://questdb.com/glossary/market-replay-systems): Market replay systems reconstruct historical order books, trades, and quotes in sequence so teams can backtest strategies and investigate market events. - [Market Surveillance Systems](https://questdb.com/glossary/market-surveillance-systems): Market surveillance systems monitor trading in real time to detect manipulation, insider trading, and abuse, helping firms protect integrity and stay compliant. - [Markowitz Efficient Frontier](https://questdb.com/glossary/markowitz-efficient-frontier): Comprehensive overview of the Markowitz Efficient Frontier in portfolio theory. Learn how this foundational concept helps investors optimize portfolio allocations for maximum return at each level of risk. - [Martingale Pricing Theory](https://questdb.com/glossary/martingale-pricing-theory): Martingale pricing theory shows that in an arbitrage-free market, discounted asset prices follow a martingale under the risk-neutral probability measure. - [Materialization](https://questdb.com/glossary/materialization): Materialization turns complex query results and aggregations into physical tables or views, speeding up repeated reads of historical time-series data. - [Materialized Lake View](https://questdb.com/glossary/materialized-lake-view): Comprehensive overview of materialized lake views in data lakes and lakehouses. Learn how these pre-computed views optimize query performance and enable efficient analytics across large-scale datasets. - [Mean Reversion Trading Strategies](https://questdb.com/glossary/mean-reversion-trading-strategies): Mean reversion trading strategies bet that prices return to their historical average, identifying temporary deviations to enter and exit quantitative positions. - [Mean-Reverting Process in Quant Strategies](https://questdb.com/glossary/mean-reverting-process-in-quant-strategies): Mean-reverting processes model prices that oscillate around a long-term average, powering statistical arbitrage that trades temporary deviations. - [Mean Squared Prediction Error (MSPE)](https://questdb.com/glossary/mean-squared-prediction-error-mspe-in-market-forecasting): Comprehensive overview of Mean Squared Prediction Error (MSPE) in market forecasting. Learn how this statistical measure evaluates prediction accuracy and guides model selection in quantitative trading. - [Mean-Variance Optimization](https://questdb.com/glossary/mean-variance-optimization): Mean-variance optimization, the core of Modern Portfolio Theory, finds portfolio weights that maximize expected return for a given level of risk. - [Memory Mapping](https://questdb.com/glossary/memory-mapping): Memory mapping (mmap) maps files into a process's virtual memory, letting databases read large datasets while the OS handles paging and caching. - [Merge-on-read](https://questdb.com/glossary/merge-on-read): Comprehensive overview of merge-on-read in database systems. Learn how this optimization strategy balances write performance with read complexity by deferring data merging until query time. - [Message Replay](https://questdb.com/glossary/message-replay): Comprehensive overview of message replay in data systems. Learn how this critical feature enables recovery, testing, and analysis of time-series data streams. - [Millisecond Precision](https://questdb.com/glossary/millisecond-precision): Comprehensive overview of millisecond precision in time-series databases and trading systems. Learn how sub-second timestamp granularity enables high-frequency data analysis and real-time applications. - [Minimum Description Length](https://questdb.com/glossary/minimum-description-length): Comprehensive overview of the Minimum Description Length (MDL) principle in data analysis. Learn how this information-theoretic framework enables model selection and complexity control. - [Monte Carlo Path Dependent Option Pricing](https://questdb.com/glossary/monte-carlo-path-dependent-option-pricing): Monte Carlo path-dependent option pricing simulates many random price paths and averages discounted payoffs to value derivatives that depend on price history. - [Monte Carlo Simulations for Derivatives](https://questdb.com/glossary/monte-carlo-simulations-for-derivatives): Comprehensive overview of Monte Carlo simulations in derivatives pricing and risk management. Learn how these computational methods enable complex financial modeling through random sampling and statistical analysis. - [Multi-version Concurrency Control](https://questdb.com/glossary/multi-version-concurrency-control): Comprehensive overview of Multi-version Concurrency Control (MVCC) in database systems. Learn how this concurrency mechanism enables consistent reads without blocking writes through version management. - [Nested Loop Join](https://questdb.com/glossary/nested-loop-join): Comprehensive overview of nested loop joins in database systems. Learn how this fundamental join algorithm operates, its performance characteristics, and optimization techniques for time-series data. - [Network Latency Monitoring](https://questdb.com/glossary/network-latency-monitoring): Comprehensive overview of network latency monitoring in financial markets. Learn how firms measure, analyze, and optimize network performance for trading systems and market data delivery. - [Neural Differential Equations in Financial Time Series](https://questdb.com/glossary/neural-differential-equations-in-financial-time-series): Neural differential equations combine neural networks with differential equations to model continuous-time financial dynamics for forecasting and risk modeling. - [Non-Custodial Prime Brokerage](https://questdb.com/glossary/non-custodial-prime-brokerage): Non-custodial prime brokerage gives institutions leverage and cross-venue liquidity through smart contracts while keeping self-custody of their assets. - [Object Storage](https://questdb.com/glossary/object-storage): Comprehensive overview of object storage in time-series and cloud systems. Learn how this scalable storage architecture manages data as objects rather than files or blocks, enabling efficient large-scale data management. - [The Great Guide to OHLC Candlesticks](https://questdb.com/glossary/ohlc-candlestick): OHLC candlesticks chart open, high, low, and close prices per interval, with clear visual examples of how to read each candle and pattern in under 10 minutes. - [OLAP (Online Analytical Processing)](https://questdb.com/glossary/olap): Comprehensive overview of OLAP (Online Analytical Processing) in data systems. Learn how this analytical approach enables complex querying and analysis of multidimensional data for business intelligence and decision support. - [OLTP vs OLAP vs Time-Series Databases](https://questdb.com/glossary/oltp-vs-olap-vs-time-series-databases): Comprehensive overview of OLTP, OLAP, and time-series databases. Learn how these categories differ in workload, architecture, and when a specialized time-series engine is the right choice versus general transactional or analytical systems. - [OLTP (Online Transaction Processing)](https://questdb.com/glossary/oltp): Comprehensive overview of Online Transaction Processing (OLTP) in database systems. Learn how OLTP handles real-time transaction processing, its characteristics, and its role in operational databases. - [On-Chain vs Off-Chain Settlement](https://questdb.com/glossary/on-chain-vs-off-chain-settlement): On-chain vs off-chain settlement compares blockchain finality with intermediary-based clearing, weighing speed, cost, scalability, and trade risk. - [Open Data Lake](https://questdb.com/glossary/open-data-lake): Comprehensive overview of open data lakes. Learn how vendor-neutral storage, table formats, and query engines combine to enable flexible analytics across time-series and capital markets workloads. - [Open Format Databases](https://questdb.com/glossary/open-format-databases): Comprehensive overview of open format databases. Learn how engines built on open, vendor-neutral file and table formats enable shared storage, flexible compute, and long-term data ownership across analytics systems. - [Optimal Execution Strategies - Almgren-Chriss Model](https://questdb.com/glossary/optimal-execution-strategies-almgren-chriss-model): The Almgren-Chriss model schedules large orders by balancing market impact against timing risk, minimizing total execution cost for optimal trade execution. - [Optimal Stopping Theory in Trading Algorithms](https://questdb.com/glossary/optimal-stopping-theory-in-trading-algorithms): Optimal stopping theory finds the best moment to enter or exit a trade under uncertainty, balancing expected returns against execution costs. - [ORC File](https://questdb.com/glossary/orc-file): Comprehensive overview of ORC (Optimized Row Columnar) file format. Learn how this columnar storage format optimizes data storage and processing in big data systems. - [Order Book Data Storage](https://questdb.com/glossary/order-book-data-storage): Order book data storage persists full limit-order-book depth over time, powering trade reconstruction, microstructure research, and best-execution analytics. - [Order Book Imbalance](https://questdb.com/glossary/order-book-imbalance): Order book imbalance is a microstructure metric measuring the gap between buy and sell interest, signaling short-term price pressure and likely moves. - [Order Execution Algorithms](https://questdb.com/glossary/order-execution-algorithms): Comprehensive overview of order execution algorithms in financial markets. Learn how these automated trading systems optimize trade execution, minimize market impact, and reduce transaction costs. - [Order Flow Imbalance Models](https://questdb.com/glossary/order-flow-imbalance-models): Order Flow Imbalance models quantify net buying versus selling pressure from market orders to explain price formation and predict short-term moves. - [Order Flow Toxicity](https://questdb.com/glossary/order-flow-toxicity): Order flow toxicity measures the adverse selection risk market makers face from informed counterparties, gauged by metrics like VPIN to set spreads and sizing. - [Order Imbalance Strategies](https://questdb.com/glossary/order-imbalance-strategies): Order imbalance strategies trade temporary buy-sell mismatches in the order book to capture alpha and supply liquidity, key for market makers. - [Order Lifecycle](https://questdb.com/glossary/order-lifecycle): The order lifecycle tracks a trading order from creation through execution to settlement, covering each state, transition, and monitoring requirement. - [Order Management System (OMS)](https://questdb.com/glossary/order-management-system-oms): An Order Management System (OMS) runs the trade lifecycle from creation to settlement, handling order routing, compliance, and positions across venues. - [Order Matching Engine](https://questdb.com/glossary/order-matching-engine): An order matching engine pairs buy and sell orders by price-time priority, maintaining the limit order book at the core of electronic trading. - [Order Throttling](https://questdb.com/glossary/order-throttling): Comprehensive overview of order throttling in trading systems. Learn how rate limiting mechanisms protect market infrastructure and ensure fair access while managing system load and preventing abuse. - [Ornstein-Uhlenbeck Process for Mean Reversion](https://questdb.com/glossary/ornstein-uhlenbeck-process-for-mean-reversion): The Ornstein-Uhlenbeck process is a stochastic model pulling values back to a long-term mean, widely used for mean-reversion trading, rates, and volatility. - [Out-of-order Event](https://questdb.com/glossary/out-of-order-event): Comprehensive overview of out-of-order events in time-series data processing. Learn how these temporal anomalies impact data ingestion, analysis, and system design. - [Out-of-order Ingestion](https://questdb.com/glossary/out-of-order-ingestion): Out-of-order ingestion lets a time-series database accept data with timestamps earlier than events already processed, with notable performance trade-offs. - [Outlier Detection](https://questdb.com/glossary/outlier-detection): Comprehensive overview of outlier detection in time-series data analysis. Learn how this technique identifies anomalous patterns, its implementation methods, and applications in financial markets and industrial systems. - [Page Cache](https://questdb.com/glossary/page-cache): Comprehensive overview of page cache in database systems. Learn how this memory management mechanism optimizes disk I/O operations and improves database performance through efficient caching of frequently accessed data pages. - [Pairs Trading Strategy](https://questdb.com/glossary/pairs-trading-strategy): Comprehensive overview of pairs trading strategy in financial markets. Learn how this market-neutral approach exploits price relationships between correlated securities for statistical arbitrage opportunities. - [Partial Autocorrelation Function](https://questdb.com/glossary/partial-autocorrelation-function): Comprehensive overview of the Partial Autocorrelation Function (PACF) in time series analysis. Learn how this statistical tool measures direct relationships between lagged observations while controlling for intermediate effects. - [Partition Pruning](https://questdb.com/glossary/partition-pruning): Comprehensive overview of partition pruning in time-series databases. Learn how this optimization technique improves query performance by skipping irrelevant data partitions. - [Passive vs Aggressive Order Strategies](https://questdb.com/glossary/passive-vs-aggressive-order-strategies): Passive order strategies post liquidity to capture the spread while aggressive strategies take liquidity for immediate fills, shaping cost and market impact. - [Payload Format](https://questdb.com/glossary/payload-format): Comprehensive overview of payload formats in time-series data systems. Learn how data structure specifications enable efficient ingestion, storage, and processing of time-series data. - [Pegged Orders](https://questdb.com/glossary/pegged-orders): Pegged orders automatically adjust their price to track a market reference such as the NBBO, midpoint, or primary exchange, without constant manual updates. - [Percentile Approximation](https://questdb.com/glossary/percentile-approximation): Percentile approximation estimates percentile values from large datasets without scanning every point, balancing accuracy against compute for fast analytics. - [Portfolio Optimization](https://questdb.com/glossary/portfolio-optimization): Comprehensive overview of portfolio optimization in financial markets. Learn how this quantitative approach balances risk and return to construct efficient investment portfolios. - [Portfolio Rebalancing Algorithms](https://questdb.com/glossary/portfolio-rebalancing-algorithms): Portfolio rebalancing algorithms trade automatically to hold target allocations, balancing tracking error, transaction costs, and market impact. - [Position Management Systems](https://questdb.com/glossary/position-management-systems): Comprehensive overview of position management systems in financial markets. Learn how these critical systems track and manage trading positions, risk exposure, and compliance across multiple asset classes. - [Pre-Trade Risk Analytics](https://questdb.com/glossary/pre-trade-risk-analytics): Pre-trade risk analytics evaluate orders before execution, checking portfolio risk, trading limits, and compliance to stop harmful or unauthorized trades. - [Pre-trade Risk Checks](https://questdb.com/glossary/pre-trade-risk-checks): Pre-trade risk checks validate orders in microseconds against position limits, size, price bands, and credit thresholds before they reach the market. - [Predicate Pushdown](https://questdb.com/glossary/predicate-pushdown): Comprehensive overview of predicate pushdown in database optimization. Learn how this query optimization technique improves performance by filtering data early in the execution process. - [Predictive Maintenance Analytics](https://questdb.com/glossary/predictive-maintenance-analytics): Comprehensive overview of predictive maintenance analytics in industrial systems. Learn how time-series data analysis enables proactive equipment maintenance, reduces downtime, and optimizes operational efficiency. - [Principal Component Analysis (PCA) for Portfolio Risk](https://questdb.com/glossary/principal-component-analysis-pca-for-portfolio-risk): PCA for portfolio risk reduces correlated asset returns to a few key factors, revealing the main drivers of risk for sharper portfolio optimization. - [Principal Trading vs Agency Trading](https://questdb.com/glossary/principal-trading-vs-agency-trading): Principal trading commits a firm's own capital and risk, while agency trading executes for clients on commission, differing in risk, execution and impact. - [Principal Trading vs Riskless Principal Trading](https://questdb.com/glossary/principal-trading-vs-riskless-principal-trading): Principal trading takes on market risk by holding positions, while riskless principal trading offsets trades simultaneously to eliminate that risk exposure. - [Probability of Informed Trading (PIN) Models](https://questdb.com/glossary/probability-of-informed-trading-pin-models): PIN models, from Easley and O'Hara, estimate the share of informed trading by decomposing order flow, quantifying information asymmetry and market efficiency. - [Protocol Buffers (Protobuf)](https://questdb.com/glossary/protobuf): Protocol Buffers (Protobuf) is Google's compact binary serialization format, exchanging schema-defined structured data faster than JSON or XML. - [Quantitative Momentum Strategies](https://questdb.com/glossary/quantitative-momentum-strategies): Quantitative momentum strategies use statistical models to capture price trends, combining cross-sectional and time-series signals across timeframes and assets. - [Query Hint](https://questdb.com/glossary/query-hint): Comprehensive overview of query hints in database systems. Learn how these optional directives guide query optimizers to improve performance and execution plans. - [Query Latency](https://questdb.com/glossary/query-latency): Comprehensive overview of query latency in database systems. Learn how query response time impacts system performance, factors affecting latency, and optimization strategies. - [Query Plan](https://questdb.com/glossary/query-plan): Comprehensive overview of query plans in database systems. Learn how databases optimize and execute queries through structured execution strategies and cost-based optimization. - [Query Planner](https://questdb.com/glossary/query-planner): Comprehensive overview of query planners in database systems. Learn how these critical components optimize query execution paths to improve performance and efficiency in time-series and relational databases. - [Query Pushdown](https://questdb.com/glossary/query-pushdown): Query pushdown moves computation closer to data storage, cutting data transfer and speeding queries, especially across large time-series datasets. - [Quote Fade](https://questdb.com/glossary/quote-fade): Comprehensive overview of quote fade in financial markets. Learn how this market microstructure phenomenon impacts liquidity and execution quality, and its implications for trading strategies. - [Quote Stuffing](https://questdb.com/glossary/quote-stuffing): Comprehensive overview of quote stuffing in financial markets. Learn how this manipulative trading practice overwhelms market infrastructure and creates artificial opportunities. - [Radial Basis Function Kernel](https://questdb.com/glossary/radial-basis-function-kernel): The radial basis function (RBF) kernel measures similarity by Euclidean distance, enabling non-linear modeling in SVMs and Gaussian processes. - [Raft Consensus](https://questdb.com/glossary/raft-consensus): Comprehensive overview of the Raft consensus algorithm in distributed systems. Learn how this protocol enables fault-tolerant data replication and consistency across distributed databases. - [Read-after-write Consistency](https://questdb.com/glossary/read-after-write-consistency): Read-after-write consistency guarantees a client can immediately read data it just wrote, keeping updates visible in time-series and real-time applications. - [Real-time Analytics](https://questdb.com/glossary/real-time-analytics): Comprehensive overview of real-time analytics in time-series systems. Learn how organizations process and analyze data as it arrives to enable immediate insights and decision-making. - [Real-time Dashboarding](https://questdb.com/glossary/real-time-dashboarding): Comprehensive overview of real-time dashboarding in time-series systems. Learn how organizations visualize live data streams, monitor metrics, and enable rapid decision-making through dynamic dashboards. - [Real-time Data Ingestion](https://questdb.com/glossary/real-time-data-ingestion): Comprehensive overview of real-time data ingestion in financial markets and time-series systems. Learn how organizations process high-velocity data streams for immediate analysis and decision-making. - [Real-time Data Visualization](https://questdb.com/glossary/real-time-data-visualization): Real-time data visualization renders streaming data through graphics that update continuously, turning live market feeds into instant, actionable insight. - [Real-time Risk Assessment](https://questdb.com/glossary/real-time-risk-assessment): Comprehensive overview of real-time risk assessment in financial markets. Learn how firms monitor and manage risk exposure continuously through automated systems and analytics. - [Real-time Trade Surveillance](https://questdb.com/glossary/real-time-trade-surveillance): Comprehensive overview of real-time trade surveillance in financial markets. Learn how modern monitoring systems detect market manipulation, insider trading, and other compliance violations in real-time. - [Reinforcement Learning for Optimal Market Execution](https://questdb.com/glossary/reinforcement-learning-for-optimal-market-execution): Reinforcement learning for market execution trains AI agents to split large orders, minimizing market impact while improving execution quality. - [Reinforcement Learning in Market Making](https://questdb.com/glossary/reinforcement-learning-in-market-making): Reinforcement learning lets market-making agents learn optimal bid-ask quotes through market interaction, balancing inventory risk against profit via rewards. - [What Is a Relational Database?](https://questdb.com/glossary/relational-database): Relational databases are popular. When should you use one? What is it for? Visit our glossary page to learn more and deepen your technical knowledge. - [Repo Market Liquidity Crisis](https://questdb.com/glossary/repo-market-liquidity-crisis): Comprehensive overview of repo market liquidity crises in financial markets. Learn how these critical funding market disruptions can trigger systemic risks and impact market stability. - [Reservoir Sampling](https://questdb.com/glossary/reservoir-sampling): Comprehensive overview of reservoir sampling in data systems. Learn how this probabilistic algorithm maintains representative samples from data streams with limited memory. - [Risk Management in Swaps Trading](https://questdb.com/glossary/risk-management-in-swaps-trading): Comprehensive overview of risk management practices in swaps trading. Learn how financial institutions monitor, measure, and mitigate risks in swap portfolios through sophisticated quantitative methods and operational controls. - [Risk-Neutral Measure in Derivative Pricing](https://questdb.com/glossary/risk-neutral-measure-in-derivative-pricing): The risk-neutral measure values assets as if investors ignore risk, so every asset earns the risk-free rate, simplifying derivative pricing and hedging. - [Risk Parity Portfolio Construction](https://questdb.com/glossary/risk-parity-portfolio-construction): Comprehensive overview of risk parity portfolio construction in financial markets. Learn how this sophisticated approach allocates assets based on risk contribution rather than capital allocation. - [Risk Reversal in Options Trading](https://questdb.com/glossary/risk-reversal-in-options-trading): A risk reversal pairs a long out-of-the-money call with a short OTM put to express a directional view while offsetting option premium costs. - [Risk Weighted Assets (RWA) Calculation in Basel III](https://questdb.com/glossary/risk-weighted-assets-rwa-calculation-in-basel-iii): Risk Weighted Assets (RWA) under Basel III weight assets by credit, market, and operational risk to set the capital buffers banks must hold. - [Rolling Window Analysis](https://questdb.com/glossary/rolling-window-analysis): Rolling window analysis computes statistics over a sliding time interval, revealing moving averages, regime changes, and evolving patterns in time-series data. - [Rollup Table](https://questdb.com/glossary/rollup-table): Comprehensive overview of rollup tables in time-series databases. Learn how these pre-aggregated tables optimize query performance and manage data at scale through strategic summarization. - [Root Mean Squared Error (RMSE)](https://questdb.com/glossary/root-mean-squared-error): Root Mean Squared Error (RMSE) measures predictive accuracy as the square root of mean squared errors, widely used in time-series and financial forecasting. - [Sampling Resolution](https://questdb.com/glossary/sampling-resolution): Comprehensive overview of sampling resolution in time-series data. Learn how sampling frequency affects data quality, storage requirements, and analytical capabilities in time-series databases. - [Schema Evolution](https://questdb.com/glossary/schema-evolution): Comprehensive overview of schema evolution in time-series databases and data systems. Learn how schema changes are managed while maintaining data access and compatibility. - [Schema on Read](https://questdb.com/glossary/schema-on-read): Comprehensive overview of schema-on-read in data systems. Learn how this flexible approach allows data structure interpretation at query time rather than ingestion time. - [What Is Segmentation in Time- Series or Statistical Analysis?](https://questdb.com/glossary/segmentation): There are many forms of statistical and time series analysis. This article explains segmentation as a form of time series and statistical analysis. - [Sensor Fusion](https://questdb.com/glossary/sensor-fusion): Comprehensive overview of sensor fusion in time-series data systems. Learn how this data integration technique combines multiple sensor inputs to produce more accurate and reliable information. - [Sentiment Analysis in Market Forecasting](https://questdb.com/glossary/sentiment-analysis-in-market-forecasting): Comprehensive overview of sentiment analysis in market forecasting. Learn how this technique processes unstructured data to gauge market sentiment and predict price movements across financial markets. - [Settlement Finality in Trading](https://questdb.com/glossary/settlement-finality-in-trading): Comprehensive overview of settlement finality in financial markets. Learn how this critical concept ensures definitive transfer of ownership and reduces systemic risk in trading systems. - [Shannon Entropy](https://questdb.com/glossary/shannon-entropy): Shannon entropy quantifies uncertainty and information content in data, used in finance to gauge market efficiency and price predictability. - [Shapley Value in Financial Risk Attribution](https://questdb.com/glossary/shapley-value-in-financial-risk-attribution): Comprehensive overview of Shapley Value in financial risk attribution. Learn how this game theory concept helps allocate risk contributions across portfolio components and analyze systemic risk in financial networks. - [Sharpe Ratio vs Sortino Ratio](https://questdb.com/glossary/sharpe-ratio-vs-sortino-ratio): Comprehensive comparison of Sharpe and Sortino ratios in portfolio analysis. Learn how these risk-adjusted return metrics differ and when to use each for performance measurement. - [Signal Smoothing](https://questdb.com/glossary/signal-smoothing): Comprehensive overview of signal smoothing in time-series data analysis. Learn how this technique reduces noise while preserving important trends and patterns in temporal data. - [Simple Moving Average](https://questdb.com/glossary/simple-moving-average): Comprehensive overview of simple moving average (SMA) in time-series analysis. Learn how this fundamental indicator smooths data and its applications in trading and analytics. - [Sketch Algorithm](https://questdb.com/glossary/sketch-algorithm): Comprehensive overview of sketch algorithms in time-series databases and data processing. Learn how these probabilistic data structures enable efficient analysis of large-scale streaming data with bounded memory usage. - [Sliding Window](https://questdb.com/glossary/sliding-window): A sliding window keeps a moving view of the most recent data points as new ones arrive, powering continuous streaming calculations and real-time analytics. - [Slippage and Market Impact Estimation](https://questdb.com/glossary/slippage-and-market-impact-estimation): Slippage and market impact estimation models the gap between expected and actual execution prices, helping traders predict and minimize trading costs. - [Slippage in Financial Markets](https://questdb.com/glossary/slippage): Slippage is the gap between a trade's expected and executed price, driven by liquidity and delay, shaping execution costs and trading strategies. - [Smart Contract-Based Lending](https://questdb.com/glossary/smart-contract-based-lending): Smart contract-based lending uses self-executing blockchain code for trustless borrowing and lending of digital assets, enforcing collateral and liquidation. - [Smart Order Routing (SOR)](https://questdb.com/glossary/smart-order-routing-sor): Smart Order Routing (SOR) optimizes trade execution across fragmented venues, weighing price, liquidity, cost, and latency for best execution. - [Snapshot Isolation](https://questdb.com/glossary/snapshot-isolation): Comprehensive overview of snapshot isolation in database systems. Learn how this concurrency control mechanism enables consistent reads while maintaining high throughput for write operations. - [Sovereign Bond Yield Spreads](https://questdb.com/glossary/sovereign-bond-yield-spreads): Comprehensive overview of sovereign bond yield spreads in financial markets. Learn how these critical indicators measure relative risk between government bonds and their importance in global markets. - [Spectral Analysis for Market Signals](https://questdb.com/glossary/spectral-analysis-for-market-signals): Spectral analysis uses Fourier transforms to decompose market time series into frequency components, revealing cycles and periodicities in price data. - [Spectral Clustering for Regime Changes](https://questdb.com/glossary/spectral-clustering-for-regime-changes): Comprehensive overview of spectral clustering for regime change detection in financial markets. Learn how this machine learning technique helps identify distinct market states and transitions using eigendecomposition of similarity matrices. - [State-space Model](https://questdb.com/glossary/state-space-model): State-space models represent dynamic systems with a state equation for hidden states and an observation equation linking them to measured time-series data. - [Stationarity Test](https://questdb.com/glossary/stationarity-test): Comprehensive overview of stationarity tests in time-series analysis. Learn how these statistical methods assess data stability and support reliable forecasting and modeling. - [Statistical Arbitrage (Stat Arb)](https://questdb.com/glossary/statistical-arbitrage-stat-arb): Comprehensive overview of statistical arbitrage in financial markets. Learn how this quantitative trading strategy leverages mathematical models to identify and profit from price discrepancies across related securities. - [Statistical Power Analysis in Backtesting Models](https://questdb.com/glossary/statistical-power-analysis-in-backtesting-models): Comprehensive overview of statistical power analysis in trading strategy backtesting. Learn how this methodology helps assess the reliability of backtesting results and avoid false discoveries. - [Statistical Risk Models (Examples)](https://questdb.com/glossary/statistical-risk-models): Statistical risk models use historical data and mathematical methods to measure, analyze, and predict portfolio losses via return distributions. - [Stochastic Differential Equations in Finance](https://questdb.com/glossary/stochastic-differential-equations-in-finance): Stochastic differential equations model asset prices, rates, and other variables under uncertainty, underpinning derivatives pricing and risk management. - [Storage Engine](https://questdb.com/glossary/storage-engine): A storage engine is the database component that manages how data is persisted, retrieved, and organized on disk or in memory for different workload patterns. - [Storage Tiering](https://questdb.com/glossary/storage-tiering): Comprehensive overview of storage tiering in time-series databases and data systems. Learn how organizations optimize data storage costs and performance by automatically moving data across different storage tiers based on access patterns and age. - [What Is Stream Processing?](https://questdb.com/glossary/stream-processing): Stream processing? Complex event processing? How does it work? Visit our glossary page to learn more and deepen your technical knowledge. - [Structured Vs. Unstructured Time-Series Data (Examples)](https://questdb.com/glossary/structured-vs.-unstructured-time-series-data): Structured vs unstructured time-series data differ in schema and format, shaping how databases store, query, and analyze financial, industrial, and IoT data. - [Subquery](https://questdb.com/glossary/subquery): Comprehensive overview of subqueries in database systems. Learn how these nested queries enable complex data analysis and how they impact query performance in time-series databases. - [Survival Analysis in Default Risk Estimation](https://questdb.com/glossary/survival-analysis-in-default-risk-estimation): Survival analysis models the time until corporate default, using hazard functions and censored data to estimate credit risk and predict default probability. - [Swap Pricing Formulas](https://questdb.com/glossary/swap-pricing-formulas): Swap pricing formulas value interest rate, currency, and other swaps by discounting future cash flows so the contract starts at zero value for both parties. - [Synthetic Market Data Generation](https://questdb.com/glossary/synthetic-market-data-generation): Comprehensive overview of synthetic market data generation in financial markets. Learn how firms create realistic simulated data for testing, development, and research purposes while maintaining statistical properties of real markets. - [Synthetic Stablecoins](https://questdb.com/glossary/synthetic-stablecoins): Synthetic stablecoins hold their peg through smart contracts, crypto over-collateralization, and economic incentives instead of directly holding fiat reserves. - [Systematic Arbitrage](https://questdb.com/glossary/systematic-arbitrage): Comprehensive overview of systematic arbitrage in financial markets. Learn how quantitative trading strategies identify and exploit price discrepancies across multiple markets and instruments using automated systems. - [Telemetry Data](https://questdb.com/glossary/telemetry-data): Comprehensive overview of telemetry data in time-series databases and IoT systems. Learn how telemetry enables remote monitoring, analysis, and control of systems through automated data collection and transmission. - [Temporal Data Modeling](https://questdb.com/glossary/temporal-data-modeling): Comprehensive overview of temporal data modeling in financial markets and time-series systems. Learn how temporal data models capture time-dependent information and enable historical analysis of market data. - [Temporal Join](https://questdb.com/glossary/temporal-join): A temporal join combines records by time relationships rather than exact matches, correlating misaligned time-series data, as in the ASOF join. - [Term Structure of Interest Rates Vasicek CIR Models](https://questdb.com/glossary/term-structure-of-interest-rates-vasicek-cir-models): Comprehensive overview of term structure models in interest rates. Learn how Vasicek and Cox-Ingersoll-Ross (CIR) models capture interest rate dynamics and enable fixed income valuation. - [Test Error](https://questdb.com/glossary/test-error): Test error measures how a machine learning model performs on unseen holdout data, giving an unbiased estimate of generalization and revealing overfitting. - [Thread Scheduling](https://questdb.com/glossary/thread-scheduling): Comprehensive overview of thread scheduling in database systems. Learn how operating systems and databases manage thread execution to optimize performance and resource utilization. - [Tick Data Storage Architecture](https://questdb.com/glossary/tick-data-storage-architecture): Comprehensive overview of Tick Data Storage Architecture. Learn how trading firms physically organize, compress, and retrieve high-frequency market ticks for analytics, backtesting, and regulatory reconstruction. - [Tick Data (Examples)](https://questdb.com/glossary/tick-data): Tick data is the most granular market data, capturing every price change, trade, and quote update, the foundation of high-frequency trading and analysis. - [Time-based Partitioning](https://questdb.com/glossary/time-based-partitioning): Comprehensive overview of time-based partitioning in time-series databases. Learn how this data organization strategy improves query performance and data management through temporal segmentation. - [Time Bucketing](https://questdb.com/glossary/time-bucketing): Time bucketing groups temporal data into fixed-width intervals, turning raw ticks into candlesticks or hourly averages for efficient time-series aggregation. - [Time-range Filter](https://questdb.com/glossary/time-range-filter): Comprehensive overview of time-range filters in time-series databases. Learn how these essential query constraints enable efficient temporal data analysis by limiting results to specific time intervals. - [What Is Time Series Data Analysis?](https://questdb.com/glossary/time-series-analysis): Time series data analysis is a deep topic. This article outlines the methods and provides links to supporting materials. Learn about the various types of time series data analysis, their use cases, algorithms, and much more. - [Time-Series Compression Algorithms](https://questdb.com/glossary/time-series-compression-algorithms): Time-series compression algorithms shrink temporal data storage with techniques like delta and Gorilla encoding while preserving accuracy and query speed. - [What Is a Time-Series Database? Definition & Examples](https://questdb.com/glossary/time-series-database): Time-series databases (TSDBs) store timestamped data efficiently. See when to use one, how they beat relational databases, and which perform best. - [Time-series Histogram](https://questdb.com/glossary/time-series-histogram): Comprehensive overview of time-series histograms in data analysis. Learn how these statistical visualizations track value distributions over time while enabling efficient storage and analysis of large datasets. - [Time-series Index](https://questdb.com/glossary/time-series-index): Comprehensive overview of time-series indices in databases. Learn how these specialized indexing structures optimize queries and enhance performance for temporal data. - [Time Travel Query](https://questdb.com/glossary/time-travel-query): Comprehensive overview of time travel queries in time-series databases and data systems. Learn how this feature enables access to historical data states and supports data auditing, debugging, and compliance requirements. - [Time-Weighted Average Price (TWAP)](https://questdb.com/glossary/time-weighted-average-price-twap): Time-Weighted Average Price (TWAP) splits an order into equal slices executed at regular intervals to track the average price and cut market impact. - [Timestamp Alignment](https://questdb.com/glossary/timestamp-alignment): Comprehensive overview of timestamp alignment in time-series data processing. Learn how this crucial process ensures data consistency, enables accurate analysis, and supports reliable aggregations across multiple time series. - [Timestamp Precision](https://questdb.com/glossary/timestamp-precision): Timestamp precision sets the smallest time interval a database can distinguish, from seconds to nanoseconds, shaping accuracy, storage, and query performance. - [Timestamp Synchronization (PTP/NTP)](https://questdb.com/glossary/timestamp-synchronization-ptp-ntp): Timestamp synchronization with PTP and NTP coordinates nanosecond-precise time across systems for trade surveillance, sequencing, and regulatory reporting. - [Tombstone Record](https://questdb.com/glossary/tombstone-record): A tombstone record marks data as deleted instead of removing it immediately, keeping distributed and time-series databases consistent until cleanup runs. - [Trade Crossing Networks](https://questdb.com/glossary/trade-crossing-networks): Comprehensive overview of trade crossing networks in financial markets. Learn how these specialized trading venues facilitate large block trades and minimize market impact through anonymous matching mechanisms. - [Trade Execution Quality](https://questdb.com/glossary/trade-execution-quality): Comprehensive overview of trade execution quality in financial markets. Learn how trading firms measure and optimize execution performance through metrics like implementation shortfall, VWAP deviation, and market impact. - [Trade Lifecycle Management](https://questdb.com/glossary/trade-lifecycle-management): Trade lifecycle management covers every stage from order initiation through execution, clearing, settlement, and reporting while managing risk and compliance. - [Trade Surveillance](https://questdb.com/glossary/trade-surveillance): Comprehensive overview of trade surveillance in financial markets. Learn how automated monitoring systems detect market manipulation, insider trading, and other compliance violations through real-time analysis of trading patterns. - [Transaction Cost Analysis in High Frequency Trading](https://questdb.com/glossary/transaction-cost-analysis-in-high-frequency-trading): Comprehensive overview of transaction cost analysis (TCA) in high-frequency trading. Learn how sophisticated analytics measure and optimize trading costs in microsecond environments. - [Transaction Cost Modeling](https://questdb.com/glossary/transaction-cost-modeling): Transaction cost modeling estimates explicit fees and implicit costs like market impact and timing, helping traders optimize execution and trading strategies. - [Transaction Latency Analysis](https://questdb.com/glossary/transaction-latency-analysis): Comprehensive overview of transaction latency analysis in financial markets. Learn how firms measure, monitor, and optimize transaction processing times across trading infrastructure. - [Transaction Timestamping](https://questdb.com/glossary/transaction-timestamping): Transaction timestamping records precise times across a trade's lifecycle, enabling accurate event sequencing, regulatory compliance, and latency analysis. - [Transactional Log](https://questdb.com/glossary/transactional-log): Comprehensive overview of transactional logs in database systems. Learn how these sequential records ensure data integrity, durability, and recovery capabilities in time-series and financial systems. - [Transactional Table](https://questdb.com/glossary/transactional-table): Comprehensive overview of transactional tables in database systems. Learn how these tables support ACID properties, concurrent access, and data consistency guarantees while maintaining historical versions. - [Trend Detection](https://questdb.com/glossary/trend-detection): Trend detection separates persistent directional patterns from noise in time-series data using moving averages, statistical tests, and classification. - [Trend-Following Algorithms](https://questdb.com/glossary/trend-following-algorithms): Trend-following algorithms are systematic strategies that detect price momentum and generate trade signals across timeframes and asset classes. - [Upsert](https://questdb.com/glossary/upsert): Comprehensive overview of upsert operations in database systems. Learn how this atomic operation combines insert and update functionality for efficient data management and time-series data handling. - [Value at Risk (VaR) Models](https://questdb.com/glossary/value-at-risk-var-models): Value at Risk (VaR) models estimate the maximum expected portfolio loss over a time period at a given confidence level, a core market risk metric. - [Variance Gamma Model for Option Pricing](https://questdb.com/glossary/variance-gamma-model-for-option-pricing): Comprehensive overview of the Variance Gamma model in options pricing. Learn how this advanced stochastic process captures market dynamics through gamma-distributed time changes. - [Vectorized Execution](https://questdb.com/glossary/vectorized-execution): Comprehensive overview of vectorized execution in database systems. Learn how this performance optimization technique processes multiple data points simultaneously for improved query efficiency. - [Vectorized Query Execution](https://questdb.com/glossary/vectorized-query-execution): Comprehensive overview of vectorized query execution. Learn how processing data in columnar batches, often with SIMD instructions, accelerates analytical queries, especially for time-series and capital markets workloads. - [Vega Exposure in Options Portfolios](https://questdb.com/glossary/vega-exposure-in-options-portfolios): Comprehensive guide to vega exposure in options portfolios. Learn how this critical risk measure impacts option values and portfolio management in response to volatility changes. - [Versioned Table](https://questdb.com/glossary/versioned-table): Comprehensive overview of versioned tables in data systems. Learn how this table type enables time travel queries, audit trails, and data governance through snapshot-based version control. - [Volatility Arbitrage Strategies](https://questdb.com/glossary/volatility-arbitrage-strategies): Volatility arbitrage strategies trade gaps between implied and realized volatility in options while hedging the underlying to capture volatility risk premiums. - [Volume Profile](https://questdb.com/glossary/volume-profile): Comprehensive overview of volume profile analysis in financial markets. Learn how volume profile visualizations reveal trading activity and price levels of interest through time-series market data analysis. - [Watermarking](https://questdb.com/glossary/watermarking): Comprehensive overview of watermarking in stream processing and time-series data systems. Learn how watermarking helps manage late-arriving data and ensures reliable event-time processing in streaming analytics. - [Wide Table](https://questdb.com/glossary/wide-table): Wide tables store dozens or hundreds of columns per row. See how they pair with columnar storage to shape time-series performance, compression, and queries. - [Windowed Aggregation](https://questdb.com/glossary/windowed-aggregation): Comprehensive overview of windowed aggregation in time-series data processing. Learn how this fundamental technique enables analysis of data within specific time intervals and supports real-time analytics. - [Write Amplification](https://questdb.com/glossary/write-amplification): Write amplification is the ratio of physical data written to disk versus data requested, affecting storage efficiency and hardware life in databases. - [Write Throughput](https://questdb.com/glossary/write-throughput): Comprehensive overview of write throughput in database systems. Learn how this performance metric impacts data ingestion capabilities and system scalability in time-series databases. - [Yield Curve Construction](https://questdb.com/glossary/yield-curve-construction): Yield curve construction builds a continuous term structure of interest rates from market data, underpinning fixed-income pricing, swaps, and risk management. - [Z-score Normalization](https://questdb.com/glossary/z-score-normalization): Z-score normalization rescales data into standard deviations from the mean, making values comparable across scales in time-series and finance. - [Zero-copy Reads](https://questdb.com/glossary/zero-copy-reads): Comprehensive overview of zero-copy reads in database systems. Learn how this optimization technique eliminates unnecessary data copying between memory buffers to improve performance and reduce CPU overhead. - [Zero-Coupon Bond Pricing](https://questdb.com/glossary/zero-coupon-bond-pricing): Comprehensive overview of zero-coupon bond pricing in financial markets. Learn how these fundamental fixed income instruments are valued and their role in yield curve construction and trading strategies. ## Additional Resources - [QuestDB GitHub](https://github.com/questdb/questdb): Open source time-series database - [QuestDB Demo](https://demo.questdb.io/): Interactive demo environment - [QuestDB Slack Community](https://slack.questdb.com/): Join our community