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/CBMinAFBVV95cUxPbDYyUDJQa19tcDVmMFViR3hNSXFXc01RVm1HSWpCTm44Z1lPc0poM0V3dmFQSHNlX3FITFUxLVFOajY5LVZuZHNkM0tLWEJJdTFsYWtUanpxZVNzalBPY1JUWkpJb2FOZWhfV1ZXSHhxZGNUUklVRVBlT0NqZHVJS2dtYWlmZkxkM3BNY0RlcUtyOFBWSzFFTVp4YjY?oc=5","as_of":"2026-04-13T13:18:39.050419+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxPbDYyUDJQa19tcDVmMFViR3hNSXFXc01RVm1HSWpCTm44Z1lPc0poM0V3dmFQSHNlX3FITFUxLVFOajY5LVZuZHNkM0tLWEJJdTFsYWtUanpxZVNzalBPY1JUWkpJb2FOZWhfV1ZXSHhxZGNUUklVRVBlT0NqZHVJS2dtYWlmZkxkM3BNY0RlcUtyOFBWSzFFTVp4YjY?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_a8d4bb9172583e3a","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-13T16:19:54.847056+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxPbDYyUDJQa19tcDVmMFViR3hNSXFXc01RVm1HSWpCTm44Z1lPc0poM0V3dmFQSHNlX3FITFUxLVFOajY5LVZuZHNkM0tLWEJJdTFsYWtUanpxZVNzalBPY1JUWkpJb2FOZWhfV1ZXSHhxZGNUUklVRVBlT0NqZHVJS2dtYWlmZkxkM3BNY0RlcUtyOFBWSzFFTVp4YjY?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxPbDYyUDJQa19tcDVmMFViR3hNSXFXc01RVm1HSWpCTm44Z1lPc0poM0V3dmFQSHNlX3FITFUxLVFOajY5LVZuZHNkM0tLWEJJdTFsYWtUanpxZVNzalBPY1JUWkpJb2FOZWhfV1ZXSHhxZGNUUklVRVBlT0NqZHVJS2dtYWlmZkxkM3BNY0RlcUtyOFBWSzFFTVp4YjY?oc=5","source_event_id":"evt_84d84a1a9bdc","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"d49078cd78f1e555","published_at":"2026-04-13T12:58:00+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"}],"event_type":"price_action","information_gaps":["The name of the strategy/company is not provided.","The timing/date of the purchase is not provided.","Whether the purchase has been completed or is planned is not provided.","No details on the preferred stock terms (issuer, conversion, maturity) are provided.","No article text or additional context is available to confirm or quantify the claim beyond the headline."],"key_facts":["Headline mentions a strategy buying $1 billion of Bitcoin.","Headline specifies the purchase is made using preferred stock.","No additional details (company/strategy name, timing, or execution) are provided in the supplied text."],"numeric_claims":[{"label":"Bitcoin purchase amount","value":"$1 billion"}],"primary_claim":"A strategy is buying $1 billion of Bitcoin using preferred stock.","relevance_score":0.62,"sentiment":"neutral","source_quality":"unknown","summary":"The Yahoo Finance headline states that a strategy is buying $1 billion of Bitcoin using preferred stock.","topics":["Bitcoin","preferred stock","strategy investment","capital allocation"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"","tickers":[],"title":"Strategy Buys $1 Billion Of Bitcoin Using Preferred Stock - Yahoo Finance","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_57acf44785dc in signals