SQLite Web: event_store.db

Update row 478854 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-22T03:44:00.815672+00:00","reason_trace":{"cutoff_iso":"2026-04-19T03:44:00Z","eligible_timeframes":["1d"],"market_now":"2026-04-21T23:44:00.815693-04:00","period_key":"2026-04-21","recent_signal_hours":72,"signal_timestamp":"2026-04-21T00:00:00Z","strategy":"big_move"},"severity":"high","signal_type":"technical_indicator_signal","source":"technical_analyzer","value":{"bars":600,"confidence":0.8350852794988803,"details":{"atr":18.21908988356627,"atr_normalized_move":2.6834,"bars":600,"last_buy":{"close":458.7699890136719,"timestamp":"2026-04-21T00:00:00Z"},"last_sell":{"close":379.2099914550781,"timestamp":"2025-11-20T00:00:00Z"},"macd_clarity":1.0,"macd_gap":3.923358,"price_move_pct":0.1193,"recent_buys":[{"close":286.8399963378906,"macdLine":4.970932123178272,"rsi":69.4775240185022,"signalLine":3.9607225521667577,"timestamp":"2024-07-17T00:00:00+00:00","volume":293900.0},{"close":299.6499938964844,"macdLine":5.552589050948825,"rsi":68.43709236477508,"signalLine":4.6909743855388975,"timestamp":"2024-07-25T00:00:00+00:00","volume":281900.0},{"close":367.260009765625,"macdLine":6.32853155941973,"rsi":69.04123762229793,"signalLine":2.687068887456013,"timestamp":"2025-02-19T00:00:00+00:00","volume":299900.0},{"close":333.8599853515625,"macdLine":4.107368162964349,"rsi":65.94090618028105,"signalLine":3.707552035569058,"timestamp":"2025-06-27T00:00:00+00:00","volume":346200.0},{"close":458.7699890136719,"macdLine":1.6868492918897573,"rsi":65.24122152323467,"signalLine":-2.236508436417276,"timestamp":"2026-04-21T00:00:00+00:00","volume":437958.0}],"recent_sells":[{"close":211.1699981689453,"macdLine":-0.9496279973768083,"rsi":36.66621324966434,"signalLine":0.24203513145865932,"timestamp":"2024-04-17T00:00:00+00:00","volume":270800.0},{"close":272.0,"macdLine":-0.42079003537293147,"rsi":39.47007290458784,"signalLine":0.9269564425397655,"timestamp":"2024-09-04T00:00:00+00:00","volume":126300.0},{"close":265.1300048828125,"macdLine":-1.6887091946037458,"rsi":34.371221133611996,"signalLine":0.4038233151110633,"timestamp":"2024-09-05T00:00:00+00:00","volume":168800.0},{"close":285.5,"macdLine":-5.985773901521668,"rsi":30.92393633055896,"signalLine":-2.7503115717933806,"timestamp":"2025-03-21T00:00:00+00:00","volume":630200.0},{"close":379.2099914550781,"macdLine":-3.4015093333742925,"rsi":33.624991936192686,"signalLine":0.5631345964938586,"timestamp":"2025-11-20T00:00:00+00:00","volume":255400.0}],"rsi":65.24122152323467,"rsi_distance":0.1586,"signal":{"close":458.7699890136719,"timestamp":"2026-04-21T00:00:00Z"},"volume_clarity":0.6129,"volume_ratio":1.9194},"direction":"up","last_buy":{"close":458.7699890136719,"timestamp":"2026-04-21T00:00:00Z"},"last_sell":{"close":379.2099914550781,"timestamp":"2025-11-20T00:00:00Z"},"magnitude":1.192787731737179,"price":458.7699890136719,"recent_buys":[{"close":286.8399963378906,"macdLine":4.970932123178272,"rsi":69.4775240185022,"signalLine":3.9607225521667577,"timestamp":"2024-07-17T00:00:00+00:00","volume":293900.0},{"close":299.6499938964844,"macdLine":5.552589050948825,"rsi":68.43709236477508,"signalLine":4.6909743855388975,"timestamp":"2024-07-25T00:00:00+00:00","volume":281900.0},{"close":367.260009765625,"macdLine":6.32853155941973,"rsi":69.04123762229793,"signalLine":2.687068887456013,"timestamp":"2025-02-19T00:00:00+00:00","volume":299900.0},{"close":333.8599853515625,"macdLine":4.107368162964349,"rsi":65.94090618028105,"signalLine":3.707552035569058,"timestamp":"2025-06-27T00:00:00+00:00","volume":346200.0},{"close":458.7699890136719,"macdLine":1.6868492918897573,"rsi":65.24122152323467,"signalLine":-2.236508436417276,"timestamp":"2026-04-21T00:00:00+00:00","volume":437958.0}],"recent_sells":[{"close":211.1699981689453,"macdLine":-0.9496279973768083,"rsi":36.66621324966434,"signalLine":0.24203513145865932,"timestamp":"2024-04-17T00:00:00+00:00","volume":270800.0},{"close":272.0,"macdLine":-0.42079003537293147,"rsi":39.47007290458784,"signalLine":0.9269564425397655,"timestamp":"2024-09-04T00:00:00+00:00","volume":126300.0},{"close":265.1300048828125,"macdLine":-1.6887091946037458,"rsi":34.371221133611996,"signalLine":0.4038233151110633,"timestamp":"2024-09-05T00:00:00+00:00","volume":168800.0},{"close":285.5,"macdLine":-5.985773901521668,"rsi":30.92393633055896,"signalLine":-2.7503115717933806,"timestamp":"2025-03-21T00:00:00+00:00","volume":630200.0},{"close":379.2099914550781,"macdLine":-3.4015093333742925,"rsi":33.624991936192686,"signalLine":0.5631345964938586,"timestamp":"2025-11-20T00:00:00+00:00","volume":255400.0}],"signal":{"close":458.7699890136719,"timestamp":"2026-04-21T00:00:00Z"},"signal_kind":"bigMoveUp","strategy":"big_move","ticker":"VMI","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