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-09T15:06:58.940339+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:5cc0500eae8fbbd1","evidence_event_ids":["evt_25ec78245dad"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxNUnRRMHJ0V2NOcTRMaVJhcG5uaTFWM3BKbVNLamlzaU5uR1F4bDM3aHZqd3h5TXBXWEZfcjFXNjROQzU0U1hwbE91LS0zS1pNYzkzcWFRclJIVU1RZVBNSTVGLXh4WkxVd1R0YTdmaU9YSUJLUEdWRHRZZVNmMWRaOEhSQzZORXYxZmNjT3gxRFZQaUxtTjNjdw?oc=5","as_of":"2026-04-09T15:06:58.940339+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/CBMimAFBVV95cUxNUnRRMHJ0V2NOcTRMaVJhcG5uaTFWM3BKbVNLamlzaU5uR1F4bDM3aHZqd3h5TXBXWEZfcjFXNjROQzU0U1hwbE91LS0zS1pNYzkzcWFRclJIVU1RZVBNSTVGLXh4WkxVd1R0YTdmaU9YSUJLUEdWRHRZZVNmMWRaOEhSQzZORXYxZmNjT3gxRFZQaUxtTjNjdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_dc858fc4ab828568","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-10T00:58:20.987845+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxNUnRRMHJ0V2NOcTRMaVJhcG5uaTFWM3BKbVNLamlzaU5uR1F4bDM3aHZqd3h5TXBXWEZfcjFXNjROQzU0U1hwbE91LS0zS1pNYzkzcWFRclJIVU1RZVBNSTVGLXh4WkxVd1R0YTdmaU9YSUJLUEdWRHRZZVNmMWRaOEhSQzZORXYxZmNjT3gxRFZQaUxtTjNjdw?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/CBMimAFBVV95cUxNUnRRMHJ0V2NOcTRMaVJhcG5uaTFWM3BKbVNLamlzaU5uR1F4bDM3aHZqd3h5TXBXWEZfcjFXNjROQzU0U1hwbE91LS0zS1pNYzkzcWFRclJIVU1RZVBNSTVGLXh4WkxVd1R0YTdmaU9YSUJLUEdWRHRZZVNmMWRaOEhSQzZORXYxZmNjT3gxRFZQaUxtTjNjdw?oc=5","source_event_id":"evt_25ec78245dad","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b3e357d98c747ef2","kind":"sector_rotation","published_at":"2026-04-04T15:22:31+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"ETF","name":"Anfield US Equity Sector Rotation ETF","relevance":"high","symbol":"","type":"fund"},{"asset_class":"ETF","name":"iShares PHLX SOX Semiconductor Sector Index Fund","relevance":"high","symbol":"SOXX","type":"fund"},{"asset_class":"index_fund","name":"PHLX SOX Semiconductor Sector Index Fund","relevance":"medium","symbol":"","type":"index_fund_reference"}],"event_type":"other","information_gaps":["No information is provided on which sectors are gaining or losing.","No macro driver (e.g., rates, inflation, earnings, AI cycle) is mentioned in the provided text.","No evidence is provided on whether this represents a regime shift versus short-term rebalancing.","No holding-history figures (dates, weights, changes) are present in the provided text.","The cleaned article content appears to be mostly CSS/HTML and does not include the substantive GuruFocus content."],"key_facts":["Headline indicates a GuruFocus page titled \u201cAnfield US Equity Sector Rotation ETF's iShares PHLX SOX Semiconductor Sector Index Fund (SOXX) Holding History.\u201d","The provided cleaned article text contains only CSS/HTML styling and does not include the holding-history data or any narrative about sector rotation."],"numeric_claims":[],"primary_claim":"The provided source is a GuruFocus page about the Anfield US Equity Sector Rotation ETF\u2019s holding history for SOXX (iShares PHLX SOX Semiconductor Sector Index Fund).","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The signal references an Anfield US Equity Sector Rotation ETF page on GuruFocus that tracks the holding history of the iShares PHLX SOX Semiconductor Sector Index Fund (SOXX). No sector gain/loss, macro driver, or rotation direction is stated in the provided text.","topics":["sector rotation","semiconductors","ETF holding history","SOXX"]},"source":"GuruFocus","source_domain":"gstatic.com","summary":"Anfield US Equity Sector Rotation ETF's iShares PHLX SOX Semiconductor Sector Index Fund(SOXX) Holding History GuruFocus","tickers":["SOXX"],"title":"Anfield US Equity Sector Rotation ETF's iShares PHLX SOX Semiconductor Sector Index Fund(SOXX) 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 11699 in events