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.5981129197587849,"details":{"bars":600,"ema_fast":83.90150314134551,"ema_price":83.90150314134551,"ema_slow":83.63198450427355,"fast_length":12,"fast_slope":0.0098,"price_ema_length":12,"recent_matches":[{"close":59.470001220703125,"ema_fast":54.486252122123545,"ema_price":54.486252122123545,"ema_slow":54.43988745285813,"timestamp":"2025-04-23T00:00:00+00:00","volume":159800.0},{"close":74.27999877929688,"ema_fast":71.753728541462,"ema_price":71.753728541462,"ema_slow":71.61787303957288,"timestamp":"2025-08-14T00:00:00+00:00","volume":51400.0},{"close":78.61000061035156,"ema_fast":76.52242403869752,"ema_price":76.52242403869752,"ema_slow":76.42921904716574,"timestamp":"2025-10-15T00:00:00+00:00","volume":118500.0},{"close":75.30000305175781,"ema_fast":70.89162693654666,"ema_price":70.89162693654666,"ema_slow":70.73912660538116,"timestamp":"2025-11-25T00:00:00+00:00","volume":91700.0},{"close":88.37999725341797,"ema_fast":83.90150314134551,"ema_price":83.90150314134551,"ema_slow":83.63198450427355,"timestamp":"2026-04-08T00:00:00+00:00","volume":95493.0}],"rel_gap":0.003223,"rel_price_gap":0.053378,"signal":{"close":88.37999725341797,"timestamp":"2026-04-08T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.21351198461976129,"price":88.37999725341797,"recent_buys":[],"recent_sells":[],"signal":{"close":88.37999725341797,"timestamp":"2026-04-08T00:00:00Z"},"signal_kind":"emaCrossUp","strategy":"ema_signals","ticker":"MCB","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_91442f1977e8 in signals