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.nasdaq.com/articles/capital-clean-energy-carriers-becomes-oversold-ccec","as_of":"2026-04-09T21:31:27.529333+00:00","canonical_url":"https://www.nasdaq.com/articles/capital-clean-energy-carriers-becomes-oversold-ccec","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/capital-clean-energy-carriers-becomes-oversold-ccec","article_chars":2766,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_2d5d94cb6c00a2ff","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/capital-clean-energy-carriers-becomes-oversold-ccec","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:53:18.643708+00:00","extraction_method":"heuristic","fetched_description":"Legendary investor Warren Buffett advises to be fearful when others are greedy, and be greedy when others are fearful. One way we can try to measure the level of fear in a given stock is through a technical analysis indicator called the Relative Strength Index, or RSI, which me","fetched_title":"Capital Clean Energy Carriers Becomes Oversold (CCEC) | Nasdaq","final_url":"https://www.nasdaq.com/articles/capital-clean-energy-carriers-becomes-oversold-ccec","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/capital-clean-energy-carriers-becomes-oversold-ccec","source_event_id":"evt_d94688edf958","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6a11c1a3c3f38ef1","kind":"unusual_volume","published_at":"2026-04-09T20:34:26+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 09, 2026","Thursday"],"entities":[{"asset_class":"equity","name":"Capital Clean Energy Carriers Corp","relevance":"high","symbol":"CCEC","type":"company"},{"asset_class":"ETF","name":"S&P 500 ETF","relevance":"medium","symbol":"SPY","type":"ETF"}],"event_type":"price_action","information_gaps":["The signal type requested is discovery_unusual_volume_delta, but the provided text does not include any volume ratio vs average or volume delta figures.","No explicit confirmation by news is provided for the oversold move; the article does not cite a specific fundamental or macro catalyst.","No catalyst is stated beyond a general technical interpretation (heavy selling may be exhausting).","No baseline volume or average volume is provided, so unusual volume cannot be quantified from the text."],"key_facts":["The article states that a stock is considered oversold if RSI is below 30.","During Thursday trading, CCEC\u2019s RSI reading was 23.4.","The article says CCEC shares traded as low as $16.7683 per share.","The article compares CCEC\u2019s RSI to SPY\u2019s current RSI reading of 60.8.","The article states CCEC\u2019s 52-week low is $14.65 and 52-week high is $24.8299.","The article states the last trade was $17.32."],"numeric_claims":[{"label":"CCEC RSI","value":"23.4"},{"label":"SPY RSI","value":"60.8"},{"label":"CCEC intraday low (stated)","value":"$16.7683"},{"label":"CCEC 52-week low","value":"$14.65"},{"label":"CCEC 52-week high","value":"$24.8299"},{"label":"CCEC last trade (stated)","value":"$17.32"}],"primary_claim":"CCEC\u2019s RSI fell to 23.4 (oversold, below 30) during Thursday trading.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"BNK Invest (via Nasdaq.com) reports that Capital Clean Energy Carriers Corp (CCEC) entered oversold territory with an RSI of 23.4 on Thursday. The article frames this as a potential sign that heavy selling may be exhausting, but it does not cite a specific news catalyst.","topics":["RSI oversold","technical analysis","momentum","52-week range","trading on Thursday"]},"source":"Nasdaq Markets","source_domain":"nasdaq.com","summary":"Legendary investor Warren Buffett advises to be fearful when others are greedy, and be greedy when others are fearful. One way we can try to measure the level of fear in a given stock is through a technical analysis indicator called the Relative Strength Index, or RSI, which me","tickers":["CCEC"],"title":"Capital Clean Energy Carriers Becomes Oversold (CCEC)","url":"https://www.nasdaq.com/articles/capital-clean-energy-carriers-becomes-oversold-ccec"}

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_936e83800662 in signals