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.4984267984687997,"details":{"bars":600,"ema_fast":52.4069268481479,"ema_price":52.4069268481479,"ema_slow":52.69457454990382,"fast_length":12,"fast_slope":-0.000336,"price_ema_length":12,"recent_matches":[{"close":53.81999969482422,"ema_fast":53.85716170870025,"ema_price":53.85716170870025,"ema_slow":54.20787700989739,"timestamp":"2026-02-26T00:00:00+00:00","volume":173500.0},{"close":52.650001525878906,"ema_fast":53.52925029219076,"ema_price":53.52925029219076,"ema_slow":53.92199111355202,"timestamp":"2026-03-05T00:00:00+00:00","volume":234900.0},{"close":52.93000030517578,"ema_fast":52.96534568648123,"ema_price":52.96534568648123,"ema_slow":53.40564634476439,"timestamp":"2026-03-16T00:00:00+00:00","volume":141200.0},{"close":52.02000045776367,"ema_fast":52.86217076986796,"ema_price":52.86217076986796,"ema_slow":53.295074123420235,"timestamp":"2026-03-18T00:00:00+00:00","volume":206500.0},{"close":52.310001373291016,"ema_fast":52.4069268481479,"ema_price":52.4069268481479,"ema_slow":52.69457454990382,"timestamp":"2026-04-01T00:00:00+00:00","volume":231000.0}],"rel_gap":0.005459,"rel_price_gap":0.001849,"signal":{"close":52.310001373291016,"timestamp":"2026-04-01T00:00:00Z"},"slow_length":26},"direction":"down","last_buy":null,"last_sell":null,"magnitude":0.021835090554418186,"price":52.310001373291016,"recent_buys":[],"recent_sells":[],"signal":{"close":52.310001373291016,"timestamp":"2026-04-01T00:00:00Z"},"signal_kind":"priceBelowEma12","strategy":"ema_signals","ticker":"UVV","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_3d28b2304755 in signals