SQLite Web: event_store.db

Update row sig_37241aac2fff in signals

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1428439/0001950047-26-003309.txt","as_of":"2026-04-09T03:12:49.786272+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1428439/0001950047-26-003309.txt","company":"ROKU, INC","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1428439/0001950047-26-003309.txt","article_chars":1767,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_e1e71b0cb1177794","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1428439/0001950047-26-003309.txt","content_type":"text/plain","enriched_at":"2026-04-09T19:30:02.064870+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1428439/0001950047-26-003309.txt","html_truncated":false,"paywall_likely":false,"publisher_domain":"sec.gov","publisher_resolution":"canonical_url","requested_url":"https://www.sec.gov/Archives/edgar/data/1428439/0001950047-26-003309.txt","source_event_id":"evt_deeabd7dce4d","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"form_type":"144","fp":"6d2fe1d6a8cb7167","kind":"sec_filing","published_at":"20260408","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["2026-04-08","2026-03-05","2026-03-03","2008-02-28","2026-04-09T03:12:49.786272+00:00"],"entities":[{"asset_class":"equity","name":"ROKU, INC","relevance":"high","symbol":"ROKU","type":"issuer"},{"asset_class":"equity","name":"Charles Collier","relevance":"high","symbol":"","type":"reporting-owner"},{"asset_class":"equity","name":"Morgan Stanley Smith Barney LLC","relevance":"medium","symbol":"","type":"broker"}],"event_type":"listing","information_gaps":["The text provided does not include the full Form 144 table fields (e.g., exact share counts for the 04/08/2026 option exercise/cash entry) beyond partial numeric fragments.","No prior known state is included in the prompt, so the specific \u201cdelta vs prior\u201d change cannot be determined from the provided text alone.","The filing\u2019s purpose (e.g., whether it is a sale, disposition, or other transfer) is not fully explicit in the excerpt beyond the presence of \u201cStock Option Exercise\u201d and \u201cCash\u201d descriptors."],"key_facts":["SEC accession number: 0001950047-26-003309.","Conformed submission type: Form 144.","Filed as of date: 2026-04-08; date as of change: 2026-04-08.","Subject company/issuer: ROKU, INC (CIK: 0001428439).","Reporting-owner: Charles Collier (CIK: 0001951665).","Filing includes a transaction entry dated 04/08/2026 with description including \u201cStock Option Exercise\u201d and \u201cCash\u201d.","The filing references \u201cNASDAQ Common\u201d and includes a \u201c04/08/2026\u201d date for the option exercise/cash entry.","The filing includes additional dated entries for Charles Collier on 03/05/2026 and 03/03/2026 (amounts shown in the text).","Signature: /s/ Charles Collier; date shown as 04/08/2026."],"numeric_claims":[{"label":"Option exercise date","value":"04/08/2026"},{"label":"Cash date (as shown in same entry)","value":"04/08/2026"},{"label":"Additional entry date 1","value":"03/05/2026"},{"label":"Additional entry date 2","value":"03/03/2026"},{"label":"Common stock amount (03/05/2026 entry)","value":"1715"},{"label":"Common stock amount (03/03/2026 entry)","value":"1715"},{"label":"Price/amount shown (03/05/2026 entry)","value":"171500.00"},{"label":"Price/amount shown (03/03/2026 entry)","value":"163902.55"}],"primary_claim":"On 2026-04-08, ROKU, INC filed SEC Form 144 (accession 0001950047-26-003309) for reporting-owner Charles Collier.","relevance_score":0.45,"sentiment":"neutral","source_quality":"medium","summary":"ROKU, INC filed a Form 144 on 2026-04-08. The filing is associated with reporting-owner Charles Collier and indicates common stock transactions related to an option exercise and cash activity.","topics":["SEC Form 144","insider/reporting-owner sale notice","common stock","stock option exercise","ROKU","Nasdaq"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 144 \u00b7 ROKU, INC \u00b7 Filed 20260408","ticker":"ROKU","tickers":["ROKU"],"title":"ROKU filed 144","url":"https://www.sec.gov/Archives/edgar/data/1428439/0001950047-26-003309.txt"}

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')

Cancel