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.5296784980675916,"details":{"bars":600,"ema_fast":6.997294942711436,"ema_price":6.997294942711436,"ema_slow":7.153671118755355,"fast_length":12,"fast_slope":0.002415,"price_ema_length":12,"recent_matches":[{"close":8.430000305175781,"ema_fast":8.37295057083453,"ema_price":8.37295057083453,"ema_slow":8.378382575083867,"timestamp":"2026-01-22T00:00:00+00:00","volume":4878500.0},{"close":8.0600004196167,"ema_fast":8.003385854561271,"ema_price":8.003385854561271,"ema_slow":8.147667895141522,"timestamp":"2026-02-04T00:00:00+00:00","volume":10469100.0},{"close":8.180000305175781,"ema_fast":7.743319417554783,"ema_price":7.743319417554783,"ema_slow":7.92065595985378,"timestamp":"2026-02-18T00:00:00+00:00","volume":25812500.0},{"close":7.159999847412109,"ema_fast":7.158642950574086,"ema_price":7.158642950574086,"ema_slow":7.353824687991087,"timestamp":"2026-03-23T00:00:00+00:00","volume":7349200.0},{"close":7.090000152587891,"ema_fast":6.997294942711436,"ema_price":6.997294942711436,"ema_slow":7.153671118755355,"timestamp":"2026-04-06T00:00:00+00:00","volume":5529300.0}],"rel_gap":0.02186,"rel_price_gap":0.013249,"signal":{"close":7.090000152587891,"timestamp":"2026-04-06T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.08743828082000295,"price":7.090000152587891,"recent_buys":[],"recent_sells":[],"signal":{"close":7.090000152587891,"timestamp":"2026-04-06T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"WEN","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_0abd4a1c14f4 in signals