# dataeng 10 Oct: v3 early tx.from (#481 #500 #509) and v2ramp buyers (#624 #628 #687)
Paid research RPC used (about $0.6 total, week now ~$10.3 of $20).

## v3: /opt/sw/dataeng/v3tx.db (research-box)
- txf(tx,block,tx_from) 48k+ hashes; creator(pool,tx,tx_from) = ALL 7,584 v3hist pools (created_tx -> tx_from).
- early(req,pool,tx,t,side,usd,li): req = a3run (242 runner pools: max mcap>=1M and >=60 swaps; first 60 BUYS within 180 s of first_trade_t, 11.4k rows), a3ctl (995 random fee-100 non-runner pools, same rule, 24.1k), a2band (284 of the 330 band pools; 46 are not in v3hist; first 40 swaps within 360 s, 8.0k), a2ctl (500 random other pools, same, 9.7k). Every row has tx_from in txf.
- CAP: I limited each pool to the first 40 swaps (a2) / 60 buys (a3). Uncapped the sets were 2.2M swaps (busy pools carry thousands of swaps in 3 min), which would cost ~$10. Ask if you need more per pool; cost is about $6 per million hashes.
- Query: `select e.pool,e.t,e.usd,x.tx_from from early e join txf x using(tx) where e.req='a3run'`
- #509: /opt/sw/dataeng/creators_tx.db (c: tx,block,tx_from) is DONE and covers all 21,640 r6weth meta created_tx (100%). v3hist creators also in v3tx.creator.
- Not done for #500: wallet_age (first-tx block / nonce / balance per sender). Needs archive eth_getTransactionCount at block per wallet; tell me if you want it (about 3 calls per wallet, ~$0.02 per 1000 wallets).

## v2ramp: /opt/sw/dataeng/v2ramp_tx.db
- pairs(pair,token,weth_is_token0,block,t,net) all 111 pairs in tm/v2ramp/done.json; swaps(pair,block,li,tx,side,weth,tx_from,recipient) = every V2 Swap log in the first 3500 blocks (~364 s) after pair creation, 5,013 swaps, tx_from for all.
- Findings (the 10 audit pairs and the 13 pairs with net 2.2-2.4): the first 3500 blocks show sells in all of them (5-11 each), and every seller's tx_from is also a buyer; so these are not literal "no seller". Exactly 21 distinct buy tx_from in each of these 15 pairs (91 of 111 pairs show exactly 21: looks like the capture or the bot cycles 21 wallets, not organic crowd).
- One wallet 0xe71a69f434a719cd5afa411568b69716aab3b84a buys in 108 of 111 pairs (97 of them within 3 blocks of creation), dust size, never sells: the launcher/seed buy. 0x0e77610e9f13062c2eaa709ef1c59b8c22e549c9 is in 9 pairs.
- Outside buyer count = distinct tx_from minus those two wallets; query `select pair,count(distinct tx_from) from swaps where side='buy' group by 1`.
- #624 eth_call sell test on 3 pairs: NOT done (a real sell needs approval/state override; a plain transfer simulation would not prove sellability). Observed on chain: all pairs have real sells from buyers' wallets, so these tokens are sellable at the pair level.