SELECT stock.id AS "stock_id", stock.name AS "stock_name", stock.share_market_data AS "market_data" 
FROM /dsq_stock2/a_stock stock 
WHERE stock.name like ? 
AND share_market_data.time('2024-09-16 00:00:00','2025-09-16 00:00:00').find(name = 'total_mv').avg().assert($1 > 0) 
LIMIT 0, 500000 
WITH TIMEOUT = 50m
/**
output()
params('*宁德时代*')
**/
;



SELECT stock.id AS "stock_id", stock.name AS "stock_name", stock.share_market_data AS "market_data" 
FROM /dsq_stock2/a_stock stock 
WHERE stock.name like '*宁德时代*' 
AND share_market_data.time('2024-09-16 00:00:00','2025-09-16 00:00:00').find(name = 'total_mv').avg().assert($1 > 0) 
LIMIT 0, 500000 
WITH TIMEOUT = 50m
/**
output()
**/
;


SELECT stock.id AS "stock_id", stock.name AS "stock_name", share_market_data.time('2024-09-16 00:00:00','2025-09-16 00:00:00').find(name = 'total_mv').avg() AS "total_mv" 
FROM /dsq_stock2/a_stock stock 
WHERE stock.name like '*宁德时代*' 
AND share_market_data.time('2024-09-16 00:00:00','2025-09-16 00:00:00').find(name = 'total_mv').avg().assert($1 > 0) 
LIMIT 0, 500000 
WITH TIMEOUT = 50m
/**
output()
**/
;