Create
Query
event_store.db
—
signals
actions
approvals
artifacts
commitments
constraints
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
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 sig_fde5baf63c07 in signals
id
sig_fde5baf63c07
Primary key.
TEXT
event_id
5836
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
market_headline_delta
TEXT NOT NULL
value
{"aggregator_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxQZXFFUUJOSEpReXdKYzMwaU1iS3VIMzlIVXotSUlRS3ZDel9RcUNLQ1prb0JiUGhLaHlVeUtlMFJSS1pfVlI2Y0hWZXVRSXVSeUxoZ1pKaWNHbmRFZUJFZDJzd000QXFrRUNLQ0NETkRkNzBLeTNFR1VJaEZQZ1ZGU1lIVTUyRXJ6NkE2eUpqSHJlUlFUX2o3R3JELVNJeVlpNHB2RmFiSDhKY04yVmU2LWE5VmZEQ2NYbXc?oc=5","as_of":"2026-04-08T10:15:25.520441+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxQZXFFUUJOSEpReXdKYzMwaU1iS3VIMzlIVXotSUlRS3ZDel9RcUNLQ1prb0JiUGhLaHlVeUtlMFJSS1pfVlI2Y0hWZXVRSXVSeUxoZ1pKaWNHbmRFZUJFZDJzd000QXFrRUNLQ0NETkRkNzBLeTNFR1VJaEZQZ1ZGU1lIVTUyRXJ6NkE2eUpqSHJlUlFUX2o3R3JELVNJeVlpNHB2RmFiSDhKY04yVmU2LWE5VmZEQ2NYbXc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b31fb5239bb9e2e7","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T10:16:13.188098+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxQZXFFUUJOSEpReXdKYzMwaU1iS3VIMzlIVXotSUlRS3ZDel9RcUNLQ1prb0JiUGhLaHlVeUtlMFJSS1pfVlI2Y0hWZXVRSXVSeUxoZ1pKaWNHbmRFZUJFZDJzd000QXFrRUNLQ0NETkRkNzBLeTNFR1VJaEZQZ1ZGU1lIVTUyRXJ6NkE2eUpqSHJlUlFUX2o3R3JELVNJeVlpNHB2RmFiSDhKY04yVmU2LWE5VmZEQ2NYbXc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"stocktitan.net","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxQZXFFUUJOSEpReXdKYzMwaU1iS3VIMzlIVXotSUlRS3ZDel9RcUNLQ1prb0JiUGhLaHlVeUtlMFJSS1pfVlI2Y0hWZXVRSXVSeUxoZ1pKaWNHbmRFZUJFZDJzd000QXFrRUNLQ0NETkRkNzBLeTNFR1VJaEZQZ1ZGU1lIVTUyRXJ6NkE2eUpqSHJlUlFUX2o3R3JELVNJeVlpNHB2RmFiSDhKY04yVmU2LWE5VmZEQ2NYbXc?oc=5","source_event_id":"evt_3b45296d7762","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2dca31fabc14321c","published_at":"2026-04-08T10:00:00+00:00","publisher_domain":"stocktitan.net","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Cango","relevance":"primary","symbol":"","type":"company"},{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"primary","symbol":"BTC","type":"crypto_asset"}],"event_type":"price_action","information_gaps":["No additional article text was provided beyond the headline; details such as timing of the sale, total loan amount, and whether the 19.3% refers to a specific period are not included.","No ticker/symbol for Cango is provided in the provided text.","No information is given on market impact (e.g., price reaction) beyond the headline linkage."],"key_facts":["Cango sold 2,000 Bitcoin.","The purpose stated is to pay down loans.","Mining costs fell 19.3%.","The headline links the Bitcoin sale to the mining-cost decline."],"numeric_claims":[{"label":"Bitcoin sold","value":"2,000"},{"label":"Mining cost change","value":"-19.3%"}],"primary_claim":"Cango sold 2,000 Bitcoin to pay down loans as mining costs fell 19.3%.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"Cango sold 2,000 Bitcoin to pay down loans, citing that mining costs fell 19.3%. The headline implies a cash-management action linked to improved mining economics.","topics":["crypto","Bitcoin sales","mining costs","loan repayment","corporate treasury"]},"source":"Stock Titan","source_domain":"stocktitan.net","source_url":"https://www.stocktitan.net","summary":"","tickers":[],"title":"Cango sold 2,000 Bitcoin to pay down loans as mining costs fell 19.3% - Stock Titan","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp"}
TEXT NOT NULL
threshold
NULL
TEXT
direction
NULL
TEXT
severity
NULL
TEXT
window
NULL
TEXT
source
market_ingestor
TEXT NOT NULL
reason_trace
{"_evidence_event_ids":["evt_3b45296d7762"]}
TEXT
dedupe_key
signal_enriched:market_headline_delta:1edf722751620e77
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-08T10:15:25.520441+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel