SQLite Web: event_store.db

Update row 44565 in events

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-14T20:31:28.776446+00:00","reason_trace":{"cutoff_iso":"2026-04-11T20:31:28Z","eligible_timeframes":["1d"],"market_now":"2026-04-14T16:31:28.776462-04:00","period_key":"2026-04-14","recent_signal_hours":72,"signal_timestamp":"2026-04-14T00:00:00Z","strategy":"big_move"},"severity":"high","signal_type":"technical_indicator_signal","source":"technical_analyzer","value":{"bars":600,"confidence":0.7782437572116848,"details":{"atr":3.468852477311697,"atr_normalized_move":2.0266,"bars":600,"last_buy":{"close":57.40999984741211,"timestamp":"2026-04-14T00:00:00Z"},"last_sell":{"close":26.459999084472656,"timestamp":"2025-11-17T00:00:00Z"},"macd_clarity":0.4439,"macd_gap":0.71999,"price_move_pct":0.1395,"recent_buys":[{"close":40.61000061035156,"macdLine":1.1963080629896439,"rsi":65.79669534516964,"signalLine":0.6995812990368486,"timestamp":"2024-02-12T00:00:00+00:00","volume":1715600.0},{"close":53.29999923706055,"macdLine":0.8635816173267727,"rsi":65.90344740606845,"signalLine":0.04343902913743747,"timestamp":"2025-01-23T00:00:00+00:00","volume":995500.0},{"close":54.06999969482422,"macdLine":1.256626123218581,"rsi":67.27207131746839,"signalLine":0.28607644795366616,"timestamp":"2025-01-24T00:00:00+00:00","volume":1007100.0},{"close":36.869998931884766,"macdLine":0.9010438478409881,"rsi":67.18807152259953,"signalLine":0.6793735741075253,"timestamp":"2026-01-06T00:00:00+00:00","volume":2016700.0},{"close":57.40999984741211,"macdLine":1.6219189958362108,"rsi":66.35391295897598,"signalLine":0.9019289655232663,"timestamp":"2026-04-14T00:00:00+00:00","volume":2917110.0}],"recent_sells":[{"close":41.310001373291016,"macdLine":-1.1120658324566932,"rsi":33.82969750309255,"signalLine":-0.1532874756506761,"timestamp":"2025-02-21T00:00:00+00:00","volume":1567800.0},{"close":32.75,"macdLine":-0.9246999634913635,"rsi":36.19260239529659,"signalLine":-0.6410959439654256,"timestamp":"2025-05-06T00:00:00+00:00","volume":1968600.0},{"close":30.209999084472656,"macdLine":-0.6820307822067377,"rsi":31.462501598376193,"signalLine":-0.06442464209437478,"timestamp":"2025-08-04T00:00:00+00:00","volume":4900500.0},{"close":26.8700008392334,"macdLine":-0.23634662427496167,"rsi":38.05564445774043,"signalLine":0.2700451662395951,"timestamp":"2025-11-14T00:00:00+00:00","volume":5759200.0},{"close":26.459999084472656,"macdLine":-0.5417221964697951,"rsi":37.114397308492904,"signalLine":0.10769169369771708,"timestamp":"2025-11-17T00:00:00+00:00","volume":3592200.0}],"rsi":66.35391295897598,"rsi_distance":0.1215,"signal":{"close":57.40999984741211,"timestamp":"2026-04-14T00:00:00Z"},"volume_clarity":0.9343,"volume_ratio":2.4014},"direction":"up","last_buy":{"close":57.40999984741211,"timestamp":"2026-04-14T00:00:00Z"},"last_sell":{"close":26.459999084472656,"timestamp":"2025-11-17T00:00:00Z"},"magnitude":1.3953947261319248,"price":57.40999984741211,"recent_buys":[{"close":40.61000061035156,"macdLine":1.1963080629896439,"rsi":65.79669534516964,"signalLine":0.6995812990368486,"timestamp":"2024-02-12T00:00:00+00:00","volume":1715600.0},{"close":53.29999923706055,"macdLine":0.8635816173267727,"rsi":65.90344740606845,"signalLine":0.04343902913743747,"timestamp":"2025-01-23T00:00:00+00:00","volume":995500.0},{"close":54.06999969482422,"macdLine":1.256626123218581,"rsi":67.27207131746839,"signalLine":0.28607644795366616,"timestamp":"2025-01-24T00:00:00+00:00","volume":1007100.0},{"close":36.869998931884766,"macdLine":0.9010438478409881,"rsi":67.18807152259953,"signalLine":0.6793735741075253,"timestamp":"2026-01-06T00:00:00+00:00","volume":2016700.0},{"close":57.40999984741211,"macdLine":1.6219189958362108,"rsi":66.35391295897598,"signalLine":0.9019289655232663,"timestamp":"2026-04-14T00:00:00+00:00","volume":2917110.0}],"recent_sells":[{"close":41.310001373291016,"macdLine":-1.1120658324566932,"rsi":33.82969750309255,"signalLine":-0.1532874756506761,"timestamp":"2025-02-21T00:00:00+00:00","volume":1567800.0},{"close":32.75,"macdLine":-0.9246999634913635,"rsi":36.19260239529659,"signalLine":-0.6410959439654256,"timestamp":"2025-05-06T00:00:00+00:00","volume":1968600.0},{"close":30.209999084472656,"macdLine":-0.6820307822067377,"rsi":31.462501598376193,"signalLine":-0.06442464209437478,"timestamp":"2025-08-04T00:00:00+00:00","volume":4900500.0},{"close":26.8700008392334,"macdLine":-0.23634662427496167,"rsi":38.05564445774043,"signalLine":0.2700451662395951,"timestamp":"2025-11-14T00:00:00+00:00","volume":5759200.0},{"close":26.459999084472656,"macdLine":-0.5417221964697951,"rsi":37.114397308492904,"signalLine":0.10769169369771708,"timestamp":"2025-11-17T00:00:00+00:00","volume":3592200.0}],"signal":{"close":57.40999984741211,"timestamp":"2026-04-14T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"TWST","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')

Cancel