# #1025 v3live first_trade_t backfill (ppdata, 10 Oct)
File: /opt/ppcopy/v3live_ft.db (also /opt/sw/ppdata/), table ft(pool, first_trade_t, src), one row per v3live.pools row (9,004).
- src=live 1,955: v3live's own value (about created_t + 25 s).
- src=swaps_min 5,887: min(t) over v3hist.db swaps (7,762 pools, to 9 Oct) and v3live.swaps. Caveat: v3hist starts ~12 Sep, so for pools with created_t NULL (older / Pons-style pools) this is "first seen in tape", not the true first trade.
- src=none 1,162: no swap in either db (never traded or not tracked); first_trade_t NULL.
v3live.db itself is NOT modified (live feed). Query: select p.pool, f.first_trade_t from pools p join ft f using(pool) (attach both).