Indexed StellarBlockchain Data
Stellar, a payments Layer 1 under federated Byzantine agreement, closes a ledger every few seconds, holds non-native assets in trustlines and carries its order book in the protocol.
How to query Stellar data with SonarX
Instant Data Share
Available todaySnowflake, and file dumps to your object storage
Query Stellar 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
Used for:
- Analytics teams already on Snowflake that want Stellar 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 Stellar 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
Kafka Streaming
Enabled on requestEvent stream
Consume Stellar activity as a continuous stream of normalized records, produced as the chain is indexed instead of polled for.
Used for:
- Trading and execution systems that act on Stellar activity within seconds
- Fraud and anomaly detection that has to fire before settlement
- Live dashboards and alerting on Stellar wallet or protocol activity
- Feeding a stream processor that already reads from Kafka
- Keeping an internal store hot without waiting for a batch window
- Event-driven services that would otherwise poll on a timer
Balances
Available todayTables and REST
Read what a Stellar 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 Stellar 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 Stellar balances on page load
- Compliance checks that read one Stellar 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 Stellar 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 Stellar data behind their own API layer
Stellar data: frequently asked questions
What is Stellar?
Stellar has closed ledgers since 2014, and since the protocol upgrade of November 2015 it has run on the Stellar Consensus Protocol, a federated Byzantine agreement scheme in which each participant chooses the peers whose agreement it depends on. Ledgers close every few seconds, and a closed ledger is final. The model is accounts rather than outputs, but with a twist that shapes every query: an account holds XLM directly and holds every other asset in a trustline it must open first, subject to a minimum balance set by the network’s base reserve. XLM divides into ten million stroops. Assets are identified by a code plus the account that issued them, not by a contract address, and the ledger itself carries an order book, so offers, path payments and liquidity pools are protocol operations rather than applications, a design it shares with the XRP Ledger. General smart contracts arrived late, with the Soroban environment shipping to mainnet in February 2024. It runs WebAssembly, not the EVM.
Stellar data on SonarX
SonarX indexes closed ledgers, transactions and the operations inside them, payments and path payments, offers and trades from the order book, trustline creation and authorization changes, account settings and balances, and Soroban contract activity. The same normalized model covers every network SonarX indexes, so Stellar payment data can be examined beside other chains’ transfers rather than in a format only this ledger uses.
Full historical coverage is available today as a data-share or a file delivery. Real-time delivery keeps the same dataset current to chain tip. Point-in-time balance tables are available for Stellar. Kafka streaming can be enabled for Stellar on request.
How SonarX indexes Stellar
The operation is the unit of state change here, not the transaction, and one transaction can carry up to a hundred of them, so a transfer view is assembled from operations and their results rather than from transaction rows. Balances are not one field either: XLM sits on the account while every issued asset sits in its own trustline, keyed by code and issuer and carrying authorization flags that can be revoked, so one holder legitimately has many balance records. Path payments then consume offers across the order book, which means a single payment produces trades, and the assets on each side of it differ.
What teams build with Stellar data
This is a payments network, so blockchain payment data here means corridor questions: which issuers moved value, between which anchors, in what asset, and what it cost. Stablecoin and issued-asset reporting is the first workload, and it reads trustlines rather than balances, because holder counts and frozen positions are trustline facts. Treasury and reconciliation work is the second, where an institution holding an issued asset has to restate positions as at a date across accounts it controls. Order-book research is the third, and it is unusual in being protocol-native: offers, trades and path-payment fills are ledger records, not contract logs, so market structure can be studied without decoding anything. Token analytics covers the issuance side across chains, and TRON is the frequent comparison when the subject is stablecoin volume.
Getting Stellar 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. Stellar history is available now, and streaming is provisioned on request. Say which issuers or assets matter most, because that usually decides how far back the ledger actually needs to be read. 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 a Stellar data API?
APIs over indexed Stellar 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 Stellar 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 Stellar coverage go?
The historical data-share and file delivery cover the ledger's recorded history and are available today. Because ledgers have closed every few seconds since 2014, that run holds a very large number of small ledgers, so depth is confirmed against the earliest date a workflow actually needs rather than quoted as a single sequence number. Real-time delivery keeps the same dataset current to chain tip.
How are Stellar assets identified without token contracts?
By a code and an issuer. A non-native asset is the pair of a short asset code and the account that issued it, so two assets can share a code and be entirely unrelated. Holders opt in by opening a trustline, which can be authorized or frozen by the issuer, so supply and holder counts are read from trustline state rather than from a token contract's storage.
How do path payments appear in Stellar data?
As one operation with several settlement legs. A path payment sends one asset and delivers another, filling against offers on the built-in order book along the way, so the sender and receiver amounts are denominated differently and the intermediate hops exist only in the ledger changes the operation produced. Reading only the payment amount understates both the trading activity and the fees involved.
Does Stellar run EVM smart contracts?
No. Stellar carried no general contract environment for most of its life, and the one it gained in February 2024, Soroban, runs WebAssembly rather than EVM bytecode. Solidity contracts do not deploy here, and most economic activity on the network is still expressed through protocol operations such as payments, offers and trustline changes rather than through contract calls.