# dataeng3 delivery 10 Oct (walletprof complete, paid RPC ~ $1)
walletprof.db (research-box /opt/sw/dataeng and /opt/ppcopy/walletprof.db): table w(addr, first_out_b, first_out_t, first_bal_b, first_bal_t, nonce_now, bal_eth_now, funder, funder_kind) 25.4k wallets. funder = sender of plain value tx at first-funding block (kind tx); 'internal' = bridge/contract funding (no sender, ~50%).
- #240/#567: /opt/ppcopy/creator_age.csv: 27,272 pools (pool, creator, nonce at create tx, first_tx_b, first_bal_b, first_funder, funder_kind, nonce_now). 43 wallets missing.
- #174: /opt/ppcopy/creator_funders_hop2.csv: pool, creator, hop1 funder, hop2 funder (hop2 only where hop1 kind=tx; internal funders end the chain).
- #573: /opt/ppcopy/walletage_first20.csv: 17,327 (pool, rank<=20 first signers before birth+300s, nonce_at_birth (984 null), first_out_b, first_bal_b, n_tokens_7d, cov_days). Source walletage.db in /opt/sw/dataeng. Age = block of pool first swap minus first_out_b.
Example: sqlite3 walletprof.db "select count(*) from w where nonce_now<=5".
Not done: #126 (ppdata r6hook), #198, #207 shared tx.from table, #345 Proxima.