tickerbot_list_signal_events
Retrieve time spans when a boolean signal was true for a ticker, including start/end timestamps and prices, with built-in flags like golden cross and uptrend, filterable by date range and cursor.
Instructions
Occurrence SPANS of a boolean signal for one ticker, newest-first. For STATE flags (above_sma_50, in_uptrend) each row is a true-WINDOW: started_at when it flipped true, ended_at when it flipped back (null while still true), with prices at both ends. For EVENT flags (golden_cross, gap_up) each row is a point firing (started_at = ended_at). "Golden crosses in June" is from=2026-06-01&to=2026-06-30. Built-in booleans only — numerics and custom signals have no precomputed spans (use tickerbot_get_series).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | No | Window end (inclusive) on started_at; a bare YYYY-MM-DD means through the end of that day. | |
| from | No | Window start (inclusive) on each span's started_at — YYYY-MM-DD, ISO, or epoch-ms. | |
| limit | No | Page size. Max 1000, newest first. | |
| cursor | No | Opaque cursor — pages older, inside the from/to window if one is set. | |
| signal | Yes | Built-in boolean flag name. | |
| ticker | Yes | Symbol. | |
| merge_gap_seconds | No | Interval-union: contiguous windows whose gap is ≤ N seconds collapse into one — de-fragments flags with thousands of per-tick rows (e.g. 3600 for daily flags). Default 0 = no merge. A cursor pins this; resend it unchanged when paging. |