Question: BIGB returns null price / rsi / all returns in the etf-monster-universe precompute despite being in the universe since v2 (2026-05-10). Fetcher bug, or dead ticker? Verdict: Dead ticker. BIGB (Roundhill BIG Bank ETF) liquidated/delisted 2023-12-13 — not a fetcher bug. Removed from etf-monster-universe.json.

What we're asking

Filed by the 2026-05-26 weird-ETF desk consolidation as a ~15 min data-gap task: BIGB shows a permanent null row in stonks/data/summaries/etf-monster-universe.json (price, rsi, all SMAs, all returns null; only pctFrom52wkHigh: -2.78 survives). The task framed it as "check stonks/data/stocks/BIGB/ — fix fetcher or remove from universe," and labeled the name "Roundhill Big Tech."

What we found

1. The name is wrong in our metadata. info.json reports "Roundhill Big Bank ETF" (banks + capital-markets exposure via swaps/forwards), not "Big Tech." The etf-monster-universe.json mechanisms map also mistagged it "underlying": "big-tech". The v2 add on 2026-05-10 appears to have assumed "BIG" = Big Tech.

2. The OHLC is frozen in 2023. data/stocks/BIGB/ohlc/max.json is weekly interval ("interval": "1wk"), count: 41, data_start 2023-03-13, data_end 2023-12-18. The last bar is a flat synthetic close (open=high=low=close=28.87, volume=0). _meta.json shows last_updated 2026-05-23 — i.e. the fetcher ran recently but still only got stale 2023 weekly data.

3. The "current price" is a stale quote echo. info.json (fetched 2026-05-23) reports current_price 28.87 — exactly the last 2023-12-18 weekly close — with tiny volume (volume: 169, average_volume: 2052). yfinance's quote endpoint echoes the final pre-delisting snapshot; it is not a live price.

4. A fresh fetch (2026-05-28) confirms delisting. deno task fetch BIGB:

   • info ✓ (stale 52wk-high snapshot)
   • 7d / 10d / 30d / 3m / 6m / 12m ✗ — $BIGB: possibly delisted; no price data found
   • max ✓ — same 41 stale weekly entries

5. Independent primary confirmation. Roundhill announced closure of the Roundhill BIG Bank ETF (BIGB): ceased accepting creation/redemption orders ~2023-12-11; shares ceased trading on the listing exchange before open of business 2023-12-13; liquidation proceeds distributed ~2023-12-14 (Roundhill "Changes to Fund Lineup"; SEC 497(e) supplement; OCC anticipated-liquidation memo #53737 and final cash-settlement memo #53776). This is exactly why the OHLC ends the week of 2023-12-18 and all daily fetches now report "possibly delisted."

6. Precompute behaves correctly. The null row is the precompute's staleness guard nulling price/returns/latestDate when the latest OHLC bar (2023-12-18) is ~2.4 years stale; pctFrom52wkHigh survives only because it is sourced from the info.json quote echo.

Verdict + reasoning

Delisted ticker, not a fetcher bug — nothing to fix. There is no live daily data for a fund that liquidated 17 months before it was added to the universe. Keeping BIGB in etf-monster-universe produces a permanent null row that clutters monster-ETF tier tables for no signal.

Action taken (2026-05-28):

• Removed BIGB from etf-monster-universe.json symbols array and mechanisms map (51 → 50 symbols).
• Corrected the watchlist description to record the removal + reason and to note the "Big Bank ≠ Big Tech" misnaming.
• Re-ran deno task precompute etf-monster-universe → 50 stocks, BIGB null row gone.
• Left data/stocks/BIGB/ in place (harmless; nothing scans it now). No _securities.json / alias entries existed for BIGB, so no further cleanup.

Generalizable note: a recently-launched-then-liquidated thematic ETF can pass an initial "ticker exists" eyeball check because yfinance still serves a stale info quote + a frozen weekly max series. The tell is a weekly-interval OHLC whose data_end is months/years old while info echoes a price equal to the last weekly close. When adding thematic ETFs to a discovery universe, confirm a non-stale daily bar exists, not just a quote.

Source receipts

• Roundhill / PRNewswire, 2023-11-24: https://www.prnewswire.com/news-releases/roundhill-announces-changes-to-fund-lineup-301996025.html
• SEC 497(e) supplement, 2023-11-24: https://www.sec.gov/Archives/edgar/data/1683471/000089418923008550/roundhill497eliquidations.htm
• OCC memo #53737, 2023-12-13: https://infomemo.theocc.com/infomemos?number=53737
• OCC memo #53776, 2023-12-15: https://infomemo.theocc.com/infomemos?number=53776