~$ crypto-under-the-hood

# The machinery behind the coins

~/notes / reading on-chain data

How Explorers Index Chains

A block explorer is a database built from chain data. Knowing how it is constructed explains what it can answer and where it can be wrong.

Ivan Kruse · · 2 min

An explorer does not read the chain when you query it. It reads a database built in advance from chain data.

The pipeline

Ingestion. An archive node provides blocks, transactions, receipts and state.

Decoding. Raw transaction data is decoded into readable form using contract ABIs where available. This is why verified contracts show readable function calls and unverified ones show a hex blob.

Indexing. Data is written into structures that make queries fast: by address, by block, by token, by event.

Enrichment. Labels, token metadata, price data and heuristic address clustering are layered on top.

Serving. The web interface and API query the database.

Where errors enter

Labels are heuristic. Identifying an address as belonging to a particular exchange is inference, and it is periodically wrong. Venues also reorganise their wallet structure, which produces apparent flows that are artefacts.

Decoding depends on verification. An unverified contract cannot be decoded, so its interactions appear as raw data.

Token metadata is self-reported. Name and symbol come from the contract and can be anything. Multiple tokens share names deliberately.

Price data comes from external sources with their own methodologies.

Reindexing after reorgs. When a chain reorganises, the explorer must discard and rebuild. Brief inconsistencies during that process are normal.

What is authoritative and what is not

Authoritative: transaction data, block data, balances, contract code. These come directly from the chain and are verifiable independently.

Not authoritative: labels, entity names, token identification, prices, and anything described as an estimate.

The confusion between these two categories produces most of the bad analysis in this sector. A chart of exchange balances is a chart of addresses someone believes belong to exchanges.

The practical consequences

Verify anything important against a second explorer. They use different labelling and different heuristics.

Read raw data when it matters. Every explorer shows the underlying transaction fields.

Treat token identification carefully. Check the contract address, not the name, particularly for anything you are about to buy.

Remember that the explorer is a service. It can be down, wrong, or discontinued. Your own node does not depend on it.

The alternative

Querying a node directly, either your own or a provider’s, gives raw data without the interpretation layer.

That is more work and it is what you should do for anything you intend to act on. For orientation, an explorer is fine, and the distinction is the same one that applies to every derived data source in this sector, including the aggregated volume figures that venues such as a platform with real on-chain withdrawals publish directly and more reliably for their own market.

# Corrections and technical nitpicks are welcome. Send them over. They get published with the fix.

explorersindexingdata

# related notes