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 477640 in events
seq
Primary key.
INTEGER
id
evt_45a1f4755057
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-22T01:03:30.004332+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-22T01:02:27.838680+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:f3fc016e8fef22d6","evidence_event_ids":["evt_d34227c61126"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/prediction-small-little-known-stock-could-skyrocket-driven-post-iran-war-rebuilding-and","as_of":"2026-04-22T01:02:27.838680+00:00","canonical_url":"https://www.fool.com/investing/2026/04/21/ppih-stock-small-cap-data-center-iran-war-stocks/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/prediction-small-little-known-stock-could-skyrocket-driven-post-iran-war-rebuilding-and","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_64392925278ebc53","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/21/ppih-stock-small-cap-data-center-iran-war-stocks/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T01:03:29.992535+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsWhen the Iran war ends, the Middle East will face major, long-lasting rebuilding needs, as its infrastructure has been severely damaged.","fetched_title":"Prediction: This Small, Little-Known Stock Could Skyrocket, Driven By Post-Iran War Rebuilding and Surging AI Data Center Buildouts | Nasdaq","final_url":"https://www.nasdaq.com/articles/prediction-small-little-known-stock-could-skyrocket-driven-post-iran-war-rebuilding-and","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/prediction-small-little-known-stock-could-skyrocket-driven-post-iran-war-rebuilding-and","source_event_id":"evt_d34227c61126","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"125490c02ae5d1ec","kind":"unusual_volume","published_at":"2026-04-22T00:33:30+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["Feb. 28 (year not specified)","September 2025","Jan. 31, 2026"],"entities":[{"asset_class":"equity","name":"Perma-Pipe International","relevance":"high","symbol":"PPIH","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"medium","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"medium","symbol":"INTC","type":"company"},{"asset_class":"equity","name":"Saudi Aramco","relevance":"medium","symbol":"","type":"company"},{"asset_class":"other","name":"U.S. Department of Energy","relevance":"low","symbol":"","type":"government agency"}],"event_type":"other","information_gaps":["No unusual volume ratio vs average is provided in the supplied text (baseline volume, current volume, and volume ratio are missing).","The signal\u2019s \u201cconfirmed by news vs unexplained\u201d aspect is not addressed; the article is a promotional/bullish thesis and does not explicitly attribute any volume spike to a specific news release on the same day.","The catalyst hypothesis for the volume delta cannot be grounded because the volume data itself is absent; only general catalysts (rebuilding thesis, AI cooling market, and Sep 2025 Saudi Aramco approval) are described."],"key_facts":["The article states that when the Iran war ends, the Middle East will face major, long-lasting rebuilding needs due to infrastructure damage (contextual claim).","The article claims Perma-Pipe (PPIH) is positioned to secure rebuilding work across oil and gas and district energy markets.","The article claims Perma-Pipe is benefiting from entry into the global cooling systems market for AI-enabled data centers.","The article describes Perma-Pipe as a global leader in engineered pipe services, including insulation solutions, containment systems, anti-corrosion coatings, engineering support, custom fabrication, and leak detection technology.","The article states Perma-Pipe\u2019s newest end market is AI-enabled data center cooling systems.","The article states Perma-Pipe has 14 operating locations across seven countries, with concentration in the U.S., Canada, and the Middle East.","The article provides a revenue breakdown for the fiscal year ended Jan. 31, 2026: U.S. 28%, Canada 23%, UAE 22%, Saudi Arabia 22%, Other 5%.","The article states that in September 2025, Perma-Pipe announced its Saudi business unit received formal technical and commercial approval from Saudi Aramco, expanding opportunities to directly serve the oil and gas sector and participate in Saudi Arabia\u2019s pipe coating market.","The article states Perma-Pipe is cash flow positive, insiders own nearly 11% of shares, trailing-12-month P/E is 14.4, and debt-to-equity is manageable (as presented in the article)."],"numeric_claims":[{"label":"Insider ownership","value":"nearly 11% (as stated)"},{"label":"Trailing-12-month P/E","value":"14.4 (as stated)"},{"label":"Market cap","value":"under $300 million (as stated)"},{"label":"Operating locations","value":"14 (as stated)"},{"label":"Countries with operating locations","value":"7 (as stated)"},{"label":"Revenue FY ended Jan. 31, 2026 - U.S.","value":"28%"},{"label":"Revenue FY ended Jan. 31, 2026 - Canada","value":"23%"},{"label":"Revenue FY ended Jan. 31, 2026 - UAE","value":"22%"},{"label":"Revenue FY ended Jan. 31, 2026 - Saudi Arabia","value":"22%"},{"label":"Revenue FY ended Jan. 31, 2026 - Other","value":"5%"}],"primary_claim":"Perma-Pipe International (PPIH) is positioned to benefit from post-Iran-war Middle East rebuilding and from surging AI-enabled data center buildouts, which the article claims are multiyear catalysts for growth.","relevance_score":0.55,"sentiment":"positive","source_quality":"high","summary":"The signal is a bullish article about Perma-Pipe International (NASDAQ: PPIH), arguing the stock could rise on Middle East rebuilding after the Iran war and on growth in AI-enabled data center cooling systems. The provided text does not include any unusual trading volume metrics, so the \u201cunusual volume delta\u201d portion cannot be quantified from this content.","topics":["unusual trading volume (not provided)","microcap growth thesis","Middle East rebuilding","Iran war aftermath (context)","oil and gas engineered pipe services","district energy","AI data center cooling systems","Saudi Aramco approval (Sep 2025)"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsWhen the Iran war ends, the Middle East will face major, long-lasting rebuilding needs, as its infrastructure has been severely damaged.","tickers":[],"title":"Prediction: This Small, Little-Known Stock Could Skyrocket, Driven By Post-Iran War Rebuilding and Surging AI Data Center Buildouts","url":"https://www.fool.com/investing/2026/04/21/ppih-stock-small-cap-data-center-iran-war-stocks/"}}
TEXT NOT NULL
source_ref
candidate:sc_64392925278ebc53
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:f3fc016e8fef22d6
TEXT
episode_id
NULL
TEXT
created_at
2026-04-22T01:03:30.012447+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel