# #894 fresh pools after 9 Oct 06:44 (ppdata, 10 Oct 2026)
Why stale: canon_pools / pool_paths / token_born are built from the chain tapes (r6*), which end 9 Oct 06:31 UTC; no source behind them is live. Rebuilding them cannot move the end date.
Delivered instead: /opt/ppcopy/live_paths.db (also /opt/sw/ppdata/live_paths.db), rebuilt every 6 h (cron 17 */6) from radar_state.json (3,718 pools, 3,356 tokens, t_first from 7 Oct; 2,670 pools after the tape end).
Table pools: pool, token, venue (radar labels incl. v2, pons_grad, stock/tokq), quote, hooked, t_first, cap_first, cap_5m, max_cap, crossed (json thresholds hit), depth_usd, done5, symbol, rank, is_first, n_siblings, first_pool. meta: radar_saved, min_t_first.
Gaps: no cap_1m/15m/60m, t50k/100k/200k, n_senders (radar keeps only c5, mx); no init liquidity or creator_from; v4 WETH/USDG not full history, only pools radar saw. Overlap 7-9 Oct with canon: use canon for t_first < 1791528700, live for the rest.
Example: select venue,count(*),sum(max_cap>=1e6) from pools where t_first>1791528700 group by 1
Full same-schema refresh needs a path writer in radar.py (ppfeeds/ops, live-adjacent) or a fresh swap tape past 9 Oct; ask if you want it.