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-04T12:39:58.928875+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:9fc7d81d8c08df63","evidence_event_ids":["evt_442a2ab99b08"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://phemex.com/news/article/bitcoin-etfs-attract-226m-in-net-inflows-in-just-four-days-70886","as_of":"2026-04-04T12:39:58.928875+00:00","canonical_url":"https://phemex.com/news/article/bitcoin-etfs-attract-226m-in-net-inflows-in-just-four-days-70886","enrichment":{"aggregator_url":"https://phemex.com/news/article/bitcoin-etfs-attract-226m-in-net-inflows-in-just-four-days-70886","article_chars":352,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4990857eff3fa17f","canonical_host":"phemex.com","canonical_is_aggregator":false,"canonical_url":"https://phemex.com/news/article/bitcoin-etfs-attract-226m-in-net-inflows-in-just-four-days-70886","content_type":"text/html","enriched_at":"2026-04-04T12:41:31.314641+00:00","extraction_method":"heuristic","fetched_description":"Bitcoin ETFs attract $22.6M in net inflows within four days, signaling strong investor interest in regulated crypto investment products.","fetched_title":"Bitcoin ETFs Garner $22.6M in First Four Days | Phemex News","final_url":"https://phemex.com/news/article/bitcoin-etfs-attract-226m-in-net-inflows-in-just-four-days-70886","html_truncated":false,"paywall_likely":false,"publisher_domain":"phemex.com","publisher_resolution":"canonical_url","requested_url":"https://phemex.com/news/article/bitcoin-etfs-attract-226m-in-net-inflows-in-just-four-days-70886","source_event_id":"evt_442a2ab99b08","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"c4df0cde745f08dc","published_at":"","publisher_domain":"phemex.com","query":"bitcoin ETF flows exchange reserves derivatives funding update","signal_understanding":{"analysis_basis":"article","claim_confidence":0.5,"dates_mentioned":[],"entities":[{"asset_class":"crypto_etf","name":"Bitcoin ETFs","relevance":"high","symbol":"BTC","type":"asset_class"}],"event_type":"listing","information_gaps":["Which specific Bitcoin ETF(s) are included in the $22.6M figure is not stated.","The exact trading start date/timeframe for the \u201cfirst four days of trading\u201d is not provided.","Whether the $22.6M is net of redemptions and fees is not explicitly defined in the text.","No breakdown by fund, issuer, or daily inflow amounts is provided.","The article does not provide supporting data sources or methodology for the inflow calculation."],"key_facts":["Bitcoin ETFs recorded net inflows of $22.6 million in their first four days of trading."],"numeric_claims":[{"label":"Net inflows (first four days)","value":"$22.6 million"}],"primary_claim":"Bitcoin exchange-traded funds (ETFs) had $22.6 million in net inflows in their first four days of trading.","relevance_score":0.55,"sentiment":"positive","source_quality":"low","summary":"Bitcoin ETFs recorded $22.6 million in net inflows during their first four days of trading, indicating strong early investor demand for the newly launched regulated products.","topics":["Bitcoin","ETFs","net inflows","regulated crypto investment products","early trading demand"]},"snippet":"Bitcoin ETFs attract $22.6M in net inflows within four days, signaling strong investor interest in regulated crypto investment products.","source":"web_search","source_domain":"phemex.com","summary":"Bitcoin ETFs attract $22.6M in net inflows within four days, signaling strong investor interest in regulated crypto investment products.","title":"Bitcoin ETFs Attract $22.6M in Net Inflows in Just Four Days - Phemex","url":"https://phemex.com/news/article/bitcoin-etfs-attract-226m-in-net-inflows-in-just-four-days-70886"}}

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