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-03T11:42:42.284122+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:eb291614562bc877","evidence_event_ids":["evt_406bbe9f37a6"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.ainvest.com/news/bitcoin-price-action-etf-flows-futures-open-interest-real-story-2604/","as_of":"2026-04-03T11:42:42.284122+00:00","canonical_url":"https://www.ainvest.com/news/bitcoin-price-action-etf-flows-futures-open-interest-real-story-2604/","enrichment":{"aggregator_url":"https://www.ainvest.com/news/bitcoin-price-action-etf-flows-futures-open-interest-real-story-2604/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_36704b52d34889a3","canonical_host":"ainvest.com","canonical_is_aggregator":false,"canonical_url":"https://www.ainvest.com/news/bitcoin-price-action-etf-flows-futures-open-interest-real-story-2604/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T00:41:32.618646+00:00","extraction_method":"heuristic","fetched_description":"Bitcoin's Price Action: ETF Flows and Futures Open Interest Tell the Real Story","fetched_title":"Bitcoin's Price Action: ETF Flows and Futures Open Interest Tell the Real Story","final_url":"https://www.ainvest.com/news/bitcoin-price-action-etf-flows-futures-open-interest-real-story-2604/","html_truncated":false,"paywall_likely":false,"publisher_domain":"ainvest.com","publisher_resolution":"canonical_url","requested_url":"https://www.ainvest.com/news/bitcoin-price-action-etf-flows-futures-open-interest-real-story-2604/","source_event_id":"evt_406bbe9f37a6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"93702bfef8abd8ae","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 2026","October 2025","Q1 2026"],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptocurrency"},{"asset_class":"financial","name":"U.S. Dollar Index","relevance":"medium","symbol":"","type":"index"},{"asset_class":"derivatives","name":"CME Bitcoin Futures","relevance":"high","symbol":"CME","type":"futures"}],"event_type":"research","information_gaps":["Uncertainty about the durability of the March inflow and its impact on future price movements.","Lack of specific data on the potential effects of macroeconomic volatility on Bitcoin's price."],"key_facts":["Bitcoin trades near $68,510, down 19.5% yearly.","March 2026 ETF inflows were $1.32 billion, reversing four months of outflows.","CME Bitcoin futures open interest stabilizes with net long positions."],"numeric_claims":[{"label":"March ETF inflows","value":"$1.32 billion"},{"label":"Average investor cost basis","value":"$84,000"},{"label":"Current Bitcoin price","value":"$68,510"}],"primary_claim":"U.S. spot Bitcoin ETFs experienced $1.32 billion in inflows in March 2026, their first monthly gain since October 2025.","relevance_score":0.8,"sentiment":"mixed","source_quality":"high","summary":"Bitcoin's price is currently around $68,510, with March ETF inflows of $1.32 billion marking the first monthly gain since October 2025, despite ongoing macroeconomic pressures.","topics":["Bitcoin","ETF inflows","futures open interest","market dynamics"]},"snippet":"The primary money flows show a tentative but fragile reversal. U.S. spot Bitcoin ETFs posted $1.32 billion in March inflows, their first monthly gain since ...","source":"web_search","source_domain":"ainvest.com","summary":"The primary money flows show a tentative but fragile reversal. U.S. spot Bitcoin ETFs posted $1.32 billion in March inflows, their first monthly gain since ...","title":"Bitcoin's Price Action: ETF Flows and Futures Open Interest ... - AInvest","url":"https://www.ainvest.com/news/bitcoin-price-action-etf-flows-futures-open-interest-real-story-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 8898 in events