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.5773612784209197,"details":{"bars":600,"ema_fast":44.77043126623554,"ema_price":44.77043126623554,"ema_slow":44.67132154001138,"fast_length":12,"fast_slope":0.006251,"price_ema_length":12,"recent_matches":[{"close":40.18000030517578,"ema_fast":39.3127099852743,"ema_price":39.3127099852743,"ema_slow":39.2991341258555,"timestamp":"2025-06-24T00:00:00+00:00","volume":57600.0},{"close":40.099998474121094,"ema_fast":39.093562005181106,"ema_price":39.093562005181106,"ema_slow":39.07806733496193,"timestamp":"2025-08-20T00:00:00+00:00","volume":77900.0},{"close":42.27000045776367,"ema_fast":40.97088024064649,"ema_price":40.97088024064649,"ema_slow":40.92884119502005,"timestamp":"2025-10-14T00:00:00+00:00","volume":183300.0},{"close":41.869998931884766,"ema_fast":40.836595097952475,"ema_price":40.836595097952475,"ema_slow":40.8239847841157,"timestamp":"2025-10-24T00:00:00+00:00","volume":95200.0},{"close":46.29999923706055,"ema_fast":44.77043126623554,"ema_price":44.77043126623554,"ema_slow":44.67132154001138,"timestamp":"2026-04-08T00:00:00+00:00","volume":67851.0}],"rel_gap":0.002219,"rel_price_gap":0.034165,"signal":{"close":46.29999923706055,"timestamp":"2026-04-08T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.13665876584740952,"price":46.29999923706055,"recent_buys":[],"recent_sells":[],"signal":{"close":46.29999923706055,"timestamp":"2026-04-08T00:00:00Z"},"signal_kind":"emaCrossUp","strategy":"ema_signals","ticker":"EQBK","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_97bf279d47da in signals