SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/icon-iclr-q1-2025-earnings-call-transcript","as_of":"2026-04-20T14:11:25.277652+00:00","canonical_url":"https://www.fool.com/earnings/call-transcripts/2026/04/20/icon-iclr-q1-2025-earnings-call-transcript/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/icon-iclr-q1-2025-earnings-call-transcript","article_chars":133,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_5b5dd0173525c6f5","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/earnings/call-transcripts/2026/04/20/icon-iclr-q1-2025-earnings-call-transcript/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-20T14:13:20.015371+00:00","extraction_method":"trafilatura","fetched_description":"@media (max-width: 768px) { .image-container { width: 100% !important; float: none !important; margin: 0 0 1rem 0 !important; } } Image source: The Mo","fetched_title":"ICON (ICLR) Q1 2025 Earnings Call Transcript | Nasdaq","final_url":"https://www.nasdaq.com/articles/icon-iclr-q1-2025-earnings-call-transcript","html_truncated":true,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/icon-iclr-q1-2025-earnings-call-transcript","source_event_id":"evt_a087430498e8","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"407358d3b64f0b78","kind":"unusual_volume","published_at":"2026-04-20T13:31:57+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":["Q1 2025"],"entities":[{"asset_class":"equity","name":"ICON (ICLR)","relevance":"mentioned in headline only","symbol":"ICLR","type":"company"},{"asset_class":"other","name":"Nasdaq, Inc.","relevance":"mentioned in disclaimer","symbol":"","type":"publisher"}],"event_type":"earnings","information_gaps":["Unusual volume delta is not described in the provided text.","No volume ratio vs average is provided.","No baseline volume or direction (higher/lower) is provided.","No catalyst hypothesis is provided or supported by the provided text.","The source summary appears truncated and does not include the relevant volume information."],"key_facts":["Headline references ICON (ICLR) Q1 2025 Earnings Call Transcript.","Body text provided is only a disclaimer: views/opinions expressed are those of the author and do not necessarily reflect those of Nasdaq, Inc."],"numeric_claims":[],"primary_claim":"No unusual volume delta details (ticker, volume ratio vs average, or catalyst) are present in the provided text.","relevance_score":0.15,"sentiment":"neutral","source_quality":"unknown","summary":"The provided text contains only a generic disclaimer and does not include any information about unusual trading volume, volume ratio, or catalysts.","topics":["earnings call transcript","disclaimer text"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"@media (max-width: 768px) { .image-container { width: 100% !important; float: none !important; margin: 0 0 1rem 0 !important; } } Image source: The Mo","tickers":["ICLR"],"title":"ICON (ICLR) Q1 2025 Earnings Call Transcript","url":"https://www.fool.com/earnings/call-transcripts/2026/04/20/icon-iclr-q1-2025-earnings-call-transcript/"}

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

event_store.db — signals

Update row sig_046995d7db0e in signals