📊 On-Chain Data Analysis Project with Google Cloud 📊 Undergraduates rarely get the chance to work with real enterprise infrastructure. In this program, our members queried raw Ethereum and Solana transactions directly from BigQuery's public datasets. Our sincere thanks to Google Cloud and @Jimiiiiiiiiii for making this possible 💚 🧐 Two members documented what they found working directly with Google Cloud BigQuery. ① The Enterprise Blockchain Design Dilemma — Chaeyun Cho (17th cohort, Computer Science '23) Across roughly 16.45M valid contract calls on Ethereum (Jun 2 – Jul 1, 2026, excluding simple transfers), USDT and USDC alone accounted for over 75%. From there, the piece works through on-chain bottlenecks and the trade-offs of each mitigation pattern. 🔗 ② On-Chain Data Analysis: Weeks 1–2 — Yeju Jang (School of Software, Eltec College of Engineering) A working log comparing Ethereum and Solana across usage, reliability, and active addresses. 🔗 🔗 GitHub — Learning Points 📌 A failed hypothesis is still a result — We expected fees to rise with transaction volume. Over the period we examined, that didn't hold. 📌 Most of the work happens before you reach the data — Dataset subscription steps, free-tier quotas, type errors in the visualization layer. Clearing these one by one was a large part of the job. EWHA-CHAIN is a student organization built around hands-on industry projects. Thank you to every partner who worked with us and to all our 17th cohort members — and please look forward to what our 18th cohort takes on next. Thank you 💚