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.6929705919854922,"details":{"bars":600,"ema_fast":6.466387181802482,"ema_price":6.466387181802482,"ema_slow":6.393246980669711,"fast_length":12,"fast_slope":0.025478,"price_ema_length":12,"recent_matches":[{"close":14.949999809265137,"ema_fast":14.379330023826467,"ema_price":14.379330023826467,"ema_slow":14.336292276285398,"timestamp":"2025-01-10T00:00:00+00:00","volume":329500.0},{"close":9.420000076293945,"ema_fast":8.509678838216825,"ema_price":8.509678838216825,"ema_slow":8.460122726968548,"timestamp":"2025-05-13T00:00:00+00:00","volume":826500.0},{"close":10.0,"ema_fast":8.610747490480586,"ema_price":8.610747490480586,"ema_slow":8.515396782681636,"timestamp":"2025-07-08T00:00:00+00:00","volume":859900.0},{"close":6.940000057220459,"ema_fast":6.555285757725947,"ema_price":6.555285757725947,"ema_slow":6.550557884908258,"timestamp":"2025-12-04T00:00:00+00:00","volume":309600.0},{"close":7.349999904632568,"ema_fast":6.466387181802482,"ema_price":6.466387181802482,"ema_slow":6.393246980669711,"timestamp":"2026-04-08T00:00:00+00:00","volume":336239.0}],"rel_gap":0.01144,"rel_price_gap":0.136647,"signal":{"close":7.349999904632568,"timestamp":"2026-04-08T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.5465881939867281,"price":7.349999904632568,"recent_buys":[],"recent_sells":[],"signal":{"close":7.349999904632568,"timestamp":"2026-04-08T00:00:00Z"},"signal_kind":"emaCrossUp","strategy":"ema_signals","ticker":"XPOF","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_15294ed4cbc2 in signals