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/bullish-two-hundred-day-moving-average-cross-dfp","as_of":"2026-04-20T20:32:04.855080+00:00","canonical_url":"https://www.nasdaq.com/articles/bullish-two-hundred-day-moving-average-cross-dfp","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bullish-two-hundred-day-moving-average-cross-dfp","article_chars":991,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_e567a9d7ce7502d8","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/bullish-two-hundred-day-moving-average-cross-dfp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:03:28.015791+00:00","extraction_method":"trafilatura","fetched_description":"In trading on Monday, shares of Flaherty & Crumrine Dynamic Preferred and Income F (Symbol: DFP) crossed above their 200 day moving average of $21.15, changing hands as high as $21.25 per share. Flaherty & Crumrine Dynamic Preferred and Income F shares are currently tra","fetched_title":"Bullish Two Hundred Day Moving Average Cross - DFP | Nasdaq","final_url":"https://www.nasdaq.com/articles/bullish-two-hundred-day-moving-average-cross-dfp","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bullish-two-hundred-day-moving-average-cross-dfp","source_event_id":"evt_60afa1ca0e59","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"f69ec7aeaae5ef04","kind":"new_listings","published_at":"2026-04-20T20:10:48+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Monday"],"entities":[{"asset_class":"equity","name":"Flaherty & Crumrine Dynamic Preferred and Income F","relevance":"high","symbol":"DFP","type":"company"}],"event_type":"price_action","information_gaps":["The exact date (calendar day) for \u201cMonday\u201d is not provided.","The article excerpt is truncated after \u201ccurrently tra\u2026\u201d, so additional context (e.g., full current price, volume, or confirmation of the crossover timing) is not available.","No details are provided on whether this is a new listing versus an indicator-based price event; the signal type is \u201cdiscovery_new_listings_delta,\u201d but the text describes a moving-average crossover."],"key_facts":["On Monday, DFP crossed above its 200-day moving average of $21.15.","During the move, DFP shares traded as high as $21.25 per share.","DFP was trading up about 0.5% on the day.","DFP\u2019s 52-week low was $19.09 and 52-week high was $22.11.","The last trade cited was $21.16."],"numeric_claims":[{"label":"200-day moving average","value":"$21.15"},{"label":"Intraday high","value":"$21.25"},{"label":"Daily change","value":"~0.5%"},{"label":"52-week low","value":"$19.09"},{"label":"52-week high","value":"$22.11"},{"label":"Last trade","value":"$21.16"}],"primary_claim":"Flaherty & Crumrine Dynamic Preferred and Income F (DFP) crossed above its 200-day moving average of $21.15, trading as high as $21.25.","relevance_score":0.55,"sentiment":"positive","source_quality":"medium","summary":"DFP shares crossed above their 200-day moving average on Monday, trading up about 0.5% and reaching a high of $21.25.","topics":["200-day moving average crossover","price performance","52-week range","dividend/market commentary"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"In trading on Monday, shares of Flaherty & Crumrine Dynamic Preferred and Income F (Symbol: DFP) crossed above their 200 day moving average of $21.15, changing hands as high as $21.25 per share. Flaherty & Crumrine Dynamic Preferred and Income F shares are currently tra","tickers":[],"title":"Bullish Two Hundred Day Moving Average Cross - DFP","url":"https://www.nasdaq.com/articles/bullish-two-hundred-day-moving-average-cross-dfp"}

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