internal

C3: prune derived_prices rows older than the hot window (dry-run by default)

Daily retention prune: removes derived_prices rows older than derived_prices_hot_window_days (default 90d) across all known symbols.

DRY-RUN BY DEFAULT (execute=False) until the founder explicitly enables automated pruning by flipping the lambda to execute=True. Flipping to execute=True is a FOUNDER DECISION and is gated by C3 cutover preconditions (core_ohlc_serving_enabled=True + R2 export verified) enforced inside prune_derived.run — so even a mistaken flip raises before deleting if the cutover isn't complete. Deleted rows are irreversible.

pg_cron schedule: daily at 03:50 UTC (0004_schedule_prune_derived.sql). Dead-man 2x = 48h.

post/internal/cron/prune-derived

Headers

x-internal-secretstring nullable

Response

Successful Response

object required

Changes

Changed in 1 of the 7 revisions of this API.13

Aug 18, 2026b7c4b36e1fa113See the full diff
- ●
  removed the optional property detail from the response with the 422 status
  response-optional-property-removed
- ○
  added the required property details to the response with the 422 status
  response-required-property-added
- ○
  added the required property error to the response with the 422 status
  response-required-property-added
- ○
  added the required property message to the response with the 422 status
  response-required-property-added
This revision also has 4 changes that name no endpoint, such as unreferenced schemas being removed. See the revision's changelog

Full history