Indexed AptosBlockchain Data
Aptos descends from Diem, and on its Move Layer 1 balances live inside typed resources stored under accounts while Block-STM executes a block's transactions in parallel.
How to query Aptos data with SonarX
Instant Data Share
Available todaySnowflake, and file dumps to your object storage
Query Aptos 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 Aptos 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 Aptos 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 Aptos 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 Aptos activity within seconds
- Fraud and anomaly detection that has to fire before settlement
- Live dashboards and alerting on Aptos 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
Curated Datasets
Available todayPurpose-built tables
Protocol-level Aptos datasets modelled for one job, so the decoding and the joins are done before the data reaches you.
- DeFi
Used for:
- Position-level Aptos lending, swap and liquidity analysis
- Reward, delegation and validator reporting without rebuilding the model
- Token distribution, holder and payment-flow reporting
- Risk and exposure work that needs protocol state, not raw logs
- Skipping the decoding layer an in-house team would have to maintain
- Extending an existing Aptos share with a modelled slice
Realtime API
Enabled on requestREST over the indexed dataset
Query indexed Aptos 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 Aptos data behind their own API layer
Aptos data: frequently asked questions
What is Aptos?
Aptos has produced blocks since October 2022, and it descends from Diem: the Move language, the BFT consensus and much of the framework came out of that project. Validators run AptosBFT under proof of stake, and a committed block is final, so there is nothing to unwind and no confirmation depth to count. APT is the native token, divisible into a hundred million octas, and addresses are thirty-two bytes. Where Sui made objects the primitive, Aptos kept accounts and put typed resources under them: a balance is a field inside a resource stored at an account address, and a module’s state lives wherever its resources are held. Execution is parallel through Block-STM, which runs transactions optimistically and re-executes the ones that conflict, so a block’s transactions are ordered without being processed in single file. Two numbering systems coexist. Every transaction carries a global ledger version and a block groups those versions, so height and version are different axes through the same history.
Aptos data on SonarX
SonarX indexes Aptos in the shapes the framework produces: blocks and their transactions, state changes at the resource level, module publications, typed events, coin and fungible-asset movements, staking and delegation records, and derived balances. Everything is normalized into the model SonarX uses across every network it covers, so an Aptos holding and an EVM holding can be compared without rewriting the query for each.
Full historical coverage is available today as a data-share or a file delivery. Real-time delivery is enabled on request. Kafka streaming can be enabled for Aptos on request.
How SonarX indexes Aptos
Three Aptos-specific problems turn up in every project. Balances are not a ledger table: they are fields inside typed resources under an account, so a holder view means reading the right resource type, and the same asset can sit in a coin store and in a fungible-asset store at once, which double counts if both are summed. Events are the second, because older streams are tied to handles with their own counters while newer ones are emitted by modules directly, and a complete series needs both resolved into one. Numbering is the third, since a join on block height and a join on ledger version are not the same join and mixing them loses transactions at the edges.
What teams build with Aptos data
Custody and exchange reconciliation is the first workload, and it stands or falls on resolving the two token representations, because a report that counts a coin store and a fungible-asset store for the same asset states the position twice. Reward and delegation accounting is the second, derived from staking state per epoch rather than from transfers, and staking analytics covers that shape of work across chains. Token distribution analysis is the third, following an asset from minting to the accounts that still hold it. Application analytics is a fourth, built from typed events, which is cleaner than log decoding as long as both event generations are handled. Teams comparing parallel-execution designs usually pull Solana into the same warehouse.
Getting Aptos 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. Aptos history is available now as a share or a file delivery, and streaming is provisioned on request. If asset-level accuracy matters more than raw activity, say so, because that decides how the two token standards are reconciled. 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 Aptos data API?
APIs over indexed Aptos 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 Aptos 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 Aptos coverage go?
The historical data-share and file delivery cover the chain's recorded history from its 2022 mainnet forward, and are available today. Framework standards changed over that period, so early and late records of the same asset can take different forms, and depth is confirmed when the share is scoped.
How does SonarX handle Aptos resources and fungible assets?
By resolving both representations into one view. A holding on Aptos lives inside a typed resource stored under an account, and the framework later added a fungible-asset standard beside the original coin standard, so one asset can sit in two kinds of store at once. Adding them together overstates supply, so SonarX reconciles them rather than reporting each separately.
Do Aptos transactions have block numbers?
They have both a block and a version, and the two are not interchangeable. Every transaction carries a global ledger version, and a block is a batch of those versions, so a join on height and a join on version answer different questions. Analysis that mixes them will silently drop or duplicate transactions at block boundaries.
How is Aptos state different from Sui's?
Aptos kept accounts and stores typed resources under them, so state is addressed by account and type. Sui made the object the primitive, with an owner and a version per object. Both use Move, but a holdings query written for one does not port to the other, which is why SonarX indexes them as two datasets with the same normalized output.