Create
Query
event_store.db
—
signals
actions
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_254bcd5e4a78 in signals
id
sig_254bcd5e4a78
Primary key.
TEXT
event_id
39412
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
technical_indicator_signal
TEXT NOT NULL
value
{"bars":600,"confidence":0.7756662373693914,"details":{"atr":2.144406334246107,"atr_normalized_move":0.9886,"bars":600,"last_buy":{"close":80.0199966430664,"timestamp":"2026-04-13T00:00:00Z"},"last_sell":{"close":38.79999923706055,"timestamp":"2025-03-31T00:00:00Z"},"macd_clarity":0.5006,"macd_gap":0.826014,"price_move_pct":0.0272,"recent_buys":[{"close":47.0,"macdLine":0.8473149325736387,"rsi":63.18484568017021,"signalLine":0.7190347381767981,"timestamp":"2024-11-11T00:00:00+00:00","volume":545500.0},{"close":39.0099983215332,"macdLine":0.12682828865361984,"rsi":62.41065123612705,"signalLine":-0.2516255019887512,"timestamp":"2025-05-12T00:00:00+00:00","volume":229400.0},{"close":66.66000366210938,"macdLine":1.0129430234002044,"rsi":67.13139825335494,"signalLine":0.9003390602527863,"timestamp":"2025-12-23T00:00:00+00:00","volume":441700.0},{"close":69.56999969482422,"macdLine":1.3495274334887455,"rsi":69.01664950690399,"signalLine":1.1390716322764012,"timestamp":"2026-01-06T00:00:00+00:00","volume":701400.0},{"close":80.0199966430664,"macdLine":1.649906937897768,"rsi":69.88604004865456,"signalLine":0.8238927150408233,"timestamp":"2026-04-13T00:00:00+00:00","volume":703483.0}],"recent_sells":[{"close":41.400001525878906,"macdLine":-0.6641863527175147,"rsi":32.16426569229385,"signalLine":-0.4155894581896554,"timestamp":"2024-06-13T00:00:00+00:00","volume":870500.0},{"close":36.27000045776367,"macdLine":-0.935316960748942,"rsi":32.13993742539307,"signalLine":-0.730393462750832,"timestamp":"2024-08-05T00:00:00+00:00","volume":634200.0},{"close":41.900001525878906,"macdLine":-0.4195464613950648,"rsi":38.882627482037904,"signalLine":-0.10751197773800823,"timestamp":"2024-12-19T00:00:00+00:00","volume":661100.0},{"close":40.119998931884766,"macdLine":-0.8641754646758173,"rsi":32.0581998413101,"signalLine":-0.5829691869277331,"timestamp":"2025-01-02T00:00:00+00:00","volume":664600.0},{"close":38.79999923706055,"macdLine":-0.40423814561345495,"rsi":33.042259092741276,"signalLine":-0.23938556788690613,"timestamp":"2025-03-31T00:00:00+00:00","volume":349100.0}],"rsi":69.88604004865456,"rsi_distance":0.0038,"signal":{"close":80.0199966430664,"timestamp":"2026-04-13T00:00:00Z"},"volume_clarity":1.0,"volume_ratio":2.7113},"direction":"up","last_buy":{"close":80.0199966430664,"timestamp":"2026-04-13T00:00:00Z"},"last_sell":{"close":38.79999923706055,"timestamp":"2025-03-31T00:00:00Z"},"magnitude":0.3954465314397257,"price":80.0199966430664,"recent_buys":[{"close":47.0,"macdLine":0.8473149325736387,"rsi":63.18484568017021,"signalLine":0.7190347381767981,"timestamp":"2024-11-11T00:00:00+00:00","volume":545500.0},{"close":39.0099983215332,"macdLine":0.12682828865361984,"rsi":62.41065123612705,"signalLine":-0.2516255019887512,"timestamp":"2025-05-12T00:00:00+00:00","volume":229400.0},{"close":66.66000366210938,"macdLine":1.0129430234002044,"rsi":67.13139825335494,"signalLine":0.9003390602527863,"timestamp":"2025-12-23T00:00:00+00:00","volume":441700.0},{"close":69.56999969482422,"macdLine":1.3495274334887455,"rsi":69.01664950690399,"signalLine":1.1390716322764012,"timestamp":"2026-01-06T00:00:00+00:00","volume":701400.0},{"close":80.0199966430664,"macdLine":1.649906937897768,"rsi":69.88604004865456,"signalLine":0.8238927150408233,"timestamp":"2026-04-13T00:00:00+00:00","volume":703483.0}],"recent_sells":[{"close":41.400001525878906,"macdLine":-0.6641863527175147,"rsi":32.16426569229385,"signalLine":-0.4155894581896554,"timestamp":"2024-06-13T00:00:00+00:00","volume":870500.0},{"close":36.27000045776367,"macdLine":-0.935316960748942,"rsi":32.13993742539307,"signalLine":-0.730393462750832,"timestamp":"2024-08-05T00:00:00+00:00","volume":634200.0},{"close":41.900001525878906,"macdLine":-0.4195464613950648,"rsi":38.882627482037904,"signalLine":-0.10751197773800823,"timestamp":"2024-12-19T00:00:00+00:00","volume":661100.0},{"close":40.119998931884766,"macdLine":-0.8641754646758173,"rsi":32.0581998413101,"signalLine":-0.5829691869277331,"timestamp":"2025-01-02T00:00:00+00:00","volume":664600.0},{"close":38.79999923706055,"macdLine":-0.40423814561345495,"rsi":33.042259092741276,"signalLine":-0.23938556788690613,"timestamp":"2025-03-31T00:00:00+00:00","volume":349100.0}],"signal":{"close":80.0199966430664,"timestamp":"2026-04-13T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"LIT","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-11T02:09:26Z","eligible_timeframes":["1d"],"market_now":"2026-04-13T22:09:26.982035-04:00","period_key":"2026-04-13","recent_signal_hours":72,"signal_timestamp":"2026-04-13T00:00:00Z","strategy":"big_move"}
TEXT
dedupe_key
ta:technical_indicator_signal:bigMoveUp:big_move:LIT:1d:2026-04-13T00:00:00Z:2026-04-14
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-14T02:09:26.982017+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel