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
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_32ac1893c2fe in signals
id
sig_32ac1893c2fe
Primary key.
TEXT
event_id
7561
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
technical_indicator_signal
TEXT NOT NULL
value
{"bars":600,"confidence":0.8410656270749624,"details":{"atr":0.35067543420201386,"atr_normalized_move":1.9676,"bars":600,"last_buy":{"close":11.039999961853027,"timestamp":"2026-04-07T00:00:00Z"},"last_sell":{"close":9.859999656677246,"timestamp":"2025-04-14T00:00:00Z"},"macd_clarity":0.754,"macd_gap":0.110946,"price_move_pct":0.0667,"recent_buys":[{"close":10.960000038146973,"macdLine":0.14507298294449988,"rsi":65.78486612119157,"signalLine":0.057986175683546484,"timestamp":"2025-09-08T00:00:00+00:00","volume":70300.0},{"close":11.279999732971191,"macdLine":0.23893837467475976,"rsi":69.62753841955598,"signalLine":0.13091327672909225,"timestamp":"2025-09-11T00:00:00+00:00","volume":62700.0},{"close":11.899999618530273,"macdLine":0.17111923625196646,"rsi":64.76036002741971,"signalLine":0.12262784455331892,"timestamp":"2025-12-10T00:00:00+00:00","volume":106100.0},{"close":11.9399995803833,"macdLine":0.11965889285779596,"rsi":62.56547730797674,"signalLine":0.02735536140524881,"timestamp":"2026-01-22T00:00:00+00:00","volume":101700.0},{"close":11.039999961853027,"macdLine":-0.036193412772675515,"rsi":64.40747844606288,"signalLine":-0.14713973375815406,"timestamp":"2026-04-07T00:00:00+00:00","volume":292600.0}],"recent_sells":[{"close":9.300000190734863,"macdLine":-0.13182267454659424,"rsi":34.786247269571035,"signalLine":-0.07370097500919742,"timestamp":"2024-03-15T00:00:00+00:00","volume":145100.0},{"close":9.289999961853027,"macdLine":0.01567457296318331,"rsi":38.1216734929272,"signalLine":0.04719553283132126,"timestamp":"2024-05-16T00:00:00+00:00","volume":189500.0},{"close":10.989999771118164,"macdLine":-0.15045862448237024,"rsi":37.24243426049785,"signalLine":-0.11053363203170719,"timestamp":"2025-03-06T00:00:00+00:00","volume":64600.0},{"close":9.859999656677246,"macdLine":-0.2478143880196857,"rsi":37.49259376128786,"signalLine":-0.22659065687878605,"timestamp":"2025-04-14T00:00:00+00:00","volume":98000.0}],"rsi":64.40747844606288,"rsi_distance":0.1864,"signal":{"close":11.039999961853027,"timestamp":"2026-04-07T00:00:00Z"},"volume_clarity":1.0,"volume_ratio":4.1986},"direction":"up","last_buy":{"close":11.039999961853027,"timestamp":"2026-04-07T00:00:00Z"},"last_sell":{"close":9.859999656677246,"timestamp":"2025-04-14T00:00:00Z"},"magnitude":0.7870520864439136,"price":11.039999961853027,"recent_buys":[{"close":10.960000038146973,"macdLine":0.14507298294449988,"rsi":65.78486612119157,"signalLine":0.057986175683546484,"timestamp":"2025-09-08T00:00:00+00:00","volume":70300.0},{"close":11.279999732971191,"macdLine":0.23893837467475976,"rsi":69.62753841955598,"signalLine":0.13091327672909225,"timestamp":"2025-09-11T00:00:00+00:00","volume":62700.0},{"close":11.899999618530273,"macdLine":0.17111923625196646,"rsi":64.76036002741971,"signalLine":0.12262784455331892,"timestamp":"2025-12-10T00:00:00+00:00","volume":106100.0},{"close":11.9399995803833,"macdLine":0.11965889285779596,"rsi":62.56547730797674,"signalLine":0.02735536140524881,"timestamp":"2026-01-22T00:00:00+00:00","volume":101700.0},{"close":11.039999961853027,"macdLine":-0.036193412772675515,"rsi":64.40747844606288,"signalLine":-0.14713973375815406,"timestamp":"2026-04-07T00:00:00+00:00","volume":292600.0}],"recent_sells":[{"close":9.300000190734863,"macdLine":-0.13182267454659424,"rsi":34.786247269571035,"signalLine":-0.07370097500919742,"timestamp":"2024-03-15T00:00:00+00:00","volume":145100.0},{"close":9.289999961853027,"macdLine":0.01567457296318331,"rsi":38.1216734929272,"signalLine":0.04719553283132126,"timestamp":"2024-05-16T00:00:00+00:00","volume":189500.0},{"close":10.989999771118164,"macdLine":-0.15045862448237024,"rsi":37.24243426049785,"signalLine":-0.11053363203170719,"timestamp":"2025-03-06T00:00:00+00:00","volume":64600.0},{"close":9.859999656677246,"macdLine":-0.2478143880196857,"rsi":37.49259376128786,"signalLine":-0.22659065687878605,"timestamp":"2025-04-14T00:00:00+00:00","volume":98000.0}],"signal":{"close":11.039999961853027,"timestamp":"2026-04-07T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"PCYO","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-06T20:07:55Z","eligible_timeframes":["1d"],"market_now":"2026-04-09T16:07:55.116912-04:00","period_key":"2026-04-09","recent_signal_hours":72,"signal_timestamp":"2026-04-07T00:00:00Z","strategy":"big_move"}
TEXT
dedupe_key
ta:technical_indicator_signal:bigMoveUp:big_move:PCYO:1d:2026-04-07T00:00:00Z:2026-04-09
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-09T20:07:55.116892+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel