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/CBMie0FVX3lxTFBSUE4waHZPeGxPcEZUem5nT2tvVHprZ1VSemktM1NvdlZvczI5OFpuUl9DUTNKVlV2OUVuRmhlaFdWcDQ4bVY2azlpVEkzRWZpWkdXc2tpUHVOd3FYaUpWeFRDVUN6VkY3ZGItUndxUjczMEdvVDdDSzdQSQ?oc=5","as_of":"2026-04-09T03:12:49.786272+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/CBMie0FVX3lxTFBSUE4waHZPeGxPcEZUem5nT2tvVHprZ1VSemktM1NvdlZvczI5OFpuUl9DUTNKVlV2OUVuRmhlaFdWcDQ4bVY2azlpVEkzRWZpWkdXc2tpUHVOd3FYaUpWeFRDVUN6VkY3ZGItUndxUjczMEdvVDdDSzdQSQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_dd6146f5375169fa","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-09T19:33:54.223885+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMie0FVX3lxTFBSUE4waHZPeGxPcEZUem5nT2tvVHprZ1VSemktM1NvdlZvczI5OFpuUl9DUTNKVlV2OUVuRmhlaFdWcDQ4bVY2azlpVEkzRWZpWkdXc2tpUHVOd3FYaUpWeFRDVUN6VkY3ZGItUndxUjczMEdvVDdDSzdQSQ?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/CBMie0FVX3lxTFBSUE4waHZPeGxPcEZUem5nT2tvVHprZ1VSemktM1NvdlZvczI5OFpuUl9DUTNKVlV2OUVuRmhlaFdWcDQ4bVY2azlpVEkzRWZpWkdXc2tpUHVOd3FYaUpWeFRDVUN6VkY3ZGItUndxUjczMEdvVDdDSzdQSQ?oc=5","source_event_id":"evt_45514b712e3d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a2ef5fe317731f8f","kind":"options_flow","published_at":"2026-04-08T18:10:05+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":["2026"],"entities":[{"asset_class":"equity","name":"DORM","relevance":"mentioned in headline only","symbol":"DORM","type":"ticker"}],"event_type":"other","information_gaps":["Options flow direction (calls vs puts) is not provided.","Expiry date(s) or days-to-expiry are not provided.","Flow size (contracts or $) is not provided.","Open-interest context (e.g., % of OI) is not provided.","Whether the flow suggests informed positioning cannot be assessed without the above metrics.","No actual options chain/flow table content is present in the provided text."],"key_facts":["The headline mentions \u201cDORM\u201d and \u201c2026 Price Action Summary & Free High Return Stock Watch Alerts.\u201d","The provided \u201cArticle Text\u201d is largely CSS/HTML styling and does not include readable options-flow metrics."],"numeric_claims":[],"primary_claim":"No grounded options-flow details for ticker DORM (calls vs puts, expiry, size vs open interest, or days to expiry) are present in the provided article text.","relevance_score":0.15,"sentiment":"neutral","source_quality":"high","summary":"The provided signal text does not contain any actual options-flow data (calls/puts, expiries, contract size, or open-interest context). It appears to be a page shell/HTML/CSS rather than an extracted article body with the needed figures.","topics":["options flow","ESG investment","2026 price action summary","stock watch alerts"]},"source":"baoquankhu1.vn","source_domain":"gstatic.com","summary":"Options Flow: Is DORM a good ESG investment - 2026 Price Action Summary & Free High Return Stock Watch Alerts baoquankhu1.vn","tickers":[],"title":"Options Flow: Is DORM a good ESG investment - 2026 Price Action Summary & Free High Return Stock Watch Alerts - 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_9b7644c3b6f1 in signals