Create
Query
event_store.db
—
signals
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 sig_7fce1f2e875d in signals
id
sig_7fce1f2e875d
Primary key.
TEXT
event_id
53506
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
technical_indicator_signal
TEXT NOT NULL
value
{"bars":286,"confidence":0.7264236507009284,"details":{"atr":0.013028318317592257,"atr_normalized_move":1.9189,"bars":286,"last_buy":{"close":10.539999961853027,"timestamp":"2026-04-15T00:00:00Z"},"last_sell":null,"macd_clarity":0.079,"macd_gap":0.001122,"price_move_pct":0.0024,"recent_buys":[{"close":10.09000015258789,"macdLine":0.016102739083692086,"rsi":69.53644758179415,"signalLine":0.01241978946205988,"timestamp":"2025-04-29T00:00:00+00:00","volume":221800.0},{"close":10.350000381469727,"macdLine":0.009091149705550805,"rsi":62.96594127551981,"signalLine":0.008646028981738595,"timestamp":"2025-12-01T00:00:00+00:00","volume":47600.0},{"close":10.359999656677246,"macdLine":0.009269173011077214,"rsi":64.3902931046732,"signalLine":0.00813284334059097,"timestamp":"2025-12-09T00:00:00+00:00","volume":50500.0},{"close":10.479999542236328,"macdLine":0.016184045306561146,"rsi":66.98781095574483,"signalLine":0.014136344038889382,"timestamp":"2026-02-26T00:00:00+00:00","volume":300400.0},{"close":10.539999961853027,"macdLine":0.014204413364579338,"rsi":67.08509767102896,"signalLine":0.01308234623680037,"timestamp":"2026-04-15T00:00:00+00:00","volume":2903624.0}],"recent_sells":[],"rsi":67.08509767102896,"rsi_distance":0.0972,"signal":{"close":10.539999961853027,"timestamp":"2026-04-15T00:00:00Z"},"volume_clarity":1.0,"volume_ratio":15.3882},"direction":"up","last_buy":{"close":10.539999961853027,"timestamp":"2026-04-15T00:00:00Z"},"last_sell":null,"magnitude":0.7675470592859626,"price":10.539999961853027,"recent_buys":[{"close":10.09000015258789,"macdLine":0.016102739083692086,"rsi":69.53644758179415,"signalLine":0.01241978946205988,"timestamp":"2025-04-29T00:00:00+00:00","volume":221800.0},{"close":10.350000381469727,"macdLine":0.009091149705550805,"rsi":62.96594127551981,"signalLine":0.008646028981738595,"timestamp":"2025-12-01T00:00:00+00:00","volume":47600.0},{"close":10.359999656677246,"macdLine":0.009269173011077214,"rsi":64.3902931046732,"signalLine":0.00813284334059097,"timestamp":"2025-12-09T00:00:00+00:00","volume":50500.0},{"close":10.479999542236328,"macdLine":0.016184045306561146,"rsi":66.98781095574483,"signalLine":0.014136344038889382,"timestamp":"2026-02-26T00:00:00+00:00","volume":300400.0},{"close":10.539999961853027,"macdLine":0.014204413364579338,"rsi":67.08509767102896,"signalLine":0.01308234623680037,"timestamp":"2026-04-15T00:00:00+00:00","volume":2903624.0}],"recent_sells":[],"signal":{"close":10.539999961853027,"timestamp":"2026-04-15T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"DMAA","timeframe":"1d","timeframe_bucket":"daily"}
TEXT NOT NULL
threshold
NULL
TEXT
direction
NULL
TEXT
severity
high
TEXT
window
NULL
TEXT
source
technical_analyzer
TEXT NOT NULL
reason_trace
{"cutoff_iso":"2026-04-13T01:19:47Z","eligible_timeframes":["1d"],"market_now":"2026-04-15T21:19:47.067832-04:00","period_key":"2026-04-15","recent_signal_hours":72,"signal_timestamp":"2026-04-15T00:00:00Z","strategy":"big_move"}
TEXT
dedupe_key
ta:technical_indicator_signal:bigMoveUp:big_move:DMAA:1d:2026-04-15T00:00:00Z:2026-04-16
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-16T01:19:47.067810+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel