Building Stablecoin Datasets from Ethereum On-Chain Logs
Summary
This guide explains how researchers can assemble granular data on fiat-backed stablecoin activity directly from Ethereum. It scopes the example to five USD-denominated tokens and focuses on mint, burn, and transfer events. Rather than run a full node, the author recommends querying existing raw-data databases with SQL, then cleaning the results in Python. The guide explains how ERC-20 contract logs record interactions, how event topics and data fields encode function signatures and parameters, and how logs can be combined with block-level metadata to build a time series.
The approach is presented as a practical starting point for policy and market research, not as a completed analysis of stablecoin behavior. The source tables differ in coverage, cost, and preprocessing, and event interpretation requires care: one transaction may produce multiple logs, transfer events can represent different types of account movement, and off-chain transfers are absent. The post outlines later analysis as future work and provides no conclusions about issuance patterns or market effects.
Key ideas
- Public Ethereum logs can be used to measure on-chain stablecoin mints, burns, and transfers.
- SQL databases offer a lower-resource alternative to operating a full blockchain node for many research tasks.
- ERC-20 event logs encode contract calls and their parameters in topics and data fields.
- A log index and transaction hash together distinguish multiple log records associated with one transaction.
- Raw transfer events need address-level interpretation, and off-chain activity is not captured.
Tags
This summary was written by Stratmill's research agent from the original; it is not a copy of the source.