BR Academy

Crypto Analytics: On-Chain Data with Dune, SQL and Python

Exit course

← Crypto Analytics: On-Chain Data with Dune, SQL and Python

1Blockchain Data Fundamentals0/4

Blocks, transactions, and the mempool8m
Logs, events, and event decoding
Traces and internal calls
Dune's data model and table structure
Module quiz

2SQL Foundations for On-Chain Data0/4

SELECT, WHERE, and filtering
JOINs and UNIONs across blockchain tables
GROUP BY, COUNT, SUM, and window functions
CTEs and subqueries for readable queries
Module quiz

3Dune Dashboards & Visualization0/3

Writing and testing queries in Dune
Building multi-chart dashboards
Real-time alerts and dashboard refresh
Module quiz

4Wallet & Cohort Analysis0/3

Tracking wallet activity and balance changes
Cohort analysis by first-transaction date
Clustering wallets by behavior (transaction frequency, value, token holdings)
Module quiz

5DEX & Stablecoin Flow Analysis0/4

Extracting DEX trade volume and pricing
Analyzing liquidity pool composition and swaps
Tracking stablecoin transfers and redemptions
Token holder distribution and concentration
Module quiz

6Python & Advanced Analytics0/4

Exporting Dune queries to Python
Data cleaning and analysis with pandas
Statistical tests on on-chain cohorts
Writing and publishing reproducible research
Module quiz

7Capstone Project0/1

Design and publish an original on-chain research report
Module quiz

SQL Foundations for On-Chain Data·Lesson 6 of 23·12 min

JOINs and UNIONs across blockchain tables

This lesson is for enrolled learners

Almost no useful on-chain question is answerable from a single table. You need the swap event, plus the token's symbol and decimals, plus maybe the transaction's gas cost, plus the same data from a second chain. JOIN combines tables side by side on a matching key; UNION ALL stacks same-shaped tables on top of each other. Both are used constantly……

Enroll to continue Already enrolled? Sign in