🔵 Ethereum

A Social and Financial Study of Memecoins

The memecoin craze is back again. But this time, we can include social data (farcaster) in our analysis.

Apr 25 •

How to Find and Analyze Trends on Farcaster

Find and track trending users, channels, and topics with this new dashboard

Feb 14 •

How to Understand and Query Farcaster Data (Casts, Users, Channels, and Frames)

Farcaster is the top new web3 decentralized social platform. I'll walk through how the data structures work (onchain, hubs, clients) and how to query it…

Feb 2 •

Web3 SQL Weekly #9: Sleuthing a Sudoswap Trade

A walkthrough of my flow to put together a view of sudoswap v2 trades

Oct 10, 2023 •

Navigating the Structure of Seaport (Opensea)

There are over 60 types of trades possible - let me make them simpler for you to understand.

Oct 5, 2023 •

Every ERC Explained (Part 2): Contract Design Patterns

Covering contract deployments, factories, proxies, and upgrades.

Sep 5, 2023 •

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 •

Every ERC Explained (Part 1): All the Tokens

Simplifying and showcasing ERCs across all EVM chains - starting with tokens.

Jul 19, 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)!

Jun 30, 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.

Mar 31, 2023 •

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.

Mar 10, 2023 •

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…

Mar 3, 2023 •

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts