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 79977 in events
seq
Primary key.
INTEGER
id
evt_cb6a8e56fd5d
TEXT NOT NULL
kind
signal_emitted
TEXT NOT NULL
ts
2026-04-17T20:14:09.763371+00:00
TEXT NOT NULL
actor
technical_analyzer
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-17T20:14:09.763371+00:00","reason_trace":{"cutoff_iso":"2026-04-14T20:14:09Z","eligible_timeframes":["1d","1wk"],"market_now":"2026-04-17T16:14:09.763388-04:00","period_key":"2026-04-17","recent_signal_hours":72,"signal_timestamp":"2026-04-17T00:00:00Z","strategy":"big_move"},"severity":"high","signal_type":"technical_indicator_signal","source":"technical_analyzer","value":{"bars":600,"confidence":0.8413752347139155,"details":{"atr":5.417843948643313,"atr_normalized_move":1.2496,"bars":600,"last_buy":{"close":101.80000305175781,"timestamp":"2026-04-17T00:00:00Z"},"last_sell":{"close":92.06999969482422,"timestamp":"2026-03-06T00:00:00Z"},"macd_clarity":1.0,"macd_gap":1.228073,"price_move_pct":0.0712,"recent_buys":[{"close":45.119998931884766,"macdLine":0.0031779009107495426,"rsi":58.20261496529221,"signalLine":-0.5500003824406122,"timestamp":"2024-09-05T00:00:00+00:00","volume":9230900.0},{"close":48.75,"macdLine":0.6159691595446688,"rsi":68.75828599963532,"signalLine":-0.19270119079426387,"timestamp":"2024-09-09T00:00:00+00:00","volume":9955600.0},{"close":107.11000061035156,"macdLine":2.5992532757990006,"rsi":69.75266389747925,"signalLine":2.219297581490064,"timestamp":"2025-01-10T00:00:00+00:00","volume":14330600.0},{"close":98.47000122070312,"macdLine":1.948673009762004,"rsi":69.18025544894725,"signalLine":1.7894311910114646,"timestamp":"2025-08-12T00:00:00+00:00","volume":11540800.0},{"close":101.80000305175781,"macdLine":0.06857819297135848,"rsi":58.44019359583962,"signalLine":-1.159494951298215,"timestamp":"2026-04-17T00:00:00+00:00","volume":12795848.0}],"recent_sells":[{"close":86.20999908447266,"macdLine":-3.5135184518521925,"rsi":30.774030016782206,"signalLine":-1.7959217455766971,"timestamp":"2025-03-04T00:00:00+00:00","volume":14248400.0},{"close":82.87999725341797,"macdLine":-4.631803802601894,"rsi":32.07426307942987,"signalLine":-2.9591873951993084,"timestamp":"2025-03-07T00:00:00+00:00","volume":14860400.0},{"close":108.56999969482422,"macdLine":1.5420118751514593,"rsi":44.920457248349344,"signalLine":2.5420665492322643,"timestamp":"2026-01-20T00:00:00+00:00","volume":9227200.0},{"close":95.43000030517578,"macdLine":-2.4398293765408,"rsi":35.4294834320463,"signalLine":-0.6811051039566848,"timestamp":"2026-03-05T00:00:00+00:00","volume":12720400.0},{"close":92.06999969482422,"macdLine":-3.3574619221292465,"rsi":32.93322750425729,"signalLine":-1.2163764675911972,"timestamp":"2026-03-06T00:00:00+00:00","volume":10570100.0}],"rsi":58.44019359583962,"rsi_distance":0.3853,"signal":{"close":101.80000305175781,"timestamp":"2026-04-17T00:00:00Z"},"volume_clarity":0.3358,"volume_ratio":1.5036},"direction":"up","last_buy":{"close":101.80000305175781,"timestamp":"2026-04-17T00:00:00Z"},"last_sell":{"close":92.06999969482422,"timestamp":"2026-03-06T00:00:00Z"},"magnitude":0.7124070671813838,"price":101.80000305175781,"recent_buys":[{"close":45.119998931884766,"macdLine":0.0031779009107495426,"rsi":58.20261496529221,"signalLine":-0.5500003824406122,"timestamp":"2024-09-05T00:00:00+00:00","volume":9230900.0},{"close":48.75,"macdLine":0.6159691595446688,"rsi":68.75828599963532,"signalLine":-0.19270119079426387,"timestamp":"2024-09-09T00:00:00+00:00","volume":9955600.0},{"close":107.11000061035156,"macdLine":2.5992532757990006,"rsi":69.75266389747925,"signalLine":2.219297581490064,"timestamp":"2025-01-10T00:00:00+00:00","volume":14330600.0},{"close":98.47000122070312,"macdLine":1.948673009762004,"rsi":69.18025544894725,"signalLine":1.7894311910114646,"timestamp":"2025-08-12T00:00:00+00:00","volume":11540800.0},{"close":101.80000305175781,"macdLine":0.06857819297135848,"rsi":58.44019359583962,"signalLine":-1.159494951298215,"timestamp":"2026-04-17T00:00:00+00:00","volume":12795848.0}],"recent_sells":[{"close":86.20999908447266,"macdLine":-3.5135184518521925,"rsi":30.774030016782206,"signalLine":-1.7959217455766971,"timestamp":"2025-03-04T00:00:00+00:00","volume":14248400.0},{"close":82.87999725341797,"macdLine":-4.631803802601894,"rsi":32.07426307942987,"signalLine":-2.9591873951993084,"timestamp":"2025-03-07T00:00:00+00:00","volume":14860400.0},{"close":108.56999969482422,"macdLine":1.5420118751514593,"rsi":44.920457248349344,"signalLine":2.5420665492322643,"timestamp":"2026-01-20T00:00:00+00:00","volume":9227200.0},{"close":95.43000030517578,"macdLine":-2.4398293765408,"rsi":35.4294834320463,"signalLine":-0.6811051039566848,"timestamp":"2026-03-05T00:00:00+00:00","volume":12720400.0},{"close":92.06999969482422,"macdLine":-3.3574619221292465,"rsi":32.93322750425729,"signalLine":-1.2163764675911972,"timestamp":"2026-03-06T00:00:00+00:00","volume":10570100.0}],"signal":{"close":101.80000305175781,"timestamp":"2026-04-17T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"UAL","timeframe":"1d","timeframe_bucket":"daily"}}
TEXT NOT NULL
source_ref
NULL
TEXT
confidence
REAL (default 0.0
dedupe_key
ta:technical_indicator_signal:bigMoveUp:big_move:UAL:1d:2026-04-17T00:00:00Z:2026-04-17
TEXT
episode_id
NULL
TEXT
created_at
2026-04-17T20:14:24.904964+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel