XRP Ledger: Blockchain Analytics at Scale

Case Study

XRP Ledger and the Xahau network leverage QuestDB for time-series data

The Inclusive Financial Technology Foundation (previously XRP Ledger 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, XRP Ledger, and Xahau, the first smart contract sidechain for the XRPL ecosystem, are set to keep growing.

Real-time analytics: Provides real-time analytics on the XRP Ledger Blockchain and Xahau Network.
Efficient querying: Fetches, aggregates, and updates transaction data quickly and easily.
Open source: Selected QuestDB for its high performance and open source code.

Handling vast transaction data

Storing transactions made on the XRP Ledger

A large amount of transaction data is being processed on the XRP Ledger and the Xahau Network. They use QuestDB to provide an API that formats transaction data based on transaction time, enabling user-facing applications to retrieve data in an organized, human-friendly format.

Real-time monitoring: QuestDB enables the XRP Ledger to process vast amounts of transaction data instantly.

Using QuestDB, we deliver time series datasets with real-time market data from a top 10 blockchain. This outperforms a legacy cloud-based data platform at a fraction of the cost, reducing TCO by >90%.

Daniel Siedentopf

Tech Team Lead, Inclusive Financial Technology Foundation

QuestDB SQL

SELECT *
FROM (
  SELECT
    ts AS timestamp,
    first(rate) AS open,
    last(rate) AS close,
    min(rate) AS low,
    max(rate) AS high,
    sum(volume_a) AS base_volume,
    sum(volume_b) AS counter_volume,
    count(*) AS exchanges
  FROM
    offer_exchanges
  WHERE
    pair = 'rhub8VRN6jmDy1pUykJzF3wq+EUR|XRP'
    AND ts >= '2022-12-19T02:35:42.000Z'
    AND ts <= '2024-06-19T13:35:11.169Z'
  SAMPLE BY 1d
  FILL (0,PREV,0,0,0,0,0)
  ALIGN TO CALENDAR
  ORDER BY timestamp DESC
)
WHERE
  timestamp >= '2022-12-19T00:00:00.000Z'
  AND timestamp <= '2024-06-19T00:00:00.000Z'

SQL for comprehensive data retrieval

Fast blockchains, fast queries

This query retrieves 'Candle Stick' market data (OHLC) for the EUR/XRP trading pair on the XRP Ledger. It leverages SAMPLE BY to summarize large datasets into an aggregate of 1D time chunks as part of a SELECT statement. All together, it's organized by time, filled for accuracy and cleanliness, and very fast.

Read SAMPLE BY docs

Reliable data handling

Hardware efficient, clean and tidy

QuestDB lives in XRP Ledger's' architecture for real-time data handling.

Data deduplication: Deduplication ensures clean data ingestion.
SQL simplicity: Query and update predictions using familiar SQL.
Prediction power: High speed and efficiency in data aggregation.

Growing with XRP Ledger

QuestDB powers data insights

With QuestDB, charts and analytics are built for over 46,000 unique trading pairs. Interfacing with the XRP Ledger L1 blockchain and the Xahau Network for smart contracts is demanding work. Together, QuestDB and Inclusive Financial Technology Foundation team are well positioned to handle both present and future growth.

Read the docs

“QuestDB improves the development lifecycle and enables the entire ecosystem to access real-time time series data.”

Daniel Siedentopf — Tech Team Lead, XRP Ledger Foundation

The next generation has arrived

Upgrade to QuestDB

Hyper ingestion, millisecond queries, and powerful SQL.
Lower bills through peak efficiency.

Download