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-03T12:37:56.088827+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:a098bf6ad32295f9","evidence_event_ids":["evt_2fcbbe8e22d9"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.ainvest.com/news/bitcoin-flow-war-1-32b-etf-inflows-299m-liquidations-2604/","as_of":"2026-04-03T12:37:56.088827+00:00","canonical_url":"https://www.ainvest.com/news/bitcoin-flow-war-1-32b-etf-inflows-299m-liquidations-2604/","enrichment":{"aggregator_url":"https://www.ainvest.com/news/bitcoin-flow-war-1-32b-etf-inflows-299m-liquidations-2604/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0b3b7e55a9033e78","canonical_host":"ainvest.com","canonical_is_aggregator":false,"canonical_url":"https://www.ainvest.com/news/bitcoin-flow-war-1-32b-etf-inflows-299m-liquidations-2604/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T00:56:09.613007+00:00","extraction_method":"heuristic","fetched_description":"Bitcoin's Flow War: $1.32B ETF Inflows vs. $299M Liquidations","fetched_title":"Bitcoin's Flow War: $1.32B ETF Inflows vs. $299M Liquidations","final_url":"https://www.ainvest.com/news/bitcoin-flow-war-1-32b-etf-inflows-299m-liquidations-2604/","html_truncated":false,"paywall_likely":false,"publisher_domain":"ainvest.com","publisher_resolution":"canonical_url","requested_url":"https://www.ainvest.com/news/bitcoin-flow-war-1-32b-etf-inflows-299m-liquidations-2604/","source_event_id":"evt_2fcbbe8e22d9","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"cbf5456faf60dd9d","published_at":"","publisher_domain":"ainvest.com","query":"bitcoin ETF flows exchange reserves derivatives funding update","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["March 2025","October 2025","2023"],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"funds","name":"US spot Bitcoin ETFs","relevance":"high","symbol":"","type":"financial instrument"}],"event_type":"research","information_gaps":["No specific date for the $1.32 billion inflow","Details on the nature of geopolitical risks","Clarification on the impact of ETF inflows on price movement"],"key_facts":["$1.32 billion in March ETF inflows","$299 million in daily liquidations","30% of long-term Bitcoin holders are at a loss","$500 million in net outflows for Q1","$23.1 billion in daily trading volume"],"numeric_claims":[{"label":"March ETF inflows","value":"$1.32 billion"},{"label":"Daily liquidations","value":"$299 million"},{"label":"Q1 net outflows","value":"$500 million"},{"label":"Daily trading volume","value":"$23.1 billion"}],"primary_claim":"$1.32 billion in March inflows into US spot Bitcoin ETFs is the first monthly gain since October 2025.","relevance_score":0.85,"sentiment":"mixed","source_quality":"high","summary":"In March, US spot Bitcoin ETFs saw inflows of $1.32 billion, marking the first monthly gain since October 2025, despite ongoing selling pressure from long-term holders, with over 30% facing losses since 2023.","topics":["Bitcoin","ETFs","market analysis","institutional investment"]},"snippet":"On one side, a massive $1.32 billion in March inflows into US spot BitcoinBTC+0.60% ETFs marked the category's first monthly gain since October 2025. On the ...","source":"web_search","source_domain":"ainvest.com","summary":"On one side, a massive $1.32 billion in March inflows into US spot BitcoinBTC+0.60% ETFs marked the category's first monthly gain since October 2025. On the ...","title":"Bitcoin's Flow War: $1.32B ETF Inflows vs. $299M ...","url":"https://www.ainvest.com/news/bitcoin-flow-war-1-32b-etf-inflows-299m-liquidations-2604/"}}

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