SQLite Web: event_store.db

Update row 78840 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-17T20:04:00.179713+00:00","reason_trace":{"cutoff_iso":"2026-04-14T20:04:00Z","eligible_timeframes":["1d","1wk"],"market_now":"2026-04-17T16:04:00.179726-04:00","period_key":"2026-04-17","recent_signal_hours":72,"signal_timestamp":"2026-04-16T00:00:00Z","strategy":"big_move"},"severity":"high","signal_type":"technical_indicator_signal","source":"technical_analyzer","value":{"bars":600,"confidence":0.804199287237286,"details":{"atr":0.26011889051703596,"atr_normalized_move":0.346,"bars":600,"last_buy":{"close":3.049999952316284,"timestamp":"2026-04-16T00:00:00Z"},"last_sell":{"close":1.2599999904632568,"timestamp":"2025-06-24T00:00:00Z"},"macd_clarity":1.0,"macd_gap":0.108951,"price_move_pct":0.0287,"recent_buys":[{"close":3.200000047683716,"macdLine":0.055411739426529216,"rsi":68.3595459388569,"signalLine":-0.02952717744115991,"timestamp":"2025-12-08T00:00:00+00:00","volume":298400.0},{"close":3.2699999809265137,"macdLine":0.09197005791931501,"rsi":69.91852562154389,"signalLine":-0.005227730369064928,"timestamp":"2025-12-09T00:00:00+00:00","volume":1011800.0},{"close":2.9600000381469727,"macdLine":-0.10659397442801,"rsi":55.269471680499336,"signalLine":-0.16019199511298124,"timestamp":"2026-02-20T00:00:00+00:00","volume":117300.0},{"close":2.809999942779541,"macdLine":0.0037621165327257344,"rsi":63.786531469179906,"signalLine":-0.06728048488458781,"timestamp":"2026-04-14T00:00:00+00:00","volume":261300.0},{"close":3.049999952316284,"macdLine":0.09413117874848265,"rsi":67.09014851794348,"signalLine":-0.01481986491478618,"timestamp":"2026-04-16T00:00:00+00:00","volume":160400.0}],"recent_sells":[{"close":2.9600000381469727,"macdLine":-0.023126158205198255,"rsi":37.02476464768641,"signalLine":0.03222729393570614,"timestamp":"2024-04-02T00:00:00+00:00","volume":21000.0},{"close":1.3899999856948853,"macdLine":-0.06246877380400595,"rsi":34.36454918950396,"signalLine":-0.047052431849331625,"timestamp":"2024-12-16T00:00:00+00:00","volume":31400.0},{"close":2.3499999046325684,"macdLine":0.14677189354460296,"rsi":37.50514102653674,"signalLine":0.39187494470997913,"timestamp":"2025-01-22T00:00:00+00:00","volume":3706300.0},{"close":2.069999933242798,"macdLine":-0.2583552783584029,"rsi":30.76930173601012,"signalLine":-0.21601575666470824,"timestamp":"2025-03-12T00:00:00+00:00","volume":87800.0},{"close":1.2599999904632568,"macdLine":-0.07180878129849932,"rsi":35.84067139267276,"signalLine":-0.061904372968035526,"timestamp":"2025-06-24T00:00:00+00:00","volume":406700.0}],"rsi":67.09014851794348,"rsi_distance":0.097,"signal":{"close":3.049999952316284,"timestamp":"2026-04-16T00:00:00Z"},"volume_clarity":0.3965,"volume_ratio":1.5948},"direction":"up","last_buy":{"close":3.049999952316284,"timestamp":"2026-04-16T00:00:00Z"},"last_sell":{"close":1.2599999904632568,"timestamp":"2025-06-24T00:00:00Z"},"magnitude":0.28662468019451615,"price":3.049999952316284,"recent_buys":[{"close":3.200000047683716,"macdLine":0.055411739426529216,"rsi":68.3595459388569,"signalLine":-0.02952717744115991,"timestamp":"2025-12-08T00:00:00+00:00","volume":298400.0},{"close":3.2699999809265137,"macdLine":0.09197005791931501,"rsi":69.91852562154389,"signalLine":-0.005227730369064928,"timestamp":"2025-12-09T00:00:00+00:00","volume":1011800.0},{"close":2.9600000381469727,"macdLine":-0.10659397442801,"rsi":55.269471680499336,"signalLine":-0.16019199511298124,"timestamp":"2026-02-20T00:00:00+00:00","volume":117300.0},{"close":2.809999942779541,"macdLine":0.0037621165327257344,"rsi":63.786531469179906,"signalLine":-0.06728048488458781,"timestamp":"2026-04-14T00:00:00+00:00","volume":261300.0},{"close":3.049999952316284,"macdLine":0.09413117874848265,"rsi":67.09014851794348,"signalLine":-0.01481986491478618,"timestamp":"2026-04-16T00:00:00+00:00","volume":160400.0}],"recent_sells":[{"close":2.9600000381469727,"macdLine":-0.023126158205198255,"rsi":37.02476464768641,"signalLine":0.03222729393570614,"timestamp":"2024-04-02T00:00:00+00:00","volume":21000.0},{"close":1.3899999856948853,"macdLine":-0.06246877380400595,"rsi":34.36454918950396,"signalLine":-0.047052431849331625,"timestamp":"2024-12-16T00:00:00+00:00","volume":31400.0},{"close":2.3499999046325684,"macdLine":0.14677189354460296,"rsi":37.50514102653674,"signalLine":0.39187494470997913,"timestamp":"2025-01-22T00:00:00+00:00","volume":3706300.0},{"close":2.069999933242798,"macdLine":-0.2583552783584029,"rsi":30.76930173601012,"signalLine":-0.21601575666470824,"timestamp":"2025-03-12T00:00:00+00:00","volume":87800.0},{"close":1.2599999904632568,"macdLine":-0.07180878129849932,"rsi":35.84067139267276,"signalLine":-0.061904372968035526,"timestamp":"2025-06-24T00:00:00+00:00","volume":406700.0}],"signal":{"close":3.049999952316284,"timestamp":"2026-04-16T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"VNCE","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