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.6784875878089978,"details":{"atr_14":0.066354,"bars":600,"ema_fast":0.6344270150816279,"ema_price":0.6344270150816279,"ema_slow":0.6444995061833795,"fast_length":12,"fast_slope":0.0312,"price_ema_length":12,"recent_matches":[{"close":0.7799999713897705,"ema_fast":0.7669889202223483,"ema_price":0.7669889202223483,"ema_slow":0.7487720692464704,"timestamp":"2026-02-10T00:00:00+00:00","volume":2200.0},{"close":0.640999972820282,"ema_fast":0.6400236276533429,"ema_price":0.6400236276533429,"ema_slow":0.6675605055335814,"timestamp":"2026-03-31T00:00:00+00:00","volume":1100.0},{"close":0.6499999761581421,"ema_fast":0.6340580497527589,"ema_price":0.6340580497527589,"ema_slow":0.6567219559589194,"timestamp":"2026-04-07T00:00:00+00:00","volume":700.0},{"close":0.6380000114440918,"ema_fast":0.6334853509918947,"ema_price":0.6334853509918947,"ema_slow":0.6531594281101586,"timestamp":"2026-04-09T00:00:00+00:00","volume":5700.0},{"close":0.7400000095367432,"ema_fast":0.6344270150816279,"ema_price":0.6344270150816279,"ema_slow":0.6444995061833795,"timestamp":"2026-04-17T00:00:00+00:00","volume":14469520.0}],"rel_gap":0.015628,"rel_price_gap":0.166407,"signal":{"close":0.7400000095367432,"timestamp":"2026-04-17T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.6656273578862767,"price":0.7400000095367432,"recent_buys":[],"recent_sells":[],"signal":{"close":0.7400000095367432,"timestamp":"2026-04-17T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"ABLV","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_6b3dac15c867 in signals