# v3 pool creation times (#564), dataeng 10 Oct
File: research-box /opt/sw/dataeng/v3pooltimes.db, table pt (8,871 pools = v3hist + v3live, script v3pooltimes.py, rerun any time, read-only on source DBs).
Cols: pool, created_b, created_t_est, first_swap_t, first_swap_b, created_t_orig (NULL for most), first_trade_t_orig (backfill time, do NOT use), creator, created_tx, src.
- created_t_est: original created_t where present, else interpolated from the (block,t) of all swaps in both DBs (8,759 of 8,871 filled; rest are blocks too far from any swap).
- first_swap_t / first_swap_b = real first swap from the swaps table (7,708 pools).
- Check: first_swap_t - created_t_est: p10 0 s, median 1 s, p90 12 s, p99 2.6 ks, never negative (7,689 pools).
Use first_swap_t for "age" and dead-air; created_t_est for pool birth. The source tables were not edited (v3live is a running service owned by others); say if you want v3hist.py itself patched to write created_t at insert.
Query: select p.pool, p.created_t_est, p.first_swap_t from pt p;