SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:bb5b139723d03ecc","evidence_event_ids":["evt_de16f624ec0d"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 2540 in events