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-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:7fcc73bbe5ebc4ec","evidence_event_ids":["evt_7e3bcfd4a1ad"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://alternative.me/crypto/fear-and-greed-index/","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://alternative.me/crypto/fear-and-greed-index/","enrichment":{"aggregator_url":"https://alternative.me/crypto/fear-and-greed-index/","article_chars":55,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_aa35f23f06140479","canonical_host":"alternative.me","canonical_is_aggregator":false,"canonical_url":"https://alternative.me/crypto/fear-and-greed-index/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T01:01:41.828640+00:00","extraction_method":"heuristic","fetched_description":"The crypto fear & greed index of alternative.me provides an easy overview of the current sentiment of the Bitcoin / crypto market at a glance.","fetched_title":"Crypto Fear & Greed Index - Bitcoin Sentiment - Alternative.me","final_url":"https://alternative.me/crypto/fear-and-greed-index/","html_truncated":false,"paywall_likely":false,"publisher_domain":"alternative.me","publisher_resolution":"canonical_url","requested_url":"https://alternative.me/crypto/fear-and-greed-index/","source_event_id":"evt_7e3bcfd4a1ad","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"c5a5c9cc26d0b728","kind":"crypto_extremes","published_at":"2026-04-07T23:23:59.708482+00:00","publisher_domain":"alternative.me","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Crypto Fear & Greed Index","relevance":"primary","symbol":"","type":"index"}],"event_type":"price_action","information_gaps":["No timestamp/date for when the index value was observed.","No explanation of how the index is calculated or what components contribute to the value.","No additional market context (e.g., price moves, volatility, or drivers) is provided in the text."],"key_facts":["The index value is 11.","The sentiment label shown is \u201cExtreme Fear.\u201d","The provided text includes an iOS widget copy/code section, but no additional numeric or contextual details beyond the index value and label."],"numeric_claims":[{"label":"Crypto Fear & Greed index value","value":"11"}],"primary_claim":"Crypto Fear & Greed index value is 11 and the classification is Extreme Fear.","relevance_score":0.45,"sentiment":"negative","source_quality":"unknown","summary":"The Crypto Fear & Greed index is at 11, which corresponds to \u201cExtreme Fear.\u201d","topics":["crypto sentiment","fear and greed index","extreme fear"]},"source":"Alt Fear & Greed","source_domain":"alternative.me","summary":"Index value 11 \u00b7 Extreme Fear","tickers":[],"title":"Crypto Fear & Greed: 11 (Extreme Fear)","url":"https://alternative.me/crypto/fear-and-greed-index/"}}

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