SQLite Web: event_store.db

Update row 465114 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-20T20:11:54.360053+00:00","reason_trace":{"cutoff_iso":"2026-04-17T20:11:54Z","eligible_timeframes":["1d"],"market_now":"2026-04-20T16:11:54.360071-04:00","period_key":"2026-04-20","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.8346118450725767,"details":{"atr":0.5313947480147276,"atr_normalized_move":3.5736,"bars":600,"last_buy":{"close":21.229999542236328,"timestamp":"2025-02-26T00:00:00Z"},"last_sell":{"close":19.770999908447266,"timestamp":"2026-04-20T00:00:00Z"},"macd_clarity":0.8566,"macd_gap":0.188228,"price_move_pct":0.0876,"recent_buys":[{"close":21.030000686645508,"macdLine":0.20553850520331096,"rsi":63.673182838942395,"signalLine":0.20388018027971067,"timestamp":"2024-05-31T00:00:00+00:00","volume":170700.0},{"close":24.040000915527344,"macdLine":0.1555931367483545,"rsi":62.437813593911926,"signalLine":0.11768275854441648,"timestamp":"2024-09-18T00:00:00+00:00","volume":121500.0},{"close":24.239999771118164,"macdLine":0.2136610737418536,"rsi":64.5402923816086,"signalLine":0.13687842158390393,"timestamp":"2024-09-19T00:00:00+00:00","volume":201800.0},{"close":24.639999389648438,"macdLine":0.3021952801556296,"rsi":66.36378859566523,"signalLine":0.18554280984963833,"timestamp":"2024-09-23T00:00:00+00:00","volume":191600.0},{"close":21.229999542236328,"macdLine":0.08367333481127659,"rsi":59.084173444425446,"signalLine":-0.006984008658051762,"timestamp":"2025-02-26T00:00:00+00:00","volume":243700.0}],"recent_sells":[{"close":20.229999542236328,"macdLine":-0.004355360687895882,"rsi":34.6552565530142,"signalLine":0.08694230411371116,"timestamp":"2025-03-21T00:00:00+00:00","volume":2099800.0},{"close":18.239999771118164,"macdLine":-0.09990893089470632,"rsi":40.43524941961287,"signalLine":-0.0765479374708801,"timestamp":"2025-06-20T00:00:00+00:00","volume":259700.0},{"close":17.690000534057617,"macdLine":-0.05432996255556333,"rsi":40.31941443979645,"signalLine":-0.01197722114631037,"timestamp":"2025-10-06T00:00:00+00:00","volume":208800.0},{"close":20.440000534057617,"macdLine":0.10276618913126967,"rsi":43.13603559376095,"signalLine":0.26274646611295716,"timestamp":"2026-03-20T00:00:00+00:00","volume":711400.0},{"close":19.770999908447266,"macdLine":0.03150219559305967,"rsi":31.748093707909092,"signalLine":0.21973035839828883,"timestamp":"2026-04-20T00:00:00+00:00","volume":361563.0}],"rsi":31.748093707909092,"rsi_distance":0.0583,"signal":{"close":19.770999908447266,"timestamp":"2026-04-20T00:00:00Z"},"volume_clarity":0.9738,"volume_ratio":2.4606},"direction":"down","last_buy":{"close":21.229999542236328,"timestamp":"2025-02-26T00:00:00Z"},"last_sell":{"close":19.770999908447266,"timestamp":"2026-04-20T00:00:00Z"},"magnitude":1.4294459438609648,"price":19.770999908447266,"recent_buys":[{"close":21.030000686645508,"macdLine":0.20553850520331096,"rsi":63.673182838942395,"signalLine":0.20388018027971067,"timestamp":"2024-05-31T00:00:00+00:00","volume":170700.0},{"close":24.040000915527344,"macdLine":0.1555931367483545,"rsi":62.437813593911926,"signalLine":0.11768275854441648,"timestamp":"2024-09-18T00:00:00+00:00","volume":121500.0},{"close":24.239999771118164,"macdLine":0.2136610737418536,"rsi":64.5402923816086,"signalLine":0.13687842158390393,"timestamp":"2024-09-19T00:00:00+00:00","volume":201800.0},{"close":24.639999389648438,"macdLine":0.3021952801556296,"rsi":66.36378859566523,"signalLine":0.18554280984963833,"timestamp":"2024-09-23T00:00:00+00:00","volume":191600.0},{"close":21.229999542236328,"macdLine":0.08367333481127659,"rsi":59.084173444425446,"signalLine":-0.006984008658051762,"timestamp":"2025-02-26T00:00:00+00:00","volume":243700.0}],"recent_sells":[{"close":20.229999542236328,"macdLine":-0.004355360687895882,"rsi":34.6552565530142,"signalLine":0.08694230411371116,"timestamp":"2025-03-21T00:00:00+00:00","volume":2099800.0},{"close":18.239999771118164,"macdLine":-0.09990893089470632,"rsi":40.43524941961287,"signalLine":-0.0765479374708801,"timestamp":"2025-06-20T00:00:00+00:00","volume":259700.0},{"close":17.690000534057617,"macdLine":-0.05432996255556333,"rsi":40.31941443979645,"signalLine":-0.01197722114631037,"timestamp":"2025-10-06T00:00:00+00:00","volume":208800.0},{"close":20.440000534057617,"macdLine":0.10276618913126967,"rsi":43.13603559376095,"signalLine":0.26274646611295716,"timestamp":"2026-03-20T00:00:00+00:00","volume":711400.0},{"close":19.770999908447266,"macdLine":0.03150219559305967,"rsi":31.748093707909092,"signalLine":0.21973035839828883,"timestamp":"2026-04-20T00:00:00+00:00","volume":361563.0}],"signal":{"close":19.770999908447266,"timestamp":"2026-04-20T00:00:00Z"},"signal_kind":"bigMoveDown","strategy":"big_move","ticker":"EBF","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