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.5430244960982259,"details":{"bars":600,"ema_fast":5.335595353805998,"ema_price":5.335595353805998,"ema_slow":5.3358594602017,"fast_length":12,"fast_slope":-0.000531,"price_ema_length":12,"recent_matches":[{"close":7.170000076293945,"ema_fast":7.195059447385654,"ema_price":7.195059447385654,"ema_slow":7.196704551451691,"timestamp":"2025-06-12T00:00:00+00:00","volume":4996700.0},{"close":7.210000038146973,"ema_fast":7.895221175919344,"ema_price":7.895221175919344,"ema_slow":7.950138295612869,"timestamp":"2025-07-31T00:00:00+00:00","volume":8319900.0},{"close":8.0600004196167,"ema_fast":8.417005563072173,"ema_price":8.417005563072173,"ema_slow":8.437501880475732,"timestamp":"2025-11-05T00:00:00+00:00","volume":5210400.0},{"close":7.25,"ema_fast":7.372631402553598,"ema_price":7.372631402553598,"ema_slow":7.383187117169445,"timestamp":"2026-01-12T00:00:00+00:00","volume":3679200.0},{"close":5.320000171661377,"ema_fast":5.335595353805998,"ema_price":5.335595353805998,"ema_slow":5.3358594602017,"timestamp":"2026-04-06T00:00:00+00:00","volume":2199100.0}],"rel_gap":4.9e-05,"rel_price_gap":0.002923,"signal":{"close":5.320000171661377,"timestamp":"2026-04-06T00:00:00Z"},"slow_length":26},"direction":"down","last_buy":null,"last_sell":null,"magnitude":0.011691427936713395,"price":5.320000171661377,"recent_buys":[],"recent_sells":[],"signal":{"close":5.320000171661377,"timestamp":"2026-04-06T00:00:00Z"},"signal_kind":"emaCrossDown","strategy":"ema_signals","ticker":"TDOC","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_419664aaa546 in signals