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/nike-stock-still-broken","as_of":"2026-04-10T12:11:33.277556+00:00","canonical_url":"https://www.fool.com/investing/2026/04/10/why-nike-stock-is-still-a-stay-away/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/nike-stock-still-broken","article_chars":4027,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_f93703a3d56d39a5","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/10/why-nike-stock-is-still-a-stay-away/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T12:12:18.786951+00:00","extraction_method":"heuristic","fetched_description":"Key PointsNike's sales are in decline and even a return to retail stores isn't helping.","fetched_title":"Nike Stock Is Still Broken | Nasdaq","final_url":"https://www.nasdaq.com/articles/nike-stock-still-broken","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/nike-stock-still-broken","source_event_id":"evt_9ab94e5ea73e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e4087490d750c109","kind":"unusual_volume","published_at":"2026-04-10T12:02:15+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 10, 2026","08:02 am EDT","April 3, 2026","April 7, 2026","December 17, 2004","April 15, 2005","April 10, 2026"],"entities":[{"asset_class":"equity","name":"Nike","relevance":"high","symbol":"NKE","type":"company"},{"asset_class":"other","name":"On","relevance":"medium","symbol":"","type":"brand"},{"asset_class":"other","name":"Hoka","relevance":"medium","symbol":"","type":"brand"},{"asset_class":"other","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The signal type is discovery_unusual_volume_delta, but the provided text contains no volume ratio vs average, no baseline volume, and no direction (e.g., above/below average volume).","No explicit statement is provided linking any unusual volume to a specific news catalyst; the article discusses business fundamentals and macro/tariff headwinds instead.","No confirmation mechanism for the volume anomaly (e.g., exchange data, volume spike details) is included in the provided text.","The most likely catalyst hypothesis for the volume anomaly cannot be grounded in the provided text; only general headwinds (China cooling, North American tariffs, wholesale transition sluggishness) are discussed."],"key_facts":["The article states Nike\u2019s sales are in decline.","The article states that even a return to retail stores isn\u2019t helping.","The article claims On and Hoka are taking market share and demonstrating pricing power Nike used to have.","The article says sales are expected to fall on a constant currency basis again this year.","The article cites a cooling Chinese market as a headwind.","The article cites costly new North American tariffs as a headwind.","The article says management is pivoting back to wholesale partners to recapture lost shelf space.","The article states the transition back to wholesale partners is proving sluggish.","The article characterizes Nike as an expensive stock and says it is a \u201cstay away\u201d for investors.","The article notes stock prices used were end-of-day prices of April 3, 2026 and the video was published on April 7, 2026."],"numeric_claims":[],"primary_claim":"Nike\u2019s sales are declining and the company\u2019s shift back to wholesale partners is proving sluggish, with cooling China demand and costly North American tariffs cited as headwinds.","relevance_score":0.45,"sentiment":"negative","source_quality":"high","summary":"The Motley Fool article argues Nike (NKE) remains a weak investment due to declining sales and sluggish turnaround efforts, citing cooling China demand and costly North American tariffs. It does not provide any specific unusual trading volume ratio or confirm a volume anomaly with news in the provided text.","topics":["Nike","sales decline","wholesale strategy","China demand","North American tariffs","market share","stock valuation","investor recommendation"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsNike's sales are in decline and even a return to retail stores isn't helping.","tickers":[],"title":"Nike Stock Is Still Broken","url":"https://www.fool.com/investing/2026/04/10/why-nike-stock-is-still-a-stay-away/"}

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