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-22T14:13:37.135360+00:00","dedupe_key":"signal_enriched:discovery_crypto_extremes_delta:7fcc73bbe5ebc4ec","evidence_event_ids":["evt_116d5ab7d315"],"signal_type":"discovery_crypto_extremes_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://alternative.me/crypto/fear-and-greed-index/","as_of":"2026-04-22T14:13:37.135360+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":5000,"article_truncated":true,"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-22T14:18:17.779076+00:00","extraction_method":"trafilatura","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_116d5ab7d315","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0e03a97397827044","kind":"crypto_extremes","published_at":"2026-04-22T14:13:46.185501+00:00","publisher_domain":"alternative.me","signal_understanding":{"analysis_basis":"article","claim_confidence":0.86,"dates_mentioned":[],"entities":[{"asset_class":"crypto_sentiment_index","name":"Crypto Fear & Greed Index","relevance":"primary","symbol":"","type":"index"},{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"}],"event_type":"price_action","information_gaps":["The text does not provide the full mapping of index ranges to labels beyond the stated endpoints (0 = Extreme Fear, 100 = Extreme Greed); it only explicitly labels 32 as \u201cFear.\u201d","No timestamp for when the index value 32 was observed is included in the provided text.","The article text includes setup instructions for a widget; these are not directly relevant to the index calculation but are present in the cleaned text.","The exact formula/thresholds for converting each factor into the final 0\u2013100 index value are not provided.","The text states surveys are currently paused, but does not specify how that affects the index computation in the current state."],"key_facts":["Index value reported as 32.","Source label for index value 32 is \u201cFear.\u201d","Index scale described as 0 = \u201cExtreme Fear\u201d and 100 = \u201cExtreme Greed.\u201d","The current index is stated to be for Bitcoin only.","The index is described as combining multiple factors: Volatility (25%), Market Momentum/Volume (25%), Social Media (15%), Surveys (15%) (currently paused), Dominance (10%), and Trends (10%).","Volatility component compares current volatility and max drawdowns versus average values over the last 30 and 90 days.","Social media component: Twitter analysis is running; reddit sentiment analysis is stated as not in the live index (still experimenting).","Surveys component is stated as currently paused; polling is described as weekly with 2,000\u20133,000 votes per poll (historical description).","Dominance component: rise in Bitcoin dominance is described as associated with fear/reduced speculative alt-coin investment; shrink is described as associated with increased risk-taking in alt-coins.","Trends component uses Google Trends data for Bitcoin-related queries and emphasizes changes in search volumes and related recommended searches.","An example given: Google Trends shows a +1,550% rise of the query \u201cbitcoin price manipulation.\u201d"],"numeric_claims":[{"label":"Fear & Greed Index value","value":"32"},{"label":"Volatility weight","value":"25%"},{"label":"Market Momentum/Volume weight","value":"25%"},{"label":"Social Media weight","value":"15%"},{"label":"Surveys weight","value":"15%"},{"label":"Dominance weight","value":"10%"},{"label":"Trends weight","value":"10%"},{"label":"Google Trends example rise for \u201cbitcoin price manipulation\u201d","value":"+1,550%"}],"primary_claim":"The Crypto Fear & Greed Index value is 32 and is categorized as \u201cFear.\u201d","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The Crypto Fear & Greed Index is at 32, which the source labels as \u201cFear\u201d (0 = Extreme Fear, 100 = Extreme Greed). The index is described as a 0\u2013100 sentiment meter for Bitcoin based on multiple factors (volatility/drawdowns, momentum/volume, social media, surveys, dominance, and Google Trends).","topics":["crypto sentiment","fear and greed index","bitcoin sentiment","market volatility","market momentum","social media sentiment","google trends","bitcoin dominance"]},"source":"Alt Fear & Greed","source_domain":"alternative.me","summary":"Index value 32 \u00b7 Fear","tickers":[],"title":"Crypto Fear & Greed: 32 (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 482112 in events