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.5441558186253445,"details":{"bars":600,"ema_fast":0.5717947435346251,"ema_price":0.5717947435346251,"ema_slow":0.5913030968406593,"fast_length":12,"fast_slope":0.002616,"price_ema_length":12,"recent_matches":[{"close":0.5600000023841858,"ema_fast":0.5574749459247305,"ema_price":0.5574749459247305,"ema_slow":0.6830347101441128,"timestamp":"2026-02-24T00:00:00+00:00","volume":315900.0},{"close":0.6399999856948853,"ema_fast":0.6181998467428551,"ema_price":0.6181998467428551,"ema_slow":0.6351938273485725,"timestamp":"2026-03-19T00:00:00+00:00","volume":501100.0},{"close":0.6200000047683716,"ema_fast":0.6174093603229328,"ema_price":0.6174093603229328,"ema_slow":0.6323403882930118,"timestamp":"2026-03-23T00:00:00+00:00","volume":247000.0},{"close":0.6000000238418579,"ema_fast":0.5949943261398883,"ema_price":0.5949943261398883,"ema_slow":0.6133110163562555,"timestamp":"2026-04-01T00:00:00+00:00","volume":816900.0},{"close":0.5799999833106995,"ema_fast":0.5717947435346251,"ema_price":0.5717947435346251,"ema_slow":0.5913030968406593,"timestamp":"2026-04-13T00:00:00+00:00","volume":1257200.0}],"rel_gap":0.032992,"rel_price_gap":0.01435,"signal":{"close":0.5799999833106995,"timestamp":"2026-04-13T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.13196855156191523,"price":0.5799999833106995,"recent_buys":[],"recent_sells":[],"signal":{"close":0.5799999833106995,"timestamp":"2026-04-13T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"VTGN","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_088b343125fb in signals