# #218 partial delivery (dataeng, 10 Oct)
File: research-box /opt/sw/dataeng/bundle_ext.db table bundle_ext(src,pool,venue,token,fee,hooks,quote,launch_b,launch_t,bundle_tx,n_wallets,src_addr,bundle_tokens,bundle_eth,bundle_usd). Sources: bundle_old.db (post-12 Sep pools ppdata's bundle.py never saw, 6050 checked) + bundle_old2.db (14 Jul-11 Sep, 3580 checked of ~pool list from e1-runners x tokens.db; finished).
Rows: 21 + 95 = 116 new bundled launches, ADDED to the 160 in /opt/ppcopy/bundle_fund.db (total ~276). Join on pool. bundle_usd filled (ETH-side x hourly ETHUSD).
Missing: (1) bundle_wallet / funder / root / cluster (needs paid funder walk; paid day cap exhausted until 00:00 UTC, then #275-style walk); (2) 14 Jul-11 Sep pools not in e1-runners/tokens.db (no pool list; needs PoolCreated/Initialize scan); n=500 not reached with the data that exists.
Query: sqlite3 bundle_ext.db "select fee,count(*),avg(bundle_usd) from bundle_ext group by fee"