Web3 Data Degens

Home
Leaderboard
About
New
Top
Discussion
Every ERC Explained (Part 2): Contract Design Patterns
Covering contract deployments, factories, proxies, and upgrades.
 • 
Andrew Hong
August 2023
The Modular Stack - for Dummies
How the "modular stack" unlocks new design space for applications. Written for the non-technical reader.
 • 
Andrew Hong
Advanced Wizard Guide to Dune SQL and Ethereum Data Analytics
Giving you the frameworks and functions you need to become an archwizard
 • 
Andrew Hong
5
July 2023
Every ERC Explained (Part 1): All the Tokens
Simplifying and showcasing ERCs across all EVM chains - starting with tokens.
 • 
Andrew Hong
2
Refer readers to Web3 Data Degens and get rewards
Access the data degens, get a project review, and get 1:1 career advice with me - all from referral rewards!
 • 
Andrew Hong
June 2023
Web3 SQL Weekly #8: Analyzing Account Abstraction (ERC4337)
Let's look at the top contracts and interactions from smart accounts on Polygon (and other EVM chains)!
 • 
Andrew Hong
How To Analyze Any Solana Program In Five Minutes
Get started with analyzing any Solana program (on Dune.com)
 • 
Andrew Hong
1
April 2023
Starter Guide to Solana Data Analysis (Part 2)
Let's teach you how tokens, accounts, and programs really work, and how to calculate total value locked (TVL).
 • 
Andrew Hong
Starter Guide to Solana Data Analysis (Part 1)
Analyzing the Orca Whirlpool AMM, using new Solana decoded tables.
 • 
Andrew Hong
March 2023
How To Analyze Any Crypto Token In Five Minutes
Using thirteen charts to understand the Optimism token (or any erc20 token), with concepts like momentum, liquidity, and distribution.
 • 
Andrew Hong
Web3 SQL Weekly #7: Cohort Retention for Opensea and Other NFT Marketplaces
Teaching you how to calculating monthly cohort user retention, for every NFT marketplace.
 • 
Andrew Hong
Web3 SQL Weekly #6: Finding Metaverse Landlords by creating and using labels
Creating a label for Sandbox, Decentraland, Cryptovoxels, and Otherdeed land traders so it's easy to identify which wallets are the most active…
 • 
Andrew Hong
© 2023 Andrew Hong
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing