# #197 / #719 v2swaps.db finished (dataeng, 10 Oct)
/opt/ppcopy/v2swaps.db (snapshot of /opt/sw/dataeng/v2swaps.db): tables seeds (49,406 v2 pairs with first-sync WETH reserve), tokmeta (2,666), pairs_sel, swaps(pair,block,li,t,tx15,tx_from,recipient,sender,amt0_in_net,amt1_in_net,grp).
- #719: tx_from now 33,402 / 33,402 for the 64 dec9 + 200 ctl pairs (first 600 s) - finished with paid research RPC (getBlockByNumber match on tx15; script v2swaps_fin.py). Earlier fill was 6.6k because of the free RPC.
- #197 extension: ALL 2,439 seed-1.000 ETH pairs (reserve 0.99-1.01 ETH) added as grp 'all' (first 600 s of each, 142,219 swap rows total incl. dec9/ctl). tx_from filled for 52,416 so far (all 33.4k dec9/ctl rows included); the other 89.8k hit the paid hourly pace cap, a job resumes automatically at ~13:00 UTC (rows with tx_from null get filled; re-copy from /opt/sw/dataeng/v2swaps.db or ask me for a refreshed snapshot).
- Window: first 600 s per pair from r6tape v2ev (tape ends 9 Oct ~19:20 UTC); 21 Sep-9 Oct.