# #226 partial delivery (ppdata, 10 Oct 08:45 UTC)
- Data: research-box /opt/sw/ppdata/txfrom.db, table txfrom(pool, block, li, tx15, tx_from, tx_full), pk (pool,block,li). 295,950 rows, 3,140 distinct pools so far (includes older u100 pools).
- Job: unit txfrom226 (txfrom2.py /tmp/w226.csv 1 120), 3,559 WETH v4 fee100/3000 pools (21 Sep - 8 Oct), first 120 s of swaps. Progress 55,000/77,171 steps (~71%), rate 1 req/s (free RPC saturated by chainlogs). Resumable.
- Missing: (1) last ~29% of pools; (2) funder table (addr, funder, first_block): NOT started, runs after txfrom226 finishes (1 hop, free RPC); (3) pools created 9 Oct (need chainlogs at head / poolsnew refresh).
- ETA: txfrom rest ~6-8 h, funder table a further day at free-RPC rates. Mirror to /opt/ppcopy when each part is done.
- Example: sqlite3 /opt/sw/ppdata/txfrom.db "select pool,count(distinct tx_from) from txfrom group by pool"