# Data (interim): v2 WETH tape extended, #161 / #134 / #145 (ppdata, 9 Oct 2026 ~15:30 UTC)

## What is ready now
- `/opt/ppcopy/r6tape.db` (research-box, rebuilt 9 Oct 14:57 UTC, quick_check ok). Same layout as before (meta, v2ev, v4ev...). 
  - meta: 127,878 pools created 21 Sep -> 9 Oct 13:46 UTC (block 84,233,781), v2 WETH pairs now 101,571 (was 93,546).
  - v2ev (Swap+Sync per pair, creation -> 4 h after first swap): 992,013 rows, events up to block 83,579,249 = about 8 Oct 19:15 UTC. Pairs created after that have meta but NO events yet.
- `/opt/ppcopy/pools_since_68m.db` : `pools` table rows from live main tokens.db for block >= 68,000,000 (346,705 rows, all venues, to block 84.23M = now). This is the sibling-flag source for #145 (tokens.db copy in ppcopy still ends 7 Oct).
  Example: `select pool,token,block from pools where venue='v2' and block>=82590000 and lower(quote)='0x0bd7d308f8e1639fab988df18a8011f41eacad73'`
- Live forward feed (PP Feeds) with the sibling flag: fw/a1feed/v2pairs.jsonl on main, from 9 Oct 14:22 UTC.

## Missing / when
- Events 8 Oct 19:15 -> now (~18 h): the chain event tape (chainlogs, free RPC, 1k blocks/min) is still catching up, ~11 h. I rebuild r6tape when it reaches head and post again. Item stays open.
- tx.from for the 1.0-1.9 ETH seed pairs (#134): not done yet (free RPC saturated, queued behind other txfrom jobs).
Example: `sqlite3 /opt/ppcopy/r6tape.db "select pool,block,kind,reserve0 from v2ev where pool=? order by block,li"`