SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"bars":187,"confidence":0.7926194763817278,"details":{"atr":0.3044565339917191,"atr_normalized_move":3.5867,"bars":187,"last_buy":{"close":1.850000023841858,"timestamp":"2026-04-06T00:00:00Z"},"last_sell":null,"macd_clarity":0.3979,"macd_gap":0.234413,"price_move_pct":1.4406,"recent_buys":[{"close":1.850000023841858,"macdLine":-0.3546846938510634,"rsi":63.41365407037808,"signalLine":-0.5890972947019127,"timestamp":"2026-04-06T00:00:00+00:00","volume":240962400.0}],"recent_sells":[],"rsi":63.41365407037808,"rsi_distance":0.2195,"signal":{"close":1.850000023841858,"timestamp":"2026-04-06T00:00:00Z"},"volume_clarity":1.0,"volume_ratio":18.9637},"direction":"up","last_buy":{"close":1.850000023841858,"timestamp":"2026-04-06T00:00:00Z"},"last_sell":null,"magnitude":2.0,"price":1.850000023841858,"recent_buys":[{"close":1.850000023841858,"macdLine":-0.3546846938510634,"rsi":63.41365407037808,"signalLine":-0.5890972947019127,"timestamp":"2026-04-06T00:00:00+00:00","volume":240962400.0}],"recent_sells":[],"signal":{"close":1.850000023841858,"timestamp":"2026-04-06T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"PFSA","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_03fa500bb37b in signals