SQLite Web: event_store.db

Update row 50939 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-15T22:09:32.485078+00:00","reason_trace":{"cutoff_iso":"2026-04-12T22:09:32Z","eligible_timeframes":["1d"],"market_now":"2026-04-15T18:09:32.485112-04:00","period_key":"2026-04-15","recent_signal_hours":72,"signal_timestamp":"2026-04-15T00:00:00Z","strategy":"big_move"},"severity":"high","signal_type":"technical_indicator_signal","source":"technical_analyzer","value":{"bars":600,"confidence":0.7679579341124216,"details":{"atr":0.2079683045728484,"atr_normalized_move":1.731,"bars":600,"last_buy":{"close":2.0199999809265137,"timestamp":"2026-01-16T00:00:00Z"},"last_sell":{"close":1.2300000190734863,"timestamp":"2026-04-15T00:00:00Z"},"macd_clarity":0.4038,"macd_gap":0.048269,"price_move_pct":0.2264,"recent_buys":[{"close":20.75,"macdLine":0.6749483650978334,"rsi":66.77688602367402,"signalLine":0.2615386669389813,"timestamp":"2024-03-01T00:00:00+00:00","volume":4308.0},{"close":25.25,"macdLine":1.0408165836333794,"rsi":69.93873659934037,"signalLine":0.9152605478698281,"timestamp":"2024-03-28T00:00:00+00:00","volume":8684.0},{"close":1.8700000047683716,"macdLine":-0.05723541186880543,"rsi":64.4585513589461,"signalLine":-0.14462034263188572,"timestamp":"2025-06-03T00:00:00+00:00","volume":62770700.0},{"close":1.690000057220459,"macdLine":0.022676105848802086,"rsi":59.573764206068574,"signalLine":0.00322104615384523,"timestamp":"2025-07-23T00:00:00+00:00","volume":143200.0},{"close":2.0199999809265137,"macdLine":-0.046559456377858854,"rsi":62.10046141849115,"signalLine":-0.1570396694216297,"timestamp":"2026-01-16T00:00:00+00:00","volume":986800.0}],"recent_sells":[{"close":7.75,"macdLine":-0.35922661927297206,"rsi":34.807509112029734,"signalLine":-0.31721994996887776,"timestamp":"2024-09-18T00:00:00+00:00","volume":35316.0},{"close":7.75,"macdLine":-0.3968647535462697,"rsi":34.807509112029734,"signalLine":-0.33314891068435615,"timestamp":"2024-09-19T00:00:00+00:00","volume":20524.0},{"close":5.059999942779541,"macdLine":-0.2472989741518674,"rsi":33.366266276101484,"signalLine":-0.02386349962744823,"timestamp":"2025-02-18T00:00:00+00:00","volume":125900.0},{"close":1.399999976158142,"macdLine":-0.07808737827453127,"rsi":31.22287207052699,"signalLine":-0.013152453942597188,"timestamp":"2025-12-17T00:00:00+00:00","volume":4474700.0},{"close":1.2300000190734863,"macdLine":-0.11954439213186685,"rsi":31.478465779604377,"signalLine":-0.07127586906883986,"timestamp":"2026-04-15T00:00:00+00:00","volume":1506723.0}],"rsi":31.478465779604377,"rsi_distance":0.0493,"signal":{"close":1.2300000190734863,"timestamp":"2026-04-15T00:00:00Z"},"volume_clarity":1.0,"volume_ratio":12.0061},"direction":"down","last_buy":{"close":2.0199999809265137,"timestamp":"2026-01-16T00:00:00Z"},"last_sell":{"close":1.2300000190734863,"timestamp":"2026-04-15T00:00:00Z"},"magnitude":2.0,"price":1.2300000190734863,"recent_buys":[{"close":20.75,"macdLine":0.6749483650978334,"rsi":66.77688602367402,"signalLine":0.2615386669389813,"timestamp":"2024-03-01T00:00:00+00:00","volume":4308.0},{"close":25.25,"macdLine":1.0408165836333794,"rsi":69.93873659934037,"signalLine":0.9152605478698281,"timestamp":"2024-03-28T00:00:00+00:00","volume":8684.0},{"close":1.8700000047683716,"macdLine":-0.05723541186880543,"rsi":64.4585513589461,"signalLine":-0.14462034263188572,"timestamp":"2025-06-03T00:00:00+00:00","volume":62770700.0},{"close":1.690000057220459,"macdLine":0.022676105848802086,"rsi":59.573764206068574,"signalLine":0.00322104615384523,"timestamp":"2025-07-23T00:00:00+00:00","volume":143200.0},{"close":2.0199999809265137,"macdLine":-0.046559456377858854,"rsi":62.10046141849115,"signalLine":-0.1570396694216297,"timestamp":"2026-01-16T00:00:00+00:00","volume":986800.0}],"recent_sells":[{"close":7.75,"macdLine":-0.35922661927297206,"rsi":34.807509112029734,"signalLine":-0.31721994996887776,"timestamp":"2024-09-18T00:00:00+00:00","volume":35316.0},{"close":7.75,"macdLine":-0.3968647535462697,"rsi":34.807509112029734,"signalLine":-0.33314891068435615,"timestamp":"2024-09-19T00:00:00+00:00","volume":20524.0},{"close":5.059999942779541,"macdLine":-0.2472989741518674,"rsi":33.366266276101484,"signalLine":-0.02386349962744823,"timestamp":"2025-02-18T00:00:00+00:00","volume":125900.0},{"close":1.399999976158142,"macdLine":-0.07808737827453127,"rsi":31.22287207052699,"signalLine":-0.013152453942597188,"timestamp":"2025-12-17T00:00:00+00:00","volume":4474700.0},{"close":1.2300000190734863,"macdLine":-0.11954439213186685,"rsi":31.478465779604377,"signalLine":-0.07127586906883986,"timestamp":"2026-04-15T00:00:00+00:00","volume":1506723.0}],"signal":{"close":1.2300000190734863,"timestamp":"2026-04-15T00:00:00Z"},"signal_kind":"bigMoveDown","strategy":"big_move","ticker":"TRAW","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