Crypto Data Bytes

Crypto Data Bytes

Home
🟥 Herd
🧠 Ecosystem Overviews
Basic Wizard Guide to Dune SQL and Ethereum Data Analytics
Explaining how Ethereum maps to Dune's tables and giving use case examples for all the basic SQL you need to know to be a data wizard
Dec 20, 2022 • 
Andrew Hong
109

Share this post

Crypto Data Bytes
Crypto Data Bytes
Basic Wizard Guide to Dune SQL and Ethereum Data Analytics
1
Join the Bytexplorers 🔍
Learn onchain analytics while building onchain reputation - with friends!
Jan 9, 2024 • 
Andrew Hong
52

Share this post

Crypto Data Bytes
Crypto Data Bytes
Join the Bytexplorers 🔍
23
Solana Analytics Starter Guide (Part 1): Solana Instructions
Understanding instructions on Solana, table schemas, and walking through DEX basics with Whirlpool AMM.
Apr 12, 2023 • 
Andrew Hong
27

Share this post

Crypto Data Bytes
Crypto Data Bytes
Solana Analytics Starter Guide (Part 1): Solana Instructions
How to Read Block Explorers and Understand Transactions, Traces, and Logs on Ethereum (EVM)
Learn read explorers like Etherscan and navigate data across these three key data structures, and how to find the tables you'll need to query.
Jun 15, 2024 • 
Andrew Hong
47

Share this post

Crypto Data Bytes
Crypto Data Bytes
How to Read Block Explorers and Understand Transactions, Traces, and Logs on Ethereum (EVM)
2
[2023 Annual Guide] Web3 Data Tools
Covering all the top data tools and how they're used from a data analysts perspective.
Jan 6, 2023 • 
Andrew Hong
58

Share this post

Crypto Data Bytes
Crypto Data Bytes
[2023 Annual Guide] Web3 Data Tools
[2025 Annual Guide] Crypto Data Engineering Guide
Crypto data transformation is expensive in both time and money if you don't know what you're doing. Read this to make your ETL life much easier.
Jan 6 • 
Andrew Hong
37

Share this post

Crypto Data Bytes
Crypto Data Bytes
[2025 Annual Guide] Crypto Data Engineering Guide
[2024 Annual Guide] Web3 Data Tools and Tips
Indexers, Explorers, Query engines, Data Transformations, and ZK reverse ETL - the key components you need to understand to navigate crypto data.
Jan 16, 2024 • 
Andrew Hong
30

Share this post

Crypto Data Bytes
Crypto Data Bytes
[2024 Annual Guide] Web3 Data Tools and Tips
1
How To Analyze Any Ethereum Protocol or Product In Five Minutes
Get started with analyzing any contract on any EVM chain (on Dune.com)
Dec 29, 2022 • 
Andrew Hong
35

Share this post

Crypto Data Bytes
Crypto Data Bytes
How To Analyze Any Ethereum Protocol or Product In Five Minutes
Roadmap to Becoming a Top Crypto Data Analyst
Everything you need to go from beginner to expert in crypto data.
Mar 27, 2024 • 
Andrew Hong
37

Share this post

Crypto Data Bytes
Crypto Data Bytes
Roadmap to Becoming a Top Crypto Data Analyst
5
A Guide to Solana for Ethereum Analysts
Translating EVM concepts to their Solana counterparts
Nov 22, 2023 • 
Andrew Hong
22

Share this post

Crypto Data Bytes
Crypto Data Bytes
A Guide to Solana for Ethereum Analysts
2
Advanced Wizard Guide to Dune SQL and Ethereum Data Analytics
Giving you the frameworks and functions you need to become an archwizard
Aug 16, 2023 • 
Andrew Hong
19

Share this post

Crypto Data Bytes
Crypto Data Bytes
Advanced Wizard Guide to Dune SQL and Ethereum Data Analytics
5
How To Analyze Bitcoin Data With SQL
Learn how Bitcoin works, and how to analyze block statistics, transaction values, active addresses, and address balances using Dune!
Jan 13, 2023 • 
Andrew Hong
32

Share this post

Crypto Data Bytes
Crypto Data Bytes
How To Analyze Bitcoin Data With SQL
2
© 2025 Andrew Hong
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture

Share