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.7479661581097895,"details":{"bars":600,"ema_fast":3.7294653770749795,"ema_price":3.7294653770749795,"ema_slow":3.7851575402905016,"fast_length":12,"fast_slope":0.10449,"price_ema_length":12,"recent_matches":[{"close":16.690000534057617,"ema_fast":6.123513442367285,"ema_price":6.123513442367285,"ema_slow":5.306326257819945,"timestamp":"2025-12-10T00:00:00+00:00","volume":45846400.0},{"close":5.349999904632568,"ema_fast":5.146476096552017,"ema_price":5.146476096552017,"ema_slow":5.23213246147367,"timestamp":"2026-01-12T00:00:00+00:00","volume":32500.0},{"close":4.460000038146973,"ema_fast":4.37326841621877,"ema_price":4.37326841621877,"ema_slow":4.6051414640022825,"timestamp":"2026-02-25T00:00:00+00:00","volume":7900.0},{"close":4.159999847412109,"ema_fast":4.127857018863101,"ema_price":4.127857018863101,"ema_slow":4.360399694018695,"timestamp":"2026-03-06T00:00:00+00:00","volume":7500.0},{"close":5.670000076293945,"ema_fast":3.7294653770749795,"ema_price":3.7294653770749795,"ema_slow":3.7851575402905016,"timestamp":"2026-04-08T00:00:00+00:00","volume":52492000.0}],"rel_gap":0.014713,"rel_price_gap":0.520325,"signal":{"close":5.670000076293945,"timestamp":"2026-04-08T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":2.0,"price":5.670000076293945,"recent_buys":[],"recent_sells":[],"signal":{"close":5.670000076293945,"timestamp":"2026-04-08T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"BBGI","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_527f65690f4a in signals