---
title: Verify keeptradecut_liquidity cron pickup
type: task
status: completed
description: >-
  Smoke-check that the 2026-05-21 04:30 ET KTC import cron executed the new liquidity branch and
  landed a second day of data.
base_uri: user:task/league/verify-keeptradecut-liquidity-cron-pickup.md
created_at: '2026-05-20T16:44:41.874Z'
entity_id: e128dd9e-f3c2-4ef0-8157-22e952f2acf5
finish_by: '2026-05-22T00:00:00Z'
finished_at: '2026-07-18T16:59:14.338Z'
observations:
  - ████████████████████████████████████████████████
owner_identity_uri: █████████████████████████
priority: Low
public_read: true
relations:
  - follows [[user:task/league/add-keeptradecut-liquidity-tracking.md]]
tags:
  - user:tag/league-xo-football.md
updated_at: '2026-10-25T21:22:33.613Z'
visibility_analyzed_at: '2026-11-05T23:50:35.728Z'
---

## Context

`task/league/add-keeptradecut-liquidity-tracking.md` shipped 2026-05-20. The importer change was deployed via `yarn deploy` from the league repo (commits 0170002e, 93caea89). The cron at `server/crontab-main/league-imports.cron:7` runs `scripts/import-keeptradecut.mjs` at 04:30 ET daily. The initial production run on 2026-05-20 inserted 924 rows (one `d` value); tomorrow's cron run is the first cron-driven addition.

## Plan

1. Query: `SELECT count(DISTINCT d), count(*), max(d) FROM keeptradecut_liquidity` via `mcp__postgres-league__query`.
2. Expected: `count(DISTINCT d) = 2`, `count(*) ~= 1848` (two days x ~924 rows), `max(d)` corresponds to 2026-05-21 00:00 local (timestamp around 1779336000).
3. If `count(DISTINCT d) = 1`: the cron either failed silently or the deploy did not land the new code. Check `/var/log/league/import-keeptradecut.log` on the league host and the latest `jobs` row with `job_type = IMPORT_KEEPTRADECUT`.
4. Spot-check Josh Allen fixture: `SELECT d, superflex, raw_liquidity, std_liquidity, trade_count FROM keeptradecut_liquidity WHERE pid = (SELECT pid FROM player WHERE keeptradecut_id = 365) ORDER BY d, superflex` should return 4 rows (2 days x 2 axes), all numeric.

## Interpretation

- Pass: close this task with an `[completion]` observation noting the row counts.
- Fail (count_d still 1): re-open `add-keeptradecut-liquidity-tracking.md` with a `[regression]` observation and investigate deploy/cron pickup. Did not run? Wrong code? Exception on a real-world payload edge case (e.g., null `oneQBValues` on a player the local 2026-05-20 run did not hit)?

## Key locations

- Importer: `repository/active/league/scripts/import-keeptradecut.mjs` (liquidity branch lines ~288-330)
- Cron schedule: `repository/active/league/server/crontab-main/league-imports.cron:7`
- Job log on league host: `/var/log/league/import-keeptradecut.log`
- Job report table: `jobs` filtered by `job_type = IMPORT_KEEPTRADECUT`
- Parent task: `user:task/league/add-keeptradecut-liquidity-tracking.md`