Web3 Data Degens

Home
About
Most Popular
View all
New
Top
Community
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!
 • 
Andrew Hong
A 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
 • 
Andrew Hong
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
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
Web3 SQL Weekly #5: How to Identify All Bitcoin NFT Mints (Ordinal Inscriptions)
An easy guide to the Bitcoin NFT standard (Ordinal Inscription), which also shows how bitcoin scripting works.
 • 
Andrew Hong
1
Web3 Data Degens
Web3 Data Degens
Teaching you how to learn and contribute to the web3 data ecosystem!
Recommendations
View all 5
Data Always.
Data Always. Tripoli
Not Boring by Packy McCormick
Not Boring by Packy McCormickPacky McCormick
D
Dune DigestDune Analytics
OurNetwork - Crypto, NFT, DeFi, & Web3 Analytics
OurNetwork - Crypto, NFT, DeFi, & Web3 AnalyticsSpencer Noon 🕛

Web3 Data Degens

AboutArchiveRecommendationsSitemap
© 2023 Andrew Hong
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing