SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T12:49:17.656805+00:00","dedupe_key":"signal_enriched:discovery_options_flow_delta:ff1c09a43be84c41","evidence_event_ids":["evt_b57d330887ca"],"signal_type":"discovery_options_flow_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/bear-day-rh-rh","as_of":"2026-04-08T12:49:17.656805+00:00","canonical_url":"https://www.nasdaq.com/articles/bear-day-rh-rh","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bear-day-rh-rh","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ddd2dba046b1c9d1","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/bear-day-rh-rh","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T14:28:33.448710+00:00","extraction_method":"heuristic","fetched_description":"Once a market darling, this luxury home retailer is now sliding under the weight of tariffs, falling earnings, and technical breakdowns.","fetched_title":"Bear of the Day: RH (RH) | Nasdaq","final_url":"https://www.nasdaq.com/articles/bear-day-rh-rh","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","source_event_id":"evt_b57d330887ca","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c42e944c61342ce0","kind":"options_flow","published_at":"2026-04-08T10:30:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 09, 2025","06:30 am EDT","April 2 (earnings date mentioned)","2020 (COVID lows referenced)"],"entities":[{"asset_class":"equity","name":"RH","relevance":"high","symbol":"RH","type":"company"},{"asset_class":"equity","name":"Restoration Hardware Holdings, Inc.","relevance":"medium","symbol":"RH","type":"company_former_name"},{"asset_class":"other","name":"Zacks Investment Research","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["Options-flow details required by signal_type (discovery_options_flow_delta) are not provided in the text: no call/put direction, no expiry dates, no flow size, no open-interest comparison, and no explicit indication of whether positioning is informed.","The headline includes \u201cBear of the Day: RH (RH)\u201d but does not describe options-flow mechanics; it appears to be a stock/analyst/technical bearish narrative rather than an options-flow report.","No ticker-level options contract data (strike, expiration, volume, OI, delta/flow magnitude) is present."],"key_facts":["The article states RH is a Zacks Rank #5 (Strong Sell).","It says RH faces headwinds from tariffs and a slumping stock market.","It states the stock dropped over 40% and that earnings were reported the week prior to the article.","It states Q4 earnings included a 17% EPS miss and a revenue miss, with FY25 revenue growth guided at +10\u201313%.","It states analysts reduced current-quarter earnings estimates by 79% over the last 7 days (from $1.43 to $0.30).","It states next-quarter estimates fell 10% (from $3.95 to $3.56) and current-year estimates fell 17% (from $13.26 to $11.00) over the last 7 days.","It states next-year estimates fell 20% (from $19.89 to $15.92) over the last 7 days.","It states the stock dropped from about $240 to $123 the next day and later bounced 40 points.","It states the stock is trading at lows not seen since COVID and mentions a \u201cdeath cross\u201d (50-day moving average below the 200-day)."],"numeric_claims":[{"label":"EPS miss","value":"17%"},{"label":"FY25 revenue growth guidance","value":"+10\u201313%"},{"label":"Stock drop","value":">40%"},{"label":"Current quarter estimate change (7 days)","value":"-79% (from $1.43 to $0.30)"},{"label":"Next quarter estimate change (7 days)","value":"-10% (from $3.95 to $3.56)"},{"label":"Current year estimate change (7 days)","value":"-17% (from $13.26 to $11.00)"},{"label":"Next year estimate change (7 days)","value":"-20% (from $19.89 to $15.92)"},{"label":"Price move mentioned","value":"~$240 to ~$123 (next day)"}],"primary_claim":"RH (RH) is described as having a bearish outlook due to tariff uncertainty, a >40% drop after earnings, and sharply falling earnings estimates, with technical weakness including a \u201cdeath cross.\u201d","relevance_score":0.35,"sentiment":"negative","source_quality":"high","summary":"The provided article is a bearish write-up on RH (Restoration Hardware), citing tariff headwinds, a sharp post-earnings drop, falling analyst estimates, and bearish technical signals. No specific options-flow (calls/puts, expiry, size vs open interest, or informed positioning) details are present in the text.","topics":["bearish stock outlook","tariffs","earnings miss","analyst estimate revisions","technical analysis","death cross"]},"source":"Nasdaq Investing","source_domain":"nasdaq.com","summary":"After years of premium positioning, the shine is coming off and the outlook looks bare.","tickers":["RH"],"title":"Bear of the Day: RH (RH)","url":"https://www.nasdaq.com/articles/bear-day-rh-rh"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 6755 in events