Indexed XRP LedgerBlockchain Data
The XRP Ledger closes a ledger every few seconds without mining or staking, on a payment Layer 1 of typed transactions, a native order book and assets held in trust lines.
How to query XRP Ledger data with SonarX
Instant Data Share
Available todaySnowflake, and file dumps to your object storage
Query XRP Ledger blockchain data with plain SQL from a live database inside your own Snowflake account, populated with the indexed chain dataset. There is no pipeline to build and no second copy to store. The same dataset ships as file dumps to your own object storage for lakes and warehouses that are not Snowflake.
- Full history as a Snowflake data-share
- File dumps to S3 or your own object storage
- Real-time delivery, current to chain tip — on request
Used for:
- Analytics teams already on Snowflake that want XRP Ledger data beside their existing tables
- Fund accounting and treasury reporting that reconciles against a fixed history
- Cross-chain questions answered in one SQL statement instead of one query per chain
- Loading XRP Ledger history into BigQuery, Databricks, Redshift or a Spark lake
- Replacing a self-hosted indexer and the engineering time that keeps it running
- Serving one governed dataset to several desks without copying it per team
Balances
Available todayTables and REST
Read what a XRP Ledger address held, either as it stands now or exactly as it stood at a past block or timestamp.
- Point-in-time balance tables, as at any block or timestamp
Used for:
- Reconstructing XRP Ledger portfolios and NAV as at a reporting date
- Audit and reconciliation work that has to be repeatable months later
- Wallet and portfolio products that render XRP Ledger balances on page load
- Compliance checks that read one XRP Ledger address at one block height
- Refreshing holdings for a whole book of accounts on a schedule
- Tax and cost-basis workflows that need holdings at each event
Realtime API
Enabled on requestREST over the indexed dataset
Query indexed XRP Ledger records over REST, reading the same dataset the share reads, with no warehouse in the path.
Used for:
- Applications that need one answer rather than a table scan
- Customer-facing screens where query latency is visible to a user
- Services that have no data warehouse and do not want to run one
- Prototyping against production data before committing to a share
- Backend checks that run per request instead of per batch
- Teams that want indexed XRP Ledger data behind their own API layer
XRP Ledger data: frequently asked questions
What is XRP Ledger?
The XRP Ledger has closed ledgers continuously since 2012, without mining and without staking. Validators agree on each version through the XRP Ledger Consensus Protocol, with every participant trusting a published list of validators it has chosen, and a new ledger closes every three to five seconds. All 100 billion XRP were created at the start, none can be issued since, and transaction fees are destroyed rather than paid to anyone, so supply only falls. XRP divides into a million drops. An account is an object in the ledger and must hold a reserve of XRP to exist, so addresses here are created deliberately rather than spun up and abandoned. There is no general-purpose contract VM. Transactions are typed instead: payments, offers on the ledger’s own order book, trust lines, escrows and checks. Issued assets are held in trust lines, a two-sided balance between issuer and holder rather than an entry in a token contract. Protocol changes arrive as amendments that activate only after sustained validator support, and two of them shape recent data: XLS-20 brought native NFTs in 2023 and an automated market maker followed in 2024.
XRP Ledger data on SonarX
SonarX indexes closed ledgers, typed transactions and their metadata, account objects, trust lines, order-book offers and the balances derived from all of it. Everything is normalized into the model SonarX uses across every network it covers, so an XRP Ledger question and a Stellar question can be answered in the same query language even though the two ledgers record assets differently.
Full historical coverage is available today as a data-share or a file delivery. Real-time delivery is enabled on request. Point-in-time balance tables are available for XRP Ledger.
How SonarX indexes XRP Ledger
Each close publishes a complete state tree, so the meaningful records are the differences between consecutive ledgers together with the metadata every transaction carries about the objects it touched. Balances take two forms and both have to be handled: XRP sits on the account object and is partly locked by reserves, while issued assets sit in trust lines whose balance is defined against a particular issuer, so a spendable position is a calculation rather than a field. Amendments are the third consideration, because they change transaction and object shapes partway through the history, and decoding has to be version-aware rather than assume today’s format applies to 2015.
What teams build with XRP Ledger data
The requests here come from payments and treasury teams. Corridor analysis is the first: following value between issuers, exchanges and end accounts to see where flow actually goes, which needs payments and trust-line changes together rather than transfer counts. Issuer monitoring is the second, since every issued asset is somebody’s liability and its outstanding balance is the sum of the trust lines that hold it. Reconciliation is the third, restating account positions as at a ledger with reserves netted out, which auditors ask for in exactly those terms. Market-structure work on the native order book is the fourth, now that pooled liquidity sits beside it. Token analytics covers the issuance side across chains, and Tempo comes up whenever a team is comparing payment rails built on different execution models.
Getting XRP Ledger data from SonarX
Tell us the delivery target, how far back you need and how fresh it has to be, and the share is scoped against that. XRP Ledger history is available now as a share or a file delivery, and streaming is provisioned on request. The published coverage matrix for every network SonarX indexes lives in the data documentation, and the rest of the catalogue is at all indexed chains.
Is there an XRP Ledger data API?
APIs over indexed XRP Ledger data are enabled on request: the same indexed dataset the Snowflake share reads, served over REST once provisioned. Tell us the lookup pattern you need.
How do I get XRP Ledger data into Snowflake?
SonarX provisions a data-share into your own Snowflake account. The share appears as a database you query with SQL, so there is no pipeline to build and no second copy to store, and it stays current as SonarX advances the indexing pipeline.
How far back does XRP Ledger coverage go?
The historical data-share and file delivery cover the ledger's recorded history and are available today. There is a documented limit that has nothing to do with indexing: the earliest ledgers were lost in 2012, so the public record begins at ledger 32570 in early 2013, and no provider can supply what precedes it. Depth from that point is confirmed when the share is scoped.
How are XRP Ledger trust lines and issued assets represented?
As relationships, not as token balances. XRP itself sits on the account object, but every issued asset is held in a trust line, a two-sided record between an issuer and a holder with its own limit and balance. A holder's position in an asset is therefore defined against a specific issuer, and two assets with the same code from different issuers are different things.
Does the XRP Ledger run smart contracts?
Not in the sense an EVM chain does. There is no general-purpose contract VM and no bytecode to deploy. Transactions are typed instead, with payments, order-book offers, trust lines, escrows and checks each carrying defined fields, so analysis reads transaction types and ledger objects rather than decoded event logs.
Is the XRP Ledger the same thing as Ripple?
No. Ripple is a company that builds on the ledger and holds XRP; the XRP Ledger is the public chain itself, run by independent validators; XRP is the native asset. This page is about the ledger's data. Nothing in it comes from a company's internal systems, and no single organization controls which transactions are recorded.
How does the XRP Ledger's built-in exchange appear in the data?
As ledger objects and typed transactions. Offers placed on the native order book are objects that persist until they are filled, canceled or expire, and the automated market maker added in 2024 introduces pools that sit in the same state tree. Trading history on this chain is therefore reconstructed from state changes rather than from contract events.
How do I start with XRP Ledger data?
Tell SonarX the delivery target, the history depth and the refresh cadence you need, and the share is scoped against that. There is no self-serve signup: every engagement is provisioned, so the first conversation is about scope rather than credentials.