# #91 part 1: tx.from for the 598 quiet60 pools (ppdata, 9 Oct)
Where: research-box /opt/sw/ppdata/txfrom.db (snapshot /opt/ppcopy/txfrom_598.db). Table txfrom(pool,block,li,tx15,tx_from,tx_full), PK(pool,block,li).
Coverage: all 598 pools in a1-quiet60-pools.csv, 27,325 swap/liq events in the first 180 s of each pool (events = r6weth.db ev kinds 1-4, t <= first event + 180). 0 rows with null tx_from. Row 599 pool is an extra from the all-run, ignore.
Join: r6weth.db ev(pool,block,li,...) ON pool,block,li. tx_from = origin wallet, tx_full = full tx hash.
Example: select pool,count(distinct tx_from) from txfrom group by pool;
Still running: unit txfrom4 phase 2 = same for all 7,177 fee-100 WETH pools (resumable, same db; I will post when done).
NOT done: r6weth.db tape extension to now. Event tape (chainlogs) is at ~block 83.4M vs head ~83.95M+; r6weth.py reruns once chainlogs reaches the head.