Create
Query
event_store.db
—
events
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 11641 in events
seq
Primary key.
INTEGER
id
evt_cb4474f441f1
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-10T00:54:41.776431+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-09T15:06:58.940339+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:61242f44ec0feb3c","evidence_event_ids":["evt_361bd153959a"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/etracs-monthly-pay-2xleveraged-preferred-stock-etn-about-put-more-money-your-pocket-pffl","as_of":"2026-04-09T15:06:58.940339+00:00","canonical_url":"https://www.nasdaq.com/articles/etracs-monthly-pay-2xleveraged-preferred-stock-etn-about-put-more-money-your-pocket-pffl","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/etracs-monthly-pay-2xleveraged-preferred-stock-etn-about-put-more-money-your-pocket-pffl","article_chars":2838,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_1e81debe533a9178","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/etracs-monthly-pay-2xleveraged-preferred-stock-etn-about-put-more-money-your-pocket-pffl","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T00:54:41.776377+00:00","extraction_method":"heuristic","fetched_description":"Looking at the universe of Exchange Traded Funds (ETFs) we cover at ETF Channel, on 4/13/26, ETRACS Monthly Pay 2xLeveraged Preferred Stock ETN (Symbol: PFFL) will trade ex-dividend, for its monthly dividend of $0.0407, payable on 4/21/26. As a percentage of PFFL's recent stock","fetched_title":"ETRACS Monthly Pay 2xLeveraged Preferred Stock ETN About To Put More Money In Your Pocket (PFFL) | Nasdaq","final_url":"https://www.nasdaq.com/articles/etracs-monthly-pay-2xleveraged-preferred-stock-etn-about-put-more-money-your-pocket-pffl","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/etracs-monthly-pay-2xleveraged-preferred-stock-etn-about-put-more-money-your-pocket-pffl","source_event_id":"evt_361bd153959a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"679f0ee6974f4b52","kind":"sector_rotation","published_at":"2026-04-09T14:11:53+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["4/13/26","4/21/26","April 09, 2026"],"entities":[{"asset_class":"ETN","name":"ETRACS Monthly Pay 2xLeveraged Preferred Stock ETN","relevance":"high","symbol":"PFFL","type":"fund"},{"asset_class":"ETN","name":"PFFL","relevance":"high","symbol":"PFFL","type":"ticker"}],"event_type":"other","information_gaps":["No sector rotation details are provided (no sectors identified as gaining or losing).","No macro driver is described.","No evidence is given to classify the move as a regime shift vs short-term rebalancing; the content is limited to PFFL dividend/ex-dividend mechanics."],"key_facts":["PFFL (ETRACS Monthly Pay 2xLeveraged Preferred Stock ETN) will trade ex-dividend on 4/13/26.","PFFL\u2019s monthly dividend is $0.0407 and is payable on 4/21/26.","Using a recent stock price of $7.96, the dividend is approximately 0.51% of price.","The article says shares may trade about 0.51% lower at the open on 4/13/26, all else being equal.","The article states an estimated annualized yield of 6.14%.","In Thursday trading, PFFL shares are currently up about 1.7% on the day."],"numeric_claims":[{"label":"monthly_dividend","value":"$0.0407"},{"label":"ex_dividend_date","value":"2026-04-13"},{"label":"payable_date","value":"2026-04-21"},{"label":"recent_stock_price_used","value":"$7.96"},{"label":"dividend_as_percent_of_price","value":"~0.51%"},{"label":"estimated_annualized_yield","value":"6.14%"},{"label":"intraday_move_reported","value":"~+1.7%"}],"primary_claim":"On 4/13/26, PFFL is expected to trade about 0.51% lower at the open due to its $0.0407 monthly dividend (ex-dividend on 4/13/26; payable 4/21/26).","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"The article is about ETRACS Monthly Pay 2xLeveraged Preferred Stock ETN (PFFL) going ex-dividend and the expected dividend impact on its share price. It does not provide any sector rotation (gaining/losing sectors) information.","topics":["dividend calendar","ex-dividend date","ETN dividend yield","price impact around ex-dividend"]},"source":"Nasdaq ETFs","source_domain":"nasdaq.com","summary":"Looking at the universe of Exchange Traded Funds (ETFs) we cover at ETF Channel, on 4/13/26, ETRACS Monthly Pay 2xLeveraged Preferred Stock ETN (Symbol: PFFL) will trade ex-dividend, for its monthly dividend of $0.0407, payable on 4/21/26. As a percentage of PFFL's recent stock","tickers":["PFFL"],"title":"ETRACS Monthly Pay 2xLeveraged Preferred Stock ETN About To Put More Money In Your Pocket (PFFL)","url":"https://www.nasdaq.com/articles/etracs-monthly-pay-2xleveraged-preferred-stock-etn-about-put-more-money-your-pocket-pffl"}}
TEXT NOT NULL
source_ref
candidate:sc_1e81debe533a9178
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_sector_rotation_delta:61242f44ec0feb3c
TEXT
episode_id
NULL
TEXT
created_at
2026-04-10T00:54:41.776487+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel