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/CBMihwJBVV95cUxPWFF3Q29zX2ZRUFRfbE4tNzU3aURkQ3FNSGk3Yjg4QnA4VkJ5al9ncjF5Qy1nMHNmTmJYRXhBQWhncFloTFR2N1RMcW45SmplRTk4ZjRMbTZ5SWF2eDBMY2hYTEFIellYQlkwN0tFVm5qUkRERjlKQmRtYmNFTUlGTWVxMXpvX05Nc3NITnY5b1Fidkp5MjByNEpxbTN6UWdheXV3NTI1U0ZMeHRhNm1ndlU5MXNYaEFYbTZkUWFYdlBVWWdGY3J2Yi14SXN4RUtCblhSSVN6WkNmZ1Vvdl9SbllPaVowbi1TZTFmajM3dmdsT0k2MVljNm1fNzJHT2lnWjJ0Z2hpUQ?oc=5","as_of":"2026-04-08T08:41:30.947704+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/CBMihwJBVV95cUxPWFF3Q29zX2ZRUFRfbE4tNzU3aURkQ3FNSGk3Yjg4QnA4VkJ5al9ncjF5Qy1nMHNmTmJYRXhBQWhncFloTFR2N1RMcW45SmplRTk4ZjRMbTZ5SWF2eDBMY2hYTEFIellYQlkwN0tFVm5qUkRERjlKQmRtYmNFTUlGTWVxMXpvX05Nc3NITnY5b1Fidkp5MjByNEpxbTN6UWdheXV3NTI1U0ZMeHRhNm1ndlU5MXNYaEFYbTZkUWFYdlBVWWdGY3J2Yi14SXN4RUtCblhSSVN6WkNmZ1Vvdl9SbllPaVowbi1TZTFmajM3dmdsT0k2MVljNm1fNzJHT2lnWjJ0Z2hpUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6eef847999a5ca1b","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-08T08:41:59.931603+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwJBVV95cUxPWFF3Q29zX2ZRUFRfbE4tNzU3aURkQ3FNSGk3Yjg4QnA4VkJ5al9ncjF5Qy1nMHNmTmJYRXhBQWhncFloTFR2N1RMcW45SmplRTk4ZjRMbTZ5SWF2eDBMY2hYTEFIellYQlkwN0tFVm5qUkRERjlKQmRtYmNFTUlGTWVxMXpvX05Nc3NITnY5b1Fidkp5MjByNEpxbTN6UWdheXV3NTI1U0ZMeHRhNm1ndlU5MXNYaEFYbTZkUWFYdlBVWWdGY3J2Yi14SXN4RUtCblhSSVN6WkNmZ1Vvdl9SbllPaVowbi1TZTFmajM3dmdsT0k2MVljNm1fNzJHT2lnWjJ0Z2hpUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"barrons.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihwJBVV95cUxPWFF3Q29zX2ZRUFRfbE4tNzU3aURkQ3FNSGk3Yjg4QnA4VkJ5al9ncjF5Qy1nMHNmTmJYRXhBQWhncFloTFR2N1RMcW45SmplRTk4ZjRMbTZ5SWF2eDBMY2hYTEFIellYQlkwN0tFVm5qUkRERjlKQmRtYmNFTUlGTWVxMXpvX05Nc3NITnY5b1Fidkp5MjByNEpxbTN6UWdheXV3NTI1U0ZMeHRhNm1ndlU5MXNYaEFYbTZkUWFYdlBVWWdGY3J2Yi14SXN4RUtCblhSSVN6WkNmZ1Vvdl9SbllPaVowbi1TZTFmajM3dmdsT0k2MVljNm1fNzJHT2lnWjJ0Z2hpUQ?oc=5","source_event_id":"evt_2625ed3289f3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7100734a63f9e368","published_at":"2026-04-08T08:08:00+00:00","publisher_domain":"barrons.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.86,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"crypto","name":"Ethereum","relevance":"high","symbol":"ETH","type":"cryptocurrency"},{"asset_class":"crypto","name":"XRP","relevance":"high","symbol":"XRP","type":"cryptocurrency"},{"asset_class":"geopolitical","name":"Iran","relevance":"medium","symbol":"","type":"country"}],"event_type":"price_action","information_gaps":["No article body content was provided beyond the headline; magnitude (% change), timing, and whether the move is sustained are not specified.","\u201cIran hope\u201d is not defined in the provided text (no details on the specific development or timeframe).","No confirmation of exact prices for Ethereum or XRP is included in the provided text (only that they \u201cjumped\u201d)."],"key_facts":["Headline states Bitcoin price surged above $70,000.","Headline states Ethereum and XRP jumped.","Headline attributes the crypto rally to \u201cIran hope.\u201d"],"numeric_claims":[{"label":"Bitcoin price level","value":"above $70,000"}],"primary_claim":"Bitcoin surged above $70,000, and Ethereum and XRP rose as cryptos rallied on hope related to Iran.","relevance_score":0.78,"sentiment":"positive","source_quality":"high","summary":"Barron's reports Bitcoin has risen above $70,000, with Ethereum and XRP also jumping as crypto prices rally on \u201cIran hope.\u201d","topics":["cryptocurrency rally","Bitcoin price level breakout","Ethereum price increase","XRP price increase","Iran-related optimism"]},"source":"Barron's","source_domain":"barrons.com","source_url":"https://www.barrons.com","summary":"","tickers":[],"title":"Bitcoin Price Surges Above $70,000. Ethereum, XRP Jump as Cryptos Rally on Iran Hope. - Barron's","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_738bbd6b875e in signals