Learn
Blockchain data infrastructure, explained
Guides to blockchain indexers, onchain data APIs, and the infrastructure underneath them. Written by the SQD team.
Decoding Solana program activity declaratively, including the calls that failed
One declarative query reads Solana program activity by program ID and discriminator, and surfaces the failed and uncommitted calls most tools drop.
An AI-assisted onchain investigation: from an address to a fund-flow path
How an agent triages a wallet, follows the trace, and cites block-level evidence at each hop, with an investigation envelope that names the next step.
RWA monitoring agents: tracking tokenized-asset events across chains
Permissioned tokens emit compliance events a stablecoin never does. Monitor freezes, pauses, and recoveries across every chain an asset lives on.
Stablecoin data: tracking cross-chain flows and peg health
Following stablecoin transfers across every chain they live on with one query model, aligning windows across chains by timestamp, and reading peg health from DEX trades.
Hyperliquid perps data: fills, positions, and realized PnL
The Hyperliquid fills dataset: what a fill record holds, maker and taker fees, realized PnL from closing trades, and how to separate crypto markets from the TradFi and HIP-3 listings on the same venue.
Internal transactions explained: traces and the cost of getting them
What an internal transaction is, why event logs and the transaction list miss it, what a trace record contains, and why traces are one of the most expensive things to pull from an RPC node.
Build a Hyperliquid trader leaderboard with the Pipes SDK
A worked Pipes SDK example: stream the full Hyperliquid fills tape into your own ClickHouse, rank traders by realized PnL, and split volume into crypto versus TradFi markets.
What is onchain analytics?
How blockchain history feeds analytics dashboards. The data pipeline, the common metrics, and how this is done in tools like Dune and in-house BI.
What is a wallet history API?
Address-keyed access to transaction history, balances, and token holdings. What wallets, accounting tools, and tax software need.
Compliance data for crypto: what regulators and investigators look at
Transaction traces, state diffs, attribution data, and the chain-of-custody requirements regulated entities work with. What goes into a Travel Rule submission.
AI agents and onchain data: what an agent needs to act on blockchain state
What an agent actually needs from onchain data, the Model Context Protocol (MCP) pattern, and how on-demand and pre-indexed pipelines differ in agent workflows.
The blockchain data stack in 2026
A reference architecture for onchain data: nodes, indexers, APIs, warehouses, and analytics. The layers, the trade-offs, and named providers at each tier.