/WTF-Onchain-Analysis

blockchain data analysis tutorials with Dune, maintained by SixdegreeLab. Available in English and 中文.

Primary LanguageTeXApache License 2.0Apache-2.0

Mastering Onchain Analytics

Online Book:

This is a series tutorials for blockchain analysis enthusiasts, helping new users learn blockchain data analysis from scratch and become an on-chain data analyst master.

table of contents

Id English Chinese
Elementary --- ---
#0 become chain analyst 成为链上数据分析师
#1 dune platform introduction Dune平台简介
#2 quickstart 数据分析新手上路
#3 build first dashboard 创建第一个Dune数据看板
#4 understanding tables 熟悉数据表
#5 sql basics part1 SQL基础（一）
#6 sql basics part2 SQL基础（二）
#7 practice build lens dashboard part1 实践案例：制作Lens的数据看板（一）
#8 practice build lens dashboard part2 实践案例：制作Lens的数据看板（二）
Intermediate ---- ----
#9 useful queries part1 常见查询一：ERC20代币价格
#10 useful queries part2 常见查询二：代币的持有者、总供应量、账户余额
#11 useful queries part3 常见查询三：自定义数据、数字序列、数组、JSON等
#12 nft analysis NFT数据分析
#13 lending analysis 借贷协议数据分析
#14 defi analysis DeFi数据分析
#15 dunesql introduction Dune SQL 查询引擎入门
#16 blockchain analysis polygon Polygon区块链概况分析
#17 mev analysis uniswap MEV数据分析——以Uniswap为例
#18 uniswap multichain analysis Uniswap多链数据对比分析
#19 useful metrics 各类常见指标分析
Advanced --- ---
#20 network analysis 区块链网络分析
#21 btc analysis BTC数据分析-以指标CDD为例
#22 how to build spellbook 如何构建魔法表（Spellbook）
#23 how to build app use dune api 使用Dune API创建应用程序

About Us

SixdegreeLab are a group of on-chain data enthusiasts. Our mission is to provide users with accurate on-chain data charts, analysis, and insights, and we are committed to popularizing on-chain data analysis. By establishing a community, writing tutorials, etc., train data analysts on the chain, output valuable analysis content, promote the community to build the data layer of the blockchain, and cultivate talents for the broad blockchain data application in the future.