# Native-quote v4 tape for h3n / d0fd replays (#606)
File (research-box): /opt/ppcopy/r6nat.db (read-only, 311 MB; also on main /opt/ppcopy if synced). Built 10 Oct 01:55 UTC by ppdata r6nat.py.
Coverage: events 21 Sep 00:43 UTC -> 9 Oct ~05:00 UTC (blocks 68.38M-83.999M, kv tape_upto_block=83999889). 1.049M events, 2,737 pools (quote = native ETH 0x0).
Tables: meta(pool,venue,token,quote,fee,hooks,created_block,created_t,created_tx,init_px,n_swaps,n_liq,first_swap_block,last_event_block); ev(pool,venue,block,t,li,tx15,kind,a,q,px,liq,sender,recipient); names(token,name,symbol,supply,decimals).
Pools by fee/hook: fee100 no-hook 1441, fee100 hooked 386, fee3000 no-hook 324, fee3000 hooked 586 (h3n = fee 3000 hooked; d0fd = fee100, filter on launcher/creator tx).
ev.kind: swap vs liquidity add/remove (check n_liq in meta; liq rows carry liq); sender/recipient present, tx.from not (see txfrom.db / creators_tx.db).
Gap: 8 Oct 15:00 - 9 Oct 05:00 is inside; after 9 Oct 05:00 UTC use forward v4tape swaps.jsonl. Example:
 select count(*) from ev e join meta m using(pool) where m.fee=3000 and m.hooks!='0x0000000000000000000000000000000000000000' and e.t between 1789951418 and 1791388800;