A DEX swap settles its token movement in nested internal calls; an event-log-only feed sees the receipt, not the execution. SQD serves logs, transactions, traces, and state diffs from one endpoint, across 225+ networks, so the path of a swap or a liquidation is in scope, not out of reach.
Track swap, mint, burn, and sync events across AMMs on any EVM chain with one query shape. The same handler reads Uniswap V3 on Ethereum and PancakeSwap on BNB Chain; Solana AMMs use the Solana instruction shape, not EVM logs.
Stream borrow, repay, and liquidation events from Aave, Compound, Morpho, and any lending protocol. Combine state diffs with event logs to recompute collateralization per block, the inputs a liquidation keeper or risk engine runs on.
Full execution traces and state diffs expose the internal calls and storage writes event logs omit. Reconstruct the exact execution order in a block, the swap path, the liquidation path, the value an event-only feed never sees.
Transaction traces and state diffs expose sandwich attacks, arbitrage paths, and front-running. Reconstruct the execution order within a block, including the internal and delegate calls basic event indexing misses entirely.
Most of what a DeFi transaction does happens inside it, not as it. A Uniswap swap routed through three contracts is one submitted transaction and a tree of internal calls underneath; a Compound liquidation moves value through delegate calls across several contracts. An indexer that only reads event logs never sees those calls.
The gap is measurable. Over 20 Ethereum blocks (21,000,000 to 21,000,020), USDC was the direct recipient of 66 transactions but was called 260 times once internal calls are counted. The 194-call difference happened inside transactions aimed at routers, aggregators, and multisigs, and a transaction filter cannot see any of it.
Trace-level data is what production indexers run on: GMX moved multichain perp data off subgraphs, Curvance indexes on Monad, and Levr.Bet runs prediction-market data on SQD.
The query that finds every internal call into a contract filters the trace stream by call type and callee:
Two gotchas: the response nests fields under action (callTo arrives as action.to, the call type as action.callType, which separates a call from a delegatecall), and a trace carries a transactionIndex, not a transaction hash, so to tie a hop to a hash you request the transaction. callValue on each hop is the ETH moved there.
A contract deployment is a create trace, so the same trace stream is a deployment registry. Filter traces by type create and you get the deployer and the new address, including pools created by a factory or by CREATE2 that a transaction list never surfaces as deployments. The first deployment in block 21,000,000:
Deployer 0xcdc1…89b8 created 0x521d…7f23. For DeFi that means tracking a factory's new pools from the trace stream, no hand-maintained address list. The full walkthrough is in the internal transactions guide.
Live queries against real blockchain data. Pick a network, choose a query, hit run.
The public endpoint is free for development. See plans for dedicated portals and higher limits.
Each of these runs on the same SQD data layer.
SQD sits at the extract-and-decode end of the analytics pipeline.
A raw event log is hex-encoded topics and data.
Query any address and get its history: token transfers, native and internal value, NFT movements, and contract calls, across 225+ networks through one query shape.
Onchain, every stablecoin movement is a Transfer event: a mint is a transfer from the zero address, a burn is a transfer to it, a payment is one between two wallets.
A tokenized treasury fund is a regulated security that lives on a public chain.
Most indexers give you event logs.
An agent answers whole-market Hyperliquid perp questions through the same analytics, OHLC, and query tools it uses for every other chain.
One declarative query reads Solana program activity by program ID and discriminator, and surfaces the failed and uncommitted calls most tools drop.
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.
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.
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.
Private Portal. Dedicated. Validated. Managed. Tell us what you're building, we'll show you what it looks like on SQD.