SQLite Web: event_store.db

Update row sig_aaa3c3df117a 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/0001951665-26-000006.txt","as_of":"2026-04-11T03:10:51.104915+00:00","canonical_url":"https://www.sec.gov/Archives/edgar/data/1428439/0001951665-26-000006.txt","company":"ROKU, INC","enrichment":{"aggregator_url":"https://www.sec.gov/Archives/edgar/data/1428439/0001951665-26-000006.txt","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5de0ce0993ce7366","canonical_host":"sec.gov","canonical_is_aggregator":false,"canonical_url":"https://www.sec.gov/Archives/edgar/data/1428439/0001951665-26-000006.txt","content_type":"text/plain","enriched_at":"2026-04-11T09:05:25.259566+00:00","extraction_method":"trafilatura","fetched_description":"","fetched_title":"","final_url":"https://www.sec.gov/Archives/edgar/data/1428439/0001951665-26-000006.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/0001951665-26-000006.txt","source_event_id":"evt_1ab9b6564bdc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"form_type":"4","fp":"5a269034a1d0d54a","kind":"sec_filing","published_at":"20260410","publisher_domain":"sec.gov","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["2026-04-10","2026-04-08","2026-04-08 (repeated in table)","2008-02-28 (former company name change date)","2032-11-03","2033-04-02","2034-09-02","2034-11-03","2034-01-31","2034-02-28","2034-04-30","2033-01-31","2033-07-31","2034-06-02","2035-01-01","2034-08-05","2033-10-31","2034-09-30","2034-12-01","2033-02-28","2033-08-31"],"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":"Charles D. Collier Revocable Trust","relevance":"medium","symbol":"","type":"trust"}],"event_type":"listing","information_gaps":["The provided text does not explicitly state the nature of each beneficial ownership change (e.g., whether it is a sale, purchase, exercise, or grant) beyond the presence of \u201cEmployee Stock Option (right to buy)\u201d labels.","The meaning of the \u201cD\u201d and \u201cM\u201d codes in the table rows is not defined in the provided text.","The filing\u2019s complete set of transactions is truncated in the provided excerpt (ends mid-line: \u201cEmployee Stock Option (\u201d).","No explicit guidance or financial implications (earnings, revenue, outlook) are included in the provided text; only ownership-change data is shown."],"key_facts":["SEC filing: Form 4 for issuer ROKU, INC (SEC Act: 1934 Act; SEC file number 001-38211).","Filed as of date: 2026-04-10; accession number: 0001951665-26-000006.","Conformed period of report: 2026-04-08.","Reporting owner: Charles Collier (listed as President, Roku Media).","Issuer security class referenced: Class A Common Stock (multiple entries shown).","The text includes multiple \u201cEmployee Stock Option (right to buy)\u201d entries with associated Class A Common Stock quantities and dates (e.g., 2032-11-03, 2033-04-02, 2034-09-02, 2034-11-03, etc.).","The filing shows \u201cD\u201d and \u201cM\u201d codes in the table rows (exact meaning not defined in provided text)."],"numeric_claims":[{"label":"Number of public documents","value":"1"},{"label":"Conformed period of report","value":"20260408"},{"label":"Filed as of date","value":"20260410"},{"label":"Option-related Class A common stock quantity example (first shown)","value":"177139"},{"label":"Option-related Class A common stock quantity example (second shown)","value":"1332"},{"label":"Option-related Class A common stock quantity example (third shown)","value":"1150"}],"primary_claim":"On 2026-04-10, ROKU, INC filed Form 4 (period of report 2026-04-08) showing Charles Collier\u2019s beneficial ownership changes in ROKU Class A common stock, including option-related transactions.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"ROKU, INC filed Form 4 on 2026-04-10 reporting changes in beneficial ownership by Charles Collier. The filing period is 2026-04-08 and lists multiple transactions related to Class A common stock tied to employee stock options.","topics":["SEC Form 4","insider transactions","beneficial ownership","Class A common stock","employee stock options"]},"source":"sec_edgar","source_domain":"sec.gov","summary":"Form 4 \u00b7 ROKU, INC \u00b7 Filed 20260410","ticker":"ROKU","tickers":["ROKU"],"title":"ROKU filed 4","url":"https://www.sec.gov/Archives/edgar/data/1428439/0001951665-26-000006.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