# Data ready (ppdata, 10 Oct 2026): #388 USDG/SUSD v4 tape, #392 e1x refresh + custom-fee native tape
Tape end: chain block 83,999,994 (about 9 Oct 07:00 UTC). Nothing after that is on chain tape yet (chainlogs has no b084). For 9 Oct 07:00 to now use the live feeds (v4init, v4tape). All files read-only in /opt/ppcopy on research-box.

## #388 USDG/SUSD-quote v4 tape (analyst1)
- **/opt/ppcopy/r6usd.db**: 26,618 pools (26,584 USDG, 34 SUSD), 3.41M events, 21 Sep to 9 Oct 07:00 UTC, 14,288 pools with swaps. Same schema as r6weth.db (meta/ev/kv): ev.kind 1 = v4 swap (px = sqrtPriceX96, a = amount0, q = amount1 raw, sender), 10 = liquidity change, 20 = init.
- Token supply/decimals for these pools: r6tape.db meta (token_supply human units, token_decimals). Older table r6tape.db v4ev holds the same swaps (analyst2 used it).
- Price: r=(px/2^96)^2 = token1 raw per token0 raw; USD per token = (quote_raw/token_raw)*10^(dec-6) (USDG, SUSD ~ $1; SUSD is a thin peg, treat its caps as suspect).
- Example: sqlite3 -readonly /opt/ppcopy/r6usd.db "select pool,count(*) from ev where kind=1 group by pool order by 2 desc limit 5"

## #392 (analyst2)
1. **/opt/ppcopy/e1x-runners.csv** (script /opt/sw/ppdata/e1x.py): 27,272 pools born 21 Sep to 9 Oct, ALL quotes: v3+v4 WETH, v4 native, v4 USDG/SUSD. Columns: pool, token, venue, fee, hooks, **quote**, created_bkk, peak_cap, peak_bkk, first_{100000,300000,1000000,3000000,5000000,10000000,20000000}_bkk, cap_last, last_bkk, swaps, vol_usd, mins_to_1m, cap_flag (ok = >= $40k traded and >= 5 swaps). 634 ok pools with peak >= $1M (USDG 211, WETH v3 202, WETH v4 173, native v4 39, SUSD 9).
   Method differs from e1-runners.csv: cap from median-of-5 swap prints x supply x Binance ETHUSDT hourly (USDG/SUSD x 1.0), no glitch filter, no holders. On 738 pools in both, peak_cap vs e1 = median 1.09x (p10 1.02, p90 1.23): e1x is slightly higher. Not covered: v2 pools, and e1-runners.csv itself was NOT rebuilt (needs the paid-RPC pipeline); use e1 for births before 21 Sep, e1x from 21 Sep. Born 8-10 Oct: only to 9 Oct 07:00 UTC.
2. **/opt/ppcopy/r6nat2.db**: swap + liquidity tape (r6nat schema) for v4 NATIVE-ETH, NO-HOOK pools with fee not in (100, 3000), born 13 Sep onward (block 62.36M): the 132 pools that are runners (peak >= $1M, ok in e1 or e1x; you counted 143 with 11 outside this filter) plus 3,000 random controls of the other 86,388 such pools. Tape to block 83,999,442. Tell controls from runners by joining to e1-runners.csv / e1x-runners.csv on pool (controls were drawn from non-runners, seed 7). Weight controls by 86,388/3,000 for population rates.
   Example: sqlite3 -readonly /opt/ppcopy/r6nat2.db "select fee,count(*) from meta group by 1 order by 2 desc"