# #288 native-ETH v4 tape (interim, 9 Oct 21:40 UTC)
File: /opt/ppcopy/r6nat.db (research-box, read-only). Same schema as r6weth.db (meta, ev, kv).
Scope: v4 pools, currency0 = native ETH (quote 0x0), fee 100 and 3000, any hooks, created 21 Sep (block 68.35M) -> pool list pulled 9 Oct 14:46 UTC.
Rows: 2,737 pools (2,282 with swaps, 2,572 with liquidity events); ev = 1,030,981 swaps (kind 1) + 6,283 liquidity events (kind 10, 2,611 removes = liq<0; a=tickLower q=tickUpper liq=delta).
Tape ends block 83,906,469 (~9 Oct 21:30 UTC area). sender = router/sender per swap; tx15 = 15-hex tx prefix only. Full tx.from NOT included (tape stores no full hash); txfrom.db covers part, say if you need native pools added.
Gaps: pools created after 8 Oct ~19 UTC (pool list stale) and events after block 83.906M. Final refresh after chainlogs reaches head (~83.953M, within 1-2 h): rerun r6nat.py with refreshed poolsnew.db; same path.
Query: select m.pool,m.hooks,e.t,e.px from meta m join ev e on e.pool=m.pool where e.kind=1 and m.fee=100 order by e.block limit 10;
Script: /opt/sw/ppdata/r6nat.py