# Request to PP Data from FW Analyst 2 (8 Oct 2026, 17:45 Bangkok)

Why all four: Ben's rule (8 Oct) says every idea needs an OUTSIDE MONEY TEST before it goes to the test manager (what did real outside buyers actually get back in the same coins at our entry time and size). These fields make that test possible on v3 and make it exact on v4. Priority order = order below.

## R1. tx.from (signer) for every swap in the v3 golden tape
- Where: /opt/sw/harness/gold/p/<pool>.pkl (add an array `frm` aligned with the existing swap arrays), or one side table on research-box `swap_from(pool, block, li, frm)`.
- Why: on v3 the swap recipient is usually a router, so we cannot tell whose money it was. With the signer we can compute every wallet's ETH in / ETH out per coin and run the outside money test on the live mc5 coins and on A1-ADD.
- Backfill newest first; then keep it current with the hourly append.

## R2. Keep the v4 day files going past 7 Oct
- Where: /opt/hist/rh/YYYY-MM-DD.db, same tables (launches, pools, swaps, transfers, bars), one file per day.
- Why: every A2 test and the outside money test run on them; the newest day now is 7 Oct. The legitimacy fields (laneradar, solid, deepread, CASIG) only start on 4 Oct, so new days are what makes the "winners vs rest" test possible.

## R3. Tokenized stocks: main pools' full swap history + reference prices
- Tokens (from the KOL tape): NVDA 0xd0601ce157db5bdc3162bbac2a2c8af5320d9eec, TSLA 0x322f0929c4625ed5bad873c95208d54e1c003b2d, SPY 0x117cc2133c37b721f49de2a7a74833232b3b4c0c, AAPL 0xaf3d76f1834a1d425780943c99ea8a608f8a93f9, MU 0xff080c8ce2e5feadaca0da81314ae59d232d4afd, GOOGL 0x2e0847e8910a9732eb3fb1bb4b70a580adad4fe3, MSFT 0xe93237c50d904957cf27e7b1133b510c669c2e74, AMZN 0x12f190a9f9d7d37a250758b26824b97ce941bf54, COIN 0x6330d8c3178a418788df01a47479c0ce7ccf450b, GME 0x1b0e319c6a659f002271b69db8a7df2f911c153e, GLD 0xc9a981fee1f9dec688bb123ccdecc63d0debfc4e, COST 0x4ea005168d7f09a7a0ba9d1def21a479950e44c2, IBM 0x980dcf6766fa79f5cf0c4aadb3ab477ff15a9619, HIMS 0xccee82fe024c36fa15e1005ede3e9e4787e23d09, KLAC 0x96b933c74ecb4a0926b9210cef7b743ef46be2e9, SPCX 0x4a0e65a3eccec6dbe60ae065f2e7bb85fae35eea.
- Per token: the 3 deepest pools against ETH, WETH or USDG (0x5fc5360d0400a0fd4f2af552add042d716f1d168) by TVL (skip the 70-95% fee pools, they are traps), every swap from the pool's start (block, time, amounts, sqrt price, tick, liquidity).
- Plus 1-minute reference prices for the same tickers including pre-market, after-hours and weekend gaps (any public source), stored next to it.
- Why: idea A2-STOCK. If the chain price drifts from the real price while the stock market is closed, trading the gap back is rug-free and positive-sum.
- Deliver: research-box /opt/ppcopy/stocks.db (tables `pool`, `swap`, `ref_px`).

## R4. v4 swap sender (router) per swap in the day files
- The Swap event's `sender` (msg.sender to the PoolManager = the router). Table `swap_sender(pid, block, li, sender)` in each day file, or one side table.
- Why: with it we can measure exactly what GMGN users got (GMGN router 0x65050a9b7e5075a2ba5ced7b1b64ee66262c40dc). That is the cleanest "people like us" outside money test; today we must guess outsiders from wallet activity, which also mislabels skilled traders as fleets.

Contact: FW Analyst 2, workspace research-box /root/fwa2/edge. Pipeline copy: /root/pipeline/pp-requests/2026-10-08-a2.md