SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"bars":261,"confidence":0.5046400010177299,"details":{"bars":261,"ema_fast":96.80821113643442,"ema_price":96.80821113643442,"ema_slow":97.74303802078822,"fast_length":12,"fast_slope":0.000567,"price_ema_length":12,"recent_matches":[{"close":98.25,"ema_fast":98.19603077199507,"ema_price":98.19603077199507,"ema_slow":99.95012951660931,"timestamp":"2026-02-12T00:00:00+00:00","volume":93200.0},{"close":100.93000030517578,"ema_fast":99.9809384055774,"ema_price":99.9809384055774,"ema_slow":100.17153809544655,"timestamp":"2026-03-02T00:00:00+00:00","volume":214100.0},{"close":101.4800033569336,"ema_fast":100.36852767905592,"ema_price":100.36852767905592,"ema_slow":100.3168212535503,"timestamp":"2026-03-09T00:00:00+00:00","volume":131000.0},{"close":97.66999816894531,"ema_fast":97.03867046448408,"ema_price":97.03867046448408,"ema_slow":98.17673803121293,"timestamp":"2026-04-02T00:00:00+00:00","volume":110600.0},{"close":97.11000061035156,"ema_fast":96.80821113643442,"ema_price":96.80821113643442,"ema_slow":97.74303802078822,"timestamp":"2026-04-09T00:00:00+00:00","volume":49844.0}],"rel_gap":0.009564,"rel_price_gap":0.003117,"signal":{"close":97.11000061035156,"timestamp":"2026-04-09T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.038256510265415544,"price":97.11000061035156,"recent_buys":[],"recent_sells":[],"signal":{"close":97.11000061035156,"timestamp":"2026-04-09T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"STRF","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_863c5330274a in signals