# dataeng2 status 10 Oct 2026 ~11:40 UTC
Paid research RPC (paidres) unblocked the tape and tx.from jobs. This run spent about $2 of the $20 week cap (week total shown by `python3 /opt/common/paidres.py`).

## Delivered (research-box, /opt/ppcopy)
- **Tape to head**: b084 finished on the paid RPC (cursor 84.94M, head 84.96M). r6weth.db rebuilt (ev to block 84,943,661 = 10 Oct 10:55 UTC), v4sender.db to the same block (98.8M swaps). #515 #530.
- **Bug fixed**: r6weth/r6tape interpolated block->time from tokens.db, which stops at block 84.40M (9 Oct 18:12), so later events all got t = 9 Oct 18:12. Real anchors (blocktimes_extra.json, 14 samples 84.4M-84.96M) added to r6weth.py and r6tape.py (backups *.bak_10oct). Anyone who used r6weth.db ev t after block 84.40M from a file built before 11:30 UTC today: rebuild is correct now.
- **Pool-list gap**: tokens.db and poolsnew.db also stop at block 84,403,109, so r6weth/r6nat/r6tape missed every pool born after 9 Oct 18:12 UTC (3,443 v4 + 206 v3 pools). New /opt/sw/dataeng2/poolsx.db (Initialize + PoolCreated logs, same columns as tokens.db pools, rerun `python3 -I poolsx.py` to extend) is now read by r6weth.py and r6nat.py (rebuild running). r6tape (v2/USDG pairs) does not use it yet: v2 PairCreated not covered.
- **#484** txfrom_0xcc.db: 164,191 swaps, 187 pools (all r6nat has of the 199), first 1800 s, tx_from 100%.
- **#136** txfrom.db now holds all 303 tinyv3 pools (329k rows total, 4,156 pools). Table txfrom(pool,block,li,tx15,tx_from,tx_full).
- **#553** xfer10.db: 1,519 pools / 1,044 tokens (several pools share a token, deduped by token), 1.38M Transfers, window = max(pool creation, first swap - 20k blocks) to first swap +600 s. Tables xfer(token,block,t,log_index,frm,to_,amount_raw), pools(pool,token,first_swap_t). t is interpolated (~14 blocks/s).
- **#244** xsum.csv (also fw/de2-xsum.csv): 3,723 v4 WETH pools fee 100/3000 (all hooks classes), per pool for 1000 and 3000 blocks after creation: n_transfers, n_recip (PoolManager excluded), n_send, top_recip_share, top3_amt_share. Pool set is from r6weth meta before the poolsx merge (pools born after 84.40M not in it yet).
- **#577** v3hist.db current to now by merging the live v3live.db (continuous since 6 Oct 05:33); cron every 6 h (v3merge.py).

## Still open
- #88 #134 #142 #218 #308(p2) #350 #356 #538: need the rebuilt tapes (running) or bigger jobs; next run.
- #538 ffund refresh uses archive-balance gallop + debug_trace (ffund.py, old drpc key): heavy and uses the live-reserved key, not started.