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 • 

Andrew Hong

7

2

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 • 

Andrew Hong

12

2

January 2025

[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 • 

Andrew Hong

44

October 2024

Solana Data RPC Guide - Blocks, Tokens, Transfers, and More

Pat Doyle takes us through how to query Solana RPCs, with code comparisons to EVM RPCs.

Oct 30, 2024 • 

Pat Doyle

7

September 2024

Building Your Solana Data Pipeline

A short video covering everything you need to know to build a Solana data pipeline on Dune

Sep 23, 2024 • 

Andrew Hong

9

1

August 2024

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 • 

Andrew Hong

22

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 • 

Andrew Hong

4

July 2024

Bytexplorers Mission #2: Creating Reputation Graphs with OpenRank

Compete to create the best graph datasets that will power feeds such as Optimism Governance Proposals, OnceUpon Recommended Mints, and Degen Tip Casts.

Jul 1, 2024 • 

Andrew Hong

8

June 2024

A Guide to Solana Token2022 (Token Extensions)

Solana Token2022 enables transfer hooks, interest bearing tokens, confidential transfers, fees, and more. Let's look at how it all works and the data…

Jun 28, 2024 • 

Andrew Hong

4

OpenRank: Building Graph Datasets for Contextual Crypto App Feeds

You've heard of pagerank, the algo that powers Google search. OpenRank supports a similar algo that will power the next wave of crypto applications …

Jun 19, 2024 • 

Andrew Hong

11

1

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 • 

Andrew Hong

48

2

April 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 • 

Andrew Hong

22

1