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.5636051893529833,"details":{"bars":600,"ema_fast":5.823609881588354,"ema_price":5.823609881588354,"ema_slow":5.51996743051181,"fast_length":12,"fast_slope":-0.00136,"price_ema_length":12,"recent_matches":[{"close":7.090000152587891,"ema_fast":7.251174763056651,"ema_price":7.251174763056651,"ema_slow":7.9569137955505065,"timestamp":"2025-12-31T00:00:00+00:00","volume":86200.0},{"close":7.599999904632568,"ema_fast":8.198198432213546,"ema_price":8.198198432213546,"ema_slow":8.223736393108767,"timestamp":"2026-01-20T00:00:00+00:00","volume":79400.0},{"close":8.229999542236328,"ema_fast":8.243107020716398,"ema_price":8.243107020716398,"ema_slow":8.233835316774321,"timestamp":"2026-01-26T00:00:00+00:00","volume":61400.0},{"close":8.010000228881836,"ema_fast":8.35770395917425,"ema_price":8.35770395917425,"ema_slow":8.300526216470933,"timestamp":"2026-01-29T00:00:00+00:00","volume":64300.0},{"close":5.78000020980835,"ema_fast":5.823609881588354,"ema_price":5.823609881588354,"ema_slow":5.51996743051181,"timestamp":"2026-04-06T00:00:00+00:00","volume":96000.0}],"rel_gap":0.055008,"rel_price_gap":0.007488,"signal":{"close":5.78000020980835,"timestamp":"2026-04-06T00:00:00Z"},"slow_length":26},"direction":"down","last_buy":null,"last_sell":null,"magnitude":0.22003205989814362,"price":5.78000020980835,"recent_buys":[],"recent_sells":[],"signal":{"close":5.78000020980835,"timestamp":"2026-04-06T00:00:00Z"},"signal_kind":"priceBelowEma12","strategy":"ema_signals","ticker":"STI","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_e95f7c19d3f0 in signals