How Crypto Prices Are Actually Built On-Chain (SQL)

How Crypto Prices Are Actually Built On-Chain (SQL) | Crypto SQL Advanced #1 In this video, we go beyond basic SQL and start thinking like real on-chain analysts. Instead of just reading price data, we break down how token prices are actually built using blockchain data. You’ll learn: how to use Dune price tables (prices.usd_latest, prices.usd) the difference between latest and historical price data why price is not “given” in crypto how to calculate token price directly from DEX trades and how analysts reconstruct price from raw on-chain activity This is the first video in the SQL for Crypto Analytics — Advanced series, where we move from syntax to real data problems. In the next videos, we’ll go deeper into: → window functions → advanced query patterns → real-world on-chain analysis workflows Who this is for Beginners in on-chain analytics Anyone learning SQL with Dune Data analysts interested in Web3 / DeFi People who want to understand how crypto data actually works Tools used Dune Analytics SQL (Dune SQL / Trino) On-chain data (Ethereum, DEX trades) Key idea In crypto, price is not something you are given. It’s something you reconstruct. Follow the journey I’m learning on-chain analytics from scratch and sharing everything along the way. Subscribe if you want to learn together. TIMECODE 00:00 — Why on-chain price logic matters 00:23 — What is a token price on-chain (swaps = price) 00:58 — Levels of price data (aggregators → Dune → raw trades) 01:30 — prices.usd_latest (simple case, ready data) 02:08 — prices.usd (historical, time filtering) 02:40 — dex.trades (a simplified example for clarity) 03:13 — Multi-token logic preview (partition idea) 03:30 — Summary + next steps (window functions coming) #crypto #sql #onchain #dune #defi https://youtu.be/NGgtMC4lF9k