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.5435237209157899,"details":{"bars":600,"ema_fast":12.613617963412747,"ema_price":12.613617963412747,"ema_slow":12.50603126020907,"fast_length":12,"fast_slope":0.007792,"price_ema_length":12,"recent_matches":[{"close":12.050000190734863,"ema_fast":11.565396501878512,"ema_price":11.565396501878512,"ema_slow":11.469539658567404,"timestamp":"2026-02-19T00:00:00+00:00","volume":500.0},{"close":12.0600004196167,"ema_fast":12.055321409335496,"ema_price":12.055321409335496,"ema_slow":11.882382555779119,"timestamp":"2026-03-06T00:00:00+00:00","volume":2200.0},{"close":13.020000457763672,"ema_fast":12.11415480953971,"ema_price":12.11415480953971,"ema_slow":12.001910430128012,"timestamp":"2026-03-20T00:00:00+00:00","volume":11600.0},{"close":13.729999542236328,"ema_fast":12.392489740807907,"ema_price":12.392489740807907,"ema_slow":12.162307072524847,"timestamp":"2026-03-25T00:00:00+00:00","volume":3300.0},{"close":13.149999618530273,"ema_fast":12.613617963412747,"ema_price":12.613617963412747,"ema_slow":12.50603126020907,"timestamp":"2026-04-13T00:00:00+00:00","volume":4173.0}],"rel_gap":0.008603,"rel_price_gap":0.042524,"signal":{"close":13.149999618530273,"timestamp":"2026-04-13T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.17009605227409416,"price":13.149999618530273,"recent_buys":[],"recent_sells":[],"signal":{"close":13.149999618530273,"timestamp":"2026-04-13T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"WFCF","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_8edb0fc8b7b9 in signals