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:3a6ff888cb1263da","evidence_event_ids":["evt_5f05710ccde2"],"signal_type":"discovery_options_flow_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi8wFBVV95cUxPQjhyd2VPbmdLdS12MmxodFFkbzJLb3ozUU84Z09Ib1IwTTA3NXZoOGpWNVhrOENKZTFvVkVCaTNZamNJMWkzcEZOeTA2c1hpdXVmQjRPRkZFOGd6Wm5wWDZQdkZoelk4dS03NGZSaU9JYjdkc0FBejhKSExxeFNXdlFNUEVWQnhYeXN3ekhXWG5Ga0RQZnZvRUlySElJOWppdDZWdGZZYjJTa3lnT0txWktwSk1yQVhsNDR0U0xOelNQV3M4LUQzdXd0UkRESUJ1ZTZ6Yng0WU11dVF5REUwM3dhbGVsMzRIUHZGdmplS0U5Z2s?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/CBMi8wFBVV95cUxPQjhyd2VPbmdLdS12MmxodFFkbzJLb3ozUU84Z09Ib1IwTTA3NXZoOGpWNVhrOENKZTFvVkVCaTNZamNJMWkzcEZOeTA2c1hpdXVmQjRPRkZFOGd6Wm5wWDZQdkZoelk4dS03NGZSaU9JYjdkc0FBejhKSExxeFNXdlFNUEVWQnhYeXN3ekhXWG5Ga0RQZnZvRUlySElJOWppdDZWdGZZYjJTa3lnT0txWktwSk1yQVhsNDR0U0xOelNQV3M4LUQzdXd0UkRESUJ1ZTZ6Yng0WU11dVF5REUwM3dhbGVsMzRIUHZGdmplS0U5Z2s?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3d36a0092ae0d98b","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:24:44.404082+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi8wFBVV95cUxPQjhyd2VPbmdLdS12MmxodFFkbzJLb3ozUU84Z09Ib1IwTTA3NXZoOGpWNVhrOENKZTFvVkVCaTNZamNJMWkzcEZOeTA2c1hpdXVmQjRPRkZFOGd6Wm5wWDZQdkZoelk4dS03NGZSaU9JYjdkc0FBejhKSExxeFNXdlFNUEVWQnhYeXN3ekhXWG5Ga0RQZnZvRUlySElJOWppdDZWdGZZYjJTa3lnT0txWktwSk1yQVhsNDR0U0xOelNQV3M4LUQzdXd0UkRESUJ1ZTZ6Yng0WU11dVF5REUwM3dhbGVsMzRIUHZGdmplS0U5Z2s?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/CBMi8wFBVV95cUxPQjhyd2VPbmdLdS12MmxodFFkbzJLb3ozUU84Z09Ib1IwTTA3NXZoOGpWNVhrOENKZTFvVkVCaTNZamNJMWkzcEZOeTA2c1hpdXVmQjRPRkZFOGd6Wm5wWDZQdkZoelk4dS03NGZSaU9JYjdkc0FBejhKSExxeFNXdlFNUEVWQnhYeXN3ekhXWG5Ga0RQZnZvRUlySElJOWppdDZWdGZZYjJTa3lnT0txWktwSk1yQVhsNDR0U0xOelNQV3M4LUQzdXd0UkRESUJ1ZTZ6Yng0WU11dVF5REUwM3dhbGVsMzRIUHZGdmplS0U5Z2s?oc=5","source_event_id":"evt_5f05710ccde2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9d79b304974ea90b","kind":"options_flow","published_at":"2026-04-07T20:36:20+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Royal Caribbean","relevance":"high","symbol":"","type":"company"},{"asset_class":"other","name":"Strait of Hormuz","relevance":"medium","symbol":"","type":"geopolitical_location"}],"event_type":"other","information_gaps":["Options flow direction (calls vs puts) is not stated in the provided text.","Expiry date and days to expiry are not provided.","Trade size and whether it is large relative to open interest are not provided.","No strike prices, contract counts, or notional amounts are present.","The article\u2019s claim about 'informed positioning' or rationale is not included in the provided text.","Royal Caribbean ticker symbol is not provided in the provided text."],"key_facts":["Headline indicates unusual options activity in Royal Caribbean stock and mentions Strait of Hormuz trade/profit context.","The provided 'Article Text' contains only HTML/CSS styling and does not include readable options-flow metrics or narrative details."],"numeric_claims":[],"primary_claim":"No specific options-flow data for Royal Caribbean (calls/puts, expiry, size vs open interest, or days to expiry) is present in the provided article text.","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"The provided content does not include the actual article details about Royal Caribbean options activity; it only shows generic page styling and the headline/source summary. Therefore, no grounded options-flow specifics (calls/puts, expiry, size vs open interest, or informed positioning) can be extracted.","topics":["unusual options activity","Royal Caribbean","Strait of Hormuz headlines","options flow delta"]},"source":"MSN","source_domain":"gstatic.com","summary":"Trade Strait of Hormuz headlines and profit with unusual options activity in Royal Caribbean stock MSN","tickers":[],"title":"Trade Strait of Hormuz headlines and profit with unusual options activity in Royal Caribbean stock - MSN","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 1999 in events