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/why-amazon-stock-just-popped","as_of":"2026-04-14T20:20:10.540405+00:00","canonical_url":"https://www.fool.com/investing/2026/04/14/why-amazon-stock-just-popped/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/why-amazon-stock-just-popped","article_chars":3524,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_cf938424d9397903","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/14/why-amazon-stock-just-popped/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-15T17:13:39.596098+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsAmazon will buy all of Globalstar's shares for $90 each.","fetched_title":"Why Amazon Stock Just Popped | Nasdaq","final_url":"https://www.nasdaq.com/articles/why-amazon-stock-just-popped","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/why-amazon-stock-just-popped","source_event_id":"evt_4f2a7814f046","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"070d7f952633fa0b","kind":"unusual_volume","published_at":"2026-04-14T19:18:51+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["2027","April 14, 2026"],"entities":[{"asset_class":"equity","name":"Amazon.com","relevance":"high","symbol":"AMZN","type":"company"},{"asset_class":"equity","name":"Globalstar","relevance":"high","symbol":"GSAT","type":"company"},{"asset_class":"equity","name":"Apple","relevance":"medium","symbol":"AAPL","type":"company"}],"event_type":"merger_acquisition","information_gaps":["The signal type requests unusual volume delta, but the provided text does not include any volume ratio vs average, baseline volume, or direction for AMZN/GSAT.","The article does not explicitly state whether the volume spike is confirmed by additional news beyond the described stock price reaction.","No explicit catalyst hypothesis is labeled as the cause of unusual volume; only the acquisition announcement and related stock moves are described."],"key_facts":["Amazon will buy all of Globalstar\u2019s shares for $90 each.","The article states the acquisition is announced as $11.6 billion.","The article says Amazon receives instant DTC capability for its Amazon Leo satellite internet service.","The article states the deal includes acquiring Globalstar\u2019s roughly two dozen satellites, increasing Amazon\u2019s Amazon Leo constellation by about 10%.","The article says the $90 offer is a 23% premium over Globalstar\u2019s value as recently as yesterday.","The article says regulators permitting, the deal should close in 2027.","The article reports AMZN stock is up 4% and GSAT is up 9.3% as of 2:40 p.m. ET; AAPL is down 0.3% as of the same time."],"numeric_claims":[{"label":"Globalstar offer price (USD/share)","value":"90"},{"label":"Deal value (USD)","value":"11.6 billion"},{"label":"Premium over prior value","value":"23%"},{"label":"AMZN move by 2:40 p.m. ET","value":"up 4%"},{"label":"GSAT move by 2:40 p.m. ET","value":"up 9.3%"},{"label":"AAPL move by 2:40 p.m. ET","value":"down 0.3%"},{"label":"Globalstar satellites acquired (approx.)","value":"two dozen"},{"label":"Increase to Amazon Leo constellation (approx.)","value":"10%"}],"primary_claim":"Amazon will acquire all of Globalstar\u2019s shares for $90 each, in a deal announced as $11.6 billion.","relevance_score":0.78,"sentiment":"positive","source_quality":"high","summary":"Amazon announced it will buy Globalstar for $90 per share, a deal described as $11.6 billion. The news coincided with AMZN shares rising about 4% and GSAT shares rising about 9.3% by 2:40 p.m. ET.","topics":["acquisition","satellite internet","direct-to-cell (DTC)","Amazon Leo constellation","stock reaction"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsAmazon will buy all of Globalstar's shares for $90 each.","tickers":[],"title":"Why Amazon Stock Just Popped","url":"https://www.fool.com/investing/2026/04/14/why-amazon-stock-just-popped/"}

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