SQLite Web: event

Could not fetch row with primary-key sig_175412f5c04b.

Could not fetch row with primary-key sc_3a2058d5137725c3.

Update row sig_93fe2763d590 in signals

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"bars":600,"confidence":0.531733283692469,"details":{"atr_14":0.287106,"bars":600,"ema_fast":16.172450834459084,"ema_price":16.172450834459084,"ema_slow":16.33748641111828,"fast_length":12,"fast_slope":-0.005283,"price_ema_length":12,"recent_matches":[{"close":16.0,"ema_fast":16.587382087598,"ema_price":16.587382087598,"ema_slow":16.78838037592545,"timestamp":"2025-11-18T00:00:00+00:00","volume":7800.0},{"close":16.200000762939453,"ema_fast":16.547619615820636,"ema_price":16.547619615820636,"ema_slow":16.250504887286127,"timestamp":"2026-01-15T00:00:00+00:00","volume":1400.0},{"close":16.549999237060547,"ema_fast":17.253179674280243,"ema_price":17.253179674280243,"ema_slow":16.98570555741341,"timestamp":"2026-02-17T00:00:00+00:00","volume":1500.0},{"close":16.549999237060547,"ema_fast":17.617282628816366,"ema_price":17.617282628816366,"ema_slow":17.430744067591675,"timestamp":"2026-03-11T00:00:00+00:00","volume":1200.0},{"close":15.699999809265137,"ema_fast":16.172450834459084,"ema_price":16.172450834459084,"ema_slow":16.33748641111828,"timestamp":"2026-04-14T00:00:00+00:00","volume":7300.0}],"rel_gap":0.010102,"rel_price_gap":0.029213,"signal":{"close":15.699999809265137,"timestamp":"2026-04-14T00:00:00Z"},"slow_length":26},"direction":"down","last_buy":null,"last_sell":null,"magnitude":0.11685329082894064,"price":15.699999809265137,"recent_buys":[],"recent_sells":[],"signal":{"close":15.699999809265137,"timestamp":"2026-04-14T00:00:00Z"},"signal_kind":"priceBelowEma12","strategy":"ema_signals","ticker":"SNNUF","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')

Cancel

event_store.db — signals

Update row sig_93fe2763d590 in signals