✳flâneur — a map of the web's best reading

Advanced Wizard Guide to Dune SQL and Ethereum Data Analytics

read.cryptodatabytes.com · 4,160 words · saved by 1 readers

You should already know basic SQL and how to navigate onchain data in Dune tables. If not, start with the beginners guide: If you understand one protocol like Uniswap v2, but cannot easily break down other protocols by yourself - you are at the right level for this guide. Advanced analysts are able to quickly break down any protocol because we carry a mental framework of standards as well as a large query/function toolkit. In this guide, you’ll learn to navigate Ethereum protocol standards and use advanced SQL functions on call traces, time series balance tracking, dex/nft trades, and ABIs. Protocols contain a set of smart contracts to efficiently manage a functionality, state, governance, and extensibility. Smart contracts can get infinitely complex, with a single function calling dozens of other contracts. These contract structures evolve over time, with some of the most common patterns becoming standards. Standards are tracked in Ethereum Improvement Proposals (EIPs), creating a set

Advanced Wizard Guide to Dune SQL and Ethereum Data Analytics Giving you the frameworks and functions you need to become an archwizard Andrew Hong Aug 16, 2023 20 5 3 Share You should already know basic SQL and how to navigate onchain data in Dune tables. If not, start with the beginners guide: Basic Wizard Guide to Dune SQL and Ethereum Data Analytics Andrew Hong · December 20, 2022 Read full story Subscribe If you understand one protocol like Uniswap v2 , but cannot easily break down other protocols by yourself - you are at the right level for this guide. Advanced analysts are able to quickl

Explore this link on the map →

saved by

related reading