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.9,"details":{"bars":600,"ema_fast":1.6656850238450858,"ema_price":1.6656850238450858,"ema_slow":4.243407002651709,"fast_length":12,"fast_slope":0.084565,"price_ema_length":12,"recent_matches":[{"close":15.699999809265137,"ema_fast":15.458168994190656,"ema_price":15.458168994190656,"ema_slow":16.08732420664523,"timestamp":"2026-01-21T00:00:00+00:00","volume":990.0},{"close":13.699999809265137,"ema_fast":13.547604527706051,"ema_price":13.547604527706051,"ema_slow":14.494944007299885,"timestamp":"2026-02-13T00:00:00+00:00","volume":1870.0},{"close":14.399999618530273,"ema_fast":14.10934462507354,"ema_price":14.10934462507354,"ema_slow":14.405667267159005,"timestamp":"2026-02-26T00:00:00+00:00","volume":1320.0},{"close":14.0,"ema_fast":13.938058656179734,"ema_price":13.938058656179734,"ema_slow":14.21351452464921,"timestamp":"2026-03-06T00:00:00+00:00","volume":8300.0},{"close":2.380000114440918,"ema_fast":1.6656850238450858,"ema_price":1.6656850238450858,"ema_slow":4.243407002651709,"timestamp":"2026-04-08T00:00:00+00:00","volume":253667021.0}],"rel_gap":0.607465,"rel_price_gap":0.428842,"signal":{"close":2.380000114440918,"timestamp":"2026-04-08T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":2.0,"price":2.380000114440918,"recent_buys":[],"recent_sells":[],"signal":{"close":2.380000114440918,"timestamp":"2026-04-08T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"UCAR","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_88e44aa28d71 in signals