SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-21T20:12:54.152594+00:00","reason_trace":{"cutoff_iso":"2026-04-18T20:12:54Z","eligible_timeframes":["1d"],"market_now":"2026-04-21T16:12:54.152613-04:00","period_key":"2026-04-21","recent_signal_hours":72,"signal_timestamp":"2026-04-20T00:00:00Z","strategy":"big_move"},"severity":"high","signal_type":"technical_indicator_signal","source":"technical_analyzer","value":{"bars":600,"confidence":0.8051880693740443,"details":{"atr":0.28596922474425546,"atr_normalized_move":0.8043,"bars":600,"last_buy":{"close":2.930000066757202,"timestamp":"2026-04-20T00:00:00Z"},"last_sell":{"close":2.049999952316284,"timestamp":"2026-03-30T00:00:00Z"},"macd_clarity":0.6251,"macd_gap":0.091865,"price_move_pct":0.0852,"recent_buys":[{"close":1.4900000095367432,"macdLine":0.07556076520932686,"rsi":64.74484180458214,"signalLine":0.0726744657659909,"timestamp":"2025-10-13T00:00:00+00:00","volume":381700.0},{"close":1.4500000476837158,"macdLine":0.009288722197255739,"rsi":60.489412631483965,"signalLine":-0.012865336759346088,"timestamp":"2025-12-03T00:00:00+00:00","volume":168600.0},{"close":1.4800000190734863,"macdLine":0.021765931182889275,"rsi":62.137415892529056,"signalLine":-0.005939083170899016,"timestamp":"2025-12-04T00:00:00+00:00","volume":90400.0},{"close":1.5399999618530273,"macdLine":0.04134006814249647,"rsi":64.40924680845873,"signalLine":0.009091051176376678,"timestamp":"2025-12-08T00:00:00+00:00","volume":72800.0},{"close":2.930000066757202,"macdLine":-0.05510226092226489,"rsi":62.01602053381024,"signalLine":-0.14696740540427541,"timestamp":"2026-04-20T00:00:00+00:00","volume":221500.0}],"recent_sells":[{"close":2.049999952316284,"macdLine":-0.23095044770525108,"rsi":31.379621960598243,"signalLine":-0.20516472346231407,"timestamp":"2026-03-30T00:00:00+00:00","volume":370200.0}],"rsi":62.01602053381024,"rsi_distance":0.2661,"signal":{"close":2.930000066757202,"timestamp":"2026-04-20T00:00:00Z"},"volume_clarity":0.7151,"volume_ratio":2.0726},"direction":"up","last_buy":{"close":2.930000066757202,"timestamp":"2026-04-20T00:00:00Z"},"last_sell":{"close":2.049999952316284,"timestamp":"2026-03-30T00:00:00Z"},"magnitude":0.8518519074501478,"price":2.930000066757202,"recent_buys":[{"close":1.4900000095367432,"macdLine":0.07556076520932686,"rsi":64.74484180458214,"signalLine":0.0726744657659909,"timestamp":"2025-10-13T00:00:00+00:00","volume":381700.0},{"close":1.4500000476837158,"macdLine":0.009288722197255739,"rsi":60.489412631483965,"signalLine":-0.012865336759346088,"timestamp":"2025-12-03T00:00:00+00:00","volume":168600.0},{"close":1.4800000190734863,"macdLine":0.021765931182889275,"rsi":62.137415892529056,"signalLine":-0.005939083170899016,"timestamp":"2025-12-04T00:00:00+00:00","volume":90400.0},{"close":1.5399999618530273,"macdLine":0.04134006814249647,"rsi":64.40924680845873,"signalLine":0.009091051176376678,"timestamp":"2025-12-08T00:00:00+00:00","volume":72800.0},{"close":2.930000066757202,"macdLine":-0.05510226092226489,"rsi":62.01602053381024,"signalLine":-0.14696740540427541,"timestamp":"2026-04-20T00:00:00+00:00","volume":221500.0}],"recent_sells":[{"close":2.049999952316284,"macdLine":-0.23095044770525108,"rsi":31.379621960598243,"signalLine":-0.20516472346231407,"timestamp":"2026-03-30T00:00:00+00:00","volume":370200.0}],"signal":{"close":2.930000066757202,"timestamp":"2026-04-20T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"TROO","timeframe":"1d","timeframe_bucket":"daily"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 472876 in events