check_row.sql

-- 查询是否存在 InvestorAgent, 2025-08-01, BTC 这一行
SELECT id, agent_name, date, asset, model
FROM trading_decisions
WHERE agent_name = 'InvestorAgent'
  AND date = '2025-08-01'
  AND asset = 'BTC'
LIMIT 1;

-- 如果上面没有结果，查看 InvestorAgent 的所有数据
SELECT DISTINCT agent_name, date, asset 
FROM trading_decisions
WHERE agent_name ILIKE '%investor%'
ORDER BY date DESC
LIMIT 10;

-- 查看所有的 agent_name
SELECT DISTINCT agent_name 
FROM trading_decisions
ORDER BY agent_name
LIMIT 20;