SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"bars":505,"confidence":0.49348626224917697,"details":{"bars":505,"ema_fast":10.974348321206804,"ema_price":10.974348321206804,"ema_slow":10.964163816072007,"fast_length":12,"fast_slope":0.000425,"price_ema_length":12,"recent_matches":[{"close":10.970000267028809,"ema_fast":10.954274151346713,"ema_price":10.954274151346713,"ema_slow":10.941451246307274,"timestamp":"2026-03-11T00:00:00+00:00","volume":31500.0},{"close":10.970000267028809,"ema_fast":10.954364505930814,"ema_price":10.954364505930814,"ema_slow":10.944009313010113,"timestamp":"2026-03-16T00:00:00+00:00","volume":32000.0},{"close":10.979999542236328,"ema_fast":10.967637275316346,"ema_price":10.967637275316346,"ema_slow":10.95736513802751,"timestamp":"2026-03-26T00:00:00+00:00","volume":4600.0},{"close":10.989999771118164,"ema_fast":10.971445168964598,"ema_price":10.971445168964598,"ema_slow":10.96140067201463,"timestamp":"2026-03-31T00:00:00+00:00","volume":125500.0},{"close":11.0,"ema_fast":10.974348321206804,"ema_price":10.974348321206804,"ema_slow":10.964163816072007,"timestamp":"2026-04-02T00:00:00+00:00","volume":1800.0}],"rel_gap":0.000929,"rel_price_gap":0.002337,"signal":{"close":11.0,"timestamp":"2026-04-02T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.00934968639317799,"price":11.0,"recent_buys":[],"recent_sells":[],"signal":{"close":11.0,"timestamp":"2026-04-02T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"LEGT","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_6b5362a90957 in signals