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/CBMie0FVX3lxTE1IOGlOVlEwNEUzRk51cjhva3lfSDFMcmtOdFhOTWZIRWxHcjFZYThDRGZrRGg2RTkxNzRLak94T0tYUUE0VE5WREpoYjM4cjJoa2NfVHpBcV92N0VidGZxdkVmLUZ2a2pyYTJUSGlac0RxcTQxUy1xX1lxSQ?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/CBMie0FVX3lxTE1IOGlOVlEwNEUzRk51cjhva3lfSDFMcmtOdFhOTWZIRWxHcjFZYThDRGZrRGg2RTkxNzRLak94T0tYUUE0VE5WREpoYjM4cjJoa2NfVHpBcV92N0VidGZxdkVmLUZ2a2pyYTJUSGlac0RxcTQxUy1xX1lxSQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_02df54c392eb6037","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:57:51.683883+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTE1IOGlOVlEwNEUzRk51cjhva3lfSDFMcmtOdFhOTWZIRWxHcjFZYThDRGZrRGg2RTkxNzRLak94T0tYUUE0VE5WREpoYjM4cjJoa2NfVHpBcV92N0VidGZxdkVmLUZ2a2pyYTJUSGlac0RxcTQxUy1xX1lxSQ?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/CBMie0FVX3lxTE1IOGlOVlEwNEUzRk51cjhva3lfSDFMcmtOdFhOTWZIRWxHcjFZYThDRGZrRGg2RTkxNzRLak94T0tYUUE0VE5WREpoYjM4cjJoa2NfVHpBcV92N0VidGZxdkVmLUZ2a2pyYTJUSGlac0RxcTQxUy1xX1lxSQ?oc=5","source_event_id":"evt_30bf0af48d27","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a3b7072789428372","kind":"sector_rotation","published_at":"2026-04-09T12:31:22+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.45,"dates_mentioned":["2026"],"entities":[{"asset_class":"equity","name":"CTAS","relevance":"mentioned in headline","symbol":"CTAS","type":"equity_ticker_mentioned"}],"event_type":"other","information_gaps":["Which sectors are gaining vs losing (not present in provided text).","The macro driver behind the sector rotation (not present in provided text).","Whether the rotation is described as a regime shift or short-term rebalancing (not present in provided text).","Any concrete evidence/indicators from the weekly chart analysis (not present in provided text).","Any additional tickers/sectors mentioned beyond CTAS (not present in provided text)."],"key_facts":["Headline states: \"Will CTAS benefit from sector rotation\".","Headline references \"2026 Selloffs\" and \"Weekly Chart Analysis and Guides\".","No explicit sector gainers/losers, macro driver, or regime-vs-rebalancing language is present in the provided cleaned article text (only CSS/boilerplate)."],"numeric_claims":[],"primary_claim":"The article headline asks whether CTAS will benefit from sector rotation in the context of 2026 selloffs and weekly chart analysis.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The provided signal references an article about whether CTAS could benefit from sector rotation, framed around 2026 selloffs and weekly chart analysis. However, the cleaned article text contains only page styling/boilerplate and does not include any sector rotation details.","topics":["sector rotation","CTAS","2026 selloffs","weekly chart analysis"]},"source":"baoquankhu1.vn","source_domain":"gstatic.com","summary":"Bull Bear: Will CTAS benefit from sector rotation - 2026 Selloffs & Weekly Chart Analysis and Guides baoquankhu1.vn","tickers":[],"title":"Bull Bear: Will CTAS benefit from sector rotation - 2026 Selloffs & Weekly Chart Analysis and Guides - 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_b51bafe011c5 in signals