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.5748243853802519,"details":{"bars":600,"ema_fast":41.668706047647326,"ema_price":41.668706047647326,"ema_slow":41.55258517508097,"fast_length":12,"fast_slope":0.005666,"price_ema_length":12,"recent_matches":[{"close":38.209999084472656,"ema_fast":37.025721058868086,"ema_price":37.025721058868086,"ema_slow":36.95895962225488,"timestamp":"2025-06-26T00:00:00+00:00","volume":97500.0},{"close":39.209999084472656,"ema_fast":37.62056913562919,"ema_price":37.62056913562919,"ema_slow":37.57807702538832,"timestamp":"2025-08-22T00:00:00+00:00","volume":192700.0},{"close":37.97999954223633,"ema_fast":36.99953021938436,"ema_price":36.99953021938436,"ema_slow":36.948171821213705,"timestamp":"2025-11-06T00:00:00+00:00","volume":168900.0},{"close":41.939998626708984,"ema_fast":40.4370093044645,"ema_price":40.4370093044645,"ema_slow":40.300227680111384,"timestamp":"2026-01-21T00:00:00+00:00","volume":196600.0},{"close":42.959999084472656,"ema_fast":41.668706047647326,"ema_price":41.668706047647326,"ema_slow":41.55258517508097,"timestamp":"2026-04-06T00:00:00+00:00","volume":159800.0}],"rel_gap":0.002795,"rel_price_gap":0.03099,"signal":{"close":42.959999084472656,"timestamp":"2026-04-06T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.12395806438997768,"price":42.959999084472656,"recent_buys":[],"recent_sells":[],"signal":{"close":42.959999084472656,"timestamp":"2026-04-06T00:00:00Z"},"signal_kind":"emaCrossUp","strategy":"ema_signals","ticker":"STBA","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_144b8bcbab29 in signals