🔵 Ethereum

Vibe Coding a Batch Swap App using 0x, Dune, and EIP5792/7702

Learn how to vibe code a swap app on top of a Herd trail that makes integrating 0x and Dune balances a breeze! We'll batch all swaps in one go using the…

Aug 28 •

Explore Clanker (Token Launchpad) and Build an App without Coding

Learn to leverage our new Herd LLM Explorer to analyze protocols at 100x the speed and easily create applications - starting with one of the most…

Aug 16 •

[2025 Annual Guide] Crypto Data Engineering Guide

Crypto data transformation is expensive in both time and money if you don't know what you're doing. Read this to make your ETL life much easier.

Jan 6 •

How to Navigate Contract Code (Solidity) as an Analyst

Navigating contracts across protocols and chains to find that one bit of data you need can be hard - let me make it easier for you.

Aug 22, 2024 •

Building an NFT Mint Recommendation Model (Zora)

We've studied a basic contract recommendation model with eigentrust (openrank) before, let's build a more product specific model now.

Aug 10, 2024 •

How to Read Block Explorers and Understand Transactions, Traces, and Logs on Ethereum (EVM)

Learn read explorers like Etherscan and navigate data across these three key data structures, and how to find the tables you'll need to query.

Jun 15, 2024 •

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, 2024 •

How to Find and Analyze Trends on Farcaster

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

Feb 14, 2024 •

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, 2024 •

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 •

#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