SQLite Web: event_store.db

Update row sig_4a9138e770ab in signals

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-harley-davidson-hog","as_of":"2026-04-14T10:11:17.846354+00:00","canonical_url":"https://www.nasdaq.com/articles/bear-day-harley-davidson-hog","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bear-day-harley-davidson-hog","article_chars":2625,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_3cea234a4a4fcf14","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/bear-day-harley-davidson-hog","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T10:17:26.025264+00:00","extraction_method":"trafilatura","fetched_description":"Shifting consumer aspirations have this boomer legacy company struggling to find new markets.","fetched_title":"Bear of the Day: Harley-Davidson (HOG) | Nasdaq","final_url":"https://www.nasdaq.com/articles/bear-day-harley-davidson-hog","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bear-day-harley-davidson-hog","source_event_id":"evt_c4ee21efdbb4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b2487c3a54b12d53","kind":"new_listings","published_at":"2026-04-14T08:00:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Harley-Davidson","relevance":"primary","symbol":"HOG","type":"company"},{"asset_class":"other","name":"Zacks Investment Research","relevance":"supporting","symbol":"","type":"publisher_or_research_firm"},{"asset_class":"equity","name":"Xos","relevance":"supporting","symbol":"XOS","type":"company"},{"asset_class":"equity","name":"Zapp Electric Vehicles","relevance":"supporting","symbol":"ZAPP","type":"company"}],"event_type":"earnings","information_gaps":["No specific date for the Zacks Rank or the \u201clast earnings report\u201d is provided in the text.","The article does not quantify the magnitude of revenue miss or international sales decline beyond qualitative statements.","No details are provided on the number/size of EPS revisions beyond \u201cmultiple downward revisions.\u201d","The signal type is labeled as discovery_new_listings_delta, but the provided text does not describe any new listing or listing-related event; this mismatch is not resolved in the article text."],"key_facts":["The article names Harley-Davidson (HOG) as its \u201cBear of the Day.\u201d","It states Harley-Davidson is at a Zacks Rank #5 (Strong Sell).","It says multiple downward revisions to EPS estimates have occurred over the past 60 days for both the current quarter and the full year.","It states analysts expect negative earnings growth for the full year.","It provides Zacks Consensus Estimates for the current year: down from $4.20 to $3.24 (5.81% contraction) and states this is alongside a sales contraction of 1.99%.","It states the motorcycle industry faces a demographic cliff, with the core audience aging out and younger consumers less interested in expensive motorcycles.","It states Harley\u2019s LiveWire EV project has not generated enough buzz or revenue to offset declining traditional bike sales.","It states the last earnings report reflected softness, with revenue missing expectations and international sales dragging harder.","It states the Automotive \u2013 Domestic industry is in the Bottom 18% of the Zacks Industry Rank."],"numeric_claims":[{"label":"Zacks Rank","value":"#5 (Strong Sell)"},{"label":"Downward revisions window","value":"past 60 days"},{"label":"Current-year Zacks Consensus Estimates (from)","value":"$4.20"},{"label":"Current-year Zacks Consensus Estimates (to)","value":"$3.24"},{"label":"Consensus estimate contraction","value":"5.81%"},{"label":"Sales contraction","value":"1.99%"},{"label":"Zacks Industry Rank percentile","value":"Bottom 18%"}],"primary_claim":"Harley-Davidson (HOG) is rated Zacks Rank #5 (Strong Sell) and has seen multiple downward revisions to EPS estimates, with analysts expecting negative full-year earnings growth.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"The article presents Harley-Davidson (HOG) as a bearish stock due to weakening demand, downward revisions to earnings estimates, and negative earnings growth expectations. It cites a Zacks Rank of #5 (Strong Sell) and specific changes to consensus estimates.","topics":["tariffs/macro headwinds","motorcycle demand","demographics","earnings estimate revisions","Zacks Rank","EV project (LiveWire)","consumer credit tightening"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"Despite its status as a global icon, Harley-Davidson faces a steep uphill climb as it navigates a perfect storm of economic and demographic headwinds.","tickers":["HOG"],"title":"Bear of the Day: Harley-Davidson (HOG)","url":"https://www.nasdaq.com/articles/bear-day-harley-davidson-hog"}

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

Cancel