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/CBMiXkFVX3lxTE9VbWN1Y3dER2RJeThXcDZiWnNkaGFoSUFGclg3M1hLZ2tuSmt2cVdQNHVPVkdBQ3JiRklUQlVnRWFtVjJwMU9qYWwzdEZVMVNZRE1aRlA4c283Nk83VlHSAWNBVV95cUxPMHdMbUJ5ZVRHTmlhZ3hqMS1xemlFSHQ0WlpZdTdnSHZPR1BmaUVhTzRQZ0FKcUZ4UHdNUGRFd2JvZDJ4LWJROC1aNWhyWGg4d3dIM2ZGQkxESjdTaEtfZThKS2s?oc=5","as_of":"2026-04-08T19:57:42.365437+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/CBMiXkFVX3lxTE9VbWN1Y3dER2RJeThXcDZiWnNkaGFoSUFGclg3M1hLZ2tuSmt2cVdQNHVPVkdBQ3JiRklUQlVnRWFtVjJwMU9qYWwzdEZVMVNZRE1aRlA4c283Nk83VlHSAWNBVV95cUxPMHdMbUJ5ZVRHTmlhZ3hqMS1xemlFSHQ0WlpZdTdnSHZPR1BmaUVhTzRQZ0FKcUZ4UHdNUGRFd2JvZDJ4LWJROC1aNWhyWGg4d3dIM2ZGQkxESjdTaEtfZThKS2s?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6e69b61fae1f3a33","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-09T22:39:30.928566+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiXkFVX3lxTE9VbWN1Y3dER2RJeThXcDZiWnNkaGFoSUFGclg3M1hLZ2tuSmt2cVdQNHVPVkdBQ3JiRklUQlVnRWFtVjJwMU9qYWwzdEZVMVNZRE1aRlA4c283Nk83VlHSAWNBVV95cUxPMHdMbUJ5ZVRHTmlhZ3hqMS1xemlFSHQ0WlpZdTdnSHZPR1BmaUVhTzRQZ0FKcUZ4UHdNUGRFd2JvZDJ4LWJROC1aNWhyWGg4d3dIM2ZGQkxESjdTaEtfZThKS2s?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/CBMiXkFVX3lxTE9VbWN1Y3dER2RJeThXcDZiWnNkaGFoSUFGclg3M1hLZ2tuSmt2cVdQNHVPVkdBQ3JiRklUQlVnRWFtVjJwMU9qYWwzdEZVMVNZRE1aRlA4c283Nk83VlHSAWNBVV95cUxPMHdMbUJ5ZVRHTmlhZ3hqMS1xemlFSHQ0WlpZdTdnSHZPR1BmaUVhTzRQZ0FKcUZ4UHdNUGRFd2JvZDJ4LWJROC1aNWhyWGg4d3dIM2ZGQkxESjdTaEtfZThKS2s?oc=5","source_event_id":"evt_5b0678c88162","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"10fe693cba963f57","kind":"sector_rotation","published_at":"2026-04-07T21:24:51+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Polaris","relevance":"high","symbol":"","type":"company"},{"asset_class":"unknown","name":"Bitget","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["No explicit list of which sectors are gaining or losing is provided in the provided text.","No quantitative details (magnitude of earnings impact, tariff rates, or sector performance deltas) are provided.","No description of the macro driver beyond the mention of tariffs is provided.","No evidence in the provided text distinguishes regime shift vs short-term rebalancing beyond the phrase \u201cincreasingly pressing.\u201d","The provided article text appears to be largely HTML/CSS with no readable content beyond the headline/summary, limiting extraction."],"key_facts":["Headline states Polaris suffers an earnings slump due to tariffs.","Headline states sector rotation is becoming increasingly pressing."],"numeric_claims":[],"primary_claim":"Polaris is experiencing an earnings slump attributed to tariffs, alongside an increasingly pressing sector rotation theme.","relevance_score":0.45,"sentiment":"negative","source_quality":"high","summary":"The signal claims Polaris\u2019s earnings are slumping due to tariffs and that sector rotation is becoming increasingly important. It does not provide specific sector winners/losers or detailed rotation mechanics in the provided text.","topics":["tariffs","earnings slump","sector rotation","macro policy (trade)"]},"source":"Bitget","source_domain":"gstatic.com","summary":"Polaris Suffers Earnings Slump Due to Tariffs as Sector Rotation Becomes Increasingly Pressing Bitget","tickers":[],"title":"Polaris Suffers Earnings Slump Due to Tariffs as Sector Rotation Becomes Increasingly Pressing - Bitget","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_08de3787e837 in signals