Indexed PolkadotBlockchain Data
Polkadot is a Layer 0 relay chain that hosts no applications: it finalizes blocks, holds the validator set and passes messages for the parachains connected to it, under BABE and GRANDPA.
How to query Polkadot data with SonarX
Instant Data Share
Available todaySnowflake, and file dumps to your object storage
Query Polkadot 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 Polkadot 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 Polkadot 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 Polkadot address held, either as it stands now or exactly as it stood at a past block or timestamp.
- Real-time balances API for latest and historical balances
- Batch API for wallets, tokens and balances in bulk — on request
Used for:
- Reconstructing Polkadot 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 Polkadot balances on page load
- Compliance checks that read one Polkadot 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 Polkadot 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 Polkadot data behind their own API layer
Polkadot data: frequently asked questions
What is Polkadot?
The Polkadot relay chain produced its genesis block on 26 May 2020 and opened transfers later that year, alongside a redenomination that moved DOT by a factor of a hundred. It is a Layer 0: the relay chain hosts no applications, and instead finalizes blocks, holds the validator set and passes messages for the parachains connected to it, the first of which arrived in December 2021 through slot auctions. Consensus is split in two. BABE assigns block-production slots while GRANDPA finalizes runs of blocks, and the validators doing both are selected by Nominated Proof of Stake, where holders back candidates and share their rewards and their slashing risk. The chain’s own logic is a WebAssembly runtime held as state and replaceable by on-chain vote, so upgrades happen without a hard fork. DOT carries ten decimal places, state changes arrive as extrinsics rather than transactions, and accounts are SS58-encoded, which means one public key displays differently on Polkadot than on Moonbeam.
Polkadot data on SonarX
SonarX indexes relay-chain blocks, extrinsics and the events the runtime emits, balance transfers, nominations and validator sets, era-level staking rewards and slashes, governance and treasury records, and the cross-chain messages moving between connected networks. The same normalized model covers every network SonarX indexes, so relay-chain activity can be joined to parachain activity in one query rather than assembled from separate pipelines.
Full historical coverage is available today as a data-share or a file delivery. Real-time delivery is enabled on request. The real-time balances API is available for Polkadot, and the batch wallets, tokens and balances API can be enabled on request.
How SonarX indexes Polkadot
A block here cannot be read without knowing which runtime produced it. Extrinsics and events are compactly encoded, and their type layout comes from the metadata of the runtime active at that height, so the decoder has to be versioned along the chain and storage migrations have to be replayed in the order they happened. Two other shapes catch people out. An extrinsic can wrap a batch or a proxied call, so the account paying the fee is often not the account acting. And staking rewards are paid per era against nomination shares and commission, never as an ordinary transfer, so a nominator’s income has to be reconstructed rather than summed.
What teams build with Polkadot data
Staking accounting is the workload this chain exists to support. What a nominator actually earned depends on which validators it backed in each era, the commission they charged, and whether either was slashed, and none of that is visible as a transfer. Validator performance research is the second, reading era points, uptime consequences and slashing history to compare operators over long periods. Treasury and governance analysis is the third, since spends, referenda and their outcomes are relay-chain records rather than off-chain decisions. Cross-network position reporting is the fourth, following DOT as it moves between the relay chain and the parachains a holder actually uses. Staking analytics covers the reward side across chains, and Astar is a common second dataset when the question reaches application activity.
Getting Polkadot 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. Relay-chain history is available now, and streaming is provisioned on request. Say which parachains are in scope as well, since most questions that start here do not end here. 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 Polkadot data API?
Yes. The real-time balances API over indexed Polkadot data is available today, covering historical and latest balances, and the batch wallets, tokens and balances API is enabled on request. Both read the same indexed dataset as the Snowflake share, so an API answer and a warehouse query agree.
How do I get Polkadot 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 Polkadot coverage go?
The historical data-share and file delivery cover the relay chain's recorded history from its May 2020 genesis forward, and are available today. Early blocks predate open transfers and the redenomination of DOT, so amounts and account activity from that period need care before they are compared with later figures. Real-time delivery keeps the same dataset current to chain tip and is enabled on request.
Does Polkadot coverage include the parachains?
No. The relay chain and each parachain are separate networks with separate blocks, and this dataset is the relay chain: validators, nominations, era rewards, governance, treasury and the messages passing between chains. Parachains such as Moonbeam and Astar keep their own histories and their own pages, so a question that follows value from the relay chain into an application needs both.
Why do Polkadot extrinsics need a runtime version to decode?
Because the runtime defines the format. Extrinsics and events are compactly encoded, and the type layout that gives them meaning comes from the metadata of the runtime that was active at that block height. Polkadot upgrades its runtime on chain rather than by hard fork, so a call that decoded one way at an early height may be renamed, reshaped or removed later, and a decoder pinned to one version silently misreads the rest.
Does Polkadot run smart contracts?
Not on the relay chain. Its job is block finality, validator selection and message passing, so there is no contract environment there and nothing resembling event logs from application code. Contracts live on parachains, some of which run WebAssembly and some the EVM, and each of those is indexed as its own network rather than folded into this one.