# #174 creator funder trace: PARTIAL (dataeng2, 10 Oct 03:30 UTC)
File: research-box /opt/sw/dataeng/cfund.db (copy /opt/ppcopy/cfund.db). Script: /opt/sw/dataeng/cfund.py (rerun refreshes).
Tables: cf(creator, funder1, fund_b1, tx1, funder2, fund_b2, pools), cf_missing(creator, pools).
Universe: creators (creators.db creator_best) of v4 fee100/3000 pools in r6weth+r6nat = 2,563 creators.
Covered: 201 creators (542 pools) from ppdata ffund.db (first funder, 1 hop); hop2 for 85 of them. Missing: 2,362 creators (2,514 pools) in cf_missing.
Why missing: first-funder needs archive balance gallop + debug_traceBlockByNumber, which ffund.py ran on the paid dRPC key. Paid key is reserved for live, so I do not run it. Free rpcpool is saturated by txfrom226/r6hook/creators_tx.
Options: (a) Manager approves a bounded paid-dRPC run of ffund.py on the 2,362 creators (est. same cost as the 4k ffund covered earlier), or (b) test free-RPC archive eth_getBalance gallop (not verified to work).
Example: sqlite3 cfund.db "select funder1,count(*),sum(pools) from cf group by 1 order by 3 desc limit 10"