Create
Query
event_store.db
—
events
actions
agent_runs
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
intel_memory
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 344232 in events
seq
Primary key.
INTEGER
id
evt_8d0c64e530d3
TEXT NOT NULL
kind
artifact_upsert
TEXT NOT NULL
ts
2026-04-19T22:00:17.240868+00:00
TEXT NOT NULL
actor
planner
TEXT
subject_entity_ids
[]
TEXT
payload
{"artifact_id":"art_weekly_review_2026-04-13","confidence":0.9,"created_at":"2026-04-19T22:00:17.240868+00:00","evidence_event_ids":["evt_2f8fa6f9c2e0","evt_37a7b8ca1e34","evt_2101b79ac821","evt_cbab13bc2035","evt_90ad2d7fde66","evt_1b669c62e663","evt_04c25dc31788","evt_0cd6d217a272","evt_e1a623d03261","evt_999ac05deafa","evt_4f6e8df699d9","evt_c26e9e5409f3","evt_e36d2957ef39","evt_d5711864d1c3","evt_13437a392a51","evt_dd894b93fcaa"],"kind":"weekly_review","meta":{"fingerprint":"dc2a6dde5c9575b85604f02c79dc1d435d36d021","planner_model":"gpt-5.4-nano","source":"planner","week_end":"2026-04-19","week_start":"2026-04-13","weekly_synthesis_source":"llm"},"output_json":{"items":[{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":"commitment:0f99474c06","headline":"User approved starting an agent run to search for Atlanta date-night restaurants. (commitment)","id":"commitment:0f99474c06","kind":"commitment","links":{"deadline":"","scope":"commitment"},"next_touch_at_iso":null,"route":"plan","score":44.0,"score_hint":4.0,"source_kind":"commitment","tags":["commitment","commitment"],"ts":"2026-04-16T19:36:37.744926+00:00","urgency":"medium","user_visible":true,"waiting_on":null,"why_it_matters":"Open commitment in commitment."},{"actionable":true,"blocked_reason":null,"deadline_at_iso":null,"entity_ref":null,"headline":"News claim about Saylor/BTC $1B buy at ~71.9k avg lacks primary transaction proof","id":"sig:7e92950e03d585b4","kind":"inbox","links":{"dedupe_key":"intel_alert_signal:isk_7a80fd7e13132da3e18b:20260414_1030","evidence_event_ids":["evt_c7520a2737ee"],"reason_trace":{},"severity":"high","signal_id":"sig_6d7b4dafe60d","signal_type":"intel_alert","source":"intel_digest","topic_key":"signal:intel_alert:d59ca58d1f3fb481","triage":{"action_hints":["schedule review to verify claim against primary sources or reputable filings before treating as fact"],"confidence":0.62,"disposition":"park","entity_ids":[],"headline":"News claim about Saylor/BTC $1B buy at ~71.9k avg lacks primary transaction proof","prior":{"family":"general","importance_band":"background","suggested_disposition":"park","suggested_route":"review","suggested_urgency":"low"},"priority_score":28.7,"rationale":"The alert is high-severity tagged but the provided text has no primary documentation or exact execution timestamps, so it\u2019s not actionable yet.","review_in_days":30,"route":"review","urgency":"low"},"user_visible":false},"next_touch_at_iso":null,"route":"review","score":20.0,"score_hint":0.0,"source_kind":"signal","tags":["family:general","priority:high","route:review","severity:high","signal","signal:intel_alert","source:intel_digest","triage:park","urgency:low"],"ts":"2026-04-14T12:39:03.706791+00:00","urgency":"low","user_visible":true,"waiting_on":null,"why_it_matters":"The alert is high-severity tagged but the provided text has no primary documentation or exact execution timestamps, so it\u2019s not actionable yet."}],"review":{"next_actions":["commitment:0f99474c06 \u2014 Run the agent to produce a short, decision-ready shortlist (e.g., 5\u20138 options) with price range, cuisine, distance, reservation availability, and a recommended top 2; then conf","sig:7e92950e03d585b4 \u2014 Verify the Saylor/BTC $1B buy claim by locating primary documentation (transaction records, filings, or exact exchange/tx references). If not found, downgrade/close the alert as","(Process) \u2014 Retry the failed opportunity-research snapshots with adjusted query formatting and/or a different provider setting to eliminate the HTTP 400 errors before next week\u2019s research window."],"next_focus_ids":["commitment:0f99474c06","sig:7e92950e03d585b4"],"risks":["sig:7e92950e03d585b4 is currently not actionable because the claim lacks primary transaction proof and exact execution timestamps.","Opportunity research ingestion is failing (HTTP 400) for multiple queries, which can silently block future research outputs."],"source":"llm","summary":"This week is about executing the approved Atlanta date-night restaurant search (agent run) and keeping the rest of the pipeline clean. One market/inbox alert needs verification before it becomes actionable. Separately, multiple opportunity-research snapshots failed due to a provider HTTP 400, so we should adjust queries/inputs or retry with a safer configuration.","theme":"Close the loop on one active commitment; triage low-action signals and fix research ingestion errors.","wins":["commitment:0f99474c06 is approved and ready to execute (agent run for Atlanta date-night restaurants)."]},"signals":[{"created_at":"2026-04-19T21:38:40.613483+00:00","event_id":"evt_2f8fa6f9c2e0","severity":"","signal_type":"market_headlines_snapshot","source":"market_ingestor","value":"{\"as_of\": \"2026-04-19T21:38:40.613483+00:00\", \"headlines\": [{\"fp\": \"59c8f49bd88ca95f\", \"published_at\": \"2026-04-19T18:12:21+00:00\", \"quality_hint\": 1.0, \"source\": \"TechStock\\u00b2\", \"source_domain\": \"ts2.tech\", \"source_url\": \"https://ts2.tech\", \"summary\": \"\", \"tickers\": [], \"title\": \"US Stock Market Week Ahead: Record S&P 500 Rally Faces Iran Risk, Tesla Earnings and Fed Hearing - TechStock\\u00b2\", \"url\": \"https://ne"},{"created_at":"2026-04-19T21:22:56.858448+00:00","event_id":"evt_37a7b8ca1e34","severity":"","signal_type":"opportunity_research_snapshot","source":"opportunity_research_ingestor","value":"{\"as_of\": \"2026-04-19T21:22:56.858448+00:00\", \"bucket\": \"2026-04-19T21:00Z\", \"error\": \"http_status_400\", \"items\": [], \"meta\": {}, \"provider\": \"serper\", \"quality_hint\": 0.6, \"query\": \"silver inflation growth risk policy catalyst next 14 days\", \"source\": \"opportunity_research_ingestor\", \"source_ref\": \"web_search:serper\", \"status\": \"http_400\"}"},{"created_at":"2026-04-19T21:22:56.858448+00:00","event_id":"evt_2101b79ac821","severity":"","signal_type":"opportunity_research_snapshot","source":"opportunity_research_ingestor","value":"{\"as_of\": \"2026-04-19T21:22:56.858448+00:00\", \"bucket\": \"2026-04-19T21:00Z\", \"error\": \"http_status_400\", \"items\": [], \"meta\": {}, \"provider\": \"serper\", \"quality_hint\": 0.6, \"query\": \"gold inflation growth risk policy catalyst next 14 days\", \"source\": \"opportunity_research_ingestor\", \"source_ref\": \"web_search:serper\", \"status\": \"http_400\"}"},{"created_at":"2026-04-19T21:22:56.858448+00:00","event_id":"evt_cbab13bc2035","severity":"","signal_type":"opportunity_research_snapshot","source":"opportunity_research_ingestor","value":"{\"as_of\": \"2026-04-19T21:22:56.858448+00:00\", \"bucket\": \"2026-04-19T21:00Z\", \"error\": \"http_status_400\", \"items\": [], \"meta\": {}, \"provider\": \"serper\", \"quality_hint\": 0.6, \"query\": \"us oil wti geopolitical risk sanctions production outage catalyst next 14 days\", \"source\": \"opportunity_research_ingestor\", \"source_ref\": \"web_search:serper\", \"status\": \"http_400\"}"},{"created_at":"2026-04-19T21:22:56.858448+00:00","event_id":"evt_90ad2d7fde66","severity":"","signal_type":"opportunity_research_snapshot","source":"opportunity_research_ingestor","value":"{\"as_of\": \"2026-04-19T21:22:56.858448+00:00\", \"bucket\": \"2026-04-19T21:00Z\", \"error\": \"http_status_400\", \"items\": [], \"meta\": {}, \"provider\": \"serper\", \"quality_hint\": 0.6, \"query\": \"brent crude geopolitical risk sanctions production outage catalyst next 14 days\", \"source\": \"opportunity_research_ingestor\", \"source_ref\": \"web_search:serper\", \"status\": \"http_400\"}"},{"created_at":"2026-04-19T20:59:34.662387+00:00","event_id":"evt_1b669c62e663","severity":"","signal_type":"market_headlines_snapshot","source":"market_ingestor","value":"{\"as_of\": \"2026-04-19T20:59:34.662387+00:00\", \"headlines\": [{\"fp\": \"59c8f49bd88ca95f\", \"published_at\": \"2026-04-19T18:12:21+00:00\", \"quality_hint\": 1.0, \"source\": \"TechStock\\u00b2\", \"source_domain\": \"ts2.tech\", \"source_url\": \"https://ts2.tech\", \"summary\": \"\", \"tickers\": [], \"title\": \"US Stock Market Week Ahead: Record S&P 500 Rally Faces Iran Risk, Tesla Earnings and Fed Hearing - TechStock\\u00b2\", \"url\": \"https://ne"},{"created_at":"2026-04-19T21:44:00.177469+00:00","event_id":"evt_04c25dc31788","severity":"","signal_type":"discovery_ipo_delta","source":"discovery_ingestor","value":"{\"aggregator_url\": \"https://news.google.com/rss/articles/CBMiiAFBVV95cUxObVRya1hrZmlTWGFqUkRCTWltWjdVcmNCLVNVZTE4VktBZllRbHVXc1A0M3cyMkRQS3hZLXk0Qmc5VFlfeXI5LUM2UXlKLTVYZUwydjhDejZiUTdSUzg5eDJLRWdEWHJVMUx2VkZybTMzV3RUeGRQNlNpRlU1TndTT3NtenZjOVg4?oc=5\", \"as_of\": \"2026-04-19T21:44:00.177469+00:00\", \"canonical_url\": \"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIF"},{"created_at":"2026-04-19T21:44:00.177469+00:00","event_id":"evt_0cd6d217a272","severity":"","signal_type":"discovery_ipo_delta","source":"discovery_ingestor","value":"{\"aggregator_url\": \"https://news.google.com/rss/articles/CBMitgFBVV95cUxNZ181WDJrTXk4eHR4bTBFRGNfSDJIb0lVY0ZsSEtFeWJwNkgxcS1FVjJrb1ZjXzBma0hRVWhMS2x1aWgwYmtFQUNMbmVfN1dfNzhjZVVPeTFiQllSN0lkRjl1bEt1cW85V0dJREQzcW1mSzk1N2ZkMXlVR1FFVWtQTTZrcVR2WVdWc2E1cElPeUZaaUtUQmxqUDRZd3BzUWZyQ1RqclRaaTRTcFBGdFM4OXdlZnE4QQ?oc=5\", \"as_of\": \"2026-04-19T21:44:00.177469+00:00\", \"canonical_url\": \"https://www.gstatic.com/_/mss/boq-dots/_/s"},{"created_at":"2026-04-19T21:44:00.177469+00:00","event_id":"evt_e1a623d03261","severity":"","signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":"{\"aggregator_url\": \"https://news.google.com/rss/articles/CBMi1gFBVV95cUxPYmdtOFJYZmp2d0R0MDdCRDFBMC1OdnVkMFdqVGw3ZGJ2SFRWaml5ZVJUZGh5V01fbjdaN1pKaE1CaS1XdXA0SV8zVmpaRjUydUs1NUJWSFdYSTFsNUo1RjhydG9PUUdRRFBwRjJ2WXVPRkJlelVlVkktUHJFSGF2X0h3ZzJVdGc5cEx0dnBiRmlTUzZ2aHRYYTJlS3BvSmpiSlJjak9aY2FWdzV1N0lkaUJzYjdLZ2N0c08yZUVQRXdGaUdaOTVNM1hpSmxqQnIyMHB5X1h3?oc=5\", \"as_of\": \"2026-04-19T21:44:00.177469+00:00\", \"canonical_url\": \""},{"created_at":"2026-04-19T21:44:00.177469+00:00","event_id":"evt_999ac05deafa","severity":"","signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":"{\"aggregator_url\": \"https://www.nasdaq.com/articles/whats-fueling-enbridge-quick-dive-ahead-its-may-8-earnings-report\", \"as_of\": \"2026-04-19T21:44:00.177469+00:00\", \"canonical_url\": \"https://www.fool.com/investing/2026/04/19/fueling-enbridge-quick-dive-earnings-report/\", \"enrichment\": {\"aggregator_url\": \"https://www.nasdaq.com/articles/whats-fueling-enbridge-quick-dive-ahead-its-may-8-earnings-report\", \"article_chars"},{"created_at":"2026-04-19T21:44:00.177469+00:00","event_id":"evt_4f6e8df699d9","severity":"","signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":"{\"aggregator_url\": \"https://www.nasdaq.com/articles/think-roth-ira-your-best-retirement-savings-tool-2-reasons-its-not-no-brainer\", \"as_of\": \"2026-04-19T21:44:00.177469+00:00\", \"canonical_url\": \"https://www.fool.com/retirement/2026/04/19/think-a-roth-ira-is-your-best-retirement-savings-t/\", \"enrichment\": {\"aggregator_url\": \"https://www.nasdaq.com/articles/think-roth-ira-your-best-retirement-savings-tool-2-reasons-its"},{"created_at":"2026-04-19T21:44:00.177469+00:00","event_id":"evt_c26e9e5409f3","severity":"","signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":"{\"aggregator_url\": \"https://www.nasdaq.com/articles/smartest-dividend-stocks-buy-2000-right-now-2\", \"as_of\": \"2026-04-19T21:44:00.177469+00:00\", \"canonical_url\": \"https://www.fool.com/investing/2025/05/30/the-smartest-dividend-stocks-to-buy-with-2000-righ/\", \"enrichment\": {\"aggregator_url\": \"https://www.nasdaq.com/articles/smartest-dividend-stocks-buy-2000-right-now-2\", \"article_chars\": 5000, \"article_truncated\": tru"},{"created_at":"2026-04-19T21:44:00.177469+00:00","event_id":"evt_e36d2957ef39","severity":"","signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":"{\"aggregator_url\": \"https://www.nasdaq.com/articles/tesla-has-reclaimed-its-spot-leading-global-ev-manufacturer-stock-buy\", \"as_of\": \"2026-04-19T21:44:00.177469+00:00\", \"canonical_url\": \"https://www.fool.com/investing/2026/04/19/tesla-has-reclaimed-its-spot-as-the-leading-global/\", \"enrichment\": {\"aggregator_url\": \"https://www.nasdaq.com/articles/tesla-has-reclaimed-its-spot-leading-global-ev-manufacturer-stock-buy\","},{"created_at":"2026-04-19T21:44:00.160791+00:00","event_id":"evt_d5711864d1c3","severity":"","signal_type":"discovery_earnings_calendar_snapshot","source":"discovery_earnings_calendar","value":"{\"as_of\": \"2026-04-19T21:44:00.160791+00:00\", \"bucket\": \"2026-04-19T21:00Z\", \"items\": [{\"earnings_date\": \"2026-04-21\", \"earnings_time_hint\": \"amc\", \"eps_estimate\": \"0.4915\", \"fp\": \"4fd83ad91a4ed1a4\", \"kind\": \"earnings_calendar\", \"published_at\": \"2026-04-21T00:00:00Z\", \"quality_hint\": 1.0, \"revenue_estimate\": \"194188326\", \"source\": \"earnings_calendar\", \"summary\": \"Earnings date 2026-04-21 \\u00b7 Time amc \\u00b7 EPS es"},{"created_at":"2026-04-19T21:44:00.160791+00:00","event_id":"evt_13437a392a51","severity":"","signal_type":"discovery_sec_filings_snapshot","source":"discovery_sec_filings","value":"{\"as_of\": \"2026-04-19T21:44:00.160791+00:00\", \"bucket\": \"2026-04-19T21:00Z\", \"items\": [{\"company\": \"Zurn Elkay Water Solutions Corp\", \"form_type\": \"4\", \"fp\": \"bf0ae0af7c99bff1\", \"kind\": \"sec_filing\", \"published_at\": \"20260417\", \"quality_hint\": 1.0, \"source\": \"sec_edgar\", \"source_url\": \"https://www.sec.gov/Archives/edgar/data/1439288/0001439288-26-000093.txt\", \"summary\": \"Form 4 \\u00b7 Zurn Elkay Water Solutions Corp "},{"created_at":"2026-04-19T21:44:00.160791+00:00","event_id":"evt_dd894b93fcaa","severity":"","signal_type":"discovery_crypto_extremes_snapshot","source":"discovery_rss","value":"{\"as_of\": \"2026-04-19T21:44:00.160791+00:00\", \"bucket\": \"2026-04-19T21:00Z\", \"items\": [{\"fp\": \"bc98389ad9c29aeb\", \"published_at\": \"2026-04-19T21:29:28+00:00\", \"quality_hint\": 1.0, \"source\": \"Bitcoin.com News\", \"source_url\": \"https://news.bitcoin.com/polymarket-traders-give-bitcoin-31-chance-of-hitting-80000-this-month/\", \"summary\": \"Prediction market traders are putting real money on where bitcoin goes next, and righ"}],"week_end":"2026-04-19","week_start":"2026-04-13"},"output_mrkdwn":"*Weekly Review* \u2014 2026-04-13 to 2026-04-19\n\n*Theme:* Close the loop on one active commitment; triage low-action signals and fix research ingestion errors.\n\nThis week is about executing the approved Atlanta date-night restaurant search (agent run) and keeping the rest of the pipeline clean. One market/inbox alert needs verification before it becomes actionable. Separately, multiple opportunity-research snapshots failed due to a provider HTTP 400, so we should adjust queries/inputs or retry with a safer configuration.\n\n*Wins:*\n\u2022 commitment:0f99474c06 is approved and ready to execute (agent run for Atlanta date-night restaurants).\n\n*Risks:*\n\u2022 sig:7e92950e03d585b4 is currently not actionable because the claim lacks primary transaction proof and exact execution timestamps.\n\u2022 Opportunity research ingestion is failing (HTTP 400) for multiple queries, which can silently block future research outputs.\n\n*Next actions:*\n\u2022 commitment:0f99474c06 \u2014 Run the agent to produce a short, decision-ready shortlist (e.g., 5\u20138 options) with price range, cuisine, distance, reservation availability, and a recommended top 2; then conf\n\u2022 sig:7e92950e03d585b4 \u2014 Verify the Saylor/BTC $1B buy claim by locating primary documentation (transaction records, filings, or exact exchange/tx references). If not found, downgrade/close the alert as\n\u2022 (Process) \u2014 Retry the failed opportunity-research snapshots with adjusted query formatting and/or a different provider setting to eliminate the HTTP 400 errors before next week\u2019s research window.\n\n*Focus items:*\n\u2022 User approved starting an agent run to search for Atlanta date-night restaurants. (commitment)\n\u2022 News claim about Saylor/BTC $1B buy at ~71.9k avg lacks primary transaction proof","ready_at":"2026-04-19T22:00:17.240868+00:00","status":"ready","summary":"Close the loop on one active commitment; triage low-action signals and fix research ingestion errors.","title":"Weekly Review 2026-04-13","updated_at":"2026-04-19T22:00:17.240868+00:00"}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
artifact_upsert:weekly_review:2026-04-13:dc2a6dde5c9575b85604f02c79dc1d435d36d021
TEXT
episode_id
NULL
TEXT
created_at
2026-04-19T22:00:26.143950+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel