SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"bars":454,"confidence":0.5470664624971052,"details":{"bars":454,"ema_fast":47.01726110934649,"ema_price":47.01726110934649,"ema_slow":48.91883823248701,"fast_length":12,"fast_slope":0.00187,"price_ema_length":12,"recent_matches":[{"close":68.36000061035156,"ema_fast":67.45175590435818,"ema_price":67.45175590435818,"ema_slow":67.88233525387541,"timestamp":"2026-01-22T00:00:00+00:00","volume":4006700.0},{"close":67.62999725341797,"ema_fast":67.20167092486592,"ema_price":67.20167092486592,"ema_slow":67.68790037050468,"timestamp":"2026-01-26T00:00:00+00:00","volume":5324600.0},{"close":56.15999984741211,"ema_fast":55.539959751843774,"ema_price":55.539959751843774,"ema_slow":59.12453998913511,"timestamp":"2026-02-18T00:00:00+00:00","volume":6872600.0},{"close":47.029998779296875,"ema_fast":46.79522257188066,"ema_price":46.79522257188066,"ema_slow":49.52031271421512,"timestamp":"2026-04-01T00:00:00+00:00","volume":5621100.0},{"close":47.5,"ema_fast":47.01726110934649,"ema_price":47.01726110934649,"ema_slow":48.91883823248701,"timestamp":"2026-04-08T00:00:00+00:00","volume":4365180.0}],"rel_gap":0.038872,"rel_price_gap":0.010267,"signal":{"close":47.5,"timestamp":"2026-04-08T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.15548833061842274,"price":47.5,"recent_buys":[],"recent_sells":[],"signal":{"close":47.5,"timestamp":"2026-04-08T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"TEM","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_4f8736f8bcf7 in signals