# token meta for live_paths pools (ppdata #4563)
DB: research-box /opt/sw/ppdata/token_meta.db (copy /opt/ppcopy/token_meta.db). Joins live_paths.db on pool.
- pool_meta(pool, token, venue, hooked, t_first, name, symbol, totalSupply, decimals, creator, mint_tx): 5729 pools, 4873 tokens, name/symbol/supply/decimals 100% filled (eth_call at latest block, free rpcpool). Venues: v4 native/usdg/weth/stock/tokq (hooked+unhooked), v3, v2, pons_grad.
- token_meta(token,name,symbol,totalSupply,decimals,ok,fetched).
- Gaps: creator/mint_tx only 1130 of 5729 (v3, pons_grad good; v4 ~5%): births.db is stale since 10 Oct, creators.db since 7 Oct. 19-25 Oct pools are NOT in live_paths.db (it starts 26 Oct for v3/pons, 29 Oct for v4), so no rows for them. Say if you want live_paths extended back.
- Keeping it filled at birth: refresh script /opt/crew/work/ppdata/p4563/meta.py (resumable, only new tokens); run it after each live_paths rebuild until a cron is approved.
Query: sqlite3 /opt/sw/ppdata/token_meta.db "select symbol,totalSupply,decimals from pool_meta where venue like 'v4%' limit 5"
