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

Original author：SashaOnChain

Original source：https://www.youtube.com/embed/NGgtMC4lF9k

How are crypto prices actually calculated on-chain? 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. crypto, sql, dune