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-10T17:21:18.772571+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:1637ae06b0eb5c2b","evidence_event_ids":["evt_fd4b9caa4339"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxOWjJFRkVISWQxSHBDd3ZrTEdUa0xGeWNFLU9vZDg2dWxwVDhwb1k4RThHUjJkNGVQQ3dadkRueHc0Q2dDazBmNG15eVFfRlBFYlNtMTMtUFpucWtZbk9FYURyMXRHdUdRTk5pZnF5cGNyT3ppcUF1UERMbU54VGtlOE5tdlJEbm5SU0JDUg?oc=5","as_of":"2026-04-10T17:21:18.772571+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/CBMijAFBVV95cUxOWjJFRkVISWQxSHBDd3ZrTEdUa0xGeWNFLU9vZDg2dWxwVDhwb1k4RThHUjJkNGVQQ3dadkRueHc0Q2dDazBmNG15eVFfRlBFYlNtMTMtUFpucWtZbk9FYURyMXRHdUdRTk5pZnF5cGNyT3ppcUF1UERMbU54VGtlOE5tdlJEbm5SU0JDUg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_473dfdb5106d331a","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-10T20:19:03.327303+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijAFBVV95cUxOWjJFRkVISWQxSHBDd3ZrTEdUa0xGeWNFLU9vZDg2dWxwVDhwb1k4RThHUjJkNGVQQ3dadkRueHc0Q2dDazBmNG15eVFfRlBFYlNtMTMtUFpucWtZbk9FYURyMXRHdUdRTk5pZnF5cGNyT3ppcUF1UERMbU54VGtlOE5tdlJEbm5SU0JDUg?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/CBMijAFBVV95cUxOWjJFRkVISWQxSHBDd3ZrTEdUa0xGeWNFLU9vZDg2dWxwVDhwb1k4RThHUjJkNGVQQ3dadkRueHc0Q2dDazBmNG15eVFfRlBFYlNtMTMtUFpucWtZbk9FYURyMXRHdUdRTk5pZnF5cGNyT3ppcUF1UERMbU54VGtlOE5tdlJEbm5SU0JDUg?oc=5","source_event_id":"evt_fd4b9caa4339","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9eb096de1b27b93f","kind":"sector_rotation","published_at":"2026-04-10T15:00:02+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.35,"dates_mentioned":["Aug"],"entities":[{"asset_class":"equity","name":"Redwood Trust Inc","relevance":"high","symbol":"","type":"company"},{"asset_class":"macro","name":"Dollar Strength","relevance":"medium","symbol":"","type":"macro_factor"}],"event_type":"other","information_gaps":["Which specific sectors are gaining and losing is not stated in the provided text.","What the macro driver mechanism is (e.g., rates, inflation, risk sentiment) is not described beyond \u201cDollar Strength.\u201d","Whether this is a regime shift versus short-term rebalancing is not explicitly addressed in the provided text.","Any performance/price levels, time horizon, or evidence supporting the claim are not included in the provided text.","The cleaned article content appears to be mostly HTML/CSS, so substantive article body content may be missing."],"key_facts":["Headline states: \u201cAug Spikes: Will Redwood Trust Inc benefit from sector rotation - Dollar Strength & Reliable Intraday Trade Plans.\u201d","No explicit list of gaining or losing sectors is present in the provided cleaned article text (only styling/HTML content).","No explicit macro driver details beyond the phrase \u201cDollar Strength\u201d are provided in the provided text."],"numeric_claims":[],"primary_claim":"The headline claims that Redwood Trust Inc could benefit from sector rotation due to dollar strength and that there are reliable intraday trade plans.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"The signal suggests that in August, Redwood Trust Inc may benefit from a sector rotation driven by dollar strength, framed as an opportunity for intraday trading. However, the provided article text contains no actual sector winners/losers or macro details beyond the headline wording.","topics":["sector rotation","intraday trading","August spikes","U.S. dollar strength","Redwood Trust Inc"]},"source":"baoquankhu1.vn","source_domain":"gstatic.com","summary":"Aug Spikes: Will Redwood Trust Inc benefit from sector rotation - Dollar Strength & Reliable Intraday Trade Plans baoquankhu1.vn","tickers":[],"title":"Aug Spikes: Will Redwood Trust Inc benefit from sector rotation - Dollar Strength & Reliable Intraday Trade Plans - baoquankhu1.vn","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 19428 in events