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.577321665414688,"details":{"bars":600,"ema_fast":31.76125284327116,"ema_price":31.76125284327116,"ema_slow":31.66975951661034,"fast_length":12,"fast_slope":0.006098,"price_ema_length":12,"recent_matches":[{"close":29.479999542236328,"ema_fast":28.72441454796153,"ema_price":28.72441454796153,"ema_slow":28.687265919071685,"timestamp":"2025-06-26T00:00:00+00:00","volume":334200.0},{"close":30.489999771118164,"ema_fast":29.708002078403126,"ema_price":29.708002078403126,"ema_slow":29.67442862585339,"timestamp":"2025-08-12T00:00:00+00:00","volume":676800.0},{"close":30.200000762939453,"ema_fast":29.662368018134497,"ema_price":29.662368018134497,"ema_slow":29.637549040960547,"timestamp":"2025-11-07T00:00:00+00:00","volume":702500.0},{"close":33.31999969482422,"ema_fast":32.617982769987556,"ema_price":32.617982769987556,"ema_slow":32.552151971901814,"timestamp":"2026-02-03T00:00:00+00:00","volume":587300.0},{"close":32.81999969482422,"ema_fast":31.76125284327116,"ema_price":31.76125284327116,"ema_slow":31.66975951661034,"timestamp":"2026-04-08T00:00:00+00:00","volume":597100.0}],"rel_gap":0.002889,"rel_price_gap":0.033335,"signal":{"close":32.81999969482422,"timestamp":"2026-04-08T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.13333817236713483,"price":32.81999969482422,"recent_buys":[],"recent_sells":[],"signal":{"close":32.81999969482422,"timestamp":"2026-04-08T00:00:00Z"},"signal_kind":"emaCrossUp","strategy":"ema_signals","ticker":"WAFD","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_e9a9251195c3 in signals