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:bfa8c48593b17d63","evidence_event_ids":["evt_4b5a48e09a86"],"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-07T23:23:54.391414+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":4958,"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-08T00:56:04.180845+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_4b5a48e09a86","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.72,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"},{"asset_class":"exchange_traded_fund","name":"Bitcoin ETFs","relevance":"high","symbol":"","type":"financial_product"},{"asset_class":"person","name":"Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"geopolitical_timeline","name":"Iran deadline","relevance":"medium","symbol":"","type":"event"}],"event_type":"price_action","information_gaps":["The exact date of the $471M inflow is not provided in the cleaned text.","The specific ETF issuers/funds included in the inflow are not listed.","The article\u2019s definition of \u201cbiggest one-day haul since February\u201d (which year and which metric) is not specified in the provided text.","\u201cTrump\u2019s Iran deadline\u201d is not dated or described further in the provided text.","No ETF flow breakdown (e.g., net vs gross, number of funds) is included in the provided text."],"key_facts":["Bitcoin ETFs saw their biggest inflow in six weeks.","Bitcoin ETFs added $471M in one day.","The $471M inflow is described as the biggest one-day haul since February.","The inflow is attributed to crypto investors positioning ahead of Trump\u2019s Iran deadline."],"numeric_claims":[{"label":"Bitcoin ETF one-day inflow","value":"$471M"},{"label":"Time since last biggest one-day haul","value":"since February"},{"label":"Biggest inflow frequency","value":"biggest in six weeks"}],"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 a $471M one-day inflow, described as the biggest haul since February. The inflow is linked to crypto investors positioning ahead of Trump\u2019s Iran deadline.","topics":["Bitcoin ETFs","inflows","crypto investor positioning","Iran deadline","Trump"]},"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 2729 in events