SQLite Web: event

Could not fetch row with primary-key sc_ffb832d69276e890.

Could not fetch row with primary-key sc_8769100782e6e977.

Update row sig_08825c81c501 in signals

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"bars":600,"confidence":0.5254490752675085,"details":{"atr_14":1.199876,"bars":600,"ema_fast":37.57670023490993,"ema_price":37.57670023490993,"ema_slow":37.03565665894863,"fast_length":12,"fast_slope":0.00322,"price_ema_length":12,"recent_matches":[{"close":38.11000061035156,"ema_fast":37.707050196547776,"ema_price":37.707050196547776,"ema_slow":37.0334913256016,"timestamp":"2026-03-10T00:00:00+00:00","volume":621000.0},{"close":36.61000061035156,"ema_fast":35.65480793576871,"ema_price":35.65480793576871,"ema_slow":36.03505684211639,"timestamp":"2026-03-24T00:00:00+00:00","volume":549400.0},{"close":35.939998626708984,"ema_fast":35.89616796458815,"ema_price":35.89616796458815,"ema_slow":36.06775291964868,"timestamp":"2026-03-31T00:00:00+00:00","volume":720900.0},{"close":36.18000030517578,"ema_fast":35.90024145671649,"ema_price":35.90024145671649,"ema_slow":36.0256695788929,"timestamp":"2026-04-07T00:00:00+00:00","volume":477700.0},{"close":38.2400016784668,"ema_fast":37.57670023490993,"ema_price":37.57670023490993,"ema_slow":37.03565665894863,"timestamp":"2026-04-17T00:00:00+00:00","volume":394905.0}],"rel_gap":0.014609,"rel_price_gap":0.017652,"signal":{"close":38.2400016784668,"timestamp":"2026-04-17T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.07060773717865099,"price":38.2400016784668,"recent_buys":[],"recent_sells":[],"signal":{"close":38.2400016784668,"timestamp":"2026-04-17T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"TRS","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_08825c81c501 in signals