Extracting deep, long-term insights across blockchain history usually requires running high-cost full-history nodes, maintaining complex indexers, and managing custom analytical databases. To solve this for developers, quantitative analysts, auditors, and project teams, we're launching XRPLWin Analytics at analytics.xrplwin.com
Built as part of our participation in the XRPL Commons "Make Waves" buildathon, XRPLWin Analytics is production infrastructure. It's powered by Apache Superset on top of our fully indexed ClickHouse columnar databases, giving anyone browser-based access to the complete history of both the XRP Ledger (XRPL) and the Xahau Network.
Who This Is For
- Protocol researchers who need to answer "how has X actually behaved since genesis" without running their own indexer
- Project teams who want a live usage dashboard for their token, Hook, or app without building one
- Quant/data analysts who need raw exportable data, not just charts
- Auditors and due-diligence teams tracking issuer behavior, stablecoin flows, or Hook execution history
- Ecosystem observers who just want a fast answer to "what's happening on XRPL/Xahau right now"
Why ClickHouse + Apache Superset
Building on-chain analytics requires two things: sub-second execution over billions of rows, and a workflow that doesn't require writing a data pipeline first.
ClickHouse columnar engine — traditional relational databases struggle aggregating across years of ledger history. ClickHouse scans hundreds of millions of ledger records in milliseconds, so real-time exploration stays real-time even at full history depth. Our pipeline continuously indexes new ledgers, normalizing raw ledger and transaction data into denormalized, query-friendly tables.
Apache Superset BI layer — an enterprise-grade BI platform that lets users move between raw SQL and interactive dashboards without leaving the browser. Superset's dataset abstraction means a query you write once in SQL Lab can become a reusable chart, and that chart can become a dashboard tile, without re-implementing anything.
Core Capabilities
1. Advanced ad-hoc querying with SQL Lab
- Full SQL against complete historical tables — native ClickHouse functions, joins, subqueries, time-series aggregations
- Saved query templates, execution history, safe branching for experimental queries
- Export results to CSV/JSON for downstream modeling in Python, R, or Excel
Because the tables are already indexed for time-series access, queries like this return interactively — no separate ETL step, no waiting on a batch job.
2. No-code visualizations & custom datasets
- Register tables or saved SQL as virtual datasets for custom dimensional models
- 40+ visualization types: time-series lines, area graphs, geographic heatmaps, stacked distributions, pivot tables
- Slice by hour, day, week, month, or custom ledger ranges without touching backend query logic
- Anyone on the team can build on top of a dataset once it's registered — no need to touch SQL again for the next chart
3. Shareable, production-ready dashboards
- Group related charts into unified dashboards
- Global filters (date range, account, currency code) apply live across every chart
- Publish public dashboards or keep private internal views
- Dashboards are just as usable for a one-off investigation as for a permanent monitoring view — save either as a starting point for the next question
Pre-Built & Community Dashboards
We're porting the ecosystem dashboards people already rely on — directly into native XRPLWin Analytics Platform views, so there's a working starting point before you write a single query.
🪙 State of XRPL & Ecosystem Metrics
- Ecosystem overview: active accounts, transaction counts, ledger throughput, network growth
- Useful for: tracking adoption trends, spotting emerging apps by transaction volume, comparing growth across time windows
Example — the XRPL Network Health dashboard, live today: the XRPL is running at 99.24% ledger fill rate, with a peak throughput of 267 TPS. Median transaction fee sits at 0.000012 XRP, average fee at 0.00290239 XRP, and average ledger close time at 4.05 seconds. Total network transactions to date: 4.95B, with 10M XRP burnt in fees over the ledger's history. All of this — down to the single largest ledger by transaction count (2,594 transactions) — is queryable and chartable directly from the dashboard, not a static snapshot.
💵 Stablecoin & RWA Intelligence
- USD & non-USD stablecoin supply, issuer distribution, active holders, velocity, cross-chain flows
- Tokenized real-world assets, commercial paper, yield-bearing tokens
- Useful for: issuer transparency reporting, comparing stablecoin velocity across issuers, monitoring RWA token adoption
🔄 DEX, AMM & Liquidity Analytics
- Aggregate volumes, pool depth, fee generation, active pairs
- Useful for: liquidity providers evaluating pool health, traders assessing slippage risk, researchers studying DEX vs. order-book activity split
⚡ Xahau Hooks & Smart Contracts
- Call volumes, execution success/failure rates, state changes, fee consumption per Hook address
- Useful for: Hook developers debugging execution patterns, auditors reviewing a Hook's real-world behavior before recommending it
Beyond Dashboards: Purpose-Built Lookup Tools
Not everything worth building is a chart. Some of the most useful tools solve a specific gap in what the XRPL RPC/API can answer directly.
Take Regular Key lookups. An XRPL account can assign a Regular Key — an alternate keypair that signs on the account's behalf without exposing the master key, commonly used for security or in custodial/exchange setups where many accounts share operational control. The RPC lets you look up a single account's own RegularKey field via account_info — but there's no way to ask the reverse question, "which accounts have this key set as their Regular Key?" There's no reverse index on the ledger itself.
We built exactly that as a filterable dashboard: a searchable, indexed table of every RegularKey → Account relationship, built from historical ledger data. Enter a Regular Key address, and the table returns every account currently linked to it along with a last-active timestamp — a reverse lookup XRPL nodes can't provide directly, answered instantly instead of requiring a custom indexer.
It's a useful pattern for what else is possible on the platform: any relationship that's easy to query forward but has no reverse index on-ledger is a strong candidate for a purpose-built dashboard like this one.
Complete On-Chain Table Coverage
Core Ledger & Accounts
ledgers, transactions, accounts, activations, account_balance_history, credentials
Tokens & Pools
mpts, mpt_balances, token_balances, token_balance_history, amm_pools, hourly_token_metrics
Xahau Hooks
hooks, hook_actions, hook_execution_metrics, hook_executions_last_3_months
NFT Ecosystem
nfts, nft_history, nft_offers, nft_collections, nft_collection_daily_metrics, nft_collection_daily_volume
Oracles & Aggregations
oracles, daily_metrics, daily_account_tx_counts, hourly_amm_pool_metrics, hourly_mpt_metrics
These aren't raw ledger dumps — every table is pre-joined and pre-aggregated where it matters, so a question like "daily active accounts by week" or "top Hook addresses by fee consumption" is a single query, not a multi-table join you have to design yourself.
Frictionless Access
No software to install, no database to configure:
- Visit analytics.xrplwin.com
- Sign in with Google or Xaman Wallet
- Open SQL Lab to start querying, or jump straight into a pre-built public dashboard
What's Next
Table coverage and pre-built dashboards will keep expanding alongside the explorer platform itself — new Xahau amendments, new token standards, and ecosystem-requested dashboards all feed back into the same pipeline. If there's a dataset or dashboard you'd want to see, that feedback shapes what gets made next.
XRPLWin Analytics is our contribution to the XRPL Commons "Make Waves" buildathon — production-grade data infrastructure for anyone building on XRPL or Xahau.
Start exploring at analytics.xrplwin.com.