# Pre-launch distribution (#604, ppdata, 10 Oct 2026)

**Data:** research-box `/opt/sw/ppdata/prelaunch.db` (copy `/opt/ppcopy/prelaunch.db`), raw fetch in `prelaunch_raw.db`.

Tables: `prelaunch(token,pool,grp,venue,n_transfers_pre,n_recipients_pre,share_outside_pre,top1_5m,top10_5m, + n_recip_exdep_pre, share_xfersum_pre, top1_5m_exdep, top10_5m_exdep, deployer, supply, first_b, b5, created_b, cap5, coverage, note)` and `transfers(token,b,t,frm,"to",amount)` (t is NULL: block only; join first_b/b5 or the swaps tables for time).

Groups (`grp`): band = v3 pools (v3hist+v3live, first swap since 6 Sep) with cap 250k-1M at first swap +300 s (live mc5 rule; `cap5` = last swap mcap_usd <= +300 s); ctl = 500 random v3 fee-100 pools not in band; nh56 = the 56 v4 no-hook climbers of #547.

| grp | tokens | mean share_outside_pre | mean n_transfers_pre | mean top1_5m | mean top10_5m |
|---|---|---|---|---|---|
| band | 363 | 0.069 | 547.5 | 0.267 | 0.553 |
| ctl | 500 | 0.076 | 1.8 | 0.114 | 0.223 |
| nh56 | 56 | 0.014 | 0.0 | 0.059 | 0.239 |

coverage: [('complete', 'an1', 144), ('complete', 'fetch', 726), ('nomint', 'fetch', 49)]

**Definitions / assumptions**
- pre = Transfers in blocks strictly before the pool's first swap block. n_transfers_pre excludes mint (from=0) and transfers to the pool / PoolManager. n_recipients_pre = distinct recipients of those.
- share_outside_pre is balance-based (replay of all transfers incl. mint): supply minus balances of {pool, PoolManager, deployer, 0x0}, at the block before the first swap. share_xfersum_pre is the literal sum of pre transfers / supply (double counts multi-hop moves).
- deployer = token creator (v3hist/live `creator`, if present) + recipient of the first mint. Supply = minted - burned seen in the window (fallback pools.supply). Decimals default 18 when unknown.
- top1_5m / top10_5m = holder share of supply at first swap +300 s excluding pool/PoolManager/0x0 (deployer INCLUDED); *_exdep versions exclude the deployer too.
- Token window starts 5,000 blocks before pool creation. Rows with note `fetch`+coverage `nomint` did not show the mint in the window (token older than the pool): shares for them are partial. 161 tokens came from the earlier tw/an1 transfer db (mint reached). Pools with first swap >2M blocks after creation are skipped (`dormant_skip`).
- The 'band' list is my reconstruction (no pool list was attached): tell me if you have the exact 291.
Example: `select grp,avg(share_outside_pre) from prelaunch group by grp;`