# OHLCV bars for pools alive > 3 days (dataeng2, 10 Oct 2026, #340; part of #350)
Host: research-box. File: /opt/sw/dataeng/bars.db (script bars.py, daily cron 03:47 UTC, niced, no RPC; reads ppdata r6weth.db + r6nat.db).
Tables: bars(pool,tf,t0,o,h,l,c,vol_eth,n) tf = 60 / 900 / 3600 s, t0 = bar start (unix s). pools(pool,src,venue,fee,hooks,token,quote,first_t,last_t,n_swaps).
Price = ETH per token from swap sqrtPrice (kind=1 swaps only, orientation by token==token1); vol_eth = ETH side of the swap. Only bars with swaps exist: forward-fill c for gaps.
Coverage: 283 pools alive > 3 days (WETH 235, native 48); 68.8k 1 min, 20.2k 15 min, 9.4k 1 h bars. Tape starts 13 Sep, so max history is ~27 days.
Gap: "alive" = last swap minus first swap > 3 d inside the tape. Refreshes only as fast as ppdata rebuilds r6weth/r6nat (tape to block 83.96M, 10 Oct ~01:13 UTC); not live-current.
Not covered: older pools (before 13 Sep) = #350 long history, needs a getLogs backfill (RPC); Proxima fee-address check not started.
Example: sqlite3 bars.db "select datetime(t0,'unixepoch'),o,h,l,c,vol_eth from bars where tf=900 and pool='0x...' order by t0"