Learn
Blockchain data infrastructure, explained
Guides to blockchain indexers, onchain data APIs, and the infrastructure underneath them. Written by the SQD team.
What Robinhood's tokenized stocks trade against
Robinhood Chain's 195 stock tokens have traded $2.21B through August 30, 2026, read from 200 million raw swap events. Just over half is against dollars and a third against memecoins the registry has never listed. Plus the weekend that ran hotter than the week with no new supply behind it, why three defensible conventions give three different totals, the counterfeit GME trading against the real one, and a Pipes script that reproduces the weekend finding.
The KelpDAO rsETH bridge exploit, reproduced from onchain data
The largest DeFi hack of 2026, traced from public data: the exact transaction, its four-call trace tree, the decoded LayerZero message, and the source-chain reconciliation showing the delivery landed 12 hours before its own send.
MegaETH onchain data: what one second of the chain contains
One hour of MegaETH mainnet read block by block: a clock where the timestamp is the block number plus a constant, 96,403 transactions of which 78% are three fixed-rate services, and a price feed publishing 110 updates per second whose microsecond payload lets you measure a 24.5ms median publish lag on a chain with a one-second block clock.
Monad onchain data: 94 million blocks, and every time the chain retuned itself
Monad mainnet read from block 0: the three times the chain changed its own block time or gas limit, the exact blocks where it happened, the one upgrade that moved both at once while holding capacity flat, and the demand curve those changes tracked.
Robinhood Chain data: what five weeks of mainnet look like onchain
Robinhood Chain's financial ledger reconstructed from raw logs: DEX volume priced by the chain's own pools with no oracle, a $572M stablecoin float with Morpho Blue's $271M netted from transfers, 96 tokenized stocks marked at pool-derived prices, and corporate actions as scheduled log events. Every series from genesis; one Pipes SDK script reproduces the headline number.
Tokenized stocks on Robinhood Chain: equities as ERC-20 tokens
Robinhood issues tokenized stocks as plain ERC-20s on its Arbitrum Orbit L2: the contracts behind TSLA, NVDA, and the SpaceX token, issuance and redemptions at the zero address, and a real after-hours trade read straight from the chain.
ERC-8056: how tokenized stocks split onchain
The scaled-UI standard behind Robinhood stock tokens: uiMultiplier, TransferWithScaledUI, and the first real multiplier changes read from the chain, including a 2:1 adjustment scheduled for a Monday market open.
Verifiable is not complete: validating onchain data beyond proofs
Cryptographic proofs verify the onchain data you have, not whether it is complete. Why proof-based validation misses whole classes of logs, shown with Polygon state-sync, and how to query the full set.
How to validate a blockchain dataset against a second source
Structural checks prove a dataset is well-formed, not complete. The reconciliation method that finds missing rows: count against an independent source, escalate granularity from days to the record. Worked live with Portal and Dune.
eth_getLogs: limits, pagination, and the logs it leaves out
eth_getLogs is the standard way to read events, and the first wall teams hit. The block-range and result caps that force pagination, the archive requirement, and a real block where eth_getLogs omits logs the receipt returns.
What is a Tron indexer?
Tron's TVM emits the same event topics as Ethereum, so decoding is identical, but the request type, the typed-transaction schema, and the energy and bandwidth model differ. The data model, a real TRC-20 query, and what carries over from EVM.
USDT on Tron: querying the largest stablecoin rail
Tron settles more USDT than any other chain. Pull TRC-20 USDT transfers from the Portal in one declarative query, read a real transfer end to end, and see why the energy and bandwidth model lets transfers settle without burning TRX.
Videos and podcasts
Talks, interviews, and podcast episodes from the team building SQD.
More guides land every few weeks. For step-by-step tutorials, browse the documentation. For news and case studies, see the blog.