SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.coingecko.com/en/coins/ravedao","as_of":"2026-04-09T21:31:27.529333+00:00","canonical_url":"https://www.coingecko.com/en/coins/ravedao","enrichment":{"aggregator_url":"https://www.coingecko.com/en/coins/ravedao","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5096ae1acfa6ca01","canonical_host":"coingecko.com","canonical_is_aggregator":false,"canonical_url":"https://www.coingecko.com/en/coins/ravedao","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:56:20.234574+00:00","extraction_method":"heuristic","fetched_description":"Track the latest RaveDAO price, market cap, trading volume, news and more with CoinGecko's live RAVE/USD price chart and popular cryptocurrency price tracker.","fetched_title":"RaveDAO Price: RAVE/USD Live Price Chart, Market Cap & News Today | CoinGecko","final_url":"https://www.coingecko.com/en/coins/ravedao","html_truncated":true,"paywall_likely":false,"publisher_domain":"coingecko.com","publisher_resolution":"canonical_url","requested_url":"https://www.coingecko.com/en/coins/ravedao","source_event_id":"evt_2b132c15c8cd","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8f7d95f1cafb529f","kind":"crypto_extremes","published_at":"2026-04-09T21:31:34.005569+00:00","publisher_domain":"coingecko.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"RaveDAO","relevance":"primary","symbol":"RAVE","type":"cryptocurrency"}],"event_type":"price_action","information_gaps":["No RAVE/USD live price value is present in the provided excerpt.","No RAVE 24h volume, market cap, or 24h percentage change for RAVE is shown in the provided excerpt.","The excerpt does not show the timestamp for when the \u201ctrending\u201d and \u201ctrend score\u201d were computed.","The excerpt includes global CoinGecko stats (e.g., total market cap, BTC dominance) but does not tie them specifically to RaveDAO."],"key_facts":["Signal states: \u201cTrending: RaveDAO (RAVE)\u201d","Signal states: \u201cMarket cap rank 196\u201d","Signal states: \u201ctrend score 6\u201d","Article text shown is largely CoinGecko site navigation and global market stats; it does not provide RAVE-specific price/returns in the excerpt."],"numeric_claims":[{"label":"market_cap_rank","value":"196"},{"label":"trend_score","value":"6"}],"primary_claim":"RaveDAO (RAVE) has market cap rank 196 and a trend score of 6 on CoinGecko\u2019s trending section.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"CoinGecko\u2019s page indicates RaveDAO (RAVE) is trending, with a market-cap rank of 196 and a trend score of 6. The provided text does not include RAVE\u2019s price or 24h change values.","topics":["crypto trending","market cap rank","trend score"]},"source":"CoinGecko Trending","source_domain":"coingecko.com","summary":"Market cap rank 196, trend score 6","tickers":["RAVE","RAVEUSD"],"title":"Trending: RaveDAO (RAVE)","url":"https://www.coingecko.com/en/coins/ravedao"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_142f8e94772a in signals