BigQuery Ethereum Data Acquisition

Overview

Workflow for acquiring 5 years of Ethereum blockchain data (2020-2025, ~12.44M blocks) using Google BigQuery's public dataset within free tier limits. Includes column selection analysis for ML/time-series forecasting, cost optimization, and empirically validated download workflows.

Status: ✅ Empirically validated (v0.2.0, 2025-11-07)

When to Use This Skill

Use when:

• Evaluating BigQuery as a data source for Ethereum historical data
• Planning bulk historical blockchain data acquisition
• Optimizing column selection for feature engineering
• Calculating query costs and free tier utilization
• Comparing BigQuery vs RPC polling approaches
• Streaming downloads without BigQuery storage