Ken: add captured_at to ken_market_snapshots (momentum query) — pipelines error-free

a060e297387ebd8a32ae85230b507ff8df1249d9 · 2026-07-10 11:12:20 -0700 · Steve

Files touched

M kalshi-dash/schema.sql

Diff

commit a060e297387ebd8a32ae85230b507ff8df1249d9
Author: Steve <steve@designerwallcoverings.com>
Date:   Fri Jul 10 11:12:20 2026 -0700

    Ken: add captured_at to ken_market_snapshots (momentum query) — pipelines error-free
---
 kalshi-dash/schema.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/kalshi-dash/schema.sql b/kalshi-dash/schema.sql
index 70f855d..dd4d61c 100644
--- a/kalshi-dash/schema.sql
+++ b/kalshi-dash/schema.sql
@@ -52,8 +52,9 @@ CREATE TABLE IF NOT EXISTS ken_market_snapshots (
   ticker TEXT, event_ticker TEXT, title TEXT, subtitle TEXT, category TEXT,
   yes_bid BIGINT, yes_ask BIGINT, no_bid BIGINT, no_ask BIGINT, last_price BIGINT,
   volume BIGINT, volume_24h BIGINT, open_interest BIGINT, spread BIGINT,
-  created_at TIMESTAMPTZ DEFAULT NOW()
+  captured_at TIMESTAMPTZ DEFAULT NOW(), created_at TIMESTAMPTZ DEFAULT NOW()
 );
+ALTER TABLE ken_market_snapshots ADD COLUMN IF NOT EXISTS captured_at TIMESTAMPTZ DEFAULT NOW();
 
 CREATE TABLE IF NOT EXISTS ken_predictions (
   id BIGSERIAL PRIMARY KEY,

← 2fa8032 Ken: seed 99 paper-trading portfolios + add portfolio stat c · back to Ken · Ken: enforce safe/paper — autoTrader honors safe_mode + mast 6fc1f52 →