SQLite Web: event_store.db

Update row 472846 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:07:53.138167+00:00","reason_trace":{"cutoff_iso":"2026-04-18T20:07:53Z","eligible_timeframes":["1d"],"market_now":"2026-04-21T16:07:53.138185-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.8176969217308484,"details":{"atr":0.9517359102188254,"atr_normalized_move":0.9929,"bars":600,"last_buy":{"close":46.150001525878906,"timestamp":"2026-01-14T00:00:00Z"},"last_sell":{"close":48.505001068115234,"timestamp":"2026-04-21T00:00:00Z"},"macd_clarity":1.0,"macd_gap":0.289461,"price_move_pct":0.0191,"recent_buys":[{"close":40.880001068115234,"macdLine":-0.14762606637876274,"rsi":58.816872241111135,"signalLine":-0.2941056020583871,"timestamp":"2025-01-27T00:00:00+00:00","volume":5477500.0},{"close":42.290000915527344,"macdLine":0.3518552763020608,"rsi":69.01424604465808,"signalLine":0.13887409523251754,"timestamp":"2025-02-21T00:00:00+00:00","volume":7878700.0},{"close":42.709999084472656,"macdLine":0.42422484227788004,"rsi":69.5141282164772,"signalLine":0.22900972511626938,"timestamp":"2025-07-31T00:00:00+00:00","volume":6440800.0},{"close":44.2400016784668,"macdLine":0.20901143895850538,"rsi":63.63123084340601,"signalLine":0.17713885039754682,"timestamp":"2025-09-25T00:00:00+00:00","volume":5207700.0},{"close":46.150001525878906,"macdLine":-0.0031249122848677757,"rsi":64.04147603003186,"signalLine":-0.16274540867310408,"timestamp":"2026-01-14T00:00:00+00:00","volume":6238500.0}],"recent_sells":[{"close":39.81999969482422,"macdLine":-0.35525264513153587,"rsi":32.4222465102946,"signalLine":-0.10079766448317816,"timestamp":"2025-06-09T00:00:00+00:00","volume":13326900.0},{"close":49.689998626708984,"macdLine":0.5963640790097529,"rsi":47.03284687011965,"signalLine":0.8097935057038561,"timestamp":"2026-03-19T00:00:00+00:00","volume":7457300.0},{"close":48.540000915527344,"macdLine":0.3830345680006104,"rsi":38.82720700859686,"signalLine":0.724441718163207,"timestamp":"2026-03-20T00:00:00+00:00","volume":8570400.0},{"close":48.505001068115234,"macdLine":-0.08325271109415411,"rsi":33.150616972959966,"signalLine":0.20620809540545476,"timestamp":"2026-04-21T00:00:00+00:00","volume":7056211.0}],"rsi":33.150616972959966,"rsi_distance":0.105,"signal":{"close":48.505001068115234,"timestamp":"2026-04-21T00:00:00Z"},"volume_clarity":0.5194,"volume_ratio":1.7792},"direction":"down","last_buy":{"close":46.150001525878906,"timestamp":"2026-01-14T00:00:00Z"},"last_sell":{"close":48.505001068115234,"timestamp":"2026-04-21T00:00:00Z"},"magnitude":0.39716887202751117,"price":48.505001068115234,"recent_buys":[{"close":40.880001068115234,"macdLine":-0.14762606637876274,"rsi":58.816872241111135,"signalLine":-0.2941056020583871,"timestamp":"2025-01-27T00:00:00+00:00","volume":5477500.0},{"close":42.290000915527344,"macdLine":0.3518552763020608,"rsi":69.01424604465808,"signalLine":0.13887409523251754,"timestamp":"2025-02-21T00:00:00+00:00","volume":7878700.0},{"close":42.709999084472656,"macdLine":0.42422484227788004,"rsi":69.5141282164772,"signalLine":0.22900972511626938,"timestamp":"2025-07-31T00:00:00+00:00","volume":6440800.0},{"close":44.2400016784668,"macdLine":0.20901143895850538,"rsi":63.63123084340601,"signalLine":0.17713885039754682,"timestamp":"2025-09-25T00:00:00+00:00","volume":5207700.0},{"close":46.150001525878906,"macdLine":-0.0031249122848677757,"rsi":64.04147603003186,"signalLine":-0.16274540867310408,"timestamp":"2026-01-14T00:00:00+00:00","volume":6238500.0}],"recent_sells":[{"close":39.81999969482422,"macdLine":-0.35525264513153587,"rsi":32.4222465102946,"signalLine":-0.10079766448317816,"timestamp":"2025-06-09T00:00:00+00:00","volume":13326900.0},{"close":49.689998626708984,"macdLine":0.5963640790097529,"rsi":47.03284687011965,"signalLine":0.8097935057038561,"timestamp":"2026-03-19T00:00:00+00:00","volume":7457300.0},{"close":48.540000915527344,"macdLine":0.3830345680006104,"rsi":38.82720700859686,"signalLine":0.724441718163207,"timestamp":"2026-03-20T00:00:00+00:00","volume":8570400.0},{"close":48.505001068115234,"macdLine":-0.08325271109415411,"rsi":33.150616972959966,"signalLine":0.20620809540545476,"timestamp":"2026-04-21T00:00:00+00:00","volume":7056211.0}],"signal":{"close":48.505001068115234,"timestamp":"2026-04-21T00:00:00Z"},"signal_kind":"bigMoveDown","strategy":"big_move","ticker":"FE","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