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/CBMihwFBVV95cUxNUGd2R3A2MFgzXzM0YnhVeV9ac2RTSC1DRDNKX3hzQ0xfYW9HWVZRQ0ctZlkzQTFVTEtYRmQ3eVZCTVpzYzhYNkpjMndYZmJ0QUdydW9KUXNPeU5KWnRId0NiVEplUF9qaFNYMlhLMmYtN2tvTzR3cWprTUM1RExyVHZvS0t6NVE?oc=5","as_of":"2026-04-10T03:04:31.796915+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/CBMihwFBVV95cUxNUGd2R3A2MFgzXzM0YnhVeV9ac2RTSC1DRDNKX3hzQ0xfYW9HWVZRQ0ctZlkzQTFVTEtYRmQ3eVZCTVpzYzhYNkpjMndYZmJ0QUdydW9KUXNPeU5KWnRId0NiVEplUF9qaFNYMlhLMmYtN2tvTzR3cWprTUM1RExyVHZvS0t6NVE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9428f13310ea4394","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-10T03:40:55.624393+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxNUGd2R3A2MFgzXzM0YnhVeV9ac2RTSC1DRDNKX3hzQ0xfYW9HWVZRQ0ctZlkzQTFVTEtYRmQ3eVZCTVpzYzhYNkpjMndYZmJ0QUdydW9KUXNPeU5KWnRId0NiVEplUF9qaFNYMlhLMmYtN2tvTzR3cWprTUM1RExyVHZvS0t6NVE?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/CBMihwFBVV95cUxNUGd2R3A2MFgzXzM0YnhVeV9ac2RTSC1DRDNKX3hzQ0xfYW9HWVZRQ0ctZlkzQTFVTEtYRmQ3eVZCTVpzYzhYNkpjMndYZmJ0QUdydW9KUXNPeU5KWnRId0NiVEplUF9qaFNYMlhLMmYtN2tvTzR3cWprTUM1RExyVHZvS0t6NVE?oc=5","source_event_id":"evt_c109f05a172d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e3e4a77fdc10cce6","kind":"sector_rotation","published_at":"2026-04-09T22:35:23+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":["Aug","2026"],"entities":[{"asset_class":"equity","name":"IFBD","relevance":"high","symbol":"IFBD","type":"equity_or_ticker"}],"event_type":"other","information_gaps":["Which sectors are gaining and which are losing is not stated in the provided text.","The macro driver(s) for the sector rotation are not described.","Whether the rotation is a regime shift or short-term rebalancing is not specified.","No concrete performance metrics, probabilities, or trade parameters are included in the provided text.","The meaning of \"IFBD\" (company/ETF/fund) is not clarified beyond the ticker in the headline."],"key_facts":["Headline states: \"Aug Drivers: Will IFBD benefit from sector rotation - 2026 PostEarnings & Daily Profit Maximizing Trade Tips\".","The provided text does not list specific sectors that are gaining or losing.","The provided text does not specify the macro driver behind the sector rotation.","The provided text does not indicate whether this is a regime shift versus short-term rebalancing."],"numeric_claims":[],"primary_claim":"The article suggests that IFBD could benefit from sector rotation in August (with a 2026 post-earnings trading angle).","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"The signal claims that in August, IFBD may benefit from sector rotation, framed as a 2026 post-earnings and daily profit-maximizing trade idea. No specific gaining/losing sectors or macro driver details are present in the provided text.","topics":["sector rotation","trading tips","post-earnings","August drivers","2026"]},"source":"baoquankhu1.vn","source_domain":"gstatic.com","summary":"Aug Drivers: Will IFBD benefit from sector rotation - 2026 PostEarnings & Daily Profit Maximizing Trade Tips baoquankhu1.vn","tickers":[],"title":"Aug Drivers: Will IFBD benefit from sector rotation - 2026 PostEarnings & Daily Profit Maximizing Trade Tips - 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_2f61b5b35361 in signals