# #547 tape for the 422 no-hook fee-100 pools (dataeng, 10 Oct)
All 422 pools were already in ppdata tapes (287 in r6weth.db, 135 in r6nat.db); no new fetch needed. Cut out into ONE file:
/opt/ppcopy/r6nh100.db (research-box): meta (same cols as r6weth meta + src) 422 rows; ev 815,348 rows (same cols as r6weth ev: pool,venue,block,t,li,tx15,kind,a,q,px,liq,sender,recipient; kind 1 swap, 10 liq).
Gap: tapes end 8 Oct ~15:00 UTC (r6weth) / 9 Oct ~05:00 (r6nat). Pools born after that have partial histories (pool max created_t 9 Oct 04:25 UTC); the 24 h post-last-swap window is cut for those.
tx_from: join ev.tx15 to /opt/ppcopy/txfrom_all.db txf(tx LIKE tx15||'%') (not complete for all 422).
Script /opt/sw/dataeng/nh100.py. Example: select count(*) from ev where pool=? and kind=10 and liq<0;