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:89ad49846e14c183","evidence_event_ids":["evt_f63d9cb6b388"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxOTWE2WUJXcjZWelgxVHVXRXVjUnV0dHpER3RyVm1XZG1YYUtZaVRHQUFpdWhLZ1pHdktVVmVla3ZpRk1wUElZR2pFTy1QVnd4WDFrOTVfTVRZX0FueEIyeC1aM2l5U0RjWElpMmh6WjJ4Z0tLejVlOWdod0VNTmJpN1AwYnBxWVlNVG1pX2twbW9NcW53Uzh3?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=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxOTWE2WUJXcjZWelgxVHVXRXVjUnV0dHpER3RyVm1XZG1YYUtZaVRHQUFpdWhLZ1pHdktVVmVla3ZpRk1wUElZR2pFTy1QVnd4WDFrOTVfTVRZX0FueEIyeC1aM2l5U0RjWElpMmh6WjJ4Z0tLejVlOWdod0VNTmJpN1AwYnBxWVlNVG1pX2twbW9NcW53Uzh3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_429b7aad3378725f","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=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:51:32.502948+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxOTWE2WUJXcjZWelgxVHVXRXVjUnV0dHpER3RyVm1XZG1YYUtZaVRHQUFpdWhLZ1pHdktVVmVla3ZpRk1wUElZR2pFTy1QVnd4WDFrOTVfTVRZX0FueEIyeC1aM2l5U0RjWElpMmh6WjJ4Z0tLejVlOWdod0VNTmJpN1AwYnBxWVlNVG1pX2twbW9NcW53Uzh3?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/CBMilwFBVV95cUxOTWE2WUJXcjZWelgxVHVXRXVjUnV0dHpER3RyVm1XZG1YYUtZaVRHQUFpdWhLZ1pHdktVVmVla3ZpRk1wUElZR2pFTy1QVnd4WDFrOTVfTVRZX0FueEIyeC1aM2l5U0RjWElpMmh6WjJ4Z0tLejVlOWdod0VNTmJpN1AwYnBxWVlNVG1pX2twbW9NcW53Uzh3?oc=5","source_event_id":"evt_f63d9cb6b388","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"20ad8219ce682258","kind":"sector_rotation","published_at":"2026-04-01T01:02:00+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Zscaler","relevance":"high","symbol":"ZS","type":"company"},{"asset_class":"macro/geopolitical","name":"Middle East tensions","relevance":"medium","symbol":"","type":"geopolitical_factor"}],"event_type":"price_action","information_gaps":["The provided article text is not actually present (only CSS/HTML boilerplate), so no additional details can be extracted.","No specific sectors are identified as gaining or losing.","No description of the macro driver beyond the phrase \u201ceasing Middle East tensions.\u201d","No evidence in the provided text about whether this is a regime shift versus short-term rebalancing.","No quantitative data (returns, sector performance, time window) is included."],"key_facts":["Headline states Zscaler (ZS) stock gains occurred amid easing Middle East tensions.","Headline states the move coincided with sector rotation."],"numeric_claims":[],"primary_claim":"Zscaler (ZS) stock gained amid easing Middle East tensions and sector rotation.","relevance_score":0.45,"sentiment":"positive","source_quality":"high","summary":"The signal claims Zscaler (ZS) shares rose alongside easing Middle East tensions and a broader sector rotation. No specific gaining/losing sectors or magnitude of the rotation are provided in the supplied text.","topics":["sector rotation","geopolitical risk","Zscaler","equities"]},"source":"IndexBox","source_domain":"gstatic.com","summary":"Zscaler (ZS) Stock Gains Amid Easing Middle East Tensions and Sector Rotation - News and Statistics IndexBox","tickers":["ZS"],"title":"Zscaler (ZS) Stock Gains Amid Easing Middle East Tensions and Sector Rotation - News and Statistics - IndexBox","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/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 2638 in events