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/ptlc-etf-outflow-alert","as_of":"2026-04-08T19:57:42.365437+00:00","canonical_url":"https://www.nasdaq.com/articles/ptlc-etf-outflow-alert","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/ptlc-etf-outflow-alert","article_chars":3044,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_5b83c60b03545022","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/ptlc-etf-outflow-alert","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T22:37:08.922371+00:00","extraction_method":"heuristic","fetched_description":"Looking today at week-over-week shares outstanding changes among the universe of ETFs covered at ETF Channel, one standout is the PTLC ETF (Symbol: PTLC) where we have detected an approximate $523.0 million dollar outflow -- that's a 14.7% decrease week over week (from 67,400,0","fetched_title":"PTLC: ETF Outflow Alert | Nasdaq","final_url":"https://www.nasdaq.com/articles/ptlc-etf-outflow-alert","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/ptlc-etf-outflow-alert","source_event_id":"evt_5d0d44c6ca53","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"40f292ed09fb8283","kind":"sector_rotation","published_at":"2026-04-08T14:52:36+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 08, 2026","10:52 am EDT"],"entities":[{"asset_class":"ETF","name":"PTLC ETF","relevance":"high","symbol":"PTLC","type":"etf"}],"event_type":"price_action","information_gaps":["No sector-level information is provided (no explicit sectors gaining/losing).","No macro driver is identified in the text.","No explicit determination is made whether this is a regime shift versus short-term rebalancing.","The article mentions \u201c9 other ETFs experienced notable outflows,\u201d but does not list them in the provided text.","The article includes a list of stock tickers at the top, but does not state which are PTLC holdings or which sectors they represent."],"key_facts":["The article monitors week-over-week changes in ETF shares outstanding to identify notable inflows (units created) and outflows (units destroyed).","PTLC (Symbol: PTLC) is reported to have an approximate $523.0 million outflow week over week.","PTLC shares outstanding decreased by 14.7% week over week, from 67,400,000 to 57,500,000.","The article references PTLC\u2019s one-year price performance versus its 200-day moving average.","PTLC\u2019s 52-week low is $47.13 and 52-week high is $56.975; last trade is $53.41."],"numeric_claims":[{"label":"Outflow (approx.)","value":"$523.0 million"},{"label":"Week-over-week decrease","value":"14.7%"},{"label":"Shares outstanding (week start)","value":"67,400,000"},{"label":"Shares outstanding (week end)","value":"57,500,000"},{"label":"52-week low","value":"$47.13"},{"label":"52-week high","value":"$56.975"},{"label":"Last trade","value":"$53.41"}],"primary_claim":"PTLC saw an approximate $523.0 million outflow week over week, corresponding to a 14.7% decrease in shares outstanding (from 67,400,000 to 57,500,000).","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"The PTLC ETF (PTLC) experienced a notable week-over-week outflow, with shares outstanding falling by about $523.0 million (down 14.7%). The article does not provide evidence of sector-level gains/losses or a broader rotation regime shift.","topics":["ETF flows","shares outstanding changes","PTLC","unit creation/destruction mechanics","technical reference (200-day moving average)"]},"source":"Nasdaq ETFs","source_domain":"nasdaq.com","summary":"Looking today at week-over-week shares outstanding changes among the universe of ETFs covered at ETF Channel, one standout is the PTLC ETF (Symbol: PTLC) where we have detected an approximate $523.0 million dollar outflow -- that's a 14.7% decrease week over week (from 67,400,0","tickers":[],"title":"PTLC: ETF Outflow Alert","url":"https://www.nasdaq.com/articles/ptlc-etf-outflow-alert"}

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_208d9a737891 in signals