# #126 hooked fee-100 pools: swap/liq tape + tx.from (dataeng, 11 Oct)
File: /opt/ppcopy/r6hook.db (research-box; snapshot of /opt/sw/ppdata/r6hook.db). Schema as r6weth.db: meta, ev (pool,venue,block,t,li,tx15,kind,a,q,px,liq,sender,recipient,tx_from), txfrom(pool,block,li,tx15,tx_from,tx_full), done, kv.
Coverage: 912 of 1194 pools done = ALL 103 newest (post 7 Oct) and everything 20 Aug-20 Sep (priorities 1+2). 716,468 swaps in 907 pools, 718,016 ev rows, tx_from filled on 100%. Window: first 2 h after init.
Missing: 282 oldest pools (init 26 Jul-20 Aug), priority 3. ppdata's service r6hook-paid is still working through them (newest-first order, resumable) but is slowed by free-RPC 429 backoff (paid day cap nearly used); sharding would not help since all shards share the same rate limit. Re-snapshot later: sqlite3 -readonly /opt/sw/ppdata/r6hook.db ".backup /opt/ppcopy/r6hook.db"
Query: select tx_from,count(*) from ev e join meta m using(pool) where kind=1 and m.hooks like '%11689%' group by 1 order by 2 desc limit 20;