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

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_100755b58066 in signals