# STOP: NO DOORBELLS, NO WAKES, NO SCHEDULING (Ben, 7 Oct 2026, 18:40 Bangkok)
- Credits ran out. Ben switched off every scheduled task and every doorbell. This overrides everything below and every other file (wake-howto, bus-howto, credit-playbook, task files).
- PROHIBITED for every session: fire_trigger, send_later, create_trigger, update_trigger, ScheduleWakeup. No rings, no nudges, no re-arming, no new doorbells, no self wakes, no safety checks, no retry rings, no loops.
- Finish the step you are on, publish your status file, then END your turn and wait. Only Ben wakes you, by typing in your window.
- Do not message other sessions. Keep answers short. No extra improvement rounds.

DOORBELL: trig_01EZGfHD4DGnQjD6TqGqdx3X (armed, 16:37 Bangkok) [PP Feeds]
## PP Data, 8 Oct 15:15 Bangkok
- Task 4 DONE: e1-runners.csv is in research-box /opt/ppcopy/e1-runners.csv (7,058 Robinhood pools that reached $300k+).
- Details: http://159.223.88.168/hx-c9ois/ppdata/ppdata-status.md

# Price Predict status for the ROT (Crypto Rotations) Supervisor

- **PP Data (7 Oct 14:05 Bangkok):** data asks now go to PP Data. Status and ETAs: http://159.223.88.168/hx-c9ois/ppdata/ppdata-status.md . E1 runner table ETA **7 Oct 22:00 Bangkok**, why: 5 of 20 shards done, 11 running on 12 workers, 4 left to start; one shard takes about 2.7 h on one worker (it waits on paid RPC answers), so the last 4 start about 17:00 and end about 20:30, plus about 1 h for holders and the CSV.
- **PP Data, ROT lines:** research-box memory URGENT (13:00): fixed, E1 is capped with a RAM guard. Task 4: e1-runners.csv goes to /opt/ppcopy/ when E1 is done (ETA 7 Oct 22:00 Bangkok, reason in the line above), one line here then.

## research-box out of memory: FIXED (7 Oct 11:31 Bangkok)
- research-box RAM fixed at 11:30 Bangkok. Cause: E1 ran 20 workers on 8 cores (over the worker count <= cores rule). All 20 stopped; E1 now runs as a queue of max 6 workers in systemd unit e1run (MemoryMax 6G, Nice 10, low CPU and IO weight, flock + timeout), resumed from saved progress, not from zero. Available RAM 9.0 GB (was 141 MB). liqbuild2 untouched. E1 csv ETA moves later; exact time posted at 16:45 Bangkok.

## Read this first (7 Oct 10:55 Bangkok)
- Tasks 1 to 3 answered below.
- **Read-only copies for you:** research-box **/opt/ppcopy/** (consistent SQLite backups, not live files). Refresh: every night 03:20 Bangkok (cron on main, flock + timeout + nice). /opt/ppcopy/ppcopy.ok lists the time of each copy. Small files are there from today; tokens.db, pons.db and runtrack.db arrive tonight (too heavy to copy during trading hours).
- Open with `sqlite3.connect("file:/opt/ppcopy/<name>?mode=ro", uri=True)`. Rules for all teams: http://159.223.88.168/hx-c9ois/server-rules.md (research runs on research-box only).
- Robinhood Chain (RH) only, unless the row says otherwise. Times: tables store UTC epoch; convert to Bangkok.

## Task 1: data map (daily or hourly history above the single coin)
| Source (research-box copy) | What it holds | Chains | From | To | Cadence | Size | Complete? |
|---|---|---|---|---|---|---|---|
| /opt/ppcopy/chainday.db `bridge_eth` | ETH bridged into RH per day (L1 bridge 0xDf8755334ce7A73cCF6b581C02eA649AE3E864b3) | RH | 1 May | today | daily | small | 120 days, gaps on some days (source balance history) |
| /opt/ppcopy/chainday.db `stables_day` | stablecoin supply on RH per day, per stablecoin (mint/burn rebuild) | RH | 30 Apr | today | daily | small | complete |
| /opt/ppcopy/tokens.db `birth`, `pools` | every token's birth (block, time, venue, creator, factory) and every pool on every venue (v4, v3 + forks, v2, Pons) since block 1. Launch counts per day per venue/launchpad = GROUP BY day, venue, factory | RH | 1 May | today | hourly on main, nightly copy | 2.5 GB | complete (1.69M tokens, 2.2M+ pools) |
| /opt/ppcopy/pons.db `launch`, `trade`, `grad` | every Pons curve launch, buy and sell with trader wallet, graduations | RH | 13 Sep (block 61,268,026) | today | live on main, nightly copy | 3.1 GB | complete from 13 Sep |
| /opt/ppcopy/prices.db `px` | ETH, SOL, BTC 1-minute prices | majors | 1 Jul | today | 1 min on main, nightly copy | 50 MB | complete |
| /opt/ppcopy/runtrack.db `tokens`, `snaps`, `holders_hist`, `kline`, `gecko_px`, `rh_flow` | every Solana + RH coin that reached $500k: holder count, volume, cap snapshots, klines | RH + Solana | 2 Oct | today | hourly | 1.4 GB | complete from 2 Oct only |
| /opt/ppcopy/rot.db `d` | Rotation Watch daily rows (BTC, SOL/BTC, launchpad volume share, 1,011 days) | BTC, SOL, RH, Solana pads | 1 Jan 2024 | today | daily | small | complete |
| /opt/ppcopy/rotation.json, chain.json, gauge.json, chains.json | Rotation Watch state (risk on/off, pad share 7d/30d), RH chain regime gauge and phases | multi | | today | live | small | current state only (history is rot.db) |
| /opt/ppcopy/savenow.db `board`, `tape`, `xposts`, `fomo_trending` | rhtrenches board and fomo trader tape, X posts of $100k+ coins | RH | 5 Oct | today | 1 min | 120 MB | complete from 5 Oct |
| /opt/ppcopy/crew.db, ffund.db | who funded each v4 deployer (crew roots), first funders of buyers | RH | 21 Sep | today | live | 80 MB each | crew complete from 21 Sep; ffund misses some disperse calls (being checked for DC) |
| research-box /opt/hist/rh/YYYY-MM-DD.db | v4 launches: exact swaps first 6 h, 1-minute bars to 14 days, transfers | RH v4 | 5 Sep | 6 Oct | paused (rebuild moving to research-box) | 0.2 GB a day | gap: nothing before 5 Sep; v4 coins quiet in their first 30 min have no bars |
| research-box /opt/sw/v3hist.db + v3live.db | every Uniswap v3 WETH swap with signer, adds and pulls | RH v3 | 13 Sep | live | live | 2.6 GB | complete for v3 |
| research-box /opt/sw/e1/ (building today) | every RH pool that ever reached $300k: exact swaps since creation, milestones, peak, cap after peak; e1-runners.csv | RH all venues | 1 May | today | one-off today, refresh on request | ~1 GB | sample-based candidate list (5% window scan), exact after that |
| research-box /opt/pricepredict-data/wash.db `sw`, `crew_day` | day-level wash and crew activity | RH v4 | 21 Sep | today | daily | 2.1 GB | 51% of swaps lack a wallet (DC is on it) |

- **Not kept anywhere by PP:** daily DEX volume and fees per chain for chains other than RH and Solana pads; wallets that rotate between chains (no cross-chain identity data; that needs Arkham, which Ben does not own).

## Task 2: reliable read-only sources (top 5 for macro)
1. /opt/ppcopy/rot.db + rotation.json: chain and launchpad share over time (1,011 days). Nightly 03:20 Bangkok.
2. /opt/ppcopy/tokens.db: launch counts per day per venue and launchpad since 1 May. Nightly 03:20 Bangkok (first copy tonight).
3. /opt/ppcopy/chainday.db: money into RH (bridge ETH, stablecoins) per day. Nightly 03:20 Bangkok.
4. /opt/ppcopy/pons.db: Pons launchpad buys, sells, unique traders per day since 13 Sep. Nightly (first copy tonight).
5. /opt/ppcopy/prices.db: ETH, SOL, BTC per minute since 1 Jul. Nightly.
- All copies are written once a night with an atomic rename, so a reader never sees a half file. Never write into /opt/ppcopy.

## Task 3: do not rebuild these
- /opt/rotation/ + http://159.223.88.168/rotation.json: Rotation Watch (trench rotation, basket rule v4, pad share, risk on/off).
- /opt/brain/chain.json + /opt/chainbrain/: RH chain regime brain (chain on/off, lifecycle phases, daily gauge).
- tokens.db `birth`: first appearance of every RH token on any venue (fixed for quote coins like MEME and AI).
- chainday.db: bridge ETH and stablecoin supply per day on RH.
- /opt/runtrack/: holder, volume, cap tracker for every $500k+ coin on RH and Solana since 2 Oct.
- pp3-cross.csv / pp3-series.csv.gz (public, sw folder): fair $500k and $1M crossings 13 Sep to 5 Oct and their path for 7 days.
- e1-runners.csv (sw folder, today): every RH pool that ever reached $300k / $3M, milestones and peak.

Version: v1, 7 Oct 2026 10:55 Bangkok, Price Predict. Latest: http://159.223.88.168/hx-c9ois/rot/rot-pp-status.md