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.5059766073694278,"details":{"bars":600,"ema_fast":8.419471345491756,"ema_price":8.419471345491756,"ema_slow":8.515287979863457,"fast_length":12,"fast_slope":0.000444,"price_ema_length":12,"recent_matches":[{"close":8.670000076293945,"ema_fast":8.466228003170691,"ema_price":8.466228003170691,"ema_slow":8.650184427646778,"timestamp":"2026-03-16T00:00:00+00:00","volume":1700.0},{"close":8.670000076293945,"ema_fast":8.490257911303921,"ema_price":8.490257911303921,"ema_slow":8.635178688298648,"timestamp":"2026-03-18T00:00:00+00:00","volume":900.0},{"close":8.920000076293945,"ema_fast":8.543971711965785,"ema_price":8.543971711965785,"ema_slow":8.63980343922457,"timestamp":"2026-03-20T00:00:00+00:00","volume":4800.0},{"close":8.520000457763672,"ema_fast":8.465618864025117,"ema_price":8.465618864025117,"ema_slow":8.559801217192685,"timestamp":"2026-03-31T00:00:00+00:00","volume":500.0},{"close":8.4399995803833,"ema_fast":8.419471345491756,"ema_price":8.419471345491756,"ema_slow":8.515287979863457,"timestamp":"2026-04-06T00:00:00+00:00","volume":3180.0}],"rel_gap":0.011252,"rel_price_gap":0.002438,"signal":{"close":8.4399995803833,"timestamp":"2026-04-06T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.045009227919611705,"price":8.4399995803833,"recent_buys":[],"recent_sells":[],"signal":{"close":8.4399995803833,"timestamp":"2026-04-06T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"NYC","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_0b831c67c3f5 in signals