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/CBMikAFBVV95cUxPZC1ucjI0cXFtVEZkTXJyZnhRWXRlaUZTTVY1ODdJclh0V3o3SkxnMHpqVG5zcUZmcHE5MU9UOTVzMERTdW5xUmJGZEhtaHVNUm9Dd1JaMGJVeGozREpRWm1oSVBITVVsMWdrTGlibFV1V1B2VGYyNlBhX0V3Zlp5X2lWaWdHRWxCR2pEY3E4bTQ?oc=5","as_of":"2026-04-10T18:51:17.968267+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/CBMikAFBVV95cUxPZC1ucjI0cXFtVEZkTXJyZnhRWXRlaUZTTVY1ODdJclh0V3o3SkxnMHpqVG5zcUZmcHE5MU9UOTVzMERTdW5xUmJGZEhtaHVNUm9Dd1JaMGJVeGozREpRWm1oSVBITVVsMWdrTGlibFV1V1B2VGYyNlBhX0V3Zlp5X2lWaWdHRWxCR2pEY3E4bTQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_57c55da63fb317ba","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-10T19:20:30.196163+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxPZC1ucjI0cXFtVEZkTXJyZnhRWXRlaUZTTVY1ODdJclh0V3o3SkxnMHpqVG5zcUZmcHE5MU9UOTVzMERTdW5xUmJGZEhtaHVNUm9Dd1JaMGJVeGozREpRWm1oSVBITVVsMWdrTGlibFV1V1B2VGYyNlBhX0V3Zlp5X2lWaWdHRWxCR2pEY3E4bTQ?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/CBMikAFBVV95cUxPZC1ucjI0cXFtVEZkTXJyZnhRWXRlaUZTTVY1ODdJclh0V3o3SkxnMHpqVG5zcUZmcHE5MU9UOTVzMERTdW5xUmJGZEhtaHVNUm9Dd1JaMGJVeGozREpRWm1oSVBITVVsMWdrTGlibFV1V1B2VGYyNlBhX0V3Zlp5X2lWaWdHRWxCR2pEY3E4bTQ?oc=5","source_event_id":"evt_b5b470a24a8f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c34461f606e86147","kind":"options_flow","published_at":"2026-04-10T15:11:02+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":["2026"],"entities":[{"asset_class":"equity","name":"USA Rare Earth Inc","relevance":"high","symbol":"","type":"company"},{"asset_class":"warrant","name":"USA Rare Earth Inc Equity Warrant","relevance":"high","symbol":"","type":"derivative"}],"event_type":"other","information_gaps":["Options flow direction (calls vs puts) is not present in the provided text.","Expiry date or contract month is not present.","Days to expiry (DTE) is not present.","Trade size and whether it is large relative to open interest is not present.","Whether the flow suggests informed positioning is not determinable without the above metrics and/or additional context (e.g., unusual activity flags).","The exact ticker/symbol for the \u201cequity warrant\u201d is not provided in the supplied text."],"key_facts":["Headline mentions \u201cUSA Rare Earth Inc Equity Warrant\u201d and \u201c2026 Top Gainers & Safe Entry Trade Signal Reports.\u201d","The supplied \u201cArticle Text\u201d is dominated by HTML/CSS styling and does not contain readable options-flow data fields.","No call/put direction, expiry date, days-to-expiry, or size relative to open interest is extractable from the provided text."],"numeric_claims":[],"primary_claim":"No grounded options-flow delta details (direction, expiry, size vs open interest, or DTE) are present in the supplied article text; it appears to be mostly HTML/CSS boilerplate.","relevance_score":0.15,"sentiment":"neutral","source_quality":"high","summary":"The provided signal contains only generic/boilerplate page content and does not include any actual options-flow metrics (calls/puts, expiry, size vs open interest, or days to expiry). The only actionable text is the headline referencing USA Rare Earth Inc equity warrant and a 2026 timeframe.","topics":["options flow","equity warrant","turnaround story","2026 top gainers","trade signal"]},"source":"baoquankhu1.vn","source_domain":"gstatic.com","summary":"Options Flow: Is USA Rare Earth Inc Equity Warrant a turnaround story - 2026 Top Gainers & Safe Entry Trade Signal Reports baoquankhu1.vn","tickers":[],"title":"Options Flow: Is USA Rare Earth Inc Equity Warrant a turnaround story - 2026 Top Gainers & Safe Entry Trade Signal Reports - 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_90a044b34957 in signals