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-22T10:08:37.182699+00:00","dedupe_key":"signal_enriched:discovery_options_flow_delta:06f4eb003b7023f1","evidence_event_ids":["evt_313643df6ff2"],"signal_type":"discovery_options_flow_delta","source":"discovery_ingestor","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_6714105cd8b3259f","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:09:29.691608+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_313643df6ff2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3ad22bc60ba0e931","kind":"options_flow","published_at":"2026-04-22T08:30:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2024","2022","2015","this month","2025"],"entities":[{"asset_class":"equity","name":"RH (formerly Restoration Hardware)","relevance":"high","symbol":"RH","type":"company"},{"asset_class":"unknown","name":"Zacks Investment Research","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"unknown","name":"TradingView","relevance":"low","symbol":"","type":"charting_source"}],"event_type":"other","information_gaps":["No options-flow details are provided in the text (no call/put direction, no expiry dates, no flow size, no open interest context, and no indication of informed positioning).","The signal type indicates options flow delta, but the provided article content is a fundamental/market commentary and does not include the required options-flow fields."],"key_facts":["RH is described as a high-end home furnishings company formerly known as Restoration Hardware.","The article states RH sources ~72% of its products from Asia as of 2024, including 35% from Vietnam and 23% from China.","RH is quoted as operating with 25% tariffs from China since the last Trump administration and resourcing most China production to Vietnam at better than pre-tariff landed China pricing.","The article says RH has resourced a meaningful amount of China production to its own factory in North Carolina.","The article states gross margins fell from more than 50% to 44.8% since 2022.","The article states RH spending was 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% with volume swelled to more than 10x the norm following the company\u2019s latest earnings announcement.","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 referenced","value":"25%"},{"label":"Gross margin (current stated level)","value":"44.8%"},{"label":"Gross margin (prior stated level)","value":">50%"},{"label":"Spending last year","value":">$1 billion"},{"label":"Earnings miss magnitude (average over past four quarters)","value":"103.49%"},{"label":"Share plunge after latest earnings","value":">40%"},{"label":"Volume multiple vs norm after latest earnings","value":">10x"}],"primary_claim":"RH shares have suffered amid tariff, margin, and debt/spending pressures, with the stock plunging more than 40% on heavy volume after its latest earnings announcement.","relevance_score":0.45,"sentiment":"negative","source_quality":"high","summary":"The article is bearish on RH (formerly Restoration Hardware), citing tariff-related supply chain concerns, margin pressure, 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 misses","bearish chart pattern","consumer confidence"]},"source":"Nasdaq Investing","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

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 480309 in events