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-08T03:15:53.567262+00:00","dedupe_key":"signal_enriched:market_headline_delta:e378a4c1872f7193","evidence_event_ids":["evt_e5e940e87a65"],"signal_type":"market_headline_delta","source":"market_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi2gFBVV95cUxNQmxxcU9NTUQwQWhHV2hnVTBOekliMk44WDF4b0ctX0lvemhhTVhuQXZYVHpkQmpCN2VhQms2Wmxxc1F5T1BfUnpaY3dSLWg3QjhSd2tCWlpSX203QWhqbldIVXBKZmpuMWNKZGJWcEV1QUZKN19aTjVxUWRyd2FEMGo1Y29vR0lFNldlY2dBMzR1MmVfTUQ0QnJKa2hxMDItV3pXMVA4STVIcFRlYWNqYlBSeGFmUXktSFUtZjhsazRsVnlnOVJaMDdpakNkSmF2anBhLWk5SjBFZw?oc=5","as_of":"2026-04-08T03:15:53.567262+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMi2gFBVV95cUxNQmxxcU9NTUQwQWhHV2hnVTBOekliMk44WDF4b0ctX0lvemhhTVhuQXZYVHpkQmpCN2VhQms2Wmxxc1F5T1BfUnpaY3dSLWg3QjhSd2tCWlpSX203QWhqbldIVXBKZmpuMWNKZGJWcEV1QUZKN19aTjVxUWRyd2FEMGo1Y29vR0lFNldlY2dBMzR1MmVfTUQ0QnJKa2hxMDItV3pXMVA4STVIcFRlYWNqYlBSeGFmUXktSFUtZjhsazRsVnlnOVJaMDdpakNkSmF2anBhLWk5SjBFZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_316e3d85dd13d6b8","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T03:52:27.146169+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi2gFBVV95cUxNQmxxcU9NTUQwQWhHV2hnVTBOekliMk44WDF4b0ctX0lvemhhTVhuQXZYVHpkQmpCN2VhQms2Wmxxc1F5T1BfUnpaY3dSLWg3QjhSd2tCWlpSX203QWhqbldIVXBKZmpuMWNKZGJWcEV1QUZKN19aTjVxUWRyd2FEMGo1Y29vR0lFNldlY2dBMzR1MmVfTUQ0QnJKa2hxMDItV3pXMVA4STVIcFRlYWNqYlBSeGFmUXktSFUtZjhsazRsVnlnOVJaMDdpakNkSmF2anBhLWk5SjBFZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"stocktwits.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi2gFBVV95cUxNQmxxcU9NTUQwQWhHV2hnVTBOekliMk44WDF4b0ctX0lvemhhTVhuQXZYVHpkQmpCN2VhQms2Wmxxc1F5T1BfUnpaY3dSLWg3QjhSd2tCWlpSX203QWhqbldIVXBKZmpuMWNKZGJWcEV1QUZKN19aTjVxUWRyd2FEMGo1Y29vR0lFNldlY2dBMzR1MmVfTUQ0QnJKa2hxMDItV3pXMVA4STVIcFRlYWNqYlBSeGFmUXktSFUtZjhsazRsVnlnOVJaMDdpakNkSmF2anBhLWk5SjBFZw?oc=5","source_event_id":"evt_e5e940e87a65","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"938f7b4d18bc5e4d","published_at":"2026-04-08T00:28:57+00:00","publisher_domain":"stocktwits.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":["March"],"entities":[{"asset_class":"equity","name":"CleanSpark","relevance":"high","symbol":"CLSK","type":"company"},{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"}],"event_type":"price_action","information_gaps":["The provided article text is not available (only page styling/HTML is present), so the underlying details supporting the headline cannot be verified here.","No information is provided on the exact sale date(s), total number of BTC sold, total proceeds, or whether the $71,000 figure is an average, spot price at sale, or another metric.","No confirmation is provided that the headline reflects an official filing versus a secondary post on Stocktwits."],"key_facts":["CleanSpark sold 70% of the Bitcoin it mined in March.","The sale price was over $71,000 per Bitcoin (as stated in the headline)."],"numeric_claims":[{"label":"Percent of mined Bitcoin sold (March)","value":"70%"},{"label":"Sale price per Bitcoin","value":"> $71,000"}],"primary_claim":"CleanSpark sold 70% of the Bitcoin it mined in March for over $71,000 apiece.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"The headline claims CleanSpark sold 70% of the Bitcoin it mined in March, with proceeds priced at over $71,000 per Bitcoin.","topics":["crypto mining","Bitcoin sales","CleanSpark","market-moving disclosure"]},"source":"Stocktwits","source_domain":"stocktwits.com","source_url":"https://stocktwits.com","summary":"","tickers":[],"title":"CleanSpark Sold 70% Of The Bitcoin It Mined In March For Over $71,000 Apiece - Stocktwits","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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 4368 in events