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.506827303780322,"details":{"bars":600,"ema_fast":43.71031664476202,"ema_price":43.71031664476202,"ema_slow":44.22759218753309,"fast_length":12,"fast_slope":-0.0005,"price_ema_length":12,"recent_matches":[{"close":50.63999938964844,"ema_fast":52.08864080997528,"ema_price":52.08864080997528,"ema_slow":51.93161080295654,"timestamp":"2026-01-23T00:00:00+00:00","volume":268800.0},{"close":51.630001068115234,"ema_fast":51.963557876992496,"ema_price":51.963557876992496,"ema_slow":51.61423942224767,"timestamp":"2026-02-19T00:00:00+00:00","volume":256500.0},{"close":43.86000061035156,"ema_fast":45.05179487260801,"ema_price":45.05179487260801,"ema_slow":46.85976531458398,"timestamp":"2026-03-16T00:00:00+00:00","volume":756000.0},{"close":42.5,"ema_fast":43.298185629710154,"ema_price":43.298185629710154,"ema_slow":44.19385434069872,"timestamp":"2026-04-07T00:00:00+00:00","volume":248300.0},{"close":43.59000015258789,"ema_fast":43.71031664476202,"ema_price":43.71031664476202,"ema_slow":44.22759218753309,"timestamp":"2026-04-10T00:00:00+00:00","volume":478852.0}],"rel_gap":0.011696,"rel_price_gap":0.002753,"signal":{"close":43.59000015258789,"timestamp":"2026-04-10T00:00:00Z"},"slow_length":26},"direction":"down","last_buy":null,"last_sell":null,"magnitude":0.04678306163064279,"price":43.59000015258789,"recent_buys":[],"recent_sells":[],"signal":{"close":43.59000015258789,"timestamp":"2026-04-10T00:00:00Z"},"signal_kind":"priceBelowEma12","strategy":"ema_signals","ticker":"TGLS","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_e93a7e975489 in signals