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-09T01:43:26.310695+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:1d54c2fae504bb2e","evidence_event_ids":["evt_d43286c0bbd7"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPUmM0akNuMVB0dWdOT04zT1FCZzNpZ2d6MkJTdG5ZUW1HU2xZbXRPdFFJeTFDaHNfRVNXdUhma0k2RHZGQmszVlltcC12Tl9mYm90VF9NTWRiZFZaQUdZekRjeFotekRpY2dUaGJGaVY5YnljWlphUXh6STZKWW9pMFM5YTBoODJtV2tFcmIyb3Z6enRHRjdv?oc=5","as_of":"2026-04-09T01:43:26.310695+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/CBMilwFBVV95cUxPUmM0akNuMVB0dWdOT04zT1FCZzNpZ2d6MkJTdG5ZUW1HU2xZbXRPdFFJeTFDaHNfRVNXdUhma0k2RHZGQmszVlltcC12Tl9mYm90VF9NTWRiZFZaQUdZekRjeFotekRpY2dUaGJGaVY5YnljWlphUXh6STZKWW9pMFM5YTBoODJtV2tFcmIyb3Z6enRHRjdv?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9cc692a09e2e2665","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-09T23:43:22.766667+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPUmM0akNuMVB0dWdOT04zT1FCZzNpZ2d6MkJTdG5ZUW1HU2xZbXRPdFFJeTFDaHNfRVNXdUhma0k2RHZGQmszVlltcC12Tl9mYm90VF9NTWRiZFZaQUdZekRjeFotekRpY2dUaGJGaVY5YnljWlphUXh6STZKWW9pMFM5YTBoODJtV2tFcmIyb3Z6enRHRjdv?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/CBMilwFBVV95cUxPUmM0akNuMVB0dWdOT04zT1FCZzNpZ2d6MkJTdG5ZUW1HU2xZbXRPdFFJeTFDaHNfRVNXdUhma0k2RHZGQmszVlltcC12Tl9mYm90VF9NTWRiZFZaQUdZekRjeFotekRpY2dUaGJGaVY5YnljWlphUXh6STZKWW9pMFM5YTBoODJtV2tFcmIyb3Z6enRHRjdv?oc=5","source_event_id":"evt_d43286c0bbd7","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"840886b25929f726","kind":"sector_rotation","published_at":"2026-04-04T15:14:31+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"ETF","name":"Anfield US Equity Sector Rotation ETF","relevance":"high","symbol":"","type":"fund"},{"asset_class":"ETF","name":"iShares U.S. Pharmaceuticals ETF","relevance":"high","symbol":"IHE","type":"ETF"},{"asset_class":"website","name":"GuruFocus","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The article text provided contains only page styling/HTML fragments and does not include the actual holding-history content.","No data is provided on sector rotation direction (which sectors gain/lose).","No macro driver is described.","No timeframe or evidence is provided to determine whether this is a regime shift versus short-term rebalancing.","No performance/weight-change figures for IHE or other sectors are included."],"key_facts":["Signal type is discovery_sector_rotation_delta.","Headline indicates a GuruFocus page for \u201cAnfield US Equity Sector Rotation ETF's iShares U.S. Pharmaceuticals ETF (IHE) Holding History.\u201d","No explicit information about which sectors are gaining or losing is included in the provided article text."],"numeric_claims":[],"primary_claim":"The GuruFocus source is about the Anfield US Equity Sector Rotation ETF\u2019s holding history of iShares U.S. Pharmaceuticals ETF (IHE).","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The provided signal references a GuruFocus page about the Anfield US Equity Sector Rotation ETF\u2019s holding history for iShares U.S. Pharmaceuticals ETF (IHE). No sector rotation gains/losses or macro driver details are present in the supplied text.","topics":["sector rotation","ETF holding history","pharmaceuticals sector exposure"]},"source":"GuruFocus","source_domain":"gstatic.com","summary":"Anfield US Equity Sector Rotation ETF's iShares U.S. Pharmaceuticals ETF(IHE) Holding History GuruFocus","tickers":["IHE"],"title":"Anfield US Equity Sector Rotation ETF's iShares U.S. Pharmaceuticals ETF(IHE) Holding History - GuruFocus","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 10380 in events