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/defiance-daily-target-2x-long-avav-getting-very-oversold","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.nasdaq.com/articles/defiance-daily-target-2x-long-avav-getting-very-oversold","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/defiance-daily-target-2x-long-avav-getting-very-oversold","article_chars":2611,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_d7484c49eab57e78","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/defiance-daily-target-2x-long-avav-getting-very-oversold","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:46:06.268897+00:00","extraction_method":"heuristic","fetched_description":"In trading on Tuesday, shares of the Defiance Daily Target 2x Long AVAV ETF (Symbol: AVXX) entered into oversold territory, changing hands as low as $10.1601 per share. We define oversold territory using the Relative Strength Index, or RSI, which is a technical analysis indicat","fetched_title":"Defiance Daily Target 2x Long AVAV Getting Very Oversold | Nasdaq","final_url":"https://www.nasdaq.com/articles/defiance-daily-target-2x-long-avav-getting-very-oversold","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/defiance-daily-target-2x-long-avav-getting-very-oversold","source_event_id":"evt_de16f624ec0d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bac83b2e61c506ad","kind":"unusual_volume","published_at":"2026-04-07T20:13:32+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["April 07, 2026","Tuesday"],"entities":[{"asset_class":"ETF","name":"Defiance Daily Target 2x Long AVAV ETF","relevance":"high","symbol":"AVXX","type":"etf"}],"event_type":"price_action","information_gaps":["The signal type requests an unusual volume ratio vs average, but the provided text does not include any volume figures, baseline volume, or volume ratio.","No specific catalyst (news event or otherwise) is identified in the provided text; the only explanation offered is a general technical interpretation (oversold may indicate selling exhaustion).","The article excerpt does not state whether the oversold condition is confirmed by any external news or is purely technical/price-based."],"key_facts":["AVXX (Defiance Daily Target 2x Long AVAV) is described as entering oversold territory on Tuesday.","Oversold is defined in the article as RSI below 30.","AVXX RSI is reported as 29.7.","The article compares AVXX RSI (29.7) to the S&P 500 RSI (47.4).","AVXX traded as low as $10.1601 per share.","AVXX is reported as trading about 4% down on the day.","52-week low is stated as $9.57 and 52-week high as $73.7445; last trade is stated as $10.64."],"numeric_claims":[{"label":"AVXX RSI","value":"29.7"},{"label":"S&P 500 RSI","value":"47.4"},{"label":"Intraday low (AVXX)","value":"$10.1601"},{"label":"52-week low (AVXX)","value":"$9.57"},{"label":"52-week high (AVXX)","value":"$73.7445"},{"label":"Last trade (AVXX)","value":"$10.64"},{"label":"Daily move (AVXX)","value":"~4% down"}],"primary_claim":"AVXX\u2019s RSI fell to 29.7, which the article defines as oversold (RSI < 30), and the ETF traded as low as $10.1601 on Tuesday.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"The Defiance Daily Target 2x Long AVAV ETF (AVXX) was reported as entering oversold territory, with RSI at 29.7 (below the 30 threshold) and trading as low as $10.1601. The article does not provide an explicit unusual volume ratio versus baseline or a confirmed news catalyst.","topics":["oversold","RSI","technical analysis","ETF","trading price move"]},"source":"Nasdaq Markets","source_domain":"nasdaq.com","summary":"In trading on Tuesday, shares of the Defiance Daily Target 2x Long AVAV ETF (Symbol: AVXX) entered into oversold territory, changing hands as low as $10.1601 per share. We define oversold territory using the Relative Strength Index, or RSI, which is a technical analysis indicat","tickers":[],"title":"Defiance Daily Target 2x Long AVAV Getting Very Oversold","url":"https://www.nasdaq.com/articles/defiance-daily-target-2x-long-avav-getting-very-oversold"}

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