Create
Query
event_store.db
—
signals
actions
approvals
artifacts
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
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 sig_229be07a729d in signals
id
sig_229be07a729d
Primary key.
TEXT
event_id
12172
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/it-time-give-trade-desk-stock","as_of":"2026-04-09T18:05:02.959642+00:00","canonical_url":"https://www.fool.com/investing/2026/04/09/is-it-time-to-give-up-on-the-trade-desk-stock/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/it-time-give-trade-desk-stock","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_91402ebb158d9e5f","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/09/is-it-time-to-give-up-on-the-trade-desk-stock/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:29:17.697540+00:00","extraction_method":"heuristic","fetched_description":"Key PointsThe business remains strong, but challenges lie ahead.","fetched_title":"Is It Time to Give Up on The Trade Desk Stock? | Nasdaq","final_url":"https://www.nasdaq.com/articles/it-time-give-trade-desk-stock","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/it-time-give-trade-desk-stock","source_event_id":"evt_831944487efc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b70484ecc92587b7","kind":"unusual_volume","published_at":"2026-04-09T17:20:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 09, 2026"],"entities":[{"asset_class":"equity","name":"The Trade Desk","relevance":"high","symbol":"TTD","type":"company"},{"asset_class":"equity","name":"Amazon","relevance":"medium","symbol":"","type":"company"},{"asset_class":"equity","name":"Alphabet (Google)","relevance":"medium","symbol":"GOOG","type":"company"},{"asset_class":"equity","name":"Meta Platforms","relevance":"medium","symbol":"META","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company"}],"event_type":"other","information_gaps":["The provided signal type is discovery_unusual_volume_delta, but the article text does not include any trading volume ratio, baseline volume, or confirmation that unusual volume occurred.","No explicit catalyst is tied to unusual volume; the article discusses business/market catalysts (competition, missed expectations, restructuring) but does not link them to volume changes.","No specific volume direction (e.g., above/below average) is stated in the provided text."],"key_facts":["The article states TTD\u2019s stock is down by more than 50% in the last 12 months.","The article states TTD revenue grew in the high teens (around 18% year over year) in 2025.","The article states customer retention remained above 95%.","The article states TTD\u2019s Kokai AI-driven platform now powers close to 100% of clients\u2019 advertiser campaigns.","The article states revenue growth in 2025 was weaker than 2024 (2024 revenue grew by 26%).","The article states TTD beat revenue estimates for more than 30 consecutive quarters until a miss in the fourth quarter of 2024.","The article states the miss in Q4 2024 broke investor confidence.","The article states 2025 involved weaker growth and a massive internal restructuring.","The article identifies intensifying competition as the central risk.","The article states Amazon\u2019s advertising business generates more than $60 billion annually and is expanding into DSP space.","The article states Google and Meta continue improving ad platforms using AI and first-party data.","The article states TTD operates as an independent platform helping advertisers buy across the open internet."],"numeric_claims":[{"label":"TTD stock decline","value":"down by more than 50% in the last 12 months"},{"label":"TTD 2025 revenue growth","value":"around 18% year over year"},{"label":"TTD customer retention","value":"above 95%"},{"label":"Kokai campaign coverage","value":"close to 100% of clients\u2019 advertiser campaigns"},{"label":"TTD 2024 revenue growth","value":"26%"},{"label":"Amazon advertising business revenue","value":"more than $60 billion annually"},{"label":"TTD revenue estimate beat streak","value":"more than 30 consecutive quarters"}],"primary_claim":"The Trade Desk\u2019s stock decline is attributed to investors\u2019 expectations changing after missed expectations in Q4 2024, weaker growth and a major internal restructuring in 2025, despite continued revenue growth.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"The Motley Fool article argues that Trade Desk (TTD) is still growing but its stock has fallen sharply, with investor expectations changing due to weaker performance and restructuring. It highlights intensifying competition from Amazon, Google, and Meta as the central risk while noting the open-internet/neutral-platform thesis remains relevant.","topics":["digital advertising","adtech competition","open internet thesis","AI-driven advertising platform (Kokai)","investor expectations","stock performance decline","restructuring"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsThe business remains strong, but challenges lie ahead.","tickers":[],"title":"Is It Time to Give Up on The Trade Desk Stock?","url":"https://www.fool.com/investing/2026/04/09/is-it-time-to-give-up-on-the-trade-desk-stock/"}
TEXT NOT NULL
threshold
NULL
TEXT
direction
NULL
TEXT
severity
NULL
TEXT
window
NULL
TEXT
source
discovery_ingestor
TEXT NOT NULL
reason_trace
{"_evidence_event_ids":["evt_831944487efc"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:25dbe64a5fda2fcf
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-09T18:05:02.959642+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel