SQLite Web: event_store.db

Update row 50170 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-15T20:24:04.146607+00:00","reason_trace":{"cutoff_iso":"2026-04-12T20:24:04Z","eligible_timeframes":["1d"],"market_now":"2026-04-15T16:24:04.146621-04:00","period_key":"2026-04-15","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.7435086822681067,"details":{"atr":0.463304904443515,"atr_normalized_move":1.2519,"bars":600,"last_buy":{"close":10.569999694824219,"timestamp":"2026-04-14T00:00:00Z"},"last_sell":{"close":8.15999984741211,"timestamp":"2025-12-16T00:00:00Z"},"macd_clarity":0.208,"macd_gap":0.139332,"price_move_pct":0.052,"recent_buys":[{"close":16.360000610351562,"macdLine":0.27033734568005485,"rsi":65.5533458247489,"signalLine":0.1873869201865675,"timestamp":"2024-12-02T00:00:00+00:00","volume":12213.0},{"close":17.0,"macdLine":0.2600332903111795,"rsi":63.53882967104375,"signalLine":0.040885412192105695,"timestamp":"2025-01-22T00:00:00+00:00","volume":7100.0},{"close":18.0,"macdLine":0.5712825929152103,"rsi":69.57979209584889,"signalLine":0.2559273063200268,"timestamp":"2025-01-27T00:00:00+00:00","volume":7650.0},{"close":19.989999771118164,"macdLine":0.6649692671670273,"rsi":67.3247327591977,"signalLine":0.5136191257905768,"timestamp":"2025-02-25T00:00:00+00:00","volume":12560.0},{"close":10.569999694824219,"macdLine":0.6697797525228388,"rsi":67.53907055798183,"signalLine":0.5304475466636929,"timestamp":"2026-04-14T00:00:00+00:00","volume":23365.0}],"recent_sells":[{"close":13.34000015258789,"macdLine":0.0046357119508044775,"rsi":42.47651597068836,"signalLine":0.1720782212611462,"timestamp":"2024-10-31T00:00:00+00:00","volume":8075.0},{"close":14.350000381469727,"macdLine":-0.23186967815021475,"rsi":36.896325337926115,"signalLine":-0.1960368156591878,"timestamp":"2025-07-23T00:00:00+00:00","volume":11152.0},{"close":9.199999809265137,"macdLine":-0.938826045969197,"rsi":32.12292052163052,"signalLine":-0.8698724586108804,"timestamp":"2025-09-02T00:00:00+00:00","volume":40110.0},{"close":8.8100004196167,"macdLine":-0.22702225941468335,"rsi":37.50131996618331,"signalLine":-0.12386400423154553,"timestamp":"2025-11-20T00:00:00+00:00","volume":7250.0},{"close":8.15999984741211,"macdLine":-0.24377710786439977,"rsi":32.72042827526843,"signalLine":-0.16564327547375257,"timestamp":"2025-12-16T00:00:00+00:00","volume":11572.0}],"rsi":67.53907055798183,"rsi_distance":0.082,"signal":{"close":10.569999694824219,"timestamp":"2026-04-14T00:00:00Z"},"volume_clarity":1.0,"volume_ratio":12.3243},"direction":"up","last_buy":{"close":10.569999694824219,"timestamp":"2026-04-14T00:00:00Z"},"last_sell":{"close":8.15999984741211,"timestamp":"2025-12-16T00:00:00Z"},"magnitude":0.5201793215688978,"price":10.569999694824219,"recent_buys":[{"close":16.360000610351562,"macdLine":0.27033734568005485,"rsi":65.5533458247489,"signalLine":0.1873869201865675,"timestamp":"2024-12-02T00:00:00+00:00","volume":12213.0},{"close":17.0,"macdLine":0.2600332903111795,"rsi":63.53882967104375,"signalLine":0.040885412192105695,"timestamp":"2025-01-22T00:00:00+00:00","volume":7100.0},{"close":18.0,"macdLine":0.5712825929152103,"rsi":69.57979209584889,"signalLine":0.2559273063200268,"timestamp":"2025-01-27T00:00:00+00:00","volume":7650.0},{"close":19.989999771118164,"macdLine":0.6649692671670273,"rsi":67.3247327591977,"signalLine":0.5136191257905768,"timestamp":"2025-02-25T00:00:00+00:00","volume":12560.0},{"close":10.569999694824219,"macdLine":0.6697797525228388,"rsi":67.53907055798183,"signalLine":0.5304475466636929,"timestamp":"2026-04-14T00:00:00+00:00","volume":23365.0}],"recent_sells":[{"close":13.34000015258789,"macdLine":0.0046357119508044775,"rsi":42.47651597068836,"signalLine":0.1720782212611462,"timestamp":"2024-10-31T00:00:00+00:00","volume":8075.0},{"close":14.350000381469727,"macdLine":-0.23186967815021475,"rsi":36.896325337926115,"signalLine":-0.1960368156591878,"timestamp":"2025-07-23T00:00:00+00:00","volume":11152.0},{"close":9.199999809265137,"macdLine":-0.938826045969197,"rsi":32.12292052163052,"signalLine":-0.8698724586108804,"timestamp":"2025-09-02T00:00:00+00:00","volume":40110.0},{"close":8.8100004196167,"macdLine":-0.22702225941468335,"rsi":37.50131996618331,"signalLine":-0.12386400423154553,"timestamp":"2025-11-20T00:00:00+00:00","volume":7250.0},{"close":8.15999984741211,"macdLine":-0.24377710786439977,"rsi":32.72042827526843,"signalLine":-0.16564327547375257,"timestamp":"2025-12-16T00:00:00+00:00","volume":11572.0}],"signal":{"close":10.569999694824219,"timestamp":"2026-04-14T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"TLPPF","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