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-jumped-today","as_of":"2026-04-09T04:42:09.468703+00:00","canonical_url":"https://www.fool.com/investing/2022/05/27/why-amazon-stock-jumped-today/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/why-amazon-stock-jumped-today","article_chars":4308,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_dbe5a62a773b5b2e","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2022/05/27/why-amazon-stock-jumped-today/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:52:51.589827+00:00","extraction_method":"heuristic","fetched_description":"What happenedShareholders in Amazon (NASDAQ: AMZN) beat a rising market on Friday morning, with shares gaining 3% by 10:45 a.m. ET compared to a 1.4% boost in the S&P 500. The increase erased just a small portion of recent losses for the e-commerce giant's stock, though, whi","fetched_title":"Why Amazon Stock Jumped Today | Nasdaq","final_url":"https://www.nasdaq.com/articles/why-amazon-stock-jumped-today","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/why-amazon-stock-jumped-today","source_event_id":"evt_0f84bf72cdab","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b995e165a797b959","kind":"unusual_volume","published_at":"2026-04-09T01:53:55+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["May 27, 2022","10:45 am EDT","10:45 a.m. ET","April 27, 2022"],"entities":[{"asset_class":"equity","name":"Amazon","relevance":"high","symbol":"AMZN","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"},{"asset_class":"equity","name":"Shopify","relevance":"medium","symbol":"SHOP","type":"company"},{"asset_class":"equity","name":"Etsy","relevance":"medium","symbol":"ETSY","type":"company"},{"asset_class":"equity","name":"Macy's","relevance":"low","symbol":"","type":"company"},{"asset_class":"equity","name":"Ulta Beauty","relevance":"low","symbol":"","type":"company"},{"asset_class":"equity","name":"Walmart","relevance":"low","symbol":"WMT","type":"company"},{"asset_class":"equity","name":"Target","relevance":"low","symbol":"TGT","type":"company"}],"event_type":"price_action","information_gaps":["No unusual-volume delta details are provided (baseline volume, volume ratio, and direction are not stated).","The article does not explicitly confirm that the move was driven by unusual trading volume; it frames the catalyst as macro/sector sentiment and retailer earnings updates.","No specific volume ratio or confirmation metric is included in the provided text."],"key_facts":["On May 27, 2022, Amazon shares gained about 3% by 10:45 a.m. ET.","The S&P 500 was up about 1.4% by 10:45 a.m. ET.","The article attributes the move to a brightening outlook around economic growth and consumer spending.","The article says several tech/e-commerce peers (including Shopify and Etsy) were trading higher early that morning.","The article contrasts retailer updates: Macy's and Ulta Beauty reported solid sales/traffic/earnings, while Walmart and Target updates appeared to show a bigger negative impact from inflation.","The article notes Amazon\u2019s business depends on economic growth for product sales, while cloud is becoming a bigger factor."],"numeric_claims":[{"label":"AMZN price change by 10:45 a.m. ET","value":"~+3%"},{"label":"S&P 500 price change by 10:45 a.m. ET","value":"~+1.4%"},{"label":"AMZN YTD decline in 2022 (as stated)","value":"~down 30% so far in 2022"}],"primary_claim":"Amazon (AMZN) stock was up about 3% by 10:45 a.m. ET on May 27, 2022, outperforming the S&P 500, with the move linked to improved outlook for economic growth and consumer spending.","relevance_score":0.55,"sentiment":"positive","source_quality":"high","summary":"Amazon shares rose on May 27, 2022, gaining about 3% by 10:45 a.m. ET versus a 1.4% gain in the S&P 500, attributed to a broader tech/consumer-spending optimism. The article does not provide any unusual-volume ratio data.","topics":["equities","market rally","consumer spending","tech sector","Amazon stock","economic growth outlook"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsLower energy prices should reduce Amazon's shipping and computing costs.","tickers":[],"title":"Why Amazon Stock Jumped Today","url":"https://www.fool.com/investing/2022/05/27/why-amazon-stock-jumped-today/"}

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