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-09T18:05:02.959642+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:7a1cf373880eee88","evidence_event_ids":["evt_c3a58a69627b"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTE8wem1UaWVTYmRYeXZ1TDV3d1l4QmRtMXNHZkxuQXlkR29zalZmQWZoMEt1WnZJRGlIdW5aMFBGclVsOGw2OExGSm9WVE9BSnN0QS1zV2U5ZXRVUWJUekpGNV9KZzZ4Qzh1TUx4ZGtadTdOTGZnNjJFYUhEaw?oc=5","as_of":"2026-04-09T18:05:02.959642+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/CBMie0FVX3lxTE8wem1UaWVTYmRYeXZ1TDV3d1l4QmRtMXNHZkxuQXlkR29zalZmQWZoMEt1WnZJRGlIdW5aMFBGclVsOGw2OExGSm9WVE9BSnN0QS1zV2U5ZXRVUWJUekpGNV9KZzZ4Qzh1TUx4ZGtadTdOTGZnNjJFYUhEaw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_570b1c8812337252","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-10T01:34:17.089257+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTE8wem1UaWVTYmRYeXZ1TDV3d1l4QmRtMXNHZkxuQXlkR29zalZmQWZoMEt1WnZJRGlIdW5aMFBGclVsOGw2OExGSm9WVE9BSnN0QS1zV2U5ZXRVUWJUekpGNV9KZzZ4Qzh1TUx4ZGtadTdOTGZnNjJFYUhEaw?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/CBMie0FVX3lxTE8wem1UaWVTYmRYeXZ1TDV3d1l4QmRtMXNHZkxuQXlkR29zalZmQWZoMEt1WnZJRGlIdW5aMFBGclVsOGw2OExGSm9WVE9BSnN0QS1zV2U5ZXRVUWJUekpGNV9KZzZ4Qzh1TUx4ZGtadTdOTGZnNjJFYUhEaw?oc=5","source_event_id":"evt_c3a58a69627b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"02fc81d3bff1ebc6","kind":"sector_rotation","published_at":"2026-04-09T04:39:49+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_index_or_strategy","name":"SSBI","relevance":"high","symbol":"","type":"index_or_strategy"},{"asset_class":"equity_sectors","name":"sector rotation","relevance":"high","symbol":"","type":"market_theme"}],"event_type":"other","information_gaps":["Which specific sectors are gaining and which are losing (not provided).","What the macro driver is (not provided).","Whether the move is a regime shift or short-term rebalancing (not provided).","Any concrete trade signal details or confirmation criteria (not provided).","The meaning/definition of \u201cSSBI\u201d in this context (not provided).","The cleaned article text appears to be mostly CSS/HTML boilerplate, not the article content."],"key_facts":["Headline references \u201cAug Chart Watch\u201d and asks whether \u201cSSBI\u201d will benefit from sector rotation.","No explicit list of gaining or losing sectors is present in the provided cleaned text.","No macro driver (e.g., rates, inflation, earnings, commodities) is stated in the provided cleaned text.","No explicit conclusion about regime shift vs short-term rebalancing is stated in the provided cleaned text."],"numeric_claims":[],"primary_claim":"The headline suggests a topic of sector rotation and whether \u201cSSBI\u201d would benefit, but no specific gaining/losing sectors or drivers are present in the provided text.","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"The provided signal and cleaned article text do not contain any readable sector-rotation details (which sectors gain/lose, macro driver, or regime vs short-term rebalancing). The headline only poses a question about whether SSBI would benefit from sector rotation.","topics":["sector rotation","SSBI","2026 institutional/breakout confirmation trade signals","chart watch"]},"source":"baoquankhu1.vn","source_domain":"gstatic.com","summary":"Aug Chart Watch: Will SSBI benefit from sector rotation - 2026 Institutional & Breakout Confirmation Trade Signals baoquankhu1.vn","tickers":[],"title":"Aug Chart Watch: Will SSBI benefit from sector rotation - 2026 Institutional & Breakout Confirmation Trade Signals - 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 12219 in events