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.5118444870378571,"details":{"bars":600,"ema_fast":3.61809358826687,"ema_price":3.61809358826687,"ema_slow":3.6835063237167223,"fast_length":12,"fast_slope":9.6e-05,"price_ema_length":12,"recent_matches":[{"close":4.53000020980835,"ema_fast":4.48653934134706,"ema_price":4.48653934134706,"ema_slow":4.6514078009191255,"timestamp":"2026-01-30T00:00:00+00:00","volume":437100.0},{"close":3.700000047683716,"ema_fast":3.6471723976763,"ema_price":3.6471723976763,"ema_slow":3.788723407045626,"timestamp":"2026-03-18T00:00:00+00:00","volume":311000.0},{"close":3.7200000286102295,"ema_fast":3.693497154407308,"ema_price":3.693497154407308,"ema_slow":3.7646338607492487,"timestamp":"2026-03-26T00:00:00+00:00","volume":165100.0},{"close":3.7100000381469727,"ema_fast":3.686468367795298,"ema_price":3.686468367795298,"ema_slow":3.75066688519365,"timestamp":"2026-03-30T00:00:00+00:00","volume":252600.0},{"close":3.619999885559082,"ema_fast":3.61809358826687,"ema_price":3.61809358826687,"ema_slow":3.6835063237167223,"timestamp":"2026-04-10T00:00:00+00:00","volume":696936.0}],"rel_gap":0.017758,"rel_price_gap":0.000527,"signal":{"close":3.619999885559082,"timestamp":"2026-04-10T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.07103311866596693,"price":3.619999885559082,"recent_buys":[],"recent_sells":[],"signal":{"close":3.619999885559082,"timestamp":"2026-04-10T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"RGP","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_e1e97ae0de45 in signals