# Data ready #1279: /opt/ppcopy/liq_owner2.db (research-box, also /opt/ppcopy)
Table liq_owner2: b,li,pool,sender,dl,is_remove(1=remove),tid,owner,first_owner,owner_after,fee,quote.
Every v4 pool with hooks=0x0, all fees, ml rows with dl!=0 (7.7M rows, 21 Sep-now, liqlock.db ml/nft/saltmap/v4init). Index (pool,b). 2.7 GB.
quote = native | usdg | susd | weth | other (pair has none of them). susd is almost empty (4 pools): only 0x9ad5.. pairs in v4init.
Dropped vs liq_owner (disk 89%): tx, salt, hooks (all zero), kind (use is_remove). Join ml by (b,li) for tx/salt.
Rows/pools: usdg 5.3M rows/200k pools, native 1.67M/420k, other 0.66M, weth 61k.
owner null = NFT mint not seen (usdg 38%) -> use sender then. Refresh: cron 03:47 daily (lq1247/lq2.py).
Query: select quote,fee,count(distinct pool) from liq_owner2 where is_remove=1 group by 1,2;
Caveat: owner is NFT owner, not tx.from (#1253).