Create
Query
event_store.db
—
events
actions
agent_runs
approvals
artifacts
attention_candidates
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
intel_narrative_members
intel_narratives
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 475800 in events
seq
Primary key.
INTEGER
id
evt_03a15227315f
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-21T23:27:37.942788+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-21T19:57:20.275338+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:204695e13159caa6","evidence_event_ids":["evt_125b39e3e2c7"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.bitcoin.com/bitcoin-etfs-add-238-million-mark-fifth-straight-day-of-inflows/","as_of":"2026-04-21T19:57:20.275338+00:00","canonical_url":"https://news.bitcoin.com/bitcoin-etfs-add-238-million-mark-fifth-straight-day-of-inflows/","enrichment":{"aggregator_url":"https://news.bitcoin.com/bitcoin-etfs-add-238-million-mark-fifth-straight-day-of-inflows/","article_chars":508,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_b92aa6fa7b7ddea4","canonical_host":"news.bitcoin.com","canonical_is_aggregator":false,"canonical_url":"https://news.bitcoin.com/bitcoin-etfs-add-238-million-mark-fifth-straight-day-of-inflows/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:27:37.942718+00:00","extraction_method":"heuristic","fetched_description":"Bitcoin extended its inflow streak to 5 days with a $238 million addition. Ether followed with steady gains despite mixed trading activity.","fetched_title":"Bitcoin ETFs Add $238 Million, Mark Fifth Straight Day of Inflows","final_url":"https://news.bitcoin.com/bitcoin-etfs-add-238-million-mark-fifth-straight-day-of-inflows/","html_truncated":true,"paywall_likely":false,"publisher_domain":"news.bitcoin.com","publisher_resolution":"canonical_url","requested_url":"https://news.bitcoin.com/bitcoin-etfs-add-238-million-mark-fifth-straight-day-of-inflows/","source_event_id":"evt_125b39e3e2c7","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"068fe9f938e1c6bd","kind":"crypto_extremes","published_at":"2026-04-21T18:38:06+00:00","publisher_domain":"news.bitcoin.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.45000000000000007,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"},{"asset_class":"crypto_etf","name":"Bitcoin ETFs","relevance":"high","symbol":"","type":"instrument"},{"asset_class":"crypto_etf","name":"BlackRock IBIT","relevance":"high","symbol":"IBIT","type":"fund"},{"asset_class":"crypto","name":"Ether","relevance":"medium","symbol":"ETH","type":"asset"},{"asset_class":"crypto_etf","name":"Ether ETFs","relevance":"medium","symbol":"","type":"instrument"},{"asset_class":"crypto","name":"XRP","relevance":"medium","symbol":"XRP","type":"asset"},{"asset_class":"crypto","name":"Solana","relevance":"medium","symbol":"SOL","type":"asset"}],"event_type":"price_action","information_gaps":["The excerpt is truncated after \u201cEther ETFs gained $67.77 [\u2026]\u201d, so additional ETF figures and any time/date context are missing.","No specific inflow/outflow amounts for XRP and Solana are provided in the excerpt.","The excerpt does not include the exact date/time of the inflow measurements.","No broader market price performance details are included beyond the mention of \u201cmixed trading activity.\u201d"],"key_facts":["Bitcoin ETFs added $238.37 million and marked the fifth straight day of inflows.","BlackRock\u2019s IBIT sustained the five-day inflow streak with a $256 million addition.","Ether ETFs gained $67.77 million (the provided text cuts off after this figure).","The signal states XRP and Solana also added to the momentum, but no amounts are included in the provided excerpt."],"numeric_claims":[{"label":"Bitcoin ETF inflows (5th straight day)","value":"$238.37 million"},{"label":"BlackRock IBIT inflows (5-day streak)","value":"$256 million"},{"label":"Ether ETF inflows","value":"$67.77 million"}],"primary_claim":"Bitcoin ETFs added $238.37 million and marked a fifth consecutive day of inflows.","relevance_score":0.62,"sentiment":"positive","source_quality":"low","summary":"Bitcoin ETF inflows continued for a fifth straight day, adding about $238 million. Ether ETFs also saw inflows, while the signal notes momentum in XRP and Solana, but detailed figures for those are not fully present in the provided text.","topics":["crypto ETF inflows","Bitcoin inflow streak","BlackRock IBIT inflows","Ether ETF inflows","XRP momentum","Solana momentum"]},"source":"Bitcoin.com News","source_domain":"news.bitcoin.com","summary":"Bitcoin extended its inflow streak to five days with a $238 million addition. Ether followed with steady gains despite mixed trading activity, while both XRP and Solana added to the momentum. Key Takeaways: Bitcoin ETFs added $238.37 million, with Blackrock\u2019s IBIT sustaining the five-day inflow streak with a $256 million addition. Ether ETFs gained $67.77 [\u2026]","tickers":[],"title":"Bitcoin ETFs Add $238 Million, Mark Fifth Straight Day of Inflows","url":"https://news.bitcoin.com/bitcoin-etfs-add-238-million-mark-fifth-straight-day-of-inflows/"}}
TEXT NOT NULL
source_ref
candidate:sc_b92aa6fa7b7ddea4
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_crypto_extremes_delta:204695e13159caa6
TEXT
episode_id
NULL
TEXT
created_at
2026-04-21T23:27:37.942856+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel