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_new_listings_delta:22e760126584abb6","evidence_event_ids":["evt_691a350f0e66"],"signal_type":"discovery_new_listings_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/vita-coco-company-inc-coco-registers-bigger-fall-market-important-facts-note","as_of":"2026-04-21T00:08:29.826903+00:00","canonical_url":"https://www.nasdaq.com/articles/vita-coco-company-inc-coco-registers-bigger-fall-market-important-facts-note","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/vita-coco-company-inc-coco-registers-bigger-fall-market-important-facts-note","article_chars":3621,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_3d4c3b5af6afc6b3","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/vita-coco-company-inc-coco-registers-bigger-fall-market-important-facts-note","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:25:56.837980+00:00","extraction_method":"trafilatura","fetched_description":"Vita Coco Company, Inc. (COCO) concluded the recent trading session at $34.54, signifying a -1.06% move from its prior day's close.","fetched_title":"Vita Coco Company, Inc. (COCO) Registers a Bigger Fall Than the Market: Important Facts to Note | Nasdaq","final_url":"https://www.nasdaq.com/articles/vita-coco-company-inc-coco-registers-bigger-fall-market-important-facts-note","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/vita-coco-company-inc-coco-registers-bigger-fall-market-important-facts-note","source_event_id":"evt_691a350f0e66","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f086330fce23d3f7","kind":"new_listings","published_at":"2026-04-20T22:15:05+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Vita Coco Company, Inc.","relevance":"high","symbol":"COCO","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"},{"asset_class":"index","name":"Dow","relevance":"medium","symbol":"","type":"index"},{"asset_class":"index","name":"Nasdaq","relevance":"medium","symbol":"","type":"index"},{"asset_class":"other","name":"Zacks Consensus Estimates","relevance":"medium","symbol":"","type":"estimates_framework"},{"asset_class":"other","name":"Zacks Rank","relevance":"medium","symbol":"","type":"rating_system"}],"event_type":"price_action","information_gaps":["The signal headline mentions a different close ($47.47) and +1.76% move, but the cleaned article text states COCO closed at $34.54 and -1.06%; the discrepancy is not resolved in the provided text.","No specific earnings release date is provided.","No details are given on the magnitude/timing of analyst estimate revisions beyond the stated 2.86% EPS estimate move lower over the past month.","The article references external audits and historical return figures for the Zacks Rank, but these are not directly tied to COCO\u2019s current listing/price action beyond general claims."],"key_facts":["COCO closed the latest trading day at $34.54, representing a -1.06% change from the previous session.","The move lagged the S&P 500\u2019s daily loss of 0.91%.","The Dow declined 1.5% and the Nasdaq declined 1.96% on the day.","COCO shares were down 12.24% over the previous month.","The Consumer Staples sector gained 3.05% over the previous month, while the S&P 500 lost 7.38%.","Upcoming earnings: predicted EPS of $0.23, a 4.17% decline versus the year-ago quarter.","Upcoming earnings: revenue consensus estimate of $126.06 million, a 12.86% increase versus the year-ago quarter.","Full-year consensus estimates: earnings of $1.13 per share and revenue of $570.13 million, changes of +5.61% and +10.49% versus the preceding year.","Over the past month, the Zacks Consensus EPS estimate moved 2.86% lower.","COCO\u2019s Zacks Rank is #3 (Hold).","COCO\u2019s forward P/E is 30.85 versus the industry average forward P/E of 18.59.","COCO\u2019s PEG ratio is 1.92; the Beverages - Soft drinks industry average PEG ratio is 2.53.","The Beverages - Soft drinks industry has a Zacks Industry Rank of 66 (top 27% of 250+ industries, per article)."],"numeric_claims":[{"label":"COCO close (latest trading day)","value":"$34.54"},{"label":"COCO daily change","value":"-1.06%"},{"label":"S&P 500 daily loss","value":"0.91%"},{"label":"Dow daily change","value":"-1.5%"},{"label":"Nasdaq daily change","value":"-1.96%"},{"label":"COCO 1-month change","value":"-12.24%"},{"label":"Consumer Staples 1-month change","value":"+3.05%"},{"label":"S&P 500 1-month change","value":"-7.38%"},{"label":"Predicted EPS (next quarter)","value":"$0.23"},{"label":"Predicted EPS YoY change","value":"-4.17%"},{"label":"Revenue consensus (next quarter)","value":"$126.06 million"},{"label":"Revenue YoY change","value":"+12.86%"},{"label":"Full-year EPS consensus","value":"$1.13"},{"label":"Full-year EPS YoY change","value":"+5.61%"},{"label":"Full-year revenue consensus","value":"$570.13 million"},{"label":"Full-year revenue YoY change","value":"+10.49%"},{"label":"Zacks Consensus EPS estimate change (past month)","value":"-2.86%"},{"label":"Forward P/E","value":"30.85"},{"label":"Industry average forward P/E","value":"18.59"},{"label":"PEG ratio","value":"1.92"},{"label":"Industry average PEG ratio","value":"2.53"}],"primary_claim":"COCO closed at $34.54, a -1.06% change from the prior session, lagging the S&P 500\u2019s -0.91% daily loss.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"Vita Coco Company, Inc. (COCO) closed the latest trading day down 1.06% to $34.54, underperforming the S&P 500 and major indices. The article also cites upcoming earnings expectations and recent analyst estimate changes, with COCO rated a Zacks Rank #3 (Hold).","topics":["stock performance","market indices","earnings expectations","analyst estimate revisions","valuation metrics","Zacks Rank"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"Vita Coco Company, Inc. (COCO) closed the most recent trading day at $47.47, moving 1.76% from the previous trading session.","tickers":["COCO"],"title":"Vita Coco Company, Inc. (COCO) Registers a Bigger Fall Than the Market: Important Facts to Note","url":"https://www.nasdaq.com/articles/vita-coco-company-inc-coco-registers-bigger-fall-market-important-facts-note"}}

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