SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

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

event_store.db — signals

Update row sig_0a16976b2c70 in signals