SQLite Web: event_store.db

Could not fetch row with primary-key 176825.

Could not fetch row with primary-key 386886.

Could not fetch row with primary-key 140188.

Could not fetch row with primary-key 355471.

Could not fetch row with primary-key 429275.

Update row 438194 in events

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-20T13:10:00.946643+00:00","dedupe_key":"signal_enriched:discovery_options_flow_delta:4df25cbcf066e3c8","evidence_event_ids":["evt_224853b43bfe"],"signal_type":"discovery_options_flow_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/bear-day-sonic-automotive-sah","as_of":"2026-04-20T13:10:00.946643+00:00","canonical_url":"https://www.nasdaq.com/articles/bear-day-sonic-automotive-sah","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bear-day-sonic-automotive-sah","article_chars":3505,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_f9fd06832267f6d0","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/bear-day-sonic-automotive-sah","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-20T13:10:57.631867+00:00","extraction_method":"trafilatura","fetched_description":"Margin compression, higher prices and interest rates are creating a huge headwind in automotive.","fetched_title":"Bear of the Day: Sonic Automotive (SAH) | Nasdaq","final_url":"https://www.nasdaq.com/articles/bear-day-sonic-automotive-sah","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bear-day-sonic-automotive-sah","source_event_id":"evt_224853b43bfe","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7d680e0af754a42c","kind":"options_flow","published_at":"2026-04-20T11:00:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Sonic Automotive","relevance":"high","symbol":"SAH","type":"company"},{"asset_class":"other","name":"Zacks Rank","relevance":"medium","symbol":"","type":"rating_framework"},{"asset_class":"equity","name":"AutoNation","relevance":"low","symbol":"AN","type":"company"},{"asset_class":"equity","name":"Lithia Motors","relevance":"low","symbol":"LAD","type":"company"}],"event_type":"earnings","information_gaps":["Options-flow fields required by signal type (calls vs puts, expiry, flow side, size relative to open interest, days to expiry, and whether positioning is informed) are not present in the provided text.","No specific options contract details (strike, expiration date, call/put volume, or open interest) are included.","No explicit statement links the described bearish thesis to observed options-flow behavior."],"key_facts":["Sonic Automotive is described as Zacks Rank #5 (Strong Sell) and labeled \u201cBear of the Day.\u201d","The article states that over the last couple of months analysts trimmed earnings expectations for both the current year and next year.","It says three analysts dropped their numbers for the current year and two did so for next year.","The article reports the Zacks Consensus Estimate for the current year was reduced from $7.05 to $6.54.","It reports next year\u2019s consensus estimate was reduced from $7.84 to $7.21.","The article attributes pessimism to higher interest rates making auto loans more expensive and reducing affordability, impacting vehicle demand (especially new cars).","It states used car prices have been normalizing, compressing margins for dealers.","It describes margin compression across the industry and says Sonic is not immune.","The article states the Automotive \u2013 Retail and Whole Sales industry ranks in the Bottom 7% of the Zacks Industry Rank and that there are no Zacks Rank #1 or #2 stocks in the industry."],"numeric_claims":[{"label":"current_year_consensus_estimate_change","value":"$7.05 to $6.54"},{"label":"next_year_consensus_estimate_change","value":"$7.84 to $7.21"},{"label":"analysts_current_year_trimmed","value":"3"},{"label":"analysts_next_year_trimmed","value":"2"}],"primary_claim":"Sonic Automotive\u2019s earnings outlook has deteriorated, with analysts trimming current-year and next-year estimates, contributing to a Zacks Rank of #5 (Strong Sell).","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"The article flags Sonic Automotive (SAH) as a bearish \u201cBear of the Day\u201d due to downward earnings estimate revisions and headwinds from higher interest rates, margin compression, and weaker auto-retail conditions.","topics":["earnings estimate revisions","auto retail demand","interest rates","margin compression","Zacks Rank #5 Strong Sell","automotive industry conditions"]},"source":"Nasdaq Investing","source_domain":"nasdaq.com","summary":"Margin compression, higher prices and interest rates are creating a huge headwind in automotive.","tickers":["SAH"],"title":"Bear of the Day: Sonic Automotive (SAH)","url":"https://www.nasdaq.com/articles/bear-day-sonic-automotive-sah"}}

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')

Cancel