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-09T15:51:36.234111+00:00","dedupe_key":"signal_enriched:market_headline_delta:aa56a6074d15cca8","evidence_event_ids":["evt_3f23289a4c80"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxPNXdEZHI1UFNJV1lDejlxOUVLb1F5czZ4bUZoeGFNSFE5cjdkNTFqUjVUc21tRlJlZkFic0tVbVQwamVPUEdMT1Jya0RYVzR5clNac3ExdDZ6S0d2VXRUcWY2VXB6WXRqaTU1eWNPdjNsbXJ6Rm1xaEdrOVdfbnU5S3phR2hxQVRuWFRjclkzMlkycTlPUEE?oc=5","as_of":"2026-04-09T15:51:36.234111+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/CBMilgFBVV95cUxPNXdEZHI1UFNJV1lDejlxOUVLb1F5czZ4bUZoeGFNSFE5cjdkNTFqUjVUc21tRlJlZkFic0tVbVQwamVPUEdMT1Jya0RYVzR5clNac3ExdDZ6S0d2VXRUcWY2VXB6WXRqaTU1eWNPdjNsbXJ6Rm1xaEdrOVdfbnU5S3phR2hxQVRuWFRjclkzMlkycTlPUEE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_101a8623cc04c0ce","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-09T23:41:07.155215+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxPNXdEZHI1UFNJV1lDejlxOUVLb1F5czZ4bUZoeGFNSFE5cjdkNTFqUjVUc21tRlJlZkFic0tVbVQwamVPUEdMT1Jya0RYVzR5clNac3ExdDZ6S0d2VXRUcWY2VXB6WXRqaTU1eWNPdjNsbXJ6Rm1xaEdrOVdfbnU5S3phR2hxQVRuWFRjclkzMlkycTlPUEE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"marketbeat.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxPNXdEZHI1UFNJV1lDejlxOUVLb1F5czZ4bUZoeGFNSFE5cjdkNTFqUjVUc21tRlJlZkFic0tVbVQwamVPUEdMT1Jya0RYVzR5clNac3ExdDZ6S0d2VXRUcWY2VXB6WXRqaTU1eWNPdjNsbXJ6Rm1xaEdrOVdfbnU5S3phR2hxQVRuWFRjclkzMlkycTlPUEE?oc=5","source_event_id":"evt_3f23289a4c80","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bd93043768044afb","published_at":"2026-04-09T15:09:57+00:00","publisher_domain":"marketbeat.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptoasset"}],"event_type":"price_action","information_gaps":["No article body content was provided (the cleaned text appears to be page styling/boilerplate), so the $330M figure\u2019s source, timeframe, and whether it refers to inflows, purchases, or another metric are not verifiable from the provided text.","No additional tickers, companies, exchanges, or counterparties are mentioned in the provided content.","No explicit market direction (e.g., price up/down) or timeframe is stated beyond the headline framing."],"key_facts":["Headline states \u201c$330M Bitcoin Binge.\u201d","Headline states \u201cWhen Others Pause, Strategy Pounces,\u201d implying others are pausing while a strategy is buying/acting."],"numeric_claims":[{"label":"Bitcoin binge amount","value":"$330M"}],"primary_claim":"There was a $330M Bitcoin buying (\u201cbinge\u201d), described as a strategy that takes advantage when others pause.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"MarketBeat headline claims a $330M Bitcoin buying activity (\u201cbinge\u201d) and frames it as a strategy that acts when others pause, implying bullish momentum/continuation.","topics":["Bitcoin","crypto trading flows","market strategy","buying activity","momentum framing"]},"source":"MarketBeat","source_domain":"marketbeat.com","source_url":"https://www.marketbeat.com","summary":"","tickers":[],"title":"$330M Bitcoin Binge: When Others Pause, Strategy Pounces - MarketBeat","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 10334 in events