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/archer-aviation-just-hit-major-milestone-investors-should-watch-one-key-metric-next","as_of":"2026-04-16T17:21:14.731588+00:00","canonical_url":"https://www.fool.com/investing/2026/04/16/archer-aviation-just-hit-a-major-milestone-but/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/archer-aviation-just-hit-major-milestone-investors-should-watch-one-key-metric-next","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_dd8b12190b35bfab","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/16/archer-aviation-just-hit-a-major-milestone-but/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T02:10:00.443893+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsThe electric air taxi maker cleared a key regulatory hurdle and has nearly $2 billion in liquidity.","fetched_title":"Archer Aviation Just Hit a Major Milestone -- But Investors Should Watch This One Key Metric Next | Nasdaq","final_url":"https://www.nasdaq.com/articles/archer-aviation-just-hit-major-milestone-investors-should-watch-one-key-metric-next","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/archer-aviation-just-hit-major-milestone-investors-should-watch-one-key-metric-next","source_event_id":"evt_02efdb690749","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"cb0d7a9e4351b528","kind":"unusual_volume","published_at":"2026-04-16T16:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["2025","next 12 months","April 16, 2026","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"equity","name":"Archer Aviation","relevance":"high","symbol":"ACHR","type":"company"},{"asset_class":"other","name":"Federal Aviation Administration (FAA)","relevance":"high","symbol":"","type":"regulator"},{"asset_class":"other","name":"Midnight (aircraft)","relevance":"high","symbol":"","type":"product"},{"asset_class":"equity","name":"Joby Aviation","relevance":"medium","symbol":"","type":"company"}],"event_type":"regulation","information_gaps":["The provided signal type is discovery_unusual_volume_delta, but the text contains no volume ratio, baseline volume, or confirmation of unusual trading volume.","No explicit statement is provided about whether the milestone was confirmed by external news beyond the article\u2019s reference to the company\u2019s latest earnings release.","The article does not quantify any stock price movement or trading volume changes.","catalyst_hint is not provided in the text beyond the regulatory milestone and liquidity update.","Most likely catalyst hypothesis (from text only): the FAA acceptance milestone and improved liquidity reduce regulatory and near-term funding uncertainty, but the article frames execution risk as the key driver to watch next."],"key_facts":["The article states Archer Aviation achieved 100% FAA acceptance of its \u201cMeans of Compliance\u201d for the Midnight aircraft.","The article characterizes this as a critical milestone toward full certification, which it describes as the gatekeeper for launching commercial flying taxi services.","The article states Archer exited 2025 with nearly $2 billion in cash after capital raises.","The article states Archer still generates almost no revenue and continues to burn hundreds of millions of dollars annually.","The article says investors should watch for (1) initial commercial operations on time with real paying customers and (2) evidence that flying taxi production can scale without major delays or cost overruns within the next 12 months."],"numeric_claims":[{"label":"FAA acceptance of Means of Compliance","value":"100%"},{"label":"Cash/liquidity at exit of 2025","value":"nearly $2 billion"}],"primary_claim":"Archer Aviation achieved 100% FAA acceptance of its Midnight aircraft \u201cMeans of Compliance,\u201d clearing a major regulatory milestone toward full certification.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Archer Aviation (ACHR) reported that the FAA has accepted 100% of its Midnight aircraft \u201cMeans of Compliance,\u201d a key step toward certification, and said it exited 2025 with nearly $2B in cash. The article argues the next focus should be execution, including initial commercial operations and scalable production.","topics":["FAA certification milestone","Means of Compliance acceptance","eVTOL commercialization","liquidity/cash balance","execution risk","initial commercial operations","production scaling"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe electric air taxi maker cleared a key regulatory hurdle and has nearly $2 billion in liquidity.","tickers":[],"title":"Archer Aviation Just Hit a Major Milestone -- But Investors Should Watch This One Key Metric Next","url":"https://www.fool.com/investing/2026/04/16/archer-aviation-just-hit-a-major-milestone-but/"}

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