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/firstservice-fsv-q3-2024-earnings-transcript","as_of":"2026-04-14T17:20:03.235758+00:00","canonical_url":"https://www.fool.com/earnings/call-transcripts/2026/04/14/firstservice-fsv-q3-2024-earnings-transcript/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/firstservice-fsv-q3-2024-earnings-transcript","article_chars":626,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_3352896e18349420","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/earnings/call-transcripts/2026/04/14/firstservice-fsv-q3-2024-earnings-transcript/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-15T01:58:00.538947+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":"FirstService (FSV) Q3 2024 Earnings Transcript | Nasdaq","final_url":"https://www.nasdaq.com/articles/firstservice-fsv-q3-2024-earnings-transcript","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/firstservice-fsv-q3-2024-earnings-transcript","source_event_id":"evt_f2b9d3b40a74","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"dc32ac90941da599","kind":"unusual_volume","published_at":"2026-04-14T16:17:16+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.6,"dates_mentioned":["Q3 2024"],"entities":[{"asset_class":"equity","name":"FirstService","relevance":"high","symbol":"FSV","type":"company"}],"event_type":"earnings","information_gaps":["Unusual volume ratio vs average is not provided (baseline_volume and volume_ratio are null).","Direction of volume change (increase/decrease) is not provided.","Whether the volume move is confirmed by news is not stated in the provided text.","Any catalyst hypothesis for the volume change is not provided.","The article text appears to be a generic Nasdaq/cookie snippet rather than the earnings transcript content."],"key_facts":["Headline indicates \u201cFirstService (FSV) Q3 2024 Earnings Transcript.\u201d","The cleaned article text contains only Nasdaq watchlist/real-time data availability and cookie consent text.","No trading volume figures or volume-vs-average ratio are included in the provided text."],"numeric_claims":[],"primary_claim":"No volume ratio, baseline volume, or catalyst information for ticker FSV is present in the provided text.","relevance_score":0.2,"sentiment":"neutral","source_quality":"low","summary":"The provided content does not include any unusual trading volume data for FirstService (FSV); it only shows a Nasdaq watchlist/cookies page snippet and a headline referencing an earnings transcript.","topics":["earnings transcript","Nasdaq page snippet","unusual volume delta (not provided)"]},"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":["FSV"],"title":"FirstService (FSV) Q3 2024 Earnings Transcript","url":"https://www.fool.com/earnings/call-transcripts/2026/04/14/firstservice-fsv-q3-2024-earnings-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_9a8984d1fe25 in signals