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.5319100295429786,"details":{"bars":600,"ema_fast":74.9622177481804,"ema_price":74.9622177481804,"ema_slow":73.62700762170289,"fast_length":12,"fast_slope":0.003622,"price_ema_length":12,"recent_matches":[{"close":62.279998779296875,"ema_fast":61.97682206994573,"ema_price":61.97682206994573,"ema_slow":60.65670577773329,"timestamp":"2025-11-18T00:00:00+00:00","volume":709600.0},{"close":61.84000015258789,"ema_fast":61.62268084377315,"ema_price":61.62268084377315,"ema_slow":60.738441593568744,"timestamp":"2025-11-21T00:00:00+00:00","volume":1043100.0},{"close":51.72999954223633,"ema_fast":51.212802921092575,"ema_price":51.212802921092575,"ema_slow":52.93372226746789,"timestamp":"2026-01-06T00:00:00+00:00","volume":1207700.0},{"close":70.68000030517578,"ema_fast":70.34102582697525,"ema_price":70.34102582697525,"ema_slow":70.47386208460512,"timestamp":"2026-03-23T00:00:00+00:00","volume":2015600.0},{"close":76.44999694824219,"ema_fast":74.9622177481804,"ema_price":74.9622177481804,"ema_slow":73.62700762170289,"timestamp":"2026-04-13T00:00:00+00:00","volume":875770.0}],"rel_gap":0.018135,"rel_price_gap":0.019847,"signal":{"close":76.44999694824219,"timestamp":"2026-04-13T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.07938821687798361,"price":76.44999694824219,"recent_buys":[],"recent_sells":[],"signal":{"close":76.44999694824219,"timestamp":"2026-04-13T00:00:00Z"},"signal_kind":"priceAboveEma12","strategy":"ema_signals","ticker":"STNG","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_18b7a124f89f in signals