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-21T00:08:29.826903+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:9ce0f4c1681b388b","evidence_event_ids":["evt_193d49e43237"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/rocket-lab-stock-down-14-it-finally-time-buy","as_of":"2026-04-21T00:08:29.826903+00:00","canonical_url":"https://www.fool.com/investing/2026/04/20/rocket-lab-stock-is-down-14-is-it-finally-time-to/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/rocket-lab-stock-down-14-it-finally-time-buy","article_chars":4479,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_0b4e96ea95b00a6c","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/20/rocket-lab-stock-is-down-14-is-it-finally-time-to/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T21:31:08.289702+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsRocket Lab has established itself in the small-payload launch industry and is the second-most-used launch company in the U.S.","fetched_title":"Rocket Lab Stock Is Down 14%. Is It Finally Time to Buy? | Nasdaq","final_url":"https://www.nasdaq.com/articles/rocket-lab-stock-down-14-it-finally-time-buy","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/rocket-lab-stock-down-14-it-finally-time-buy","source_event_id":"evt_193d49e43237","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5b10f5bd539af13d","kind":"unusual_volume","published_at":"2026-04-20T23:25:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["mid-January","January","mid-March","April 9","2026","fourth quarter of this year","2028","next decade","April 20, 2026"],"entities":[{"asset_class":"equity","name":"Rocket Lab","relevance":"high","symbol":"RKLB","type":"company"},{"asset_class":"other","name":"Neutron","relevance":"high","symbol":"","type":"launch vehicle"},{"asset_class":"other","name":"Electron","relevance":"medium","symbol":"","type":"launch vehicle"},{"asset_class":"equity","name":"SpaceX","relevance":"low","symbol":"","type":"company"},{"asset_class":"other","name":"Q-Shu Pioneers of Space (iQPS)","relevance":"medium","symbol":"","type":"customer"}],"event_type":"price_action","information_gaps":["The signal type is discovery_unusual_volume_delta, but the provided text does not include any volume ratio, baseline volume, or confirmation details about unusual trading volume.","No explicit statement is made about whether the price move is confirmed by news beyond the narrative of the Neutron delay and contract announcements.","The article does not provide a specific volume delta metric (e.g., volume vs average) needed to complete the unusual_volume fields.","A catalyst hypothesis for unusual volume cannot be grounded in the provided text because no volume information is given."],"key_facts":["Rocket Lab (NASDAQ: RKLB) is described as down 14% from its 52-week high.","The article states Rocket Lab had a setback in January when a Stage 1 fuel tank ruptured during a hydrostatic pressure test.","The article says the Neutron launch was delayed to the fourth quarter of this year due to the January fuel tank rupture.","The article cites a mid-March $190 million contract for 20 hypersonic test flights using the HASTE launch vehicle.","The article says that on April 9 Rocket Lab signed a deal for three Electron launches for iQPS starting in 2028.","The article states Rocket Lab\u2019s backlog is $1.85 billion, with space systems at 74% and launch services the remainder.","The article provides analyst projections of revenue increasing to $870 million this year and $1.2 billion in 2027."],"numeric_claims":[{"label":"stock decline","value":"down 14% (from 52-week high)"},{"label":"fuel tank rupture impact","value":"Neutron launch delayed to fourth quarter of this year"},{"label":"hypersonic contract value","value":"$190 million"},{"label":"hypersonic test flights count","value":"20"},{"label":"Electron launches for iQPS","value":"3"},{"label":"backlog","value":"$1.85 billion"},{"label":"space systems share of backlog","value":"74%"},{"label":"revenue projection (this year)","value":"$870 million"},{"label":"revenue projection (2027)","value":"$1.2 billion"}],"primary_claim":"Rocket Lab\u2019s stock dipped after a January fuel tank rupture delayed its Neutron launch, and the article points to later contract announcements as positive developments despite the stock being down 14%.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"The article says Rocket Lab (NASDAQ: RKLB) is down 14% from its 52-week high and frames the move as a potential buying opportunity. It attributes the earlier decline to a January Neutron setback (fuel tank rupture) and cites subsequent contract wins as positive offsetting catalysts.","topics":["unusual_volume_delta","stock down","Neutron launch delay","fuel tank rupture","defense contract","hypersonic test flights","space systems backlog","contracts","Rocket Lab (RKLB)"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsRocket Lab has established itself in the small-payload launch industry and is the second-most-used launch company in the U.S.","tickers":[],"title":"Rocket Lab Stock Is Down 14%. Is It Finally Time to Buy?","url":"https://www.fool.com/investing/2026/04/20/rocket-lab-stock-is-down-14-is-it-finally-time-to/"}}

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 473429 in events