Create
Query
event_store.db
—
signals
actions
approvals
artifacts
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row sig_584a0262db61 in signals
id
sig_584a0262db61
Primary key.
TEXT
event_id
11020
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/should-you-buy-nike-long-haul-heres-honest-answer","as_of":"2026-04-09T10:38:52.980302+00:00","canonical_url":"https://www.fool.com/investing/2026/04/09/should-you-buy-nike-for-the-long-haul-heres-the-ho/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/should-you-buy-nike-long-haul-heres-honest-answer","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8a7e97723f274765","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/09/should-you-buy-nike-for-the-long-haul-heres-the-ho/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T00:17:00.888502+00:00","extraction_method":"heuristic","fetched_description":"Key PointsNike is in the midst of a turnaround.","fetched_title":"Should You Buy Nike for the Long Haul? Here's the Honest Answer. | Nasdaq","final_url":"https://www.nasdaq.com/articles/should-you-buy-nike-long-haul-heres-honest-answer","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/should-you-buy-nike-long-haul-heres-honest-answer","source_event_id":"evt_a70b08d0ac0f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"379efdd8873c141d","kind":"unusual_volume","published_at":"2026-04-09T09:05:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 09, 2026","2020"],"entities":[{"asset_class":"equity","name":"Nike","relevance":"high","symbol":"NKE","type":"company"},{"asset_class":"person","name":"John Donahoe","relevance":"high","symbol":"","type":"person"},{"asset_class":"person","name":"Geoffrey Seiler","relevance":"medium","symbol":"","type":"person"},{"asset_class":"media","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"equity","name":"Deckers Outdoor","relevance":"medium","symbol":"","type":"company"},{"asset_class":"equity","name":"On Holding","relevance":"medium","symbol":"","type":"company"},{"asset_class":"equity","name":"Anta","relevance":"medium","symbol":"","type":"company"},{"asset_class":"equity","name":"Li-Ning","relevance":"medium","symbol":"","type":"company"}],"event_type":"other","information_gaps":["The provided signal type is discovery_unusual_volume_delta, but the article text contains no volume data, no volume ratio vs average, and no explicit mention of unusual trading volume for NKE.","No confirmed catalyst is stated in the text beyond general turnaround/strategic issues (prior CEO actions, competition, China impact, tariffs/trade war).","The article does not provide a specific, time-linked catalyst that would explain a volume spike; any catalyst hypothesis would be speculative beyond the text."],"key_facts":["The article is dated April 09, 2026 (05:05 am EDT) and is titled \u201cShould You Buy Nike for the Long Haul? Here's the Honest Answer.\u201d","It says Nike is \u201cin the midst of a turnaround.\u201d","It says the amount of damage from Nike\u2019s prior CEO remains in question.","It states John Donahoe became CEO in 2020 and is described as having no brand experience.","The article claims Donahoe de-emphasized product innovation by shifting R&D to digital infrastructure.","The article claims Donahoe de-emphasized wholesale and focused on higher-margin direct-to-consumer (DTC).","It claims the result was a \u201cdisaster\u201d that Nike\u2019s new CEO is still working to fix.","It claims Nike cut ties with long-term retail partners and lost space to brands like Hoka (owned by Deckers) and On Running (On Holding).","It claims competitors caught up with technology and Nike\u2019s classic footwear business became oversaturated.","It claims the damage was acute in China due to local brands Anta and Li-Ning and that Nike wasn\u2019t meeting consumers where they shop with its DTC strategy.","It states tariffs and a trade war with China made things more difficult.","It says the stock has potential from operating momentum and leverage but is not a guarantee.","It concludes Nike stock falls into the \u201ctoo hard\u201d pile and was not among the author\u2019s/Stock Advisor\u2019s \u201c10 best stocks\u201d list."],"numeric_claims":[],"primary_claim":"The article states that Nike (NYSE: NKE) is in the \u201ctoo hard\u201d pile for long-term investors because the turnaround potential is uncertain and prior CEO damage is still being assessed.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article discusses Nike\u2019s turnaround prospects but concludes the stock is a difficult \u201ctoo hard\u201d pick for long-term investors. It attributes Nike\u2019s challenges to strategic missteps under former CEO John Donahoe and ongoing uncertainty about damage and recovery.","topics":["stock-picking","turnaround","Nike strategy","direct-to-consumer (DTC)","competition in footwear","China market","CEO transition","tariffs/trade war (China)"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsNike is in the midst of a turnaround.","tickers":[],"title":"Should You Buy Nike for the Long Haul? Here's the Honest Answer.","url":"https://www.fool.com/investing/2026/04/09/should-you-buy-nike-for-the-long-haul-heres-the-ho/"}
TEXT NOT NULL
threshold
NULL
TEXT
direction
NULL
TEXT
severity
NULL
TEXT
window
NULL
TEXT
source
discovery_ingestor
TEXT NOT NULL
reason_trace
{"_evidence_event_ids":["evt_a70b08d0ac0f"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:9065b3db0e69e6b9
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-09T10:38:52.980302+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel