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.5210886849441139,"details":{"atr_14":0.404842,"bars":600,"ema_fast":7.288301887061534,"ema_price":7.288301887061534,"ema_slow":7.135146763294494,"fast_length":12,"fast_slope":-0.000955,"price_ema_length":12,"recent_matches":[{"close":6.340000152587891,"ema_fast":6.479880781951048,"ema_price":6.479880781951048,"ema_slow":6.2298966506441165,"timestamp":"2026-02-24T00:00:00+00:00","volume":12900.0},{"close":6.639999866485596,"ema_fast":6.660840668365946,"ema_price":6.660840668365946,"ema_slow":6.414201365668519,"timestamp":"2026-03-03T00:00:00+00:00","volume":3500.0},{"close":6.960000038146973,"ema_fast":7.15761903605524,"ema_price":7.15761903605524,"ema_slow":6.921333434444682,"timestamp":"2026-03-26T00:00:00+00:00","volume":4000.0},{"close":7.25,"ema_fast":7.2689505591285055,"ema_price":7.2689505591285055,"ema_slow":7.100835180129061,"timestamp":"2026-04-13T00:00:00+00:00","volume":13100.0},{"close":7.25,"ema_fast":7.288301887061534,"ema_price":7.288301887061534,"ema_slow":7.135146763294494,"timestamp":"2026-04-15T00:00:00+00:00","volume":12700.0}],"rel_gap":0.021465,"rel_price_gap":0.005255,"signal":{"close":7.25,"timestamp":"2026-04-15T00:00:00Z"},"slow_length":26},"direction":"down","last_buy":null,"last_sell":null,"magnitude":0.08585955067100773,"price":7.25,"recent_buys":[],"recent_sells":[],"signal":{"close":7.25,"timestamp":"2026-04-15T00:00:00Z"},"signal_kind":"priceBelowEma12","strategy":"ema_signals","ticker":"WHLRP","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_e89d96e22d03 in signals