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/got-1000-best-pick-and-shovel-growth-stock-ai-supercycle-isnt-american","as_of":"2026-04-06T18:42:37.816572+00:00","canonical_url":"https://www.fool.com/investing/2026/04/06/got-1000-best-pick-and-shovel-growth-stock-ai/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/got-1000-best-pick-and-shovel-growth-stock-ai-supercycle-isnt-american","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6026e538b8ca26e5","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/06/got-1000-best-pick-and-shovel-growth-stock-ai/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T12:31:58.144968+00:00","extraction_method":"heuristic","fetched_description":"Key PointsTaiwan Semiconductor's sales spiked by 100% last year, driven by surging AI revenue.","fetched_title":"Got $1,000? The Best Pick-and-Shovel Growth Stock for the AI Supercycle Isn't American. | Nasdaq","final_url":"https://www.nasdaq.com/articles/got-1000-best-pick-and-shovel-growth-stock-ai-supercycle-isnt-american","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/got-1000-best-pick-and-shovel-growth-stock-ai-supercycle-isnt-american","source_event_id":"evt_d960a76a5397","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1f2bb9c9e76c3337","kind":"unusual_volume","published_at":"2026-04-06T18:20:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":["April 06, 2026"],"entities":[{"asset_class":"equity","name":"Taiwan Semiconductor Manufacturing","relevance":"high","symbol":"TSM","type":"company"}],"event_type":"other","information_gaps":["No specific volume ratio provided.","No confirmation of unusual volume from news or other sources."],"key_facts":["TSMC holds 70% of the advanced processor manufacturing market.","Sales increased by 100% last year, driven by AI revenue.","Projected sales growth of 30% this year."],"numeric_claims":[{"label":"Sales last year","value":"$122.4 billion"},{"label":"AI revenue increase","value":"48%"},{"label":"Market share","value":"70%"}],"primary_claim":"TSMC's sales doubled to $122.4 billion last year, with AI revenue increasing by 48%.","relevance_score":0.9,"sentiment":"positive","source_quality":"high","summary":"Taiwan Semiconductor Manufacturing (TSMC) has experienced a significant sales increase, driven by AI revenue, and is positioned to benefit from ongoing demand in the AI sector.","topics":["AI growth","semiconductor industry","TSMC performance"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsTaiwan Semiconductor's sales spiked by 100% last year, driven by surging AI revenue.","tickers":[],"title":"Got $1,000? The Best Pick-and-Shovel Growth Stock for the AI Supercycle Isn't American.","url":"https://www.fool.com/investing/2026/04/06/got-1000-best-pick-and-shovel-growth-stock-ai/"}

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