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-08T19:57:42.365437+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:2c6b7c57ad76834f","evidence_event_ids":["evt_6b5d1c3b90ef"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxQMnhnR3JDSGxFTVdJT19xWXNmcnh3ZVVwaDF1SXpVakx2c21kSEVnYXZIZ1FBLTItSlR1QmJidmlSVnEwOFNsOWtkVXhRbS1icy0zS2xGSG8ycnE3endWVU85LUNoOFN0YXU3QVliOHd5ZThZLXgycS1UX1dYYl9odGVDelN1bnFQU0wxVEQtdWpSdXBCLU93bGFpZ3p6MEU1MFJqXzRYNG5pcGR0S0xyWlkxeTM?oc=5","as_of":"2026-04-08T19:57:42.365437+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/CBMitAFBVV95cUxQMnhnR3JDSGxFTVdJT19xWXNmcnh3ZVVwaDF1SXpVakx2c21kSEVnYXZIZ1FBLTItSlR1QmJidmlSVnEwOFNsOWtkVXhRbS1icy0zS2xGSG8ycnE3endWVU85LUNoOFN0YXU3QVliOHd5ZThZLXgycS1UX1dYYl9odGVDelN1bnFQU0wxVEQtdWpSdXBCLU93bGFpZ3p6MEU1MFJqXzRYNG5pcGR0S0xyWlkxeTM?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_784ee4bf52d71a53","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-09T22:33:17.452588+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMitAFBVV95cUxQMnhnR3JDSGxFTVdJT19xWXNmcnh3ZVVwaDF1SXpVakx2c21kSEVnYXZIZ1FBLTItSlR1QmJidmlSVnEwOFNsOWtkVXhRbS1icy0zS2xGSG8ycnE3endWVU85LUNoOFN0YXU3QVliOHd5ZThZLXgycS1UX1dYYl9odGVDelN1bnFQU0wxVEQtdWpSdXBCLU93bGFpZ3p6MEU1MFJqXzRYNG5pcGR0S0xyWlkxeTM?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/CBMitAFBVV95cUxQMnhnR3JDSGxFTVdJT19xWXNmcnh3ZVVwaDF1SXpVakx2c21kSEVnYXZIZ1FBLTItSlR1QmJidmlSVnEwOFNsOWtkVXhRbS1icy0zS2xGSG8ycnE3endWVU85LUNoOFN0YXU3QVliOHd5ZThZLXgycS1UX1dYYl9odGVDelN1bnFQU0wxVEQtdWpSdXBCLU93bGFpZ3p6MEU1MFJqXzRYNG5pcGR0S0xyWlkxeTM?oc=5","source_event_id":"evt_6b5d1c3b90ef","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0f7b28449a446034","kind":"unusual_volume","published_at":"2026-04-06T17:00:00+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.55,"dates_mentioned":["Monday"],"entities":[],"event_type":"price_action","information_gaps":["Which specific ticker(s) had unusual volume is not provided.","The volume ratio vs average (and whether it is above/below baseline) is not provided.","Whether the unusual volume is confirmed by any news/event is not provided.","The direction of volume change (increase/decrease) is not provided.","The most likely catalyst hypothesis cannot be inferred from the provided text."],"key_facts":["The headline states that on Monday there are stocks with unusual volume.","The source is chartmill.com.","No ticker symbols are mentioned in the provided text.","No volume ratio versus average is mentioned in the provided text.","No catalyst or confirmation by news is mentioned in the provided text."],"numeric_claims":[],"primary_claim":"The article claims that on Monday there are stocks with unusual volume and suggests viewing them on chartmill.com.","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"The source is a generic statement that, on Monday, some stocks showed unusual trading volume and the reader should review them on Chartmill. No specific ticker, volume ratio, or catalyst is provided in the provided text.","topics":["unusual trading volume","stock screening","Chartmill"]},"source":"chartmill.com","source_domain":"gstatic.com","summary":"On Monday, there are stocks with unusual volume. Let's take a look. chartmill.com","tickers":[],"title":"On Monday, there are stocks with unusual volume. Let's take a look. - chartmill.com","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

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 8826 in events