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.7882551317751857,"details":{"bars":600,"ema_fast":7.981255181033006,"ema_price":7.981255181033006,"ema_slow":8.522010114776082,"fast_length":12,"fast_slope":0.085532,"price_ema_length":12,"recent_matches":[{"close":7.699999809265137,"ema_fast":4.7559038664028925,"ema_price":4.7559038664028925,"ema_slow":5.08788033745113,"timestamp":"2026-01-15T00:00:00+00:00","volume":9893400.0},{"close":6.480000019073486,"ema_fast":5.005911725353576,"ema_price":5.005911725353576,"ema_slow":5.140729073751825,"timestamp":"2026-01-21T00:00:00+00:00","volume":5677700.0},{"close":8.630000114440918,"ema_fast":5.909171918267211,"ema_price":5.909171918267211,"ema_slow":5.750883093301606,"timestamp":"2026-02-13T00:00:00+00:00","volume":50594700.0},{"close":11.40999984741211,"ema_fast":10.71196426216421,"ema_price":10.71196426216421,"ema_slow":10.16033462380218,"timestamp":"2026-03-12T00:00:00+00:00","volume":206700.0},{"close":11.4399995803833,"ema_fast":7.981255181033006,"ema_price":7.981255181033006,"ema_slow":8.522010114776082,"timestamp":"2026-04-06T00:00:00+00:00","volume":10593500.0}],"rel_gap":0.063454,"rel_price_gap":0.433358,"signal":{"close":11.4399995803833,"timestamp":"2026-04-06T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":1.733433812551089,"price":11.4399995803833,"recent_buys":[],"recent_sells":[],"signal":{"close":11.4399995803833,"timestamp":"2026-04-06T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"MLEC","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_f105474aa63e in signals