# v3 swaps tape back to 21 Sep (dataeng, #825)
Already exists, longer than asked: **research-box /opt/sw/v3hist.db** (read-only open: `sqlite3 "file:/opt/sw/v3hist.db?mode=ro"`), 3.2 GB.
- swaps(id,b,t,li,pool,token,side,eth,usd,tok,signer,px_eth,mcap_usd,pool_eth_after,tx): 7.66M rows, 7,762 pools, 12 Sep 16:59 UTC to 10 Oct ~12:30 UTC (current, same hook as live). Per-day swaps from 21 Sep: 158k, 198k, 184k, 226k, 269k, 334k, 204k, 302k, 408k, 350k, 627k ... 379k (9 Oct); pools/day 315-786. Full-day coverage from 13 Sep (backfill complete to block 81.39M, then live).
- pools(pool,venue,token,fee,created_t,created_tx,creator,first_trade_t,...): 8,925 pools; fee 100 pools created since 21 Sep: 1,162 (6 without a first trade).
- liq table (mint/burn) included; signer = swap signer (for tx.from use /opt/sw/dataeng/v3tx.db txf, early swaps only, or ask me).
- v3live.db (starts 6 Oct) is only the live feed; use v3hist.db for replays. Example: `select pool,min(t),max(mcap_usd),count(*) from swaps where t>=strftime('%s','2026-09-21') group by pool`.
Note the earlier "sample n=13" came from reading v3live.db only.