Create
Query
event_store.db
—
signals
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 sig_dac32aba2568 in signals
id
sig_dac32aba2568
Primary key.
TEXT
event_id
12407
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson","as_of":"2026-04-09T21:31:27.529333+00:00","canonical_url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson","article_chars":3843,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_273a2ea36987ac06","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T01:52:03.567672+00:00","extraction_method":"heuristic","fetched_description":"In the latest look at the underlying components of the S&P 500 ordered by largest market capitalization, Republic Services Inc (Symbol: RSG) has taken over the #225 spot from Becton, Dickinson & Co (Symbol: BDX), according to The Online Investor. Market capitalizatio","fetched_title":"Republic Services Takes Over #225 Spot From Becton, Dickinson | Nasdaq","final_url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson","source_event_id":"evt_ea0524d90fac","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7efba1223f8ab4d7","kind":"unusual_volume","published_at":"2026-04-09T20:40:23+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["April 09, 2026"],"entities":[{"asset_class":"equity","name":"Republic Services Inc","relevance":"high","symbol":"RSG","type":"company"},{"asset_class":"equity","name":"Becton, Dickinson & Co","relevance":"high","symbol":"BDX","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"}],"event_type":"other","information_gaps":["The signal type is discovery_unusual_volume_delta, but the provided text contains no unusual volume ratio, baseline volume, or volume delta details.","No explicit catalyst is described for the ranking change beyond the implied market-cap difference.","The article does not state whether the ranking change is confirmed by other news sources; it attributes the ranking to The Online Investor."],"key_facts":["The article states RSG took over the #225 spot from BDX in an S&P 500 market-cap ranking.","RSG market capitalization is given as $66.89 billion.","BDX market capitalization is given as $44.73 billion.","At the closing bell, RSG is up about 0.2% on the day Thursday.","At the closing bell, BDX is off about 0.9% on the day Thursday."],"numeric_claims":[{"label":"RSG market cap (billion USD)","value":"66.89"},{"label":"BDX market cap (billion USD)","value":"44.73"},{"label":"RSG daily move at close","value":"up ~0.2%"},{"label":"BDX daily move at close","value":"down ~0.9%"}],"primary_claim":"Republic Services Inc (RSG) has taken over the #225 spot from Becton, Dickinson & Co (BDX) in the S&P 500 market-cap ranking, with RSG at $66.89B vs BDX at $44.73B.","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"Republic Services (RSG) moved up to the #225 spot in S&P 500 size ranking by market capitalization, replacing Becton, Dickinson (BDX). The article cites RSG market cap of $66.89B versus BDX at $44.73B and notes same-day price moves.","topics":["S&P 500 constituents/rankings","market capitalization","stock relative performance"]},"source":"Nasdaq Markets","source_domain":"nasdaq.com","summary":"In the latest look at the underlying components of the S&P 500 ordered by largest market capitalization, Republic Services Inc (Symbol: RSG) has taken over the #225 spot from Becton, Dickinson & Co (Symbol: BDX), according to The Online Investor. Market capitalizatio","tickers":[],"title":"Republic Services Takes Over #225 Spot From Becton, Dickinson","url":"https://www.nasdaq.com/articles/republic-services-takes-over-225-spot-becton-dickinson"}
TEXT NOT NULL
threshold
NULL
TEXT
direction
NULL
TEXT
severity
NULL
TEXT
window
NULL
TEXT
source
discovery_ingestor
TEXT NOT NULL
reason_trace
{"_evidence_event_ids":["evt_ea0524d90fac"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:083249ecabc90e1d
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-09T21:31:27.529333+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel