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_c628f0f400919f26","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:37.753826+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_7a8d82cf2456","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bac83b2e61c506ad","kind":"sector_rotation","published_at":"2026-04-07T20:13:32+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["Tuesday","April 07, 2026"],"entities":[{"asset_class":"ETF","name":"Defiance Daily Target 2x Long AVAV ETF","relevance":"high","symbol":"AVXX","type":"etf"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"}],"event_type":"price_action","information_gaps":["No sector rotation details are provided (no sectors gaining/losing, no macro driver, and no regime-shift vs short-term rebalancing discussion).","The article references a one-year chart but does not provide the chart values beyond the stated 52-week low/high and last trade.","The underlying asset/strategy exposure of AVXX (e.g., what 'AVAV' refers to) is not explained in the provided text."],"key_facts":["AVXX entered oversold territory on Tuesday.","Oversold is defined as RSI below 30.","AVXX RSI reading hit 29.7.","S&P 500 RSI is currently 47.4 (as stated).","AVXX traded as low as $10.1601 per share.","AVXX is currently trading off about 4% on the day.","AVXX 52-week low is $9.57 and 52-week high is $73.7445 (as stated).","AVXX last trade is $10.64 (as stated)."],"numeric_claims":[{"label":"AVXX RSI","value":"29.7"},{"label":"Oversold RSI threshold","value":"30"},{"label":"S&P 500 RSI","value":"47.4"},{"label":"AVXX intraday low","value":"$10.1601"},{"label":"AVXX last trade","value":"$10.64"},{"label":"AVXX 52-week low","value":"$9.57"},{"label":"AVXX 52-week high","value":"$73.7445"},{"label":"AVXX daily move","value":"~4% down"}],"primary_claim":"AVXX\u2019s RSI reached 29.7, placing it in oversold territory (RSI < 30) while trading around $10.1601 and down about 4% on the day.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The article reports that the Defiance Daily Target 2x Long AVAV ETF (AVXX) entered oversold territory on Tuesday, with RSI at 29.7 (below the 30 threshold). It notes AVXX is down about 4% on the day and compares its RSI to the S&P 500\u2019s 47.4.","topics":["oversold","RSI","technical analysis","ETF","momentum","market comparison"]},"source":"Nasdaq ETFs","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_9ea4f8fe4bbe in signals