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/CBMi2gFBVV95cUxPWnpZX0gwdnNtRjdzcW5DVDJ4dFZDeC1vSW1PWEV1VnJmSVM4SEtBWGhhYkdlMzFZZGk3VWt2R2M1d19MMGo1d1JqYVBYT0NyeDUyNUJhUzBid0loWWtKLXl6d1o0X0Q5aWZUNVFvZHNrVnFDVjBZcnN6RGgxMmlMcnFRYjRkQnRBdjY5Y2NRbWd4ZWxaNGdsdWtXeUxBcjE5TjQwRjROR1RWakRhcnJHNXphUWh4ejZZUEhraVZ3MDFfOFk0NVUyRHlmNG5od3d6WTN1dnFMeEE0QQ?oc=5","as_of":"2026-04-08T05:30:32.359517+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/CBMi2gFBVV95cUxPWnpZX0gwdnNtRjdzcW5DVDJ4dFZDeC1vSW1PWEV1VnJmSVM4SEtBWGhhYkdlMzFZZGk3VWt2R2M1d19MMGo1d1JqYVBYT0NyeDUyNUJhUzBid0loWWtKLXl6d1o0X0Q5aWZUNVFvZHNrVnFDVjBZcnN6RGgxMmlMcnFRYjRkQnRBdjY5Y2NRbWd4ZWxaNGdsdWtXeUxBcjE5TjQwRjROR1RWakRhcnJHNXphUWh4ejZZUEhraVZ3MDFfOFk0NVUyRHlmNG5od3d6WTN1dnFMeEE0QQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9e3684466b6a0244","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-08T05:31:07.789993+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi2gFBVV95cUxPWnpZX0gwdnNtRjdzcW5DVDJ4dFZDeC1vSW1PWEV1VnJmSVM4SEtBWGhhYkdlMzFZZGk3VWt2R2M1d19MMGo1d1JqYVBYT0NyeDUyNUJhUzBid0loWWtKLXl6d1o0X0Q5aWZUNVFvZHNrVnFDVjBZcnN6RGgxMmlMcnFRYjRkQnRBdjY5Y2NRbWd4ZWxaNGdsdWtXeUxBcjE5TjQwRjROR1RWakRhcnJHNXphUWh4ejZZUEhraVZ3MDFfOFk0NVUyRHlmNG5od3d6WTN1dnFMeEE0QQ?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/CBMi2gFBVV95cUxPWnpZX0gwdnNtRjdzcW5DVDJ4dFZDeC1vSW1PWEV1VnJmSVM4SEtBWGhhYkdlMzFZZGk3VWt2R2M1d19MMGo1d1JqYVBYT0NyeDUyNUJhUzBid0loWWtKLXl6d1o0X0Q5aWZUNVFvZHNrVnFDVjBZcnN6RGgxMmlMcnFRYjRkQnRBdjY5Y2NRbWd4ZWxaNGdsdWtXeUxBcjE5TjQwRjROR1RWakRhcnJHNXphUWh4ejZZUEhraVZ3MDFfOFk0NVUyRHlmNG5od3d6WTN1dnFMeEE0QQ?oc=5","source_event_id":"evt_c7c3d21fdc8b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4499ffed9babf212","kind":"options_flow","published_at":"2026-04-03T17:30:02+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Royal Caribbean","relevance":"high","symbol":"","type":"company"},{"asset_class":"media","name":"Barchart","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["Options flow direction (calls vs puts) is not stated in the provided text.","Expiry/days-to-expiry is not stated in the provided text.","Trade size and whether it is large relative to open interest is not stated in the provided text.","Whether the activity suggests informed positioning is not stated in the provided text.","Ticker symbol for Royal Caribbean is not provided in the provided text.","Any specific strike prices, contract counts, premium, or volume/open-interest ratios are not provided in the provided text."],"key_facts":["Headline indicates unusual options activity in Royal Caribbean stock and references Strait of Hormuz headlines (from provided headline/source summary only).","The provided 'Article Text' is largely HTML/CSS boilerplate and does not contain readable options-flow metrics or trade details."],"numeric_claims":[],"primary_claim":"No grounded options-flow facts (calls/puts, expiry, size vs open interest, or informed positioning) are present in the provided article text.","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"The provided content does not include the actual Barchart article details about Royal Caribbean options flow. It only contains page styling/HTML boilerplate and the generic headline/source summary mentioning unusual options activity.","topics":["unusual options activity","Royal Caribbean","Strait of Hormuz headlines","options flow delta"]},"source":"Barchart","source_domain":"gstatic.com","summary":"Trade Strait of Hormuz Headlines and Profit with Unusual Options Activity in Royal Caribbean Stock Barchart","tickers":[],"title":"Trade Strait of Hormuz Headlines and Profit with Unusual Options Activity in Royal Caribbean Stock - Barchart","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_bfb8e9c2d7a1 in signals