New: QuestDB For AI Agents

Learn more

One Trading runs a regulated 24/7 futures exchange on QuestDB

One TradingQuestDB

One Trading is a regulated European derivatives exchange operating under MiFID II and MiCAR. They offer derivatives including dated futures across crypto and equity markets, serving retail, professional, and institutional clients across the EEA with full cross margining and portfolio margining.

One Trading is also the first venue to bring 24/7 central limit order book (CLOB) trading to equity futures, a round-the-clock product that only works if the data platform behind it can keep pace without interruption.

Their matching engine sustains 1.8 million orders per second, with round-trip latency held under 200 microseconds through close work with AWS on cloud-native colocation. Everything downstream depends on the data platform keeping up.

1.8M orders/sec
Sustained throughput from One Trading's matching engine
21B+ rows
Over 21 billion rows across the deployment, 5 billion in the orders table alone
<200µs round-trip
Matching-engine round-trip latency, via cloud-native colocation on AWS

The journey to QuestDB

One Trading's initial stack used Amazon DynamoDB and RDS, and later raw NDJSON files on S3 to keep up with write volume. These worked early on, but as trading activity grew the exchange quickly needed a purpose-built, high-performance database: one that could ingest streaming market data at full speed, serve queries in real time, and scale under ever-growing volumes.

Evaluating alternatives

One Trading evaluated several databases before choosing QuestDB:

SystemIssueLimitation
TimescaleDBPerformanceCould not sustain high-volume ingestion.
Lacks capital-markets SQL primitives
Amazon Timestream
for LiveAnalytics
Cost and performanceNow deprecated by AWS. Cost model
unsuitable, performance a concern
InfluxDBPerformanceCould not sustain high-volume ingestion.
Slow on high-cardinality data

What worked: QuestDB

QuestDB met the requirements the previous architectures could not satisfy simultaneously:

5M+ rows/sec
Constant ingestion straight from the matching engine
99.9% uptime
Sustained under extreme production load
Array support
Explore full order book snapshots with SQL
Distributed architecture
Multi-AZ deployment with automatic failover
Horizontal read scalability
Backed by object-storage-based replication
Direct line to the team
Support from the engineers who built QuestDB

QuestDB is an essential part of our trading platform - giving us a high-speed, scalable store for billions of trades that we can query in real time to power both customer-facing features and internal systems.

Stefan BlackwoodCTO, One Trading
One Trading's QuestDB Enterprise deployment: primary and replica across two AWS availability zones
One Trading's QuestDB Enterprise deployment: primary + replica across two AZs

Results

MetricValue
Total rows21 billion (5 billion in the orders table alone)
HA failover time< 1 second
Production queries served600 million
DowntimeZero

All from a single data platform. The use cases running against this deployment include:

  • Market surveillance - real-time detection of market abuse on the exchange
  • Compliance oversight - regulatory audit trails
  • Regulatory reporting - automated report generation
  • UI queries - powering the exchange frontend
  • Real-time API workloads - serving live data to clients
  • Historical order books - full order book reconstruction
  • Historical trading requests - trade history and audit

As Stefan Blackwood, One Trading's CTO, put it at Future Alpha 2026: "The data platform stopped being the problem."

Business outcomes

Self-hosting QuestDB Enterprise, rather than a usage-priced managed service, reshaped both the economics of the platform and the control One Trading has over it:

  • Predictable, controllable cost - easier to predict as they scale, not a per-query usage-priced bill that jumps with unexpected activity spikes
  • Stable under load - absorbs 1.8M orders per second with room to spare
  • Headroom to scale - more replicas and new products, without re-platforming
  • Data sovereignty - runs in their own cloud, aligned with security, privacy and DORA
  • AI-ready - AI agents interact with QuestDB directly via the REST API, with a Web Console MCP coming in v10
  • No vendor lock-in - open-format Parquet files feed complementary systems

QuestDB is a platform we can plan around. It stays predictable and stable under our full production load, and it scales with us as we grow, which gives us the headroom to bring new products to market.

Steven HarperCSO, One Trading

Trade-offs accepted

One Trading was open about the trade-offs they accepted when adopting QuestDB:

  • AWS deployment documentation was not 100% complete at the time
  • Not ideal for complex relational queries
  • Required good schema design upfront
  • Indexing was still a work in progress

Working through these as a QuestDB Enterprise partner - not just a licensee - meant direct access to the engineering team to resolve gaps, shape the roadmap around real production needs, and get fixes deployed on their timeline. Most of these items have since been addressed in the product, including indexing: the recent QuestDB 9.4.0 release shipped a new posting index for SYMBOL columns.

See also

Subscribe to stay up to date with all things QuestDB.