1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
| SELECT
| trade_date,
| stock_count,
| up_count,
| flat_count,
| down_count,
| zero_prev_close_count,
| positive_share,
| avg_ret_from_prev_close_pct,
| benchmark_type,
| price_source_table,
| run_id AS breadth_cache_run_id,
| CASE
| WHEN up_count >= 4000 AND down_count >= 4000 THEN 'BOTH_4000'
| WHEN up_count >= 4000 THEN 'UP_4000'
| WHEN down_count >= 4000 THEN 'DOWN_4000'
| ELSE 'OTHER'
| END AS class_label
| FROM ts_market_breadth_daily_cache
| WHERE scope_type = 'ALL_A_SHARE'
| AND scope_value = 'ALL'
| AND trade_date >= '2023-01-01'
| AND trade_date <= '2026-12-31'
| ORDER BY trade_date;
|
|
