Ethereum Data Guides
ArticlesDeep dives into Ethereum data — from raw tables to decoded events, ERC standards, and DeFi analytics.
By Andrew Hong
Latest Articles
How to Analyze Thousands of Transactions During a Live Hack
Mar 24, 2026
Herd MCP: Performing Onchain Research, Due Diligence, and Validation
Feb 23, 2026
Unwrapping DeFi: The Evolution of Tokens, Pools, and Vaults
Oct 27, 2025
Vibe Coding a Batch Swap App using 0x, Dune, and EIP5792/7702
Aug 28, 2025
Explore Clanker (Token Launchpad) and Build an App without Coding
Aug 16, 2025
![[2025 Annual Guide] Crypto Data Engineering Guide - Ethereum Data Guides](https://substackcdn.com/image/fetch/$s_!Y8c_!,w_1200,h_675,c_fill,f_jpg,q_auto:good,fl_progressive:steep,g_auto/https%3A%2F%2Fsubstack-post-media.s3.amazonaws.com%2Fpublic%2Fimages%2F779daefa-861c-4adf-8d82-72a3fdffe16e_2100x1904.jpeg)
[2025 Annual Guide] Crypto Data Engineering Guide
Jan 6, 2025
How to Navigate Contract Code (Solidity) as an Analyst
Aug 22, 2024
Building an NFT Mint Recommendation Model (Zora)
Aug 10, 2024
How to Read Block Explorers and Understand Transactions, Traces, and Logs on Ethereum (EVM)
Jun 15, 2024
A Social and Financial Study of Memecoins
Apr 25, 2024
How to Find and Analyze Trends on Farcaster
Feb 14, 2024
How to Understand and Query Farcaster Data (Casts, Users, Channels, and Frames)
Feb 2, 2024
Web3 SQL Weekly #9: Sleuthing a Sudoswap Trade
Oct 10, 2023
Navigating the Structure of Seaport (Opensea)
Oct 5, 2023
Every ERC Explained (Part 2): Contract Design Patterns
Sep 5, 2023
Advanced Wizard Guide to Dune SQL and Ethereum Data Analytics
Aug 16, 2023
Every ERC Explained (Part 1): All the Tokens
Jul 19, 2023
Web3 SQL Weekly #8: Analyzing Account Abstraction (ERC4337)
Jun 30, 2023
How To Analyze Any Crypto Token In Five Minutes
Mar 31, 2023
Web3 SQL Weekly #7: Cohort Retention for Opensea and Other NFT Marketplaces
Mar 10, 2023
Web3 SQL Weekly #6: Finding Metaverse Landlords by creating and using labels
Mar 3, 2023
Web3 SQL Weekly #4: Getting New and Old Users (Wallets) for a Protocol
Feb 10, 2023
Web3 SQL Weekly #3: Finding all NFTs (ERC721) held by an address
Feb 3, 2023
Web3 SQL Weekly #2: Finding contracts that have integrated with a contract
Jan 27, 2023
Web3 SQL Weekly #1: How to calculate ETH balances for any address
Jan 20, 2023
How To Analyze Any Ethereum Protocol or Product In Five Minutes
Dec 29, 2022
Day 12 (12 Days of Dune): Clustering all USDC Uniswap v2 pairs based on liquidity stability
Dec 23, 2022
Day 11 (12 Days of Dune): The volatility of liquidity (k) and prices, compared.
Dec 22, 2022
Day 10 (12 Days of Dune): Calculating price impact and total liquidity for USDC/WETH in Uniswap v2
Dec 21, 2022
Basic Wizard Guide to Dune SQL and Ethereum Data Analytics
Dec 20, 2022
Day 9 (12 Days of Dune): Calculating the percent of USDC reserves in USDC/WETH pair versus all other pairs
Dec 20, 2022
Day 8 (12 Days of Dune): Diversity of liquidity sources in USDC/WETH?
Dec 19, 2022
Day 7 (12 Days of Dune): Analyzing liquidity added and removed from USDC/WETH in Uniswap v2
Dec 18, 2022
Day 6 (12 Days of Dune): Clustering all USDC pairs in Uniswap by Usage
Dec 17, 2022
Day 5 (12 Days of Dune): Identifying sources of swaps as contracts or EOAs
Dec 16, 2022
Day 4 (12 Days of Dune): Identifying MEV bot/arbitrage transactions in Uniswap v2
Dec 15, 2022
Day 3 (12 Days of Dune): Finding pair reliance in Uniswap Swap Routing
Dec 14, 2022
Day 2 (12 Days of Dune): Finding total volume and swap frequency for Uniswap v2 (USDC/WETH)
Dec 13, 2022
Day 1 (12 Days of Dune): Finding all pairs for ERC20 tokens in Uniswap v2
Dec 12, 2022
Become a (better) web3 data wizard before the New Year!
Dec 7, 2022
Web3 Data Guide: Sudoswap
Aug 22, 2022
Learning to Work With Ethereum Storage and State Data
Mar 3, 2022
UX Research to Improve NFT Auction Experience, using Mempool Data
Aug 20, 2021
Airdropping Tokens to Users using a Community-Specific Reputation Score (Mirror.xyz)
Jul 29, 2021