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.5774197104641627,"details":{"bars":600,"ema_fast":51.749954205542096,"ema_price":51.749954205542096,"ema_slow":51.66835710738108,"fast_length":12,"fast_slope":0.0064,"price_ema_length":12,"recent_matches":[{"close":43.029998779296875,"ema_fast":41.71622121972624,"ema_price":41.71622121972624,"ema_slow":41.65718776678236,"timestamp":"2025-05-02T00:00:00+00:00","volume":18100.0},{"close":43.91999816894531,"ema_fast":43.50908969654984,"ema_price":43.50908969654984,"ema_slow":43.47423485856515,"timestamp":"2025-06-10T00:00:00+00:00","volume":43000.0},{"close":52.220001220703125,"ema_fast":49.19604202429949,"ema_price":49.19604202429949,"ema_slow":49.131198208617604,"timestamp":"2025-08-22T00:00:00+00:00","volume":52900.0},{"close":48.93000030517578,"ema_fast":47.85124633652505,"ema_price":47.85124633652505,"ema_slow":47.757559619859165,"timestamp":"2025-11-24T00:00:00+00:00","volume":57000.0},{"close":53.560001373291016,"ema_fast":51.749954205542096,"ema_price":51.749954205542096,"ema_slow":51.66835710738108,"timestamp":"2026-04-06T00:00:00+00:00","volume":78078.0}],"rel_gap":0.001579,"rel_price_gap":0.034977,"signal":{"close":53.560001373291016,"timestamp":"2026-04-06T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.1399071512650788,"price":53.560001373291016,"recent_buys":[],"recent_sells":[],"signal":{"close":53.560001373291016,"timestamp":"2026-04-06T00:00:00Z"},"signal_kind":"emaCrossUp","strategy":"ema_signals","ticker":"UNTY","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_27b8276e5576 in signals