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.5064627339163592,"details":{"atr_14":0.833713,"bars":600,"ema_fast":37.663333125609796,"ema_price":37.663333125609796,"ema_slow":37.357720338665295,"fast_length":12,"fast_slope":0.001192,"price_ema_length":12,"recent_matches":[{"close":38.130001068115234,"ema_fast":37.76519375650443,"ema_price":37.76519375650443,"ema_slow":37.98044800230042,"timestamp":"2026-01-29T00:00:00+00:00","volume":13000.0},{"close":36.189998626708984,"ema_fast":36.071655443136436,"ema_price":36.071655443136436,"ema_slow":36.44212902359912,"timestamp":"2026-03-19T00:00:00+00:00","volume":9500.0},{"close":36.9900016784668,"ema_fast":36.2127239381407,"ema_price":36.2127239381407,"ema_slow":36.45718890964042,"timestamp":"2026-03-23T00:00:00+00:00","volume":22700.0},{"close":36.7599983215332,"ema_fast":36.46139648924675,"ema_price":36.46139648924675,"ema_slow":36.520669317663234,"timestamp":"2026-03-30T00:00:00+00:00","volume":11700.0},{"close":37.90999984741211,"ema_fast":37.663333125609796,"ema_price":37.663333125609796,"ema_slow":37.357720338665295,"timestamp":"2026-04-21T00:00:00+00:00","volume":20244.0}],"rel_gap":0.008181,"rel_price_gap":0.006549,"signal":{"close":37.90999984741211,"timestamp":"2026-04-21T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.03272285184149109,"price":37.90999984741211,"recent_buys":[],"recent_sells":[],"signal":{"close":37.90999984741211,"timestamp":"2026-04-21T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"FUNC","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_fb1f23c3c30f in signals