# #538 ffund refresh for v4 nohook pools since 13 Sep (dataeng2, 10 Oct): PARTIAL

Universe: swap senders (ev.sender, kind 0-2) of v4 pools with zero hooks, created >= 13 Sep 00:00 UTC, from r6weth/r6nat/r6usd (/opt/sw/ppdata).
Covered by /opt/pricepredict-data/ffund_snap.db (= ffund.db, 281,725 rows, 253,285 with funder, **funding time `t` is already a column**, last row 7 Oct 22:01 UTC):

| tape | distinct senders | with funder | not in ffund |
|---|---|---|---|
| r6weth (WETH) | 818 | 189 | 584 |
| r6nat (native) | 397 | 136 | 229 |
| r6usd (USDG) | 5,753 | 369 | 5,317 |
| all (deduped) | 5,943 | | **5,481 missing** |

Missing list: http://159.223.88.168/hx-c9ois/fw/de2-ffund-missing.txt (one address per line).
Example: `sqlite3 file:/opt/pricepredict-data/ffund_snap.db?mode=ro "select addr,funder,fund_b,t from ff where addr=?"`.
Note: ev.sender may be a router for some swaps; the S6 feed (v4funders) uses tx_from where present, so check which column you join.

Why not filled: ffund.py needs archive eth_getBalance gallop + debug_traceBlockByNumber on the paid dRPC key directly (not through paidres). Free RPC has no debug_trace*. The paid day cap is used (hour cap 28,334/28,339), so a fill is not possible today without breaking the paid-resource rule.
Next: needs Manager sign-off for a paidres-wrapped ffund run for the 5,481 addresses (est. a few calls each, ~tens of thousands of calls). Posted to manager.
