SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"bars":125,"confidence":0.49570322270717565,"details":{"bars":125,"ema_fast":24.6596943082008,"ema_price":24.6596943082008,"ema_slow":24.72608329229637,"fast_length":12,"fast_slope":0.000445,"price_ema_length":12,"recent_matches":[{"close":24.959999084472656,"ema_fast":24.93711319529823,"ema_price":24.93711319529823,"ema_slow":24.934368664836413,"timestamp":"2026-02-25T00:00:00+00:00","volume":127900.0},{"close":25.020000457763672,"ema_fast":24.963306585687906,"ema_price":24.963306585687906,"ema_slow":24.949870504948887,"timestamp":"2026-03-03T00:00:00+00:00","volume":43400.0},{"close":24.979999542236328,"ema_fast":24.946061794829646,"ema_price":24.946061794829646,"ema_slow":24.946666298840764,"timestamp":"2026-03-11T00:00:00+00:00","volume":55400.0},{"close":24.68000030517578,"ema_fast":24.67889946678182,"ema_price":24.67889946678182,"ema_slow":24.7664489918055,"timestamp":"2026-03-31T00:00:00+00:00","volume":889900.0},{"close":24.719999313354492,"ema_fast":24.6596943082008,"ema_price":24.6596943082008,"ema_slow":24.72608329229637,"timestamp":"2026-04-08T00:00:00+00:00","volume":58846.0}],"rel_gap":0.002685,"rel_price_gap":0.002445,"signal":{"close":24.719999313354492,"timestamp":"2026-04-08T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.010739911098859991,"price":24.719999313354492,"recent_buys":[],"recent_sells":[],"signal":{"close":24.719999313354492,"timestamp":"2026-04-08T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"XELLL","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_bcc34e7ed0be in signals