SQLite Web: event_store.db

Update row sig_8b8e98c8576e 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-14T09:10:46.756430+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_73f3073a184761ce","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-14T09:11:32.642941+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_440fa9691a11","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b2487c3a54b12d53","kind":"options_flow","published_at":"2026-04-14T08:00:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Harley-Davidson","relevance":"high","symbol":"HOG","type":"company"},{"asset_class":"other","name":"Zacks Investment Research","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"other","name":"Zacks","relevance":"medium","symbol":"","type":"rankings_framework"},{"asset_class":"equity","name":"Xos","relevance":"low","symbol":"XOS","type":"company"},{"asset_class":"equity","name":"Zapp Electric Vehicles","relevance":"low","symbol":"ZAPP","type":"company"}],"event_type":"earnings","information_gaps":["No options-flow details are provided in the text: calls vs puts direction is not stated.","No expiry/tenor (days to expiry or specific expiration date) is provided.","No options flow size is provided, and there is no comparison to open interest.","No indication of whether the flow suggests informed positioning is provided.","The signal type is \u201cdiscovery_options_flow_delta,\u201d but the provided article text contains no measurable options-flow delta content."],"key_facts":["The article names Harley-Davidson (HOG) as its \u201cBear of the Day.\u201d","It states Harley-Davidson\u2019s last earnings report reflected softness, with revenue missing expectations and international sales dragging.","It says Harley-Davidson has a Zacks Rank of #5 (Strong Sell).","It states that over the past 60 days there have been multiple downward revisions to EPS estimates for both the current quarter and full year.","It states analysts now expect negative earnings growth for the full year.","It provides a change in Zacks Consensus Estimates for the current year from $4.20 to $3.24 (down 5.81%).","It states this contraction is on a sales contraction of 1.99%.","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":"EPS estimate change (current year)","value":"$4.20 to $3.24"},{"label":"EPS estimate contraction","value":"5.81%"},{"label":"Sales contraction","value":"1.99%"},{"label":"Time window for EPS revisions","value":"past 60 days"},{"label":"Industry rank percentile","value":"Bottom 18%"}],"primary_claim":"Harley-Davidson (HOG) is described as facing bearish fundamentals, including revenue missing expectations and downward revisions to EPS estimates over the past 60 days.","relevance_score":0.45,"sentiment":"negative","source_quality":"high","summary":"The article presents Harley-Davidson (HOG) as a bearish \u201cBear of the Day,\u201d citing demand headwinds, weak earnings expectations, and multiple downward EPS estimate revisions. It does not provide specific options-flow metrics (calls/puts, expiry, or size vs open interest).","topics":["bearish outlook","earnings estimate revisions","revenue miss","demand headwinds","demographics","EV project (LiveWire)","analyst estimate cuts","Zacks Rank #5 (Strong Sell)"]},"source":"Nasdaq Investing","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