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-08T19:57:42.365437+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:bfa8c48593b17d63","evidence_event_ids":["evt_85b655352334"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://decrypt.co/363483/bitcoin-etfs-add-471m-in-biggest-one-day-haul-since-february","as_of":"2026-04-08T19:57:42.365437+00:00","canonical_url":"https://decrypt.co/363483/bitcoin-etfs-add-471m-in-biggest-one-day-haul-since-february","enrichment":{"aggregator_url":"https://decrypt.co/363483/bitcoin-etfs-add-471m-in-biggest-one-day-haul-since-february","article_chars":4997,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_d3f7bcbfc7c38172","canonical_host":"decrypt.co","canonical_is_aggregator":false,"canonical_url":"https://decrypt.co/363483/bitcoin-etfs-add-471m-in-biggest-one-day-haul-since-february","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:00:55.603220+00:00","extraction_method":"heuristic","fetched_description":"Bitcoin ETFs saw their biggest inflow in six weeks as crypto investors positioned ahead of Trump's Iran deadline.","fetched_title":"Bitcoin ETFs Add $471M in Biggest One-Day Haul Since February - Decrypt","final_url":"https://decrypt.co/363483/bitcoin-etfs-add-471m-in-biggest-one-day-haul-since-february","html_truncated":true,"paywall_likely":false,"publisher_domain":"decrypt.co","publisher_resolution":"canonical_url","requested_url":"https://decrypt.co/363483/bitcoin-etfs-add-471m-in-biggest-one-day-haul-since-february","source_event_id":"evt_85b655352334","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"46b8a7ed68c5801b","kind":"crypto_extremes","published_at":"2026-04-07T09:46:25+00:00","publisher_domain":"decrypt.co","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"crypto_investment_product","name":"Bitcoin ETFs","relevance":"high","symbol":"(ETFs)","type":"financial_product"},{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"cryptocurrency","name":"Ethereum","relevance":"medium","symbol":"ETH","type":"cryptocurrency"},{"asset_class":"political_figure","name":"Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"geopolitical_timeline","name":"Iran deadline","relevance":"medium","symbol":"","type":"event"}],"event_type":"listing","information_gaps":["The article text provided does not include the exact date of the $471M inflow or the specific ETF tickers/issuers.","No breakdown is provided for which Bitcoin ETFs contributed to the inflow.","The text does not specify what the 'Trump\u2019s Iran deadline' refers to (exact deadline date/event) beyond the summary.","The provided content is dominated by a broad crypto price list; it does not explicitly link the BTC price move to the ETF inflow beyond the headline/summary."],"key_facts":["Headline states Bitcoin ETFs added $471M in the biggest one-day haul since February.","Source summary states this was the biggest inflow in six weeks.","Source summary says investors positioned ahead of Trump\u2019s Iran deadline.","The cleaned article text includes a BTC price snapshot: BTC $72,058.00 (+1.37%)."],"numeric_claims":[{"label":"Bitcoin ETF inflow (one day)","value":"$471M"},{"label":"Time since last biggest one-day haul","value":"since February"},{"label":"Time since last biggest inflow","value":"six weeks"},{"label":"BTC price (snapshot)","value":"$72,058.00"},{"label":"BTC daily change (snapshot)","value":"+1.37%"}],"primary_claim":"Bitcoin ETFs added $471M in their biggest one-day haul since February.","relevance_score":0.78,"sentiment":"positive","source_quality":"high","summary":"Bitcoin ETFs recorded their biggest one-day inflow in six weeks, adding $471M, as investors positioned ahead of Trump\u2019s Iran deadline.","topics":["Bitcoin ETFs","crypto inflows","market positioning","Iran deadline","BTC price snapshot"]},"source":"Decrypt RSS","source_domain":"decrypt.co","summary":"Bitcoin ETFs saw their biggest inflow in six weeks as crypto investors positioned ahead of Trump's Iran deadline.","tickers":[],"title":"Bitcoin ETFs Add $471M in Biggest One-Day Haul Since February","url":"https://decrypt.co/363483/bitcoin-etfs-add-471m-in-biggest-one-day-haul-since-february"}}

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