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.5499677695904509,"details":{"bars":600,"ema_fast":3.5390026177950396,"ema_price":3.5390026177950396,"ema_slow":3.6981962658362026,"fast_length":12,"fast_slope":-0.001488,"price_ema_length":12,"recent_matches":[{"close":3.9000000953674316,"ema_fast":3.9005162402603917,"ema_price":3.9005162402603917,"ema_slow":4.110770935544279,"timestamp":"2026-03-09T00:00:00+00:00","volume":10200.0},{"close":3.7899999618530273,"ema_fast":3.888653641056427,"ema_price":3.888653641056427,"ema_slow":4.075297442409138,"timestamp":"2026-03-11T00:00:00+00:00","volume":9800.0},{"close":3.8499999046325684,"ema_fast":3.885485739506211,"ema_price":3.885485739506211,"ema_slow":4.0472714686521325,"timestamp":"2026-03-13T00:00:00+00:00","volume":5000.0},{"close":3.7200000286102295,"ema_fast":3.8577961972211465,"ema_price":3.8577961972211465,"ema_slow":3.990284796513443,"timestamp":"2026-03-19T00:00:00+00:00","volume":3500.0},{"close":3.509999990463257,"ema_fast":3.5390026177950396,"ema_price":3.5390026177950396,"ema_slow":3.6981962658362026,"timestamp":"2026-04-07T00:00:00+00:00","volume":10400.0}],"rel_gap":0.043046,"rel_price_gap":0.008195,"signal":{"close":3.509999990463257,"timestamp":"2026-04-07T00:00:00Z"},"slow_length":26},"direction":"down","last_buy":null,"last_sell":null,"magnitude":0.17218518066419353,"price":3.509999990463257,"recent_buys":[],"recent_sells":[],"signal":{"close":3.509999990463257,"timestamp":"2026-04-07T00:00:00Z"},"signal_kind":"priceBelowEma12","strategy":"ema_signals","ticker":"GWAV","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_7a8b46a85df8 in signals