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-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:1d9cd5948acce5c4","evidence_event_ids":["evt_88b1ccddc82a"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://decrypt.co/363336/charles-schwab-bitcoin-ethereum-spot-trading","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://decrypt.co/363336/charles-schwab-bitcoin-ethereum-spot-trading","enrichment":{"aggregator_url":"https://decrypt.co/363336/charles-schwab-bitcoin-ethereum-spot-trading","article_chars":4950,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_78bd774181c54899","canonical_host":"decrypt.co","canonical_is_aggregator":false,"canonical_url":"https://decrypt.co/363336/charles-schwab-bitcoin-ethereum-spot-trading","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T01:00:01.054080+00:00","extraction_method":"heuristic","fetched_description":"Financial giant Charles Schwab is set to launch spot buying of Bitcoin and Ethereum by the end of the quarter, the firm said Friday.","fetched_title":"Charles Schwab Is Gearing Up to Offer Bitcoin, Ethereum Spot Trading - Decrypt","final_url":"https://decrypt.co/363336/charles-schwab-bitcoin-ethereum-spot-trading","html_truncated":true,"paywall_likely":false,"publisher_domain":"decrypt.co","publisher_resolution":"canonical_url","requested_url":"https://decrypt.co/363336/charles-schwab-bitcoin-ethereum-spot-trading","source_event_id":"evt_88b1ccddc82a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a496dd59cfa92087","kind":"crypto_extremes","published_at":"2026-04-03T21:11:55+00:00","publisher_domain":"decrypt.co","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["Friday"],"entities":[{"asset_class":"equity","name":"Charles Schwab","relevance":"high","symbol":"","type":"company"},{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"crypto","name":"Ethereum","relevance":"high","symbol":"ETH","type":"cryptocurrency"}],"event_type":"listing","information_gaps":["The cleaned text does not include the exact Schwab quote or additional implementation details (e.g., custody model, eligibility, fees, exchange/venue, or whether it is for retail vs. institutional clients).","The article text provided does not specify which quarter (e.g., Q1/Q2) or the exact end date.","The provided crypto price table is not explicitly tied to the announcement in the supplied text."],"key_facts":["The article states Charles Schwab is gearing up to offer spot buying/trading of Bitcoin and Ethereum.","The stated timing is \u201cby the end of the quarter.\u201d","The provided text includes a crypto price table showing BTC and ETH prices and percentage changes, but it does not link those prices to the Schwab announcement."],"numeric_claims":[],"primary_claim":"Charles Schwab plans to launch spot buying/trading of Bitcoin and Ethereum by the end of the quarter.","relevance_score":0.78,"sentiment":"positive","source_quality":"high","summary":"Charles Schwab said it is preparing to offer spot trading for Bitcoin and Ethereum, with launch expected by the end of the quarter.","topics":["Charles Schwab","spot crypto trading","Bitcoin","Ethereum","end of quarter launch"]},"source":"Decrypt RSS","source_domain":"decrypt.co","summary":"Financial giant Charles Schwab is set to launch spot buying of Bitcoin and Ethereum by the end of the quarter, the firm said Friday.","tickers":[],"title":"Charles Schwab Is Gearing Up to Offer Bitcoin, Ethereum Spot Trading","url":"https://decrypt.co/363336/charles-schwab-bitcoin-ethereum-spot-trading"}}

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