Ethereum Blockchain Analytics
summary
Loaded Ethereum blockchain data into BigQuery ETL and runs SQL to find concrete signals: transaction counts, the timing of an airdrop in late‑2017, and a March‑2017 surge tied to a cohort of ephemeral accounts. Builds a CryptoKitties breeding graph to trace parent→child lineages and identify high‑value collectibles. Detects a class of ephemeral one‑time addresses correlated with price movements and claims a roughly $30 billion issuance window; code, Colab notebooks and labeled data are published for reproduction.
AI-written summary · about
chapters (11)
- 0:00Introduction to analytics
- 3:50Blockchain activity trends
- 6:26CryptoKitties data visualization
- 9:04Token transfer network graphs
- 10:27ETL process and enrichment
- 13:15Collaborative analysis demo
- 14:27Address activity patterns
- 17:44Ephemeral address analysis
- 21:46Price correlation findings
- 22:51Open data and future plans
- 24:46Community collaboration call
related talks
44mBringing data science into blockchain
31mBlockchain + Tracking = Awesome Analytics
52mBlockchain: Exploring the Opportunities for Gaming
18mL2 & L1 Adoption and User Behavior Utilizing Onchain Data
39mThe Blockchain Paradox
53mBuilding on Ethereum in the AI Era
24mIndexing Ethereum Mainnet for Near Zero Cost
40mWhy you don't see Blockchain in your Everyday Life…yet