Create
Query
event_store.db
—
events
actions
approvals
artifacts
commitments
constraints
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 2555 in events
seq
Primary key.
INTEGER
id
evt_9d0fbb559b7b
TEXT NOT NULL
kind
artifact_upsert
TEXT NOT NULL
ts
2026-04-08T00:46:57.772688+00:00
TEXT NOT NULL
actor
memory_curation
TEXT
subject_entity_ids
[]
TEXT
payload
{"artifact_id":"art_owner_knowledge_pack_2026-04-07","confidence":0.84,"created_at":"2026-04-08T00:46:57.772688+00:00","evidence_event_ids":[],"kind":"owner_knowledge_pack","meta":{"day":"2026-04-07","fingerprint":"039d771778f8","generated_at":"2026-04-08T00:46:57.743750+00:00","source":"memory_curation","version":"v2"},"output_json":{"generated_at":"2026-04-08T00:46:57.743750+00:00","memory_domains":{"commitments":[],"constraints":[],"decisions":[],"open_threads":[],"preferences":[],"projects":[],"recent_events":[{"actor":"slack_compose","event_id":"evt_339df9b6830a","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T00:45:58.985636+00:00"},{"actor":"technical_analyzer","event_id":"evt_e201ec7d3abb","headline":"technical_indicator_signal","kind":"signal_emitted","ts":"2026-04-08T00:28:47.137066+00:00"},{"actor":"technical_analyzer","event_id":"evt_a29758753601","headline":"technical_indicator_signal","kind":"signal_emitted","ts":"2026-04-08T00:28:47.137066+00:00"},{"actor":"technical_analyzer","event_id":"evt_3b0b2a26740d","headline":"technical_indicator_signal","kind":"signal_emitted","ts":"2026-04-08T00:28:47.137066+00:00"},{"actor":"ingestion","event_id":"evt_ef204fc865cb","headline":"integration_failure","kind":"signal_emitted","ts":"2026-04-08T00:28:50.792428+00:00"},{"actor":"slack_compose","event_id":"evt_1c9e08c9896d","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T00:25:50.222737+00:00"},{"actor":"slack_compose","event_id":"evt_009712b5c326","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T00:23:20.022215+00:00"},{"actor":"slack_compose","event_id":"evt_116cd6dd5c1d","headline":null,"kind":"thread_message_recorded","ts":"2026-04-08T00:05:38.420339+00:00"},{"actor":"observability","event_id":"evt_958b7f68c86d","headline":"system_distress","kind":"signal_emitted","ts":"2026-04-08T00:03:24.293228+00:00"},{"actor":"slack_compose","event_id":"evt_0cbd1e7cc136","headline":null,"kind":"thread_message_recorded","ts":"2026-04-07T23:45:27.968482+00:00"},{"actor":"observability","event_id":"evt_ae369d8a33e6","headline":"system_distress","kind":"signal_emitted","ts":"2026-04-07T23:28:16.116640+00:00"},{"actor":"inbox_triage","event_id":"evt_e5f08bae93be","headline":"value","kind":"fact_upsert","ts":"2026-04-07T23:25:39.691788+00:00"},{"actor":"inbox_triage","event_id":"evt_2491c5d20418","headline":"value","kind":"fact_upsert","ts":"2026-04-07T23:25:39.684165+00:00"},{"actor":"slack_compose","event_id":"evt_f7382b1cbb09","headline":null,"kind":"thread_message_recorded","ts":"2026-04-07T23:25:19.766875+00:00"},{"actor":"ingestion","event_id":"evt_430e85797cd0","headline":"integration_failure","kind":"signal_emitted","ts":"2026-04-07T23:25:07.604969+00:00"},{"actor":"slack_compose","event_id":"evt_1a9a76d865c1","headline":null,"kind":"thread_message_recorded","ts":"2026-04-07T23:24:17.505542+00:00"}],"relationships":[],"signals":[{"created_at":"2026-04-08T00:28:47.137066+00:00","event_id":"evt_e201ec7d3abb","reason_trace":{"cutoff_iso":"2026-04-05T00:28:47Z","eligible_timeframes":["1d"],"market_now":"2026-04-07T20:28:47.137087-04:00","period_key":"2026-04-07","recent_signal_hours":72,"signal_timestamp":"2026-04-07T00:00:00Z","strategy":"ema_signals"},"severity":"medium","signal_type":"technical_indicator_signal","source":"technical_analyzer","value":{"bars":600,"confidence":0.591549902564117,"details":{"bars":600,"ema_fast":80.28908835622188,"ema_price":80.28908835622188,"ema_slow":79.99999158185928,"fast_length":12,"fast_slope":0.008521,"price_ema_length":12,"recent_matches":[{"close":82.47000122070312,"ema_fast":74.04322145236553,"ema_price":74.04322145236553,"ema_slow":73.94034115446266,"timestamp":"2025-08-22T00:00:00+00:00","volume":16000000.0},{"close":82.79000091552734,"ema_fast":81.52330716556708,"ema_price":81.52330716556708,"ema_slow":81.46979684225737,"timestamp":"2025-10-23T00:00:00+00:00","volume":3681700.0},{"close":84.95999908447266,"ema_fast":82.72897552074176,"ema_price":82.72897552074176,"ema_slow":82.67002633312258,"timestamp":"2025-11-28T00:00:00+00:00","volume":1517200.0},{"close":95.45999908447266,"ema_fast":85.67427807316571,"ema_price":85.67427807316571,"ema_slow":85.52273283852936,"timestamp":"2026-01-26T00:00:00+00:00","volume":10339500.0},{"close":84.0199966430664,"ema_fast":80.28908835622188,"ema_price":80.28908835622188,"ema_slow":79.99999158185928,"timestamp":"2026-04-07T00:00:00+00:00","volume":3794424.0}],"rel_gap":0.003614,"rel_price_gap":0.046468,"signal":{"close":84.0199966430664,"timestamp":"2026-04-07T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.1858737401671047,"price":84.0199966430664,"recent_buys":[],"recent_sells":[],"signal":{"close":84.0199966430664,"timestamp":"2026-04-07T00:00:00Z"},"signal_kind":"emaCrossUp","strategy":"ema_signals","ticker":"ZM","timeframe":"1d","timeframe_bucket":"daily"}},{"created_at":"2026-04-08T00:28:50.792428+00:00","event_id":"evt_ef204fc865cb","reason_trace":{"collector":"real_estate_macro","error":"HTTPSConnectionPool(host='fred.stlouisfed.org', port=443): Read timed out. (read timeout=12)"},"severity":"high","signal_type":"integration_failure","source":"ingestion","value":{"collector":"real_estate_macro","error":"HTTPSConnectionPool(host='fred.stlouisfed.org', port=443): Read timed out. (read timeout=12)"}},{"created_at":"2026-04-08T00:03:24.293228+00:00","event_id":"evt_958b7f68c86d","reason_trace":null,"severity":"medium","signal_type":"system_distress","source":"observability","value":{"alerts":[{"count":2,"level":"warn","remediation":"Connected sources are degraded or unauthenticated; repair credentials and reduce dependency blast radius.","type":"sources_error"}],"metrics_window_h":24,"type":"observability"}},{"created_at":"2026-04-07T23:28:16.116640+00:00","event_id":"evt_ae369d8a33e6","reason_trace":null,"severity":"medium","signal_type":"system_distress","source":"observability","value":{"alerts":[{"count":2,"level":"warn","remediation":"Connected sources are degraded or unauthenticated; repair credentials and reduce dependency blast radius.","type":"sources_error"}],"metrics_window_h":24,"type":"observability"}},{"created_at":"2026-04-07T23:25:07.604969+00:00","event_id":"evt_430e85797cd0","reason_trace":{"collector":"real_estate_macro","error":"HTTPSConnectionPool(host='fred.stlouisfed.org', port=443): Read timed out. (read timeout=12)"},"severity":"high","signal_type":"integration_failure","source":"ingestion","value":{"collector":"real_estate_macro","error":"HTTPSConnectionPool(host='fred.stlouisfed.org', port=443): Read timed out. (read timeout=12)"}}],"watchlists":[]},"owner":{"entity_id":"person:owner","missing_profile_fields":["top_focus","relationship_priorities","watchlist_tickers","active_projects","commitments","work_focus","checkin_style","preferred_contact_windows","avoidances","seed_objective"],"name":null,"profile":{}},"stats":{"commitments":0,"constraints":0,"decisions":0,"missing_profile_fields":10,"open_threads":0,"preferences":0,"projects":0,"recent_events":16,"relationships":0,"signals":5,"watchlists":0},"timezone":"America/New_York","version":"v2"},"output_mrkdwn":"Knowledge Pack: Owner\nCoverage \u2014 people 0, projects 0, commitments 0, watchlists 0, signals 5, threads 0\nRecent signals: technical_indicator_signal, integration_failure, system_distress, system_distress","ready_at":"2026-04-08T00:46:57.772688+00:00","status":"ready","summary":"Knowledge Pack: Owner\nCoverage \u2014 people 0, projects 0, commitments 0, watchlists 0, signals 5, threads 0\nRecent signals: technical_indicator_signal, integration_failure, system_distress, system_distress","title":"Owner knowledge pack 2026-04-07","updated_at":"2026-04-08T00:46:57.772688+00:00"}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
artifact_upsert:owner_knowledge_pack:039d771778f8
TEXT
episode_id
NULL
TEXT
created_at
2026-04-08T00:46:57.838743+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel