Web3 Data Degens
Subscribe
Sign in
Home
About
New
Top
Discussion
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
Mar 10
2
Share this post
Web3 SQL Weekly #7: Cohort Retention for Opensea and Other NFT Marketplaces
web3datadegens.substack.com
Copy link
Twitter
Facebook
Email
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
Mar 3
4
Share this post
Web3 SQL Weekly #6: Finding Metaverse Landlords by creating and using labels
web3datadegens.substack.com
Copy link
Twitter
Facebook
Email
February 2023
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
Feb 24
5
1
Share this post
Web3 SQL Weekly #5: How to Identify All Bitcoin NFT Mints (Ordinal Inscriptions)
web3datadegens.substack.com
Copy link
Twitter
Facebook
Email
Web3 SQL Weekly #4: Getting New and Old Users (Wallets) for a Protocol
Finding trends between new and old users can tell you if a protocol (or domain) is starting to make a comeback.
Andrew Hong
Feb 10
8
1
Share this post
Web3 SQL Weekly #4: Getting New and Old Users (Wallets) for a Protocol
web3datadegens.substack.com
Copy link
Twitter
Facebook
Email
Web3 SQL Weekly #3: Finding all NFTs (ERC721) held by an address
We get NFT balances and also track how the token was acquired (mint, bought, gifted) as well as the value paid.
Andrew Hong
Feb 3
2
Share this post
Web3 SQL Weekly #3: Finding all NFTs (ERC721) held by an address
web3datadegens.substack.com
Copy link
Twitter
Facebook
Email
January 2023
Web3 SQL Weekly #2: Finding contracts that have integrated with a contract
Showing how contract composability really works - by looking at integrations into Opensea Seaport.
Andrew Hong
Jan 27
3
Share this post
Web3 SQL Weekly #2: Finding contracts that have integrated with a contract
web3datadegens.substack.com
Copy link
Twitter
Facebook
Email
Web3 SQL Weekly #1: How to calculate ETH balances for any address
Understand how ETH (native tokens) really work in transactions, and find out how to calculate balances for any EVM chain!
Andrew Hong
Jan 20
7
4
Share this post
Web3 SQL Weekly #1: How to calculate ETH balances for any address
web3datadegens.substack.com
Copy link
Twitter
Facebook
Email
What does it take to win a data competition?
Showcasing the three winners of the Uniswap 12 Days Of Dune competition, and explaining what they did well.
Andrew Hong
Jan 18
4
Share this post
What does it take to win a data competition?
web3datadegens.substack.com
Copy link
Twitter
Facebook
Email
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
Jan 13
18
Share this post
How To Analyze Bitcoin Data With SQL
web3datadegens.substack.com
Copy link
Twitter
Facebook
Email
[2023] Guide to Web3 Data Tools
Covering all the top data tools and how they're used from a data analysts perspective.
Andrew Hong
Jan 6
29
Share this post
[2023] Guide to Web3 Data Tools
web3datadegens.substack.com
Copy link
Twitter
Facebook
Email
December 2022
How to start analyzing any Web3 protocol or product using SQL (in just five minutes)
Get started with analyzing any contract on any EVM chain (on Dune.com)
Andrew Hong
Dec 29, 2022
11
Share this post
How to start analyzing any Web3 protocol or product using SQL (in just five minutes)
web3datadegens.substack.com
Copy link
Twitter
Facebook
Email
Day 12 (12 Days of Dune): Clustering all USDC Uniswap v2 pairs based on liquidity stability
We find some really interesting insights as we use the volatility, concentration, liquidity, price impact, and reserves to analyze all USDC pairs.
Andrew Hong
Dec 23, 2022
2
Share this post
Day 12 (12 Days of Dune): Clustering all USDC Uniswap v2 pairs based on liquidity stability
web3datadegens.substack.com
Copy link
Twitter
Facebook
Email
This site requires JavaScript to run correctly. Please
turn on JavaScript
or unblock scripts