- The 2026 hiring market for onchain data roles
- The onchain data model: EVM, Solana and Sui
- Research before you build: explorers, RPC and agent tools
- Client libraries and raw data access
- EVM indexing frameworks compared
- Solana indexing
- Streaming and real-time pipelines
- Storage, part 1: OLAP engines and operational databases
- Storage, part 2: warehouses, lakehouses and query engines
- Managed onchain data platforms: buy versus build
- Transformation: dbt, SQLMesh and modeling chain data
- Orchestration, operations and cost
- Analytics craft: SQL, metrics, dashboards and AI agents
- Career playbook: getting hired as a blockchain analytics engineer
Blockchain Data Engineering Guide
The hands-on guide for data and analytics engineers working with onchain data
This book is 100% completeLast updated on 2026-11-03
How chain data is shaped, and how to index, stream, store and model it. 14 chapters, 22 hands-on exercises, 7 end-to-end projects and a private GitHub repo of runnable code
Minimum price
$19.00
$19.00
You pay
Author earns
PDF
EPUB
About
About the Book
I wrote this guide for data engineers and analytics engineers who want to work on crypto and blockchain data, and for analysts who want to get more technical.
It starts with how raw chain data is shaped on EVM chains, Solana, Sui and Bitcoin, then goes through the work underneath every number: researching a protocol before you build, reading raw data from RPC and public datasets, indexing EVM chains and Solana, streaming with correct reorg handling, storage in OLAP engines, warehouses and lakehouses, modeling and testing with dbt or SQLMesh, and orchestration and cost. It ends with analytics craft with AI agents and a career chapter built on hiring data from Unchain Data's job board, which tracks 400+ live crypto data roles at 160+ companies.
What you get:
- 125 pages: 14 chapters and 7 appendices
- 22 hands-on exercises, including 7 end-to-end projects; 19 run on free tools with no account
- Read access to a private GitHub repository with the runnable code (see the last page of the book for how to get your invite)
- PDF and ePub
You need basic SQL, and Python helps. You do not need to know crypto already: Chapter 2 explains how chain data is structured. This is a technical book, not financial or investment advice.
The guide is updated monthly, and each edition is named by year and month. Every new edition I publish is included at no extra cost, and on Leanpub it shows up in your library automatically.
If you find something wrong or out of date, email me at vincent@unchaindata.xyz
Vincent Charles
Author
About the Author
Vincent Charles
I'm Vincent Charles. I run Unchain Data and work as a fractional data lead for crypto teams. Before that I led data and BI at Binance and at Morpho, where I built both functions from zero. Most of my work is on Ethereum and Solana, with more and more Sui. I built WizardCamp, the first web app to learn blockchain analytics with SQL. This guide is the next step, for analysts who want to go further and for engineers who want to stay current in crypto data. X: @0x_vcharles. Email: vincent@unchaindata.xyz.
Contents
Table of Contents
Get the free sample chapters
Click the buttons to get the free sample in PDF or EPUB, or read the sample online here
The Leanpub 60 Day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms...
Earn $8 on a $10 Purchase, and $16 on a $20 Purchase
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
Learn more about writing on Leanpub
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Write and Publish on Leanpub
You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!
Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.
Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.