Join the web3 data degens!

We’re a group of hundreds of budding data wizards - all looking to help each other grow. I’ll be using this newsletter to send fun data tips and tricks, protocol deep dives, and full-length courses.

Be sure to follow me on Twitter for all updates as well, and don’t hesitate to reach out with ideas or questions - happy learning!

After you’ve learned the basics, go study weekly problems with the Web3 SQL Weekly guides that will contain concepts across chains - I have YouTube videos for all of them.

Don’t know anything about web3 data, tooling, or infrastructure?

I do annual guides on navigating the complex data space:

• Check out the 2022 guide for a full overview of thinking, tools and teams.

• Check out the 2023 guide for an updated landscape on the best data tools to use.

Get started with Ethereum, Bitcoin, or Solana:

• Ethereum Basics

Web3 Data Degens

A Basic Wizard Guide to Dune SQL and Ethereum Data Analytics

Here are all the concepts you’ll need to know to do all the basic analysis in Dune - your first step to becoming a wizard! Take your time with it, you don’t have to try and learn everything at once. I’ll have a more advanced guide with optimization techniques out soon too. The main optimization tip you need to know is always filter on time and join on th…

Read more

9 months ago · 41 likes · Andrew Hong

• Bitcoin Basics

Web3 Data Degens

How To Analyze Bitcoin Data With SQL

Are you here because you’re interested in Ordinals? Check out this guide! Starting today, you can play with Bitcoin data on Dune. I will explain the basic concepts you need to know and teach you how to leverage our tables to analyze block statistics, transaction values, active addresses, and address balances. We’ll also cover some more technical bits on …

Read more

8 months ago · 19 likes · Andrew Hong

• Solana Basics

Web3 Data Degens

Starter Guide to Solana Data Analysis (Part 1)

This is the first of a four part series covering basic analysis of DEXs and NFTs on Solana. Basic SQL knowledge will be helpful. part 1: basics of Solana tables and a simple whirlpool swap part 2: types of programs, token accounts, and balances (TVL…

Read more

5 months ago · Andrew Hong

If you’re interested in protocol analysis, check out this guide:

Web3 Data Degens

How To Analyze Any Web3 Protocol or Product In Five Minutes

The “cold start” analysis problem is a big one in web3 - protocol contract structures and flows all vary wildly, and learning solidity patterns isn’t necessarily easy. Figuring out what functions/events from what contracts to analyze is tough, and finding example transactions of all the different cases can be time consuming…

Read more

9 months ago · 12 likes · Andrew Hong

If you’re interested in token analysis, check out this guide:

Web3 Data Degens

How To Analyze Any Crypto Token In Five Minutes

This video/article is dedicated to Optimism - thanks to their Retroactive Public Goods Funding program, Web3 Data Degens has now earned 9.6k in OP tokens to continue education work! You can deploy your own L2 EVM chain using the OP Stack by using Conduit…

Read more

6 months ago · 9 likes · Andrew Hong