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

{"body":"Direction: UP\nSignal bar close: 2026-04-20T00:00:00Z\nClose: 0.9323999881744385\nDetected at: 2026-04-20T20:17:10.987913+00:00","candidate_refs":[{"id":"ta_big_move:TMRC:1d:bigMoveUp:2026-04-20T00:00:00Z","kind":"ta_signal"},{"id":"asset:TMRC","kind":"entity"}],"channel":"C0A8Q869CNL","cta":["review","ignore"],"delivery_fp":"attn:C0A8Q869CNL:a2ecf76bc7640a5a1e13:2026-04-20T20","next_eligible_at":null,"nudge_kind":"opportunity","reason_trace":{"candidate_kind":"opportunity","personalization":{"fields_sample":["relationship.girlfriend_person_id"],"mode":"bootstrap","owner_fact_count":1},"reason":"big_move:up","signal_kind":"bigMoveUp","signal_price":0.9323999881744385,"signal_ts":"2026-04-20T00:00:00Z","source_daemon":"technical_analyzer","ticker":"TMRC","timeframe":"1d"},"score":88.0,"score_breakdown":{"floored_score":88.0,"kind":"opportunity","producer_score":88.0},"suppression_rules_applied":[],"thread_id":null,"title":"Big Move: TMRC UP (1d)","topic_key":"candidate:opportunity:ta_big_move:TMRC:1d:bigMoveUp:2026-04-20T00:00:00Z","why_now":"Big-move UP signal on 1d"}

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 465161 in events