# PP Data -> Analyst 2 (9 Oct 2026 13:45 BKK): #16 R6 done, #46 v3from complete, #88 partial

## #16 R6 tape: DONE (host research-box)
`/opt/sw/ppdata/r6tape.db` (copy `/opt/ppcopy/r6tape.db`, 1.2 GB, read-only). Tape through block 83,346,542 (about 8 Oct 13:30 UTC).
- `meta` (117,860 pools): 24,314 v4 USDG/SUSD pools + 93,546 v2 WETH pairs created since 21 Sep (block 68,350,818). Columns: pool, venue, token, quote, token0, token1, fee, hooks, created_block, created_t, created_tx, init_sqrtp, init_tick, tick_spacing (24,313 v4 pools), token_decimals + token_supply (24,394 pools, supply in whole tokens), first_swap_block, first_swap_t, n_events.
- `v4ev` 3,263,601 rows (swaps raw-event sign + liq tickLower/Upper/liqDelta, sender), `v2ev` 910,694 rows (first 4 h of swaps + syncs).
- Gaps: tx is a 15-hex prefix only; v2 pairs are only first-4-h; tape ends 8 Oct 13:30 (see #88).
- SUSD finding (R6c) is in fw/pp-a2-answer.md: SUSD 0x9ad5.. is a thin unbacked peg, ~$10.6k USDG volume ever.
- Example: `sqlite3 -readonly /opt/ppcopy/r6tape.db "select m.pool,m.fee,m.tick_spacing,count(*) from meta m join v4ev e on e.pool=m.pool group by 1 order by 4 desc limit 5"` (check `.schema v4ev` for the join column).

## #46 v3from: DONE
`/opt/sw/ppdata/v3from.db` (copy `/opt/ppcopy/v3from.db`): `pdone` = 499 of 499 p204 pools complete; `swap_from(pool,block,li,frm)` 112,551 rows (blocks 61,039,355-83,161,041). The 6 stragglers were a flaky RPC lookup, now resolved. Newer swaps after the gold tape end (8 Oct 11:24) are not in it. The hourly gold append feeds new swaps; v3from cron is still commented, rerun on request.

## #88 WETH tape refresh: PARTIAL
- `/opt/ppcopy/r6weth.db` rebuilt: now through block 83,358,897 = **8 Oct 13:45 UTC** (was 11:24). 19,765 pools, 7.68M events, 136 v4 fee-3000 hooked pools.
- Cause of the gap: the event tape (chainlogs) is at 8 Oct 13:45; chain head is 9 Oct 06:34 (block 83.95M). It moves about 1k blocks/min (2 workers, free RPC) so about 9 h to catch up. I will rerun r6weth.py when it is there. Item stays open for that.
- Ramp still running (direct Initialize scan, blocks 83.34M-83.95M): 4 new v4 fee-3000 hooked WETH pools since the tape ends: 8 Oct 19:14, 19:54, 22:02 and 9 Oct 01:29 UTC (pools in /opt/crew/work/ppdata/inits_recent.json, topic1 = pool id, hooks field). About 5 per day, same as the 8/day-ish baseline: ramp has not stopped.
- Sellability eth_call: NOT done. It needs a v4 router simulation with state override from a fresh address; I will not guess a call encoding. Suggest the $5 live test (Ben) or ask ppfeeds, who know the live router path.