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-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_options_flow_delta:6a4594db5d5783f1","evidence_event_ids":["evt_8a625ac7660d"],"signal_type":"discovery_options_flow_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOZmdZUHZRMElqZ1FqSUdzeTk4QVJHaTFuMWQyTzdIX09tZWpKc09GNHF3dmUtWTFoX1E0NEc3Um00UkpzTE44eWtUdWVtZWotZ3p4UFR0Q1N0M0FZZUhZMkFpT3pXWmF1dGZUc2ZpZXBRSWFIZE95alNuV3U1X2JYVFc4emhoNTB3dzZGb2RnRnY?oc=5","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOZmdZUHZRMElqZ1FqSUdzeTk4QVJHaTFuMWQyTzdIX09tZWpKc09GNHF3dmUtWTFoX1E0NEc3Um00UkpzTE44eWtUdWVtZWotZ3p4UFR0Q1N0M0FZZUhZMkFpT3pXWmF1dGZUc2ZpZXBRSWFIZE95alNuV3U1X2JYVFc4emhoNTB3dzZGb2RnRnY?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f6ac6823dab21d8a","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:28:02.749710+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxOZmdZUHZRMElqZ1FqSUdzeTk4QVJHaTFuMWQyTzdIX09tZWpKc09GNHF3dmUtWTFoX1E0NEc3Um00UkpzTE44eWtUdWVtZWotZ3p4UFR0Q1N0M0FZZUhZMkFpT3pXWmF1dGZUc2ZpZXBRSWFIZE95alNuV3U1X2JYVFc4emhoNTB3dzZGb2RnRnY?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/CBMikAFBVV95cUxOZmdZUHZRMElqZ1FqSUdzeTk4QVJHaTFuMWQyTzdIX09tZWpKc09GNHF3dmUtWTFoX1E0NEc3Um00UkpzTE44eWtUdWVtZWotZ3p4UFR0Q1N0M0FZZUhZMkFpT3pXWmF1dGZUc2ZpZXBRSWFIZE95alNuV3U1X2JYVFc4emhoNTB3dzZGb2RnRnY?oc=5","source_event_id":"evt_8a625ac7660d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a32844105026bbc2","kind":"options_flow","published_at":"2026-04-03T19:55:08+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"software/tool","name":"TMAD Scanner","relevance":"high","symbol":"","type":"product"},{"asset_class":"person","name":"Lia Holmgren","relevance":"medium","symbol":"","type":"person"},{"asset_class":"media","name":"Traders Union","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No ticker is mentioned.","No options flow direction (calls vs puts) is stated.","No expiry/tenor or days-to-expiry is provided.","No trade size or size relative to open interest is given.","No information is provided to assess whether positioning is informed (e.g., unusual flow, delta/IV context).","The provided article text appears to be mostly page styling/HTML, with no additional substantive content beyond the headline/summary."],"key_facts":["The article headline says TMAD Scanner brings options flow and momentum features together.","The source summary repeats the same claim.","Lia Holmgren is credited in the headline for noting the feature integration."],"numeric_claims":[],"primary_claim":"TMAD Scanner brings options flow and momentum features together, according to Lia Holmgren (Traders Union).","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"The Traders Union article states that the TMAD Scanner combines options flow features with momentum features, as noted by Lia Holmgren. No specific ticker or options-flow metrics are provided in the provided text.","topics":["options flow","momentum","trading tools","TMAD Scanner"]},"source":"Traders Union","source_domain":"gstatic.com","summary":"TMAD Scanner brings options flow and momentum features together, Lia Holmgren notes Traders Union","tickers":[],"title":"TMAD Scanner brings options flow and momentum features together, Lia Holmgren notes - Traders Union","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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 2100 in events