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/1-reason-buy-and-hold-strategy-stock-next-decade","as_of":"2026-04-11T13:38:22.073620+00:00","canonical_url":"https://www.fool.com/investing/2026/04/11/1-reason-buy-and-hold-strategy-stock-next-decade/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/1-reason-buy-and-hold-strategy-stock-next-decade","article_chars":3121,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_7dc129624656a81a","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/11/1-reason-buy-and-hold-strategy-stock-next-decade/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-11T22:03:09.416769+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe world\u2019s leading Bitcoin treasury company trades 73% below its record high, providing investors with a valuable opportunity.","fetched_title":"1 Reason to Buy and Hold Strategy Stock for the Next Decade | Nasdaq","final_url":"https://www.nasdaq.com/articles/1-reason-buy-and-hold-strategy-stock-next-decade","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/1-reason-buy-and-hold-strategy-stock-next-decade","source_event_id":"evt_ac0f1722b1a8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9dcc96695f7fe0e4","kind":"unusual_volume","published_at":"2026-04-11T13:05:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["November 2024","April 8","April 11, 2026"],"entities":[{"asset_class":"equity","name":"Strategy","relevance":"high","symbol":"MSTR","type":"company"},{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"}],"event_type":"price_action","information_gaps":["No unusual trading volume ratio vs average is provided in the supplied text (baseline volume, volume ratio, and direction are missing).","The signal type is discovery_unusual_volume_delta, but the article content provided does not mention volume spikes or confirmation by any volume/news metric.","No specific catalyst tied to unusual volume is described beyond general Bitcoin price recovery expectations."],"key_facts":["The article states Strategy (NASDAQ: MSTR) is trading 73% below its peak from November 2024.","The article attributes the 73% drawdown to Bitcoin being down meaningfully.","The article states Strategy\u2019s financial success is dependent on its Bitcoin treasury playbook.","The article states Strategy generated $477 million in revenue in 2025.","The article states Strategy\u2019s share price is up almost 1,000% over the past six years (as of April 8).","The article states Strategy raises capital from equity, preferred, and fixed-income markets to buy Bitcoin.","The article claims Bitcoin has historically recovered from major drawdowns to reach new highs.","The article says buying and holding Strategy stock will not be a smooth ride due to volatility."],"numeric_claims":[{"label":"drawdown_vs_peak","value":"73% below peak (from November 2024)"},{"label":"revenue_2025","value":"$477 million"},{"label":"share_price_gain_past_6_years","value":"almost 1,000% (as of April 8)"}],"primary_claim":"Strategy (MSTR) is trading 73% below its peak from November 2024, largely because Bitcoin is also down, and the article expects Bitcoin recoveries to benefit MSTR.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"The article argues that Strategy (NASDAQ: MSTR) is a long-term buy because it is down 73% from its November 2024 peak, attributing the decline to Bitcoin\u2019s meaningful drop. It frames MSTR as a leveraged way to benefit from Bitcoin recovering.","topics":["long-term investing","Bitcoin treasury exposure","MSTR valuation vs peak","volatility","equity leverage to Bitcoin price"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe world\u2019s leading Bitcoin treasury company trades 73% below its record high, providing investors with a valuable opportunity.","tickers":[],"title":"1 Reason to Buy and Hold Strategy Stock for the Next Decade","url":"https://www.fool.com/investing/2026/04/11/1-reason-buy-and-hold-strategy-stock-next-decade/"}

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