SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"bars":52,"confidence":0.5793816666346349,"details":{"atr_14":3.375091,"bars":52,"ema_fast":55.340418305727866,"ema_price":55.340418305727866,"ema_slow":54.03513648299235,"fast_length":12,"fast_slope":-0.010727,"price_ema_length":12,"recent_matches":[{"close":55.9900016784668,"ema_fast":56.48190198814662,"ema_price":56.48190198814662,"ema_slow":NaN,"timestamp":"2026-03-03T00:00:00+00:00","volume":47700.0},{"close":55.29999923706055,"ema_fast":56.39875832932299,"ema_price":56.39875832932299,"ema_slow":NaN,"timestamp":"2026-03-05T00:00:00+00:00","volume":303600.0},{"close":55.630001068115234,"ema_fast":56.17233835763735,"ema_price":56.17233835763735,"ema_slow":NaN,"timestamp":"2026-03-10T00:00:00+00:00","volume":9800.0},{"close":52.040000915527344,"ema_fast":55.340418305727866,"ema_price":55.340418305727866,"ema_slow":54.03513648299235,"timestamp":"2026-04-21T00:00:00+00:00","volume":265179.0}],"rel_gap":0.024156,"rel_price_gap":0.059638,"signal":{"close":52.040000915527344,"timestamp":"2026-04-21T00:00:00Z"},"slow_length":26},"direction":"down","last_buy":null,"last_sell":null,"magnitude":0.23855384482042638,"price":52.040000915527344,"recent_buys":[],"recent_sells":[],"signal":{"close":52.040000915527344,"timestamp":"2026-04-21T00:00:00Z"},"signal_kind":"priceBelowEma12","strategy":"ema_signals","ticker":"VSECU","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_a64874245db8 in signals