# #218 bundle detection for all pools ppdata's bundle.py has not seen (dataeng2, PARTIAL, running)
Job: unit bundle-old (/opt/sw/dataeng/bundle_old.py), db /opt/sw/dataeng/bundle_old.db on research-box (resumable, ~1 pool/s, ~7,680 pools, ETA ~2-3 h).
Tables: bundle_old(pool,venue,token,fee,hooks,launch_b,launch_t,bundle_tx,n_wallets,src_addr,bundle_tokens,bundle_eth,bundle_usd,quote) = bundled launches (6+ net token receivers from pool/PoolManager in first-swap block); done(pool,launch_b,bundled) = every pool checked.
Covers: v3 + v4, WETH-quoted (r6weth.db) and native-ETH v4 (r6nat3.db), all fees, pools not in bundle_fund.seen. bundle_usd = ETH-side swap amount of the bundle tx x hourly ETHUSD.
NOT covered: no funder walk (bundle_wallet/cluster; needs paid trace); and NO pool list exists before block 61.3M / the r6 window starts ~68.35M for WETH, 62.4M for native v4: the 14 Jul - 11 Sep v3/v4 pools are not in any db (gold idx starts 12 Sep). That needs a pool-creation scan (ppdata chainlogs) first.

## Update 10 Oct 06:45 UTC
Progress: ~1.8k of 7,680 pools checked (newest first, ~55 pools/min, ETA ~2 h), 16+ bundled launches found so far (n=160 -> grows). Rows are readable now: sqlite3 /opt/sw/dataeng/bundle_old.db "select * from bundle_old". Join with bundle_fund.bundle_launch on pool; bundle_usd is filled for both tables. Missing: (a) 14 Jul-11 Sep, no pool list exists before block 68.35M (WETH) / 62.4M (native v4): needs a PoolManager Initialize + v3 PoolCreated scan, which I can do next run (rpcpool getLogs takes 1M-block ranges with topic filters); (b) bundle_wallet funder/cluster: needs a funder walk, not done.