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.6078262848012737,"details":{"atr_14":0.313173,"bars":600,"ema_fast":5.989975523558578,"ema_price":5.989975523558578,"ema_slow":5.964965922372805,"fast_length":12,"fast_slope":0.011359,"price_ema_length":12,"recent_matches":[{"close":7.599999904632568,"ema_fast":7.074858774441052,"ema_price":7.074858774441052,"ema_slow":7.048895226623097,"timestamp":"2025-04-23T00:00:00+00:00","volume":1598100.0},{"close":8.760000228881836,"ema_fast":8.589682481256505,"ema_price":8.589682481256505,"ema_slow":8.57871891270235,"timestamp":"2025-06-30T00:00:00+00:00","volume":1361300.0},{"close":8.930000305175781,"ema_fast":8.609085142021899,"ema_price":8.609085142021899,"ema_slow":8.578974969265612,"timestamp":"2025-07-21T00:00:00+00:00","volume":2113900.0},{"close":11.59000015258789,"ema_fast":11.233239097494014,"ema_price":11.233239097494014,"ema_slow":11.215637869685958,"timestamp":"2025-09-18T00:00:00+00:00","volume":1772500.0},{"close":6.360000133514404,"ema_fast":5.989975523558578,"ema_price":5.989975523558578,"ema_slow":5.964965922372805,"timestamp":"2026-04-17T00:00:00+00:00","volume":3624527.0}],"rel_gap":0.004193,"rel_price_gap":0.061774,"signal":{"close":6.360000133514404,"timestamp":"2026-04-17T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.24709590782167248,"price":6.360000133514404,"recent_buys":[],"recent_sells":[],"signal":{"close":6.360000133514404,"timestamp":"2026-04-17T00:00:00Z"},"signal_kind":"emaCrossUp","strategy":"ema_signals","ticker":"COUR","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_57b8ef5d4f5f in signals