Create
Query
event_store.db
—
events
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 11982 in events
seq
Primary key.
INTEGER
id
evt_5abc8a2d901c
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-10T01:13:47.935108+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-09T16:35:58.987693+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:d7a417c80178a365","evidence_event_ids":["evt_91481b0a532e"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/great-rotation-crushed-these-magnificent-seven-stocks-billionaire-investors-are-loading","as_of":"2026-04-09T16:35:58.987693+00:00","canonical_url":"https://www.fool.com/investing/2026/04/09/great-rotation-crush-magnificent-seven-stocks/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/great-rotation-crushed-these-magnificent-seven-stocks-billionaire-investors-are-loading","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_013edbe7c1df2983","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/09/great-rotation-crush-magnificent-seven-stocks/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:13:47.934799+00:00","extraction_method":"heuristic","fetched_description":"Key PointsMeta Platforms' shares are down, but the company is seeing strong, accelerating revenue growth.","fetched_title":"The Great Rotation Crushed These \"Magnificent Seven\" Stocks. Billionaire Investors Are Loading Up. | Nasdaq","final_url":"https://www.nasdaq.com/articles/great-rotation-crushed-these-magnificent-seven-stocks-billionaire-investors-are-loading","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/great-rotation-crushed-these-magnificent-seven-stocks-billionaire-investors-are-loading","source_event_id":"evt_91481b0a532e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"630836e7baaa40be","kind":"unusual_volume","published_at":"2026-04-09T16:05:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["April 09, 2026"],"entities":[{"asset_class":"equity","name":"Meta Platforms","relevance":"high","symbol":"META","type":"company"},{"asset_class":"equity","name":"Microsoft","relevance":"medium","symbol":"MSFT","type":"company"},{"asset_class":"equity","name":"Amazon","relevance":"medium","symbol":"AMZN","type":"company"},{"asset_class":"person","name":"Bill Ackman","relevance":"medium","symbol":"","type":"person"},{"asset_class":"person","name":"David Tepper","relevance":"medium","symbol":"","type":"person"},{"asset_class":"person","name":"Ole Andreas Halvorsen","relevance":"low","symbol":"","type":"person"},{"asset_class":"person","name":"Philippe Laffont","relevance":"low","symbol":"","type":"person"}],"event_type":"price_action","information_gaps":["No explicit unusual trading volume ratio vs average is provided in the provided text (baseline volume and volume ratio are not stated).","The signal type suggests unusual volume delta, but the article content provided focuses on price declines, investor rotation, and fundamentals rather than volume metrics.","No specific catalyst is tied to a volume spike; the closest catalyst hypothesis in the text is market rotation out of tech and concerns about AI infrastructure spending/capex, plus continued billionaire buying in Q4."],"key_facts":["The article states Meta Platforms\u2019 shares fell around 13% in Q1.","The article attributes Meta\u2019s Q1 decline to investor questions about its large capital expenditure (capex) plans.","The article says Meta is using AI to improve its recommendation algorithm, keep users on its site longer, and serve more ads.","The article says Meta\u2019s AI-powered tools help advertising partners create ads, target users, and automate bidding, leading to more ad impressions and higher ad prices.","The article says Meta is pulling back on metaverse efforts and introducing ads to its messaging platform; it cites WhatsApp and Threads as long-term growth drivers.","The article states Microsoft\u2019s shares plunged more than 23% to start 2026 and attributes this to a SaaS sell-off and caution about AI infrastructure spending by cloud providers.","The article says Microsoft\u2019s Azure revenue surged 39% last quarter and cites $625 billion in commercial remaining performance obligations (RPOs).","The article states Amazon\u2019s stock dropped nearly 10% in Q1 and discusses AI infrastructure spending plans and consumer worries as weighing on shares.","The article claims investors worried about the economy and broader markets are rotating out of tech stocks (including the \u201cMagnificent Seven\u201d) into value and small-cap stocks."],"numeric_claims":[{"label":"Meta Q1 stock decline","value":"~13%"},{"label":"Microsoft Q1/start-of-year stock decline","value":">23%"},{"label":"Microsoft Azure revenue surge","value":"39%"},{"label":"Microsoft commercial remaining performance obligations (RPOs)","value":"$625 billion"},{"label":"Amazon Q1 stock decline","value":"~10%"}],"primary_claim":"Meta Platforms (META) fell about 13% in Q1 despite strong, accelerating revenue growth driven by AI initiatives and ad improvements.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"The article argues that \u201cMagnificent Seven\u201d tech stocks (including Meta) have been sold off early in 2026 due to rotation out of tech, even as some companies report strong/accelerating fundamentals. It also claims billionaire investors were buying these names in Q4 at higher prices, implying the current weakness may be an opportunity.","topics":["Magnificent Seven","market rotation out of tech","AI-driven growth","Meta capex concerns","billionaire investor buying","Q1 stock declines","cloud/AI infrastructure spending concerns"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsMeta Platforms' shares are down, but the company is seeing strong, accelerating revenue growth.","tickers":[],"title":"The Great Rotation Crushed These \"Magnificent Seven\" Stocks. Billionaire Investors Are Loading Up.","url":"https://www.fool.com/investing/2026/04/09/great-rotation-crush-magnificent-seven-stocks/"}}
TEXT NOT NULL
source_ref
candidate:sc_013edbe7c1df2983
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:d7a417c80178a365
TEXT
episode_id
NULL
TEXT
created_at
2026-04-10T01:13:47.935155+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel