SQLite Web: event_store.db

Update row 472925 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-21T20:18:10.566906+00:00","reason_trace":{"cutoff_iso":"2026-04-18T20:18:10Z","eligible_timeframes":["1d"],"market_now":"2026-04-21T16:18:10.566929-04:00","period_key":"2026-04-21","recent_signal_hours":72,"signal_timestamp":"2026-04-20T00:00:00Z","strategy":"big_move"},"severity":"high","signal_type":"technical_indicator_signal","source":"technical_analyzer","value":{"bars":600,"confidence":0.7814697485592076,"details":{"atr":0.7457799562615841,"atr_normalized_move":0.5095,"bars":600,"last_buy":{"close":12.079999923706055,"timestamp":"2026-04-20T00:00:00Z"},"last_sell":{"close":146.64999389648438,"timestamp":"2025-08-19T00:00:00Z"},"macd_clarity":0.745,"macd_gap":0.146762,"price_move_pct":0.0325,"recent_buys":[{"close":155.0500030517578,"macdLine":6.274236457448254,"rsi":67.78778837954147,"signalLine":5.306297981212734,"timestamp":"2025-06-09T00:00:00+00:00","volume":7914.0},{"close":150.85000610351562,"macdLine":7.438323349005017,"rsi":64.69820340352304,"signalLine":5.732703054771191,"timestamp":"2025-06-10T00:00:00+00:00","volume":5229.0},{"close":157.14999389648438,"macdLine":8.768153149532708,"rsi":67.1190561406149,"signalLine":6.339793073723494,"timestamp":"2025-06-11T00:00:00+00:00","volume":6637.0},{"close":173.9499969482422,"macdLine":7.368315102266507,"rsi":65.94179313497936,"signalLine":4.600189639678504,"timestamp":"2025-07-18T00:00:00+00:00","volume":10286.0},{"close":12.079999923706055,"macdLine":0.1969944757200448,"rsi":63.31219121709128,"signalLine":0.050232311586240905,"timestamp":"2026-04-20T00:00:00+00:00","volume":14500.0}],"recent_sells":[{"close":166.25,"macdLine":-2.3227285318212694,"rsi":33.77762113769411,"signalLine":-0.7676180616527295,"timestamp":"2024-09-20T00:00:00+00:00","volume":5389.0},{"close":94.5,"macdLine":-3.2771305440755185,"rsi":32.811395560173764,"signalLine":-0.475880518654625,"timestamp":"2025-03-10T00:00:00+00:00","volume":5937.0},{"close":92.05000305175781,"macdLine":-4.031720093199141,"rsi":34.01412888752702,"signalLine":-3.6146680204401913,"timestamp":"2025-03-31T00:00:00+00:00","volume":3694.0},{"close":86.80000305175781,"macdLine":-5.324491385027841,"rsi":30.861753254261842,"signalLine":-4.2804309126386935,"timestamp":"2025-04-03T00:00:00+00:00","volume":5097.0},{"close":146.64999389648438,"macdLine":1.0131352675244898,"rsi":41.19137244692268,"signalLine":3.1080384542885557,"timestamp":"2025-08-19T00:00:00+00:00","volume":17534.0}],"rsi":63.31219121709128,"rsi_distance":0.2229,"signal":{"close":12.079999923706055,"timestamp":"2026-04-20T00:00:00Z"},"volume_clarity":0.3628,"volume_ratio":1.5442},"direction":"up","last_buy":{"close":12.079999923706055,"timestamp":"2026-04-20T00:00:00Z"},"last_sell":{"close":146.64999389648438,"timestamp":"2025-08-19T00:00:00Z"},"magnitude":0.3247864278937842,"price":12.079999923706055,"recent_buys":[{"close":155.0500030517578,"macdLine":6.274236457448254,"rsi":67.78778837954147,"signalLine":5.306297981212734,"timestamp":"2025-06-09T00:00:00+00:00","volume":7914.0},{"close":150.85000610351562,"macdLine":7.438323349005017,"rsi":64.69820340352304,"signalLine":5.732703054771191,"timestamp":"2025-06-10T00:00:00+00:00","volume":5229.0},{"close":157.14999389648438,"macdLine":8.768153149532708,"rsi":67.1190561406149,"signalLine":6.339793073723494,"timestamp":"2025-06-11T00:00:00+00:00","volume":6637.0},{"close":173.9499969482422,"macdLine":7.368315102266507,"rsi":65.94179313497936,"signalLine":4.600189639678504,"timestamp":"2025-07-18T00:00:00+00:00","volume":10286.0},{"close":12.079999923706055,"macdLine":0.1969944757200448,"rsi":63.31219121709128,"signalLine":0.050232311586240905,"timestamp":"2026-04-20T00:00:00+00:00","volume":14500.0}],"recent_sells":[{"close":166.25,"macdLine":-2.3227285318212694,"rsi":33.77762113769411,"signalLine":-0.7676180616527295,"timestamp":"2024-09-20T00:00:00+00:00","volume":5389.0},{"close":94.5,"macdLine":-3.2771305440755185,"rsi":32.811395560173764,"signalLine":-0.475880518654625,"timestamp":"2025-03-10T00:00:00+00:00","volume":5937.0},{"close":92.05000305175781,"macdLine":-4.031720093199141,"rsi":34.01412888752702,"signalLine":-3.6146680204401913,"timestamp":"2025-03-31T00:00:00+00:00","volume":3694.0},{"close":86.80000305175781,"macdLine":-5.324491385027841,"rsi":30.861753254261842,"signalLine":-4.2804309126386935,"timestamp":"2025-04-03T00:00:00+00:00","volume":5097.0},{"close":146.64999389648438,"macdLine":1.0131352675244898,"rsi":41.19137244692268,"signalLine":3.1080384542885557,"timestamp":"2025-08-19T00:00:00+00:00","volume":17534.0}],"signal":{"close":12.079999923706055,"timestamp":"2026-04-20T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"NVNO","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