SQLite Web: event_store.db

Update row 46016 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-15T02:21:58.376549+00:00","reason_trace":{"cutoff_iso":"2026-04-12T02:21:58Z","eligible_timeframes":["1d"],"market_now":"2026-04-14T22:21:58.376567-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.7464750483909826,"details":{"atr":0.004567235256378904,"atr_normalized_move":2.3647,"bars":600,"last_buy":{"close":0.02539999969303608,"timestamp":"2026-04-14T00:00:00Z"},"last_sell":{"close":0.014449999667704105,"timestamp":"2025-09-04T00:00:00Z"},"macd_clarity":0.0107,"macd_gap":0.000107,"price_move_pct":0.7397,"recent_buys":[{"close":0.04399999976158142,"macdLine":0.0010638949807716784,"rsi":68.89929442624765,"signalLine":7.295651177067445e-06,"timestamp":"2025-06-20T00:00:00+00:00","volume":927030.0},{"close":0.016355000436306,"macdLine":-0.0006309971138439129,"rsi":54.53109102331808,"signalLine":-0.0012675824184375034,"timestamp":"2025-10-16T00:00:00+00:00","volume":843367.0},{"close":0.019999999552965164,"macdLine":-9.382990736313095e-05,"rsi":61.628295108700854,"signalLine":-0.001032831916222629,"timestamp":"2025-10-17T00:00:00+00:00","volume":3344843.0},{"close":0.018200000748038292,"macdLine":0.0007044987502243388,"rsi":62.41810211051935,"signalLine":0.00019878607519670984,"timestamp":"2026-03-02T00:00:00+00:00","volume":477726.0},{"close":0.02539999969303608,"macdLine":-4.24702776967191e-05,"rsi":61.02538903024287,"signalLine":-0.0001492698471765122,"timestamp":"2026-04-14T00:00:00+00:00","volume":2003699.0}],"recent_sells":[{"close":0.01899999938905239,"macdLine":-0.001949747431398443,"rsi":36.76059656202042,"signalLine":-0.001668210460151609,"timestamp":"2025-04-04T00:00:00+00:00","volume":384966.0},{"close":0.025550000369548798,"macdLine":4.710637695686665e-05,"rsi":42.70583375438085,"signalLine":0.0004746733351437502,"timestamp":"2025-05-30T00:00:00+00:00","volume":451099.0},{"close":0.01850000023841858,"macdLine":-0.0011409353092072562,"rsi":39.600075652205184,"signalLine":-0.0007005258777646383,"timestamp":"2025-08-27T00:00:00+00:00","volume":1053007.0},{"close":0.013000000268220901,"macdLine":-0.0017284778319108171,"rsi":34.70724436140907,"signalLine":-0.00106185450410954,"timestamp":"2025-09-03T00:00:00+00:00","volume":748736.0},{"close":0.014449999667704105,"macdLine":-0.002125742159757499,"rsi":37.52111973010491,"signalLine":-0.0012746320352391319,"timestamp":"2025-09-04T00:00:00+00:00","volume":534984.0}],"rsi":61.02538903024287,"rsi_distance":0.2992,"signal":{"close":0.02539999969303608,"timestamp":"2026-04-14T00:00:00Z"},"volume_clarity":1.0,"volume_ratio":5.3983},"direction":"up","last_buy":{"close":0.02539999969303608,"timestamp":"2026-04-14T00:00:00Z"},"last_sell":{"close":0.014449999667704105,"timestamp":"2025-09-04T00:00:00Z"},"magnitude":2.0,"price":0.02539999969303608,"recent_buys":[{"close":0.04399999976158142,"macdLine":0.0010638949807716784,"rsi":68.89929442624765,"signalLine":7.295651177067445e-06,"timestamp":"2025-06-20T00:00:00+00:00","volume":927030.0},{"close":0.016355000436306,"macdLine":-0.0006309971138439129,"rsi":54.53109102331808,"signalLine":-0.0012675824184375034,"timestamp":"2025-10-16T00:00:00+00:00","volume":843367.0},{"close":0.019999999552965164,"macdLine":-9.382990736313095e-05,"rsi":61.628295108700854,"signalLine":-0.001032831916222629,"timestamp":"2025-10-17T00:00:00+00:00","volume":3344843.0},{"close":0.018200000748038292,"macdLine":0.0007044987502243388,"rsi":62.41810211051935,"signalLine":0.00019878607519670984,"timestamp":"2026-03-02T00:00:00+00:00","volume":477726.0},{"close":0.02539999969303608,"macdLine":-4.24702776967191e-05,"rsi":61.02538903024287,"signalLine":-0.0001492698471765122,"timestamp":"2026-04-14T00:00:00+00:00","volume":2003699.0}],"recent_sells":[{"close":0.01899999938905239,"macdLine":-0.001949747431398443,"rsi":36.76059656202042,"signalLine":-0.001668210460151609,"timestamp":"2025-04-04T00:00:00+00:00","volume":384966.0},{"close":0.025550000369548798,"macdLine":4.710637695686665e-05,"rsi":42.70583375438085,"signalLine":0.0004746733351437502,"timestamp":"2025-05-30T00:00:00+00:00","volume":451099.0},{"close":0.01850000023841858,"macdLine":-0.0011409353092072562,"rsi":39.600075652205184,"signalLine":-0.0007005258777646383,"timestamp":"2025-08-27T00:00:00+00:00","volume":1053007.0},{"close":0.013000000268220901,"macdLine":-0.0017284778319108171,"rsi":34.70724436140907,"signalLine":-0.00106185450410954,"timestamp":"2025-09-03T00:00:00+00:00","volume":748736.0},{"close":0.014449999667704105,"macdLine":-0.002125742159757499,"rsi":37.52111973010491,"signalLine":-0.0012746320352391319,"timestamp":"2025-09-04T00:00:00+00:00","volume":534984.0}],"signal":{"close":0.02539999969303608,"timestamp":"2026-04-14T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"TRLEF","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