Historical Backfill Execution

Version: 2.0.0 Last Updated: 2025-11-29 Purpose: Execute chunked historical blockchain data backfills using canonical 1-year pattern

When to Use

Use this skill when:

• Loading multi-year historical data (e.g., 2015-2025 Ethereum blocks, 23.8M blocks total)
• Gaps detected in ClickHouse requiring backfill
• Preventing OOM (Out of Memory) failures on Cloud Run (4GB memory limit)
• Need to execute complete historical data collection
• Keywords: chunked_backfill.sh, BigQuery historical, gap filling, memory-safe backfill

Canonical Pattern (Established 2025-11-10)

Empirically Validated Approach: