SQLite Web: event

Could not fetch row with primary-key sig_07a7babf9d20.

Could not fetch row with primary-key sig_3bd1e99e5a3a.

Could not fetch row with primary-key sig_c99c34c7d646.

Could not fetch row with primary-key sig_0e21e163c07d.

Update row sig_f34aa87c9a43 in signals

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"bars":600,"confidence":0.7379739895559589,"details":{"atr_14":0.238743,"bars":600,"ema_fast":2.6905540882406624,"ema_price":2.6905540882406624,"ema_slow":2.6413532669535034,"fast_length":12,"fast_slope":0.037106,"price_ema_length":12,"recent_matches":[{"close":5.150000095367432,"ema_fast":5.063007923942087,"ema_price":5.063007923942087,"ema_slow":5.057841306764328,"timestamp":"2024-12-05T00:00:00+00:00","volume":336900.0},{"close":4.989999771118164,"ema_fast":3.647036927757502,"ema_price":3.647036927757502,"ema_slow":3.5879523933445467,"timestamp":"2025-04-02T00:00:00+00:00","volume":17189100.0},{"close":3.4800000190734863,"ema_fast":3.160181809345251,"ema_price":3.160181809345251,"ema_slow":3.1507756148737673,"timestamp":"2025-12-02T00:00:00+00:00","volume":357000.0},{"close":3.259999990463257,"ema_fast":2.735266241654273,"ema_price":2.735266241654273,"ema_slow":2.693035700451718,"timestamp":"2026-03-16T00:00:00+00:00","volume":1565500.0},{"close":3.2200000286102295,"ema_fast":2.6905540882406624,"ema_price":2.6905540882406624,"ema_slow":2.6413532669535034,"timestamp":"2026-04-16T00:00:00+00:00","volume":627594.0}],"rel_gap":0.018627,"rel_price_gap":0.19678,"signal":{"close":3.2200000286102295,"timestamp":"2026-04-16T00:00:00Z"},"slow_length":26},"direction":"up","last_buy":null,"last_sell":null,"magnitude":0.787118077549251,"price":3.2200000286102295,"recent_buys":[],"recent_sells":[],"signal":{"close":3.2200000286102295,"timestamp":"2026-04-16T00:00:00Z"},"signal_kind":"emaCrossUp","strategy":"ema_signals","ticker":"TTEC","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_f34aa87c9a43 in signals