SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:73e7bf899174f23c","evidence_event_ids":["evt_a1df0a36c244"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxObzl4ckdZbW1tSG5USURrU0dCTGhoWWZNNDVoZFZUcTNza0ZZWjRHaHF2QXB0UHZFQVR5SGprUW9uOWJOWlJyS2ZnVnpEZk5wdGRmNEZSeThsUW51M3QxSmJfTTdfYmNmaExHWnNyNmFtMEdLZUNiNkl5bEU4b3FSazRSdGU3eGZZTkpaTzhHYmttNWpoVTZqQ0tjSHU?oc=5","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxObzl4ckdZbW1tSG5USURrU0dCTGhoWWZNNDVoZFZUcTNza0ZZWjRHaHF2QXB0UHZFQVR5SGprUW9uOWJOWlJyS2ZnVnpEZk5wdGRmNEZSeThsUW51M3QxSmJfTTdfYmNmaExHWnNyNmFtMEdLZUNiNkl5bEU4b3FSazRSdGU3eGZZTkpaTzhHYmttNWpoVTZqQ0tjSHU?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_59c6fc29ec42f5e0","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:50:59.202331+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxObzl4ckdZbW1tSG5USURrU0dCTGhoWWZNNDVoZFZUcTNza0ZZWjRHaHF2QXB0UHZFQVR5SGprUW9uOWJOWlJyS2ZnVnpEZk5wdGRmNEZSeThsUW51M3QxSmJfTTdfYmNmaExHWnNyNmFtMEdLZUNiNkl5bEU4b3FSazRSdGU3eGZZTkpaTzhHYmttNWpoVTZqQ0tjSHU?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gstatic.com","publisher_resolution":"canonical_aggregator_unresolved","requested_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxObzl4ckdZbW1tSG5USURrU0dCTGhoWWZNNDVoZFZUcTNza0ZZWjRHaHF2QXB0UHZFQVR5SGprUW9uOWJOWlJyS2ZnVnpEZk5wdGRmNEZSeThsUW51M3QxSmJfTTdfYmNmaExHWnNyNmFtMEdLZUNiNkl5bEU4b3FSazRSdGU3eGZZTkpaTzhHYmttNWpoVTZqQ0tjSHU?oc=5","source_event_id":"evt_a1df0a36c244","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d8536f8739c3b9d8","kind":"sector_rotation","published_at":"2026-04-02T12:30:00+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"E*TRADE","relevance":"primary source of the study","symbol":"","type":"company"},{"asset_class":"equity","name":"Morgan Stanley","relevance":"affiliated with E*TRADE study release","symbol":"","type":"company"},{"asset_class":"other","name":"Yahoo Finance","relevance":"publisher of the coverage","symbol":"","type":"media"}],"event_type":"research","information_gaps":["The provided cleaned article text contains only page styling/HTML fragments and does not include the study results.","No specific sectors are identified as gaining or losing.","No macro driver (e.g., rates, inflation, growth, commodities) is stated in the provided text.","No indication is provided on whether the rotation is a regime shift versus short-term rebalancing.","No time horizon or ranking/magnitude of sector changes is included."],"key_facts":["A monthly sector rotation study was released by E*TRADE from Morgan Stanley.","Yahoo Finance reported on the release."],"numeric_claims":[],"primary_claim":"E*TRADE from Morgan Stanley released a monthly sector rotation study, covered by Yahoo Finance.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"The signal indicates that E*TRADE (via Morgan Stanley) released a monthly sector rotation study, reported by Yahoo Finance. The provided article text does not include the study\u2019s specific sector winners/losers or the macro driver.","topics":["sector rotation","monthly sector rotation study","E*TRADE","Morgan Stanley","equity sectors"]},"source":"Yahoo Finance","source_domain":"gstatic.com","summary":"E*TRADE from Morgan Stanley Releases Monthly Sector Rotation Study Yahoo Finance","tickers":[],"title":"E*TRADE from Morgan Stanley Releases Monthly Sector Rotation Study - Yahoo Finance","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 2626 in events