Learn Web3 Data Analytics
Curated tutorials, guides, and video courses from the best minds in onchain analytics.
By Andrew Hong
![[2025 Annual Guide] Crypto Data Engineering Guide - Ecosystem Overviews](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
Ecosystem Overviews
Jan 6, 2025
Roadmap to Becoming a Top Crypto Data Analyst
Ecosystem Overviews
Mar 27, 2024
![[2024 Annual Guide] Web3 Data Tools and Tips - Ecosystem Overviews](https://substackcdn.com/image/fetch/$s_!YuSF!,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%2F93e5a097-5b74-4056-ba60-423bb5f39cd6_7794x6080.jpeg)
[2024 Annual Guide] Web3 Data Tools and Tips
Ecosystem Overviews
Jan 16, 2024
![[2023 Annual Guide] Web3 Data Tools - Ecosystem Overviews](https://substackcdn.com/image/fetch/$s_!qPuK!,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%2Fa5bcb5c3-9c61-4175-87fb-3d0e1e0b6f7f_1289x672.jpeg)
[2023 Annual Guide] Web3 Data Tools
Ecosystem Overviews
Jan 6, 2023
![[2022 Annual Guide] Web3 Data Thinking, Tools, and Teams - Ecosystem Overviews](https://substackcdn.com/image/fetch/$s_!EqlA!,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%2F20fa5c1b-159c-4e9a-a16d-06f0643386a7_1190x840.jpeg)
[2022 Annual Guide] Web3 Data Thinking, Tools, and Teams
Ecosystem Overviews
Feb 8, 2022
By Andrew Hong
How to Analyze Thousands of Transactions During a Live Hack
Ethereum Data Guides
Mar 24, 2026
Herd MCP: Performing Onchain Research, Due Diligence, and Validation
Ethereum Data Guides
Feb 23, 2026
Unwrapping DeFi: The Evolution of Tokens, Pools, and Vaults
Ethereum Data Guides
Oct 27, 2025
Vibe Coding a Batch Swap App using 0x, Dune, and EIP5792/7702
Ethereum Data Guides
Aug 28, 2025
Explore Clanker (Token Launchpad) and Build an App without Coding
Ethereum Data Guides
Aug 16, 2025
[2025 Annual Guide] Crypto Data Engineering Guide
Ethereum Data Guides
Jan 6, 2025
How to Navigate Contract Code (Solidity) as an Analyst
Ethereum Data Guides
Aug 22, 2024
Building an NFT Mint Recommendation Model (Zora)
Ethereum Data Guides
Aug 10, 2024
How to Read Block Explorers and Understand Transactions, Traces, and Logs on Ethereum (EVM)
Ethereum Data Guides
Jun 15, 2024
A Social and Financial Study of Memecoins
Ethereum Data Guides
Apr 25, 2024
How to Find and Analyze Trends on Farcaster
Ethereum Data Guides
Feb 14, 2024
How to Understand and Query Farcaster Data (Casts, Users, Channels, and Frames)
Ethereum Data Guides
Feb 2, 2024
Web3 SQL Weekly #9: Sleuthing a Sudoswap Trade
Ethereum Data Guides
Oct 10, 2023
Navigating the Structure of Seaport (Opensea)
Ethereum Data Guides
Oct 5, 2023
Every ERC Explained (Part 2): Contract Design Patterns
Ethereum Data Guides
Sep 5, 2023
Advanced Wizard Guide to Dune SQL and Ethereum Data Analytics
Ethereum Data Guides
Aug 16, 2023
Every ERC Explained (Part 1): All the Tokens
Ethereum Data Guides
Jul 19, 2023
Web3 SQL Weekly #8: Analyzing Account Abstraction (ERC4337)
Ethereum Data Guides
Jun 30, 2023
How To Analyze Any Crypto Token In Five Minutes
Ethereum Data Guides
Mar 31, 2023
Web3 SQL Weekly #7: Cohort Retention for Opensea and Other NFT Marketplaces
Ethereum Data Guides
Mar 10, 2023
Web3 SQL Weekly #6: Finding Metaverse Landlords by creating and using labels
Ethereum Data Guides
Mar 3, 2023
Web3 SQL Weekly #4: Getting New and Old Users (Wallets) for a Protocol
Ethereum Data Guides
Feb 10, 2023
Web3 SQL Weekly #3: Finding all NFTs (ERC721) held by an address
Ethereum Data Guides
Feb 3, 2023
Web3 SQL Weekly #2: Finding contracts that have integrated with a contract
Ethereum Data Guides
Jan 27, 2023
Web3 SQL Weekly #1: How to calculate ETH balances for any address
Ethereum Data Guides
Jan 20, 2023
How To Analyze Any Ethereum Protocol or Product In Five Minutes
Ethereum Data Guides
Dec 29, 2022
Day 12 (12 Days of Dune): Clustering all USDC Uniswap v2 pairs based on liquidity stability
Ethereum Data Guides
Dec 23, 2022
Day 11 (12 Days of Dune): The volatility of liquidity (k) and prices, compared.
Ethereum Data Guides
Dec 22, 2022
Day 10 (12 Days of Dune): Calculating price impact and total liquidity for USDC/WETH in Uniswap v2
Ethereum Data Guides
Dec 21, 2022
Basic Wizard Guide to Dune SQL and Ethereum Data Analytics
Ethereum Data Guides
Dec 20, 2022
Day 9 (12 Days of Dune): Calculating the percent of USDC reserves in USDC/WETH pair versus all other pairs
Ethereum Data Guides
Dec 20, 2022
Day 8 (12 Days of Dune): Diversity of liquidity sources in USDC/WETH?
Ethereum Data Guides
Dec 19, 2022
Day 7 (12 Days of Dune): Analyzing liquidity added and removed from USDC/WETH in Uniswap v2
Ethereum Data Guides
Dec 18, 2022
Day 6 (12 Days of Dune): Clustering all USDC pairs in Uniswap by Usage
Ethereum Data Guides
Dec 17, 2022
Day 5 (12 Days of Dune): Identifying sources of swaps as contracts or EOAs
Ethereum Data Guides
Dec 16, 2022
Day 4 (12 Days of Dune): Identifying MEV bot/arbitrage transactions in Uniswap v2
Ethereum Data Guides
Dec 15, 2022
Day 3 (12 Days of Dune): Finding pair reliance in Uniswap Swap Routing
Ethereum Data Guides
Dec 14, 2022
Day 2 (12 Days of Dune): Finding total volume and swap frequency for Uniswap v2 (USDC/WETH)
Ethereum Data Guides
Dec 13, 2022
Day 1 (12 Days of Dune): Finding all pairs for ERC20 tokens in Uniswap v2
Ethereum Data Guides
Dec 12, 2022
Become a (better) web3 data wizard before the New Year!
Ethereum Data Guides
Dec 7, 2022
Web3 Data Guide: Sudoswap
Ethereum Data Guides
Aug 22, 2022
Learning to Work With Ethereum Storage and State Data
Ethereum Data Guides
Mar 3, 2022
UX Research to Improve NFT Auction Experience, using Mempool Data
Ethereum Data Guides
Aug 20, 2021
Airdropping Tokens to Users using a Community-Specific Reputation Score (Mirror.xyz)
Ethereum Data Guides
Jul 29, 2021
By Andrew Hong
Solana Data RPC Guide - Blocks, Tokens, Transfers, and More
Solana Data Guides
Oct 30, 2024
Building Your Solana Data Pipeline
Solana Data Guides
Sep 23, 2024
A Guide to Solana Token2022 (Token Extensions)
Solana Data Guides
Jun 28, 2024
Basic Solana Data Analytics In One Hour (Youtube)
Solana Data Guides
Dec 22, 2023
A Guide to Solana for Ethereum Analysts
Solana Data Guides
Nov 22, 2023
Solana Analytics Starter Guide (Part 4): Solana Events (Logs, Anchor Logs, Event CPI)
Solana Data Guides
Nov 13, 2023
Solana Analytics Starter Guide (Part 3): NFT, pNFT, xNFT, cNFT
Solana Data Guides
Oct 30, 2023
Solana Staking and MEV Explained
Solana Data Guides
Sep 22, 2023
How To Analyze Any Solana Program In Five Minutes
Solana Data Guides
Jun 26, 2023
Solana Analytics Starter Guide (Part 2): Token Mints, Accounts, and TVL
Solana Data Guides
Apr 14, 2023
Solana Analytics Starter Guide (Part 1): Solana Instructions
Solana Data Guides
Apr 12, 2023
Dune MCP | Query onchain data across 100+ chains with one prompt
Dune Analytics Tutorials
Mar 2, 2026
Tutorial: How to run dbt projects directly on Dune
Dune Analytics Tutorials
Jan 27, 2026
Near + Dune Tutorial
Dune Analytics Tutorials
Jan 30, 2025
Dune 101: Welcome
Dune Analytics Tutorials
Aug 16, 2024
Dune 101: Navigation on the App
Dune Analytics Tutorials
Aug 16, 2024
Dune 101: Creating and Managing Dashboards
Dune Analytics Tutorials
Aug 16, 2024
Dune 101: Learning DuneSQL and Our Engines
Dune Analytics Tutorials
Aug 16, 2024
Dune 101: Exploring Queries (Views and Matviews)
Dune Analytics Tutorials
Aug 16, 2024
Dune 101: Searching and Contributing to Spellbook (Curated Tables)
Dune Analytics Tutorials
Aug 16, 2024
Dune 101: Understanding Tables (Raw, Decoded, Curated/Spellbook, Views, Uploads)
Dune Analytics Tutorials
Aug 16, 2024
Dune 101: Creating Visualizations (Charts)
Dune Analytics Tutorials
Aug 16, 2024
Dune 101: Decoding Contracts
Dune Analytics Tutorials
Aug 16, 2024
Dune 101: SQL API and Developer API
Dune Analytics Tutorials
Aug 16, 2024
Roadmap to Becoming a Top Crypto Data Analyst
Dune Analytics Tutorials
Mar 27, 2024
How to start analyzing any Crypto protocol or product using SQL (in five minutes)
Dune Analytics Tutorials
Dec 29, 2022
Flipspace Agents: Are Institutions Accumulating or Distributing Stablecoins? I Asked an AI Agent.
Flipside Crypto Tutorials
Feb 19, 2026
Flipspace Automations: How I Automated Cross-Chain USDC Intelligence in Flipside
Flipside Crypto Tutorials
Feb 18, 2026
Flipspace Data: The Data Layer Powering AI Blockchain Intelligence
Flipside Crypto Tutorials
Feb 18, 2026
Flipspace Agent Chat Demo: Stablecoin Market Share
Flipside Crypto Tutorials
Feb 18, 2026
Blockchain Analytics Course: Segment 5 | Course Recap & Web3 Professional Outputs
MetricsDAO Blockchain Analytics Course
Sep 3, 2022
Blockchain Analytics Course: Segment 4 | Dune Analytics
MetricsDAO Blockchain Analytics Course
Aug 23, 2022
Blockchain Analytics Course: Segment 3 | Querying Ethereum Using Flipside Crypto
MetricsDAO Blockchain Analytics Course
Aug 16, 2022
Blockchain Analytics Course: Segment 2 | Querying Ethereum Using Flipside Crypto
MetricsDAO Blockchain Analytics Course
Aug 10, 2022
Blockchain Analytics Course: Segment 1 | Blockchain & SQL Basics
MetricsDAO Blockchain Analytics Course
Aug 2, 2022
On Chain Analytics Course (Dune + chatGPT) - Uniswap v3
Token Design Tutorials
Jun 7, 2024
On Chain Analytics Course (Dune + chatGPT) - Uniswap v2
Token Design Tutorials
Jun 4, 2024
On Chain Analytics Course (Dune + chatGPT) - Smart contract data
Token Design Tutorials
May 31, 2024
On Chain Analytics Course (Dune + chatGPT) - Theory vs. Data
Token Design Tutorials
May 28, 2024
On Chain Analytics Course (Dune + chatGPT) - Day 0
Token Design Tutorials
May 12, 2024
NEW COURSE - On Chain Analytics, Dune, ChatGPT (Blockchain)
Token Design Tutorials
Apr 22, 2024