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.8736000061035156\nDetected at: 2026-04-20T20:11:54.360053+00:00","candidate_refs":[{"id":"ta_big_move:ZEO:1d:bigMoveUp:2026-04-20T00:00:00Z","kind":"ta_signal"},{"id":"asset:ZEO","kind":"entity"}],"channel":"C0A8Q869CNL","cta":["review","ignore"],"delivery_fp":"attn:C0A8Q869CNL:a037f13b02aeb2aae7ee: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.8736000061035156,"signal_ts":"2026-04-20T00:00:00Z","source_daemon":"technical_analyzer","ticker":"ZEO","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: ZEO UP (1d)","topic_key":"candidate:opportunity:ta_big_move:ZEO: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 465139 in events