SQLite Web: event

Could not fetch row with primary-key sig_0c998b7a9dde.

Could not fetch row with primary-key sig_e2fb9176c4da.

Update row sig_76ae3c08ff0e in signals

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"bars":600,"confidence":0.5600151949576894,"details":{"bars":600,"ema_fast":246.8363384905057,"ema_price":246.8363384905057,"ema_slow":246.52947428849802,"fast_length":12,"fast_slope":0.003328,"price_ema_length":12,"recent_matches":[{"close":226.60000610351562,"ema_fast":223.1911354259331,"ema_price":223.1911354259331,"ema_slow":222.95462944891085,"timestamp":"2025-06-10T00:00:00+00:00","volume":3122200.0},{"close":230.36000061035156,"ema_fast":222.4129147385201,"ema_price":222.4129147385201,"ema_slow":221.73234448000517,"timestamp":"2025-09-24T00:00:00+00:00","volume":5925900.0},{"close":229.1300048828125,"ema_fast":223.57645228378422,"ema_price":223.57645228378422,"ema_slow":223.1142087123289,"timestamp":"2025-11-25T00:00:00+00:00","volume":2582500.0},{"close":235.10000610351562,"ema_fast":231.0136683662243,"ema_price":231.0136683662243,"ema_slow":230.80137138880255,"timestamp":"2026-01-30T00:00:00+00:00","volume":3841100.0},{"close":251.33999633789062,"ema_fast":246.8363384905057,"ema_price":246.8363384905057,"ema_slow":246.52947428849802,"timestamp":"2026-04-13T00:00:00+00:00","volume":1590900.0}],"rel_gap":0.001245,"rel_price_gap":0.018246,"signal":{"close":251.33999633789062,"timestamp":"2026-04-13T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.07298208804953803,"price":251.33999633789062,"recent_buys":[],"recent_sells":[],"signal":{"close":251.33999633789062,"timestamp":"2026-04-13T00:00:00Z"},"signal_kind":"emaCrossUp","strategy":"ema_signals","ticker":"UNP","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')

Cancel

event_store.db — signals

Update row sig_76ae3c08ff0e in signals