SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/bear-day-rh-rh-0","as_of":"2026-04-22T10:08:37.182699+00:00","canonical_url":"https://www.nasdaq.com/articles/bear-day-rh-rh-0","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bear-day-rh-rh-0","article_chars":3988,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_0635fc22e5a3cb43","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/bear-day-rh-rh-0","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T10:12:35.967450+00:00","extraction_method":"trafilatura","fetched_description":"Luxury home furnishing retailer RH faces several bearish headwinds, including tariff policy, ballooning debt, and margin pressures. A worst-possible Zacks Rank and a bearish chart pattern add to the concern.","fetched_title":"Bear of the Day: RH (RH) | Nasdaq","final_url":"https://www.nasdaq.com/articles/bear-day-rh-rh-0","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bear-day-rh-rh-0","source_event_id":"evt_ee20173e232c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3ad22bc60ba0e931","kind":"new_listings","published_at":"2026-04-22T08:30:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["2022","2024","2015","this month","2025"],"entities":[{"asset_class":"equity","name":"RH","relevance":"primary","symbol":"RH","type":"company"},{"asset_class":"equity","name":"Restoration Hardware","relevance":"context","symbol":"RH","type":"former_name"},{"asset_class":"other","name":"Zacks Consensus Estimates","relevance":"supporting","symbol":"","type":"benchmark"},{"asset_class":"equity","name":"NVIDIA","relevance":"comparative","symbol":"NVDA","type":"company"}],"event_type":"price_action","information_gaps":["The signal type is labeled discovery_new_listings_delta, but the provided text does not mention any new listing or listing-related event.","The article references \u201clatest earnings announcement\u201d but does not provide a date or the specific earnings figures.","\u201cStagnant growth\u201d and \u201cchallenged macro environment\u201d are mentioned without measurable metrics in the provided text.","The article states RH has a Zacks Rank #5 (Strong Sell), but does not provide the date of that rank update.","The article mentions tariffs and trade deals with Indonesia and India but does not specify any concrete outcomes or timelines."],"key_facts":["RH is a high-end home furnishings company based in California, formerly Restoration Hardware.","The article states RH sources ~72% of its products from Asia as of 2024, including 35% from Vietnam and 23% from China.","The article quotes RH saying it has been operating with 25% tariffs from China since the last Trump administration and has resourced most China production to Vietnam at better than pre-tariff landed China pricing.","The article states RH has resourced a meaningful amount of China production to its own factory in North Carolina.","The article states gross margins have fallen from more than 50% to 44.8% since 2022.","The article states RH spent more than $1 billion last year and that debt is soaring.","The article states RH has missed Zacks Consensus Estimates by an average of 103.49% over the past four quarters.","The article states RH shares plunged more than 40% after the latest earnings announcement, with volume more than 10x the norm.","The article states RH is carving out a bearish flag pattern."],"numeric_claims":[{"label":"Asia sourcing share (as of 2024)","value":"~72%"},{"label":"Vietnam sourcing share (as of 2024)","value":"35%"},{"label":"China sourcing share (as of 2024)","value":"23%"},{"label":"Tariff rate from China mentioned by RH","value":"25%"},{"label":"Gross margin (current stated)","value":"44.8%"},{"label":"Gross margin change since 2022","value":"from >50% to 44.8%"},{"label":"Spending last year","value":"more than $1 billion"},{"label":"Earnings miss average vs Zacks Consensus (past four quarters)","value":"103.49%"},{"label":"Post-earnings share plunge","value":"more than 40%"},{"label":"Post-earnings volume vs norm","value":"more than 10x"},{"label":"Chart pattern described","value":"bearish flag"}],"primary_claim":"RH shares have suffered due to stagnant growth and a challenged macro environment, with specific headwinds including tariffs, margin compression, high spending and rising debt, and negative earnings surprise history.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"The article is bearish on RH (formerly Restoration Hardware), citing tariff-related supply chain and margin pressures, rising debt/spending, and a history of large earnings misses. It also describes a sharp post-earnings selloff with heavy volume and a bearish chart pattern.","topics":["tariffs","supply chain","margins","debt and spending","earnings surprises","chart pattern","consumer confidence","macro environment"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"RH shares have suffered amid stagnant growth and a challenged macro environment.","tickers":["RH"],"title":"Bear of the Day: RH (RH)","url":"https://www.nasdaq.com/articles/bear-day-rh-rh-0"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_9cb07e1fe9f4 in signals