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-duolingo-duol","as_of":"2026-04-13T11:55:13.805835+00:00","canonical_url":"https://www.nasdaq.com/articles/bear-day-duolingo-duol","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bear-day-duolingo-duol","article_chars":2617,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4cfd287fe0b26b81","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/bear-day-duolingo-duol","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-13T12:24:44.006687+00:00","extraction_method":"trafilatura","fetched_description":"Negative earnings estimate revisions stemming from a growth cooldown have caused shares to tumble from lofty 2025 highs.","fetched_title":"Bear of the Day: Duolingo (DUOL) | Nasdaq","final_url":"https://www.nasdaq.com/articles/bear-day-duolingo-duol","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bear-day-duolingo-duol","source_event_id":"evt_9124b9abb5d4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e4d3c0772453fdc8","kind":"options_flow","published_at":"2026-04-13T09:00:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["2025","2026","FY26","FY27"],"entities":[{"asset_class":"equity","name":"Duolingo","relevance":"high","symbol":"DUOL","type":"company"},{"asset_class":"unknown","name":"Zacks Investment Research","relevance":"medium","symbol":"","type":"publisher_or_source"}],"event_type":"earnings","information_gaps":["The provided text does not include any options flow details (calls vs puts, expiry dates, flow size relative to open interest, or days to expiry).","No explicit options positioning/informed-trading indicators are stated in the article text.","The signal type is 'discovery_options_flow_delta', but the article content provided is focused on earnings/estimate revisions and share-price performance rather than options flow."],"key_facts":["Duolingo (DUOL) is described as providing a mobile language learning platform.","The stock is reported to be at Zacks Rank #5 (Strong Sell) due to falling EPS revisions.","The article states DUOL shares have plunged more than 80% from steep 2025 highs.","It states DUOL has lost roughly 46% in 2026 so far and has seen continued pressure after its latest quarterly results.","The article attributes the poor share reaction post-earnings to expected near-term financial growth impact from prioritizing user growth and free learners\u2019 experience.","The article says FY26 growth expectations reflect a significant falloff relative to recent years, with a modest rebound expected in FY27, particularly on the earnings front."],"numeric_claims":[{"label":"Share decline from 2025 highs","value":"more than 80%"},{"label":"Loss in 2026 so far","value":"roughly 46%"}],"primary_claim":"Duolingo shares have plunged more than 80% from steep 2025 highs, with the decline attributed to falling EPS revisions and a growth cooldown, and the stock is rated Zacks Rank #5 (Strong Sell).","relevance_score":0.55,"sentiment":"negative","source_quality":"high","summary":"The article reports Duolingo (DUOL) shares have fallen sharply in 2026 following negative EPS estimate revisions tied to a growth cooldown. It also notes the stock is rated Zacks Rank #5 (Strong Sell) and describes a near-term growth impact from prioritizing user growth and free learners\u2019 experience.","topics":["earnings estimate revisions","growth cooldown","share price decline","Zacks Rank #5 (Strong Sell)","FY26/FY27 outlook"]},"source":"Nasdaq Investing","source_domain":"nasdaq.com","summary":"Negative earnings estimate revisions stemming from a growth cooldown have caused shares to tumble from lofty 2025 highs.","tickers":["DUOL"],"title":"Bear of the Day: Duolingo (DUOL)","url":"https://www.nasdaq.com/articles/bear-day-duolingo-duol"}

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