# #457 USD price series, hook 0x4e34 pools (ppfeeds, 10 Oct 2026)

**Where:** research-box `/opt/ppcopy/h4e_usd.db` (read-only copy; main copy: `/opt/launchwatch/pub/hx-c9ois/ppfeeds/h4e_usd.db`, 15 MB). Source tape: chain shards b061..b083, **up to block 83,999,889 (about 12 h behind now)**. Scripts: `/opt/sw/h4e/h4e_bins.py` (5-min bins in quote units, 3 min run) and `h4e_usd.py` (USD). Raw quote-unit bins: `/opt/sw/h4e/h4e_bins.db`.

**Scope (assumption):** not only the top 2,000: ALL 57,488 hook-0x4e34 v4 pools born since 13 Sep (block 61,515,333). Only 13,414 ever had a swap in the tape (the rest are never-traded spam); **7,642 of these are priced in USD**.

## Tables
- `usd5(pool, bin, o,h,l,c, buy_usd, sell_usd, n, qres_usd, cap_c)`: 5-min bins (unix s), only bins with swaps (sparse, no forward fill), 68,387 rows. Token price in USD; buy_usd = quote into the pool (buys), sell_usd = quote out; qres_usd = virtual quote reserve (L x sqrtP) at the last swap of the bin; cap_c = c x supply.
- `pools(pool, token, quote, q_src, created_t, fee, supply, first_t, last_t, t_100k, t_300k, t_1m, t_5m, peak_cap, peak_t, peak_cap_liq, swaps, buy_usd, sell_usd, max_qres_usd, n_bins)`: e1-like. t_* = first bin whose HIGH cap crossed the level **while qres_usd >= $2,000** (dust guard). peak_cap is unguarded, peak_cap_liq guarded.
- Quote USD source (`q_src`): eth (WETH 0x0bd7 / native: ETH-USD hourly), usdg (=1), stock (stocks.db ref_px 60m close, ffill over weekends), ref (the quote token's own pool vs WETH/native/USDG).

## Coverage
| quote | pools priced | hit $300k | $1M | $5M |
|---|---|---|---|---|
| WETH 0x0bd7 | 1,978 | 9 | 5 | 1 |
| 0x2e8c (ref-priced) | 1,462 | 6 | 0 | 0 |
| SPCX 0x4a0e | 1,106 | 3 | 1 | 0 |
| USDG | 636 | 0 | 0 | 0 |
| NVDA 0xd060 | 588 | 2 | 1 | 0 |
| native | 349 | 0 | 0 | 0 |
| other stocks (GME, SPY, GOOGL, MSFT, ...) | ~900 | 8 | 2 | 0 |
Total 30 pools touched $300k (8 touched $1M) out of 7,642 priced (0.4%), matching analyst3's 26 for WETH/native, and the stock/token-quoted ones are now visible: **21 non-WETH $300k touches, 3 of them above $1M** (see query). Stock-quoted pools are NOT a hidden runner lane at scale; they are mostly spam like the rest.

## Known gaps
1. **~5,800 traded pools not priced**: quotes 0x1937, 0xf51f, 0xfe09, 0xc0d6, 0x1d11 (about 1,000 pools each) have no reference pool vs a base token. In `h4e_bins.db` they have quote-unit series (`bins`, joined with `meta.quote`), so ratios/multiples work without USD; only the absolute cap does not. Would need a quote-in-quote chain (not done).
2. Tape ends at block 83,999,889 (~12 h old); a refresh is `python3 h4e_bins.py && python3 h4e_usd.py` (about 4 min, niced). Not on cron; ask if you want it daily.
3. Supply missing for ~110 pools (cap NULL). Supply taken from names/r6meta/birth, assumed constant.
4. A WETH-quoted pool peaks at $68M: almost certainly a thin-liquidity glitch; use peak_cap_liq and the t_* columns, check qres_usd.
5. Quote USD uses the quote's price at the bin; ETH-USD is hourly before 7 Oct (error small).

## Example
```
sqlite3 /opt/ppcopy/h4e_usd.db "select p.pool,p.q_src,p.t_300k,p.t_1m,p.peak_cap_liq,
 (select max(h) from usd5 u where u.pool=p.pool and u.bin>=p.t_300k) from pools p where p.t_300k is not null order by p.peak_cap_liq desc limit 10"
```