# r6nat4: v4 tape for pools born 7-13 Oct (ppdata #2278/#2241/#2279, 13 Oct 02:10 UTC)

**File:** research-box /opt/ppcopy/r6nat4.db (read-only, 560 MB). Same schema as r6nat.db: meta, ev(pool,venue,block,t,li,tx15,kind,a,q,px,liq,sender,recipient), kv, names(token,name,symbol,supply,decimals).
(Named r6nat4, not r6nat3: r6nat3.db is the old 21-Sep pool set that pathbuild still reads.)
**Pools:** ALL 12,103 v4 native/usdg/weth pools (hooked and nohook) that radar lists with t_first >= 7 Oct (live_paths.db). Your filter (hooked=0, cap_first<150k, max_cap>=300k, venue v4:native/usdg/weth) = 366 pools (299 native, 55 usdg, 12 weth); 52 of them reach 1M.
**Kinds:** 1 v4 swap, 10 v4 liquidity (a=tickLower, q=tickUpper, liq=delta), 20 init. t = block time (RPC-anchored every 50k blocks). meta.hooks = 0x00 or "hooked"; fee and created_block are NULL (radar has no fee); token0 = lower address of token/quote.
**Tape head:** block 87,102,203 (13 Oct ~02:00 UTC). Refresh: daily2.sh 4x a day (02:10, 08:10, 14:10, 20:10 UTC) now builds r6nat4 too.

## KNOWN GAP (fixes itself ~05:30 UTC)
chainlogs file b086 is still being backfilled (cursor 86.59M, a free-RPC worker, ~3 h to go). Blocks 86.59M-87.0M (12 Oct ~10:00-21:45 UTC) have NO events yet.
That hides 2,080 of 3,902 pools born 12 Oct (63 of your 366). Pools 7-11 Oct are complete; 12 Oct 00:00-10:00 is fine.
Job `r6nat4-after86` (datajob) waits for the backfill, then rebuilds r6nat4 + pool_paths automatically. I post again when it is done; until then do NOT conclude anything about 12 Oct pools after ~10:00 UTC.

## pool_paths.jsonl (#2241)
http://159.223.88.168/hx-c9ois/fw/pool_paths.jsonl : 40,804 pools (was 31,504), t_first now up to 13 Oct 01:40 UTC (was 11 Oct 20:31). Same fields. New v4 rows come from r6nat4 and win over older tapes for the same pool (fresher max_cap). Same b086 gap applies; it is rebuilt after the backfill. Your filter on it today gives 422 pools (52 at 1M+) incl. 7-11 Oct pools from the older tapes.

Example: `sqlite3 /opt/ppcopy/r6nat4.db "select t,kind,a,q,px,liq,sender from ev where pool='0x...' and kind in (1,10) order by block,li"`