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.5443732353176287,"details":{"bars":600,"ema_fast":46.063976460466094,"ema_price":46.063976460466094,"ema_slow":45.770249523635606,"fast_length":12,"fast_slope":0.008422,"price_ema_length":12,"recent_matches":[{"close":45.97999954223633,"ema_fast":45.952744743465836,"ema_price":45.952744743465836,"ema_slow":44.99785519208823,"timestamp":"2026-02-18T00:00:00+00:00","volume":5214600.0},{"close":45.68000030517578,"ema_fast":45.63842126092729,"ema_price":45.63842126092729,"ema_slow":45.18322004744952,"timestamp":"2026-02-26T00:00:00+00:00","volume":5984100.0},{"close":45.369998931884766,"ema_fast":45.19620891091897,"ema_price":45.19620891091897,"ema_slow":45.38367837513487,"timestamp":"2026-03-25T00:00:00+00:00","volume":5085000.0},{"close":46.400001525878906,"ema_fast":45.33633211103209,"ema_price":45.33633211103209,"ema_slow":45.397242273826635,"timestamp":"2026-03-31T00:00:00+00:00","volume":10751000.0},{"close":48.18000030517578,"ema_fast":46.063976460466094,"ema_price":46.063976460466094,"ema_slow":45.770249523635606,"timestamp":"2026-04-08T00:00:00+00:00","volume":7237258.0}],"rel_gap":0.006417,"rel_price_gap":0.045937,"signal":{"close":48.18000030517578,"timestamp":"2026-04-08T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.18374652014905762,"price":48.18000030517578,"recent_buys":[],"recent_sells":[],"signal":{"close":48.18000030517578,"timestamp":"2026-04-08T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"FAST","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_f19a192d7c3b in signals