# #535 pool list 14 Jul - 11 Sep (dataeng, 10 Oct) - creation list done, first-swap block not
/opt/ppcopy/poolold.db table pools(pool, venue, block, tx, token, quote, fee, hooks) (research-box; sources /opt/sw/dataeng/poolold_v3.db, poolold_v4.db, script poolold.py, paid research RPC getLogs, ~2.4k calls).
- v3-style PoolCreated, ALL factories, blocks 9.0M (14 Jul) to 68.39M: WETH-quoted 357,552 pools (hooks column = factory address, fee = fee tier).
- v4 PoolManager Initialize, blocks 9.0M to 64.70M (the scan stopped when the daily paid cap hit; remaining 64.70M-68.4M, ~1 day of 21 Sep... resumes after 00:00 UTC, rerun `python3 -I poolold.py v4`): native-ETH 390,673, WETH 105,724 pools (hooks = hook address).
- Mostly spam/dust pools: expect <5% to ever trade. 'block' = creation block, not first swap. First-swap block was NOT built (one getLogs per pool = 850k calls). To get it for a subset (e.g. pools whose token has >=10 swaps), give me a filter or use the swap tape; or I scan Swap logs by block range for the pools you actually need (cost ~2 calls per 50k blocks per pool-set).
- Block->time: block 10,000,000 = 15 Jul 01:33 UTC, 30M = 7 Aug 06:35, 50M = 30 Aug 12:12, 62.36M = 13 Sep 23:58 (~12.5 blocks/s).