Create
Query
event_store.db
—
events
actions
agent_runs
approvals
artifacts
attention_candidates
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
intel_narrative_members
intel_narratives
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 475773 in events
seq
Primary key.
INTEGER
id
evt_064bc699d682
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-21T23:24:29.047884+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-21T00:08:29.826903+00:00","dedupe_key":"signal_enriched:discovery_new_listings_delta:ff290ae39030011e","evidence_event_ids":["evt_501e52f915dd"],"signal_type":"discovery_new_listings_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/dicks-sporting-goods-dks-rises-market-takes-dip-key-facts","as_of":"2026-04-21T00:08:29.826903+00:00","canonical_url":"https://www.nasdaq.com/articles/dicks-sporting-goods-dks-rises-market-takes-dip-key-facts","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/dicks-sporting-goods-dks-rises-market-takes-dip-key-facts","article_chars":4158,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_76b35d2764806a7a","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/dicks-sporting-goods-dks-rises-market-takes-dip-key-facts","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:24:29.047834+00:00","extraction_method":"trafilatura","fetched_description":"Dick's Sporting Goods (DKS) closed the most recent trading day at $230.62, moving +2.79% from the previous trading session.","fetched_title":"Dick's Sporting Goods (DKS) Rises As Market Takes a Dip: Key Facts | Nasdaq","final_url":"https://www.nasdaq.com/articles/dicks-sporting-goods-dks-rises-market-takes-dip-key-facts","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/dicks-sporting-goods-dks-rises-market-takes-dip-key-facts","source_event_id":"evt_501e52f915dd","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"eaf5c32c99988bec","kind":"new_listings","published_at":"2026-04-20T22:15:06+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Dick's Sporting Goods","relevance":"high","symbol":"DKS","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 Rank","relevance":"medium","symbol":"","type":"rating_model"}],"event_type":"earnings","information_gaps":["The signal type mentions 'new listings delta', but the provided text contains no information about any new listings or listing changes.","The article does not specify the exact date of the 'recent trading session' or the upcoming earnings release date.","No details are provided on the magnitude/direction of analyst estimate revisions beyond the stated 0.52% EPS projection increase over 30 days.","The 'Radical New Technology' section is promotional and does not provide verifiable, company-specific facts tied to DKS within the provided text."],"key_facts":["DKS closed at $230.62.","DKS was up +2.79% versus the preceding day's closing price.","S&P 500 daily loss was 0.24%; Dow lost 0.01%; Nasdaq lost 0.26%.","DKS had gained 18.08% over the past month.","Retail-Wholesale sector gained 7.72% over the past month; S&P 500 gained 6.42%.","Upcoming EPS is projected at $2.93, a 13.06% drop versus the same quarter last year.","Most recent consensus revenue estimate is $5.01 billion, a 57.96% increase versus the same quarter last year.","Full-year Zacks Consensus Estimates: earnings of $14.33 per share and revenue of $22.24 billion.","Implied full-year year-over-year changes: earnings -1.71% and revenue +29.2%.","Within the past 30 days, consensus EPS projection moved 0.52% higher.","Current Zacks Rank for DKS is #4 (Sell).","Forward P/E is 15.66; industry average Forward P/E is 15.95.","PEG ratio is 3.18; Retail-Miscellaneous industry PEG ratio is 1.94.","Zacks Industry Rank is 149, described as within the bottom 39% of over 250 industries."],"numeric_claims":[{"label":"DKS close price (USD)","value":"230.62"},{"label":"Daily change (%)","value":"+2.79%"},{"label":"S&P 500 daily loss (%)","value":"0.24"},{"label":"Dow daily loss (%)","value":"0.01"},{"label":"Nasdaq daily loss (%)","value":"0.26"},{"label":"DKS 1-month gain (%)","value":"18.08"},{"label":"Retail-Wholesale sector 1-month gain (%)","value":"7.72"},{"label":"S&P 500 1-month gain (%)","value":"6.42"},{"label":"Upcoming EPS (USD)","value":"2.93"},{"label":"Upcoming EPS YoY change (%)","value":"-13.06"},{"label":"Upcoming revenue (USD)","value":"5.01 billion"},{"label":"Upcoming revenue YoY change (%)","value":"+57.96"},{"label":"Full-year earnings estimate (USD/share)","value":"14.33"},{"label":"Full-year revenue estimate (USD)","value":"22.24 billion"},{"label":"Full-year earnings YoY change (%)","value":"-1.71"},{"label":"Full-year revenue YoY change (%)","value":"+29.2"},{"label":"Consensus EPS change in past 30 days (%)","value":"+0.52"},{"label":"Zacks Rank","value":"4"},{"label":"Forward P/E","value":"15.66"},{"label":"Industry average Forward P/E","value":"15.95"},{"label":"PEG ratio","value":"3.18"},{"label":"Industry PEG ratio","value":"1.94"},{"label":"Zacks Industry Rank","value":"149"}],"primary_claim":"DKS closed at $230.62, representing a +2.79% move from the prior session.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Dick's Sporting Goods (DKS) closed at $230.62, up 2.79% on the day, outperforming major U.S. indexes that were down. The article highlights upcoming earnings expectations and recent consensus estimate changes, with DKS currently rated a Zacks Rank #4 (Sell).","topics":["stock performance","market comparison","earnings expectations","analyst estimate revisions","valuation metrics","Zacks Rank"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"Dick's Sporting Goods (DKS) closed the most recent trading day at $230.62, moving +2.79% from the previous trading session.","tickers":["DKS"],"title":"Dick's Sporting Goods (DKS) Rises As Market Takes a Dip: Key Facts","url":"https://www.nasdaq.com/articles/dicks-sporting-goods-dks-rises-market-takes-dip-key-facts"}}
TEXT NOT NULL
source_ref
candidate:sc_76b35d2764806a7a
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_new_listings_delta:ff290ae39030011e
TEXT
episode_id
NULL
TEXT
created_at
2026-04-21T23:24:29.047952+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel