Create
Query
event_store.db
—
signals
actions
agent_runs
approvals
artifacts
attention_candidates
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_narrative_members
intel_narratives
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_08a1e49ef010 in signals
id
sig_08a1e49ef010
Primary key.
TEXT
event_id
79409
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
technical_indicator_signal
TEXT NOT NULL
value
{"bars":600,"confidence":0.8461435973176668,"details":{"atr":0.3357635335977034,"atr_normalized_move":1.3104,"bars":600,"last_buy":{"close":6.039999961853027,"timestamp":"2026-04-15T00:00:00Z"},"last_sell":{"close":7.300000190734863,"timestamp":"2025-11-05T00:00:00Z"},"macd_clarity":1.0,"macd_gap":0.193731,"price_move_pct":0.0786,"recent_buys":[{"close":8.4399995803833,"macdLine":-0.00011682933749224134,"rsi":66.8712867667266,"signalLine":-0.18615956242823384,"timestamp":"2025-09-18T00:00:00+00:00","volume":202130200.0},{"close":8.15999984741211,"macdLine":0.04460787226727181,"rsi":60.035413953368256,"signalLine":-0.14000607548913271,"timestamp":"2025-09-19T00:00:00+00:00","volume":194706900.0},{"close":8.529999732971191,"macdLine":0.1086559014635533,"rsi":65.11084978214885,"signalLine":-0.09027368009859552,"timestamp":"2025-09-22T00:00:00+00:00","volume":219706600.0},{"close":8.6899995803833,"macdLine":0.03894243386639129,"rsi":63.64736762788254,"signalLine":-0.03766843943768802,"timestamp":"2025-11-10T00:00:00+00:00","volume":81255400.0},{"close":6.039999961853027,"macdLine":0.11749618615169588,"rsi":69.95691602099521,"signalLine":-0.07623507764190471,"timestamp":"2026-04-15T00:00:00+00:00","volume":153321300.0}],"recent_sells":[{"close":8.020000457763672,"macdLine":-0.3638249024784379,"rsi":31.61338872821206,"signalLine":-0.34110662276368314,"timestamp":"2025-04-03T00:00:00+00:00","volume":50833000.0},{"close":8.050000190734863,"macdLine":-0.40611958294310035,"rsi":32.194588416235916,"signalLine":-0.3541092147995666,"timestamp":"2025-04-04T00:00:00+00:00","volume":48737600.0},{"close":7.78000020980835,"macdLine":-0.028185186301161735,"rsi":32.116611459416106,"signalLine":0.16497011362509506,"timestamp":"2025-08-06T00:00:00+00:00","volume":185515300.0},{"close":7.539999961853027,"macdLine":-0.15967351668700935,"rsi":30.32810366630102,"signalLine":0.1000413875626742,"timestamp":"2025-08-07T00:00:00+00:00","volume":82788300.0},{"close":7.300000190734863,"macdLine":-0.11025194311246178,"rsi":37.924554639002494,"signalLine":-0.05913800332329136,"timestamp":"2025-11-05T00:00:00+00:00","volume":130490400.0}],"rsi":69.95691602099521,"rsi_distance":0.0014,"signal":{"close":6.039999961853027,"timestamp":"2026-04-15T00:00:00Z"},"volume_clarity":0.9593,"volume_ratio":2.4389},"direction":"up","last_buy":{"close":6.039999961853027,"timestamp":"2026-04-15T00:00:00Z"},"last_sell":{"close":7.300000190734863,"timestamp":"2025-11-05T00:00:00Z"},"magnitude":0.7857144012743132,"price":6.039999961853027,"recent_buys":[{"close":8.4399995803833,"macdLine":-0.00011682933749224134,"rsi":66.8712867667266,"signalLine":-0.18615956242823384,"timestamp":"2025-09-18T00:00:00+00:00","volume":202130200.0},{"close":8.15999984741211,"macdLine":0.04460787226727181,"rsi":60.035413953368256,"signalLine":-0.14000607548913271,"timestamp":"2025-09-19T00:00:00+00:00","volume":194706900.0},{"close":8.529999732971191,"macdLine":0.1086559014635533,"rsi":65.11084978214885,"signalLine":-0.09027368009859552,"timestamp":"2025-09-22T00:00:00+00:00","volume":219706600.0},{"close":8.6899995803833,"macdLine":0.03894243386639129,"rsi":63.64736762788254,"signalLine":-0.03766843943768802,"timestamp":"2025-11-10T00:00:00+00:00","volume":81255400.0},{"close":6.039999961853027,"macdLine":0.11749618615169588,"rsi":69.95691602099521,"signalLine":-0.07623507764190471,"timestamp":"2026-04-15T00:00:00+00:00","volume":153321300.0}],"recent_sells":[{"close":8.020000457763672,"macdLine":-0.3638249024784379,"rsi":31.61338872821206,"signalLine":-0.34110662276368314,"timestamp":"2025-04-03T00:00:00+00:00","volume":50833000.0},{"close":8.050000190734863,"macdLine":-0.40611958294310035,"rsi":32.194588416235916,"signalLine":-0.3541092147995666,"timestamp":"2025-04-04T00:00:00+00:00","volume":48737600.0},{"close":7.78000020980835,"macdLine":-0.028185186301161735,"rsi":32.116611459416106,"signalLine":0.16497011362509506,"timestamp":"2025-08-06T00:00:00+00:00","volume":185515300.0},{"close":7.539999961853027,"macdLine":-0.15967351668700935,"rsi":30.32810366630102,"signalLine":0.1000413875626742,"timestamp":"2025-08-07T00:00:00+00:00","volume":82788300.0},{"close":7.300000190734863,"macdLine":-0.11025194311246178,"rsi":37.924554639002494,"signalLine":-0.05913800332329136,"timestamp":"2025-11-05T00:00:00+00:00","volume":130490400.0}],"signal":{"close":6.039999961853027,"timestamp":"2026-04-15T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"SNAP","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-14T20:09:12Z","eligible_timeframes":["1d","1wk"],"market_now":"2026-04-17T16:09:12.578340-04:00","period_key":"2026-04-17","recent_signal_hours":72,"signal_timestamp":"2026-04-15T00:00:00Z","strategy":"big_move"}
TEXT
dedupe_key
ta:technical_indicator_signal:bigMoveUp:big_move:SNAP:1d:2026-04-15T00:00:00Z:2026-04-17
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-17T20:09:12.578310+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel