SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"bars":600,"confidence":0.8315010788324743,"details":{"atr":0.0005273475154097306,"atr_normalized_move":1.8963,"bars":600,"last_buy":{"close":0.24799999594688416,"timestamp":"2026-04-06T00:00:00Z"},"last_sell":null,"macd_clarity":0.0472,"macd_gap":0.000472,"price_move_pct":0.004,"recent_buys":[{"close":0.24799999594688416,"macdLine":-0.0009104000298835457,"rsi":45.11586749173489,"signalLine":-0.0013824277826267977,"timestamp":"2026-04-06T00:00:00+00:00","volume":300.0}],"recent_sells":[],"rsi":45.11586749173489,"rsi_distance":0.8295,"signal":{"close":0.24799999594688416,"timestamp":"2026-04-06T00:00:00Z"},"volume_clarity":1.0,"volume_ratio":20.0},"direction":"up","last_buy":{"close":0.24799999594688416,"timestamp":"2026-04-06T00:00:00Z"},"last_sell":null,"magnitude":0.7585146396534784,"price":0.24799999594688416,"recent_buys":[{"close":0.24799999594688416,"macdLine":-0.0009104000298835457,"rsi":45.11586749173489,"signalLine":-0.0013824277826267977,"timestamp":"2026-04-06T00:00:00+00:00","volume":300.0}],"recent_sells":[],"signal":{"close":0.24799999594688416,"timestamp":"2026-04-06T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"ASFT","timeframe":"1d","timeframe_bucket":"daily"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_8c298048e4bd in signals