odbtools/odbctest/mql/uino/089.tempclass_bucket_nodata.mql

SELECT stock.name AS "stock_name", stock.share_market_data AS "market_data" 
INTO /temp_stock_data_1_c8dc4f82-e4e7-47a1-b5ea-c8229308b7c9-0 
FROM /dsq_stock2/a_stock stock 
WHERE share_market_data.time('2025-07-01 00:00:00','2025-07-01 23:59:59').find(name = 'total_mv').unit('avg', '1d').assert($1 > 3e+07) 
LIMIT 0, 500000 WITH TIMEOUT = 6m;



SELECT stock.name AS "stock_name", stock.share_market_data AS "market_data" 
INTO /temp_stock_data_1_c8dc4f82-e4e7-47a1-b5ea-c8229308b7c9-0 
FROM /dsq_stock2/a_stock stock 
WHERE share_market_data.time('2025-07-01 00:00:00','2025-07-10 23:59:59').find(name = 'total_mv').unit('avg', '1d').assert($1 > 3e+07) 
LIMIT 0, 500000 WITH TIMEOUT = 6m;


SELECT temp.stock_name AS "stock_name", 
temp.market_data.time('2025-07-01 00:00:00','2025-07-10 23:59:59').find(name = 'close_price') AS "close_price" 
FROM /temp_stock_data_1_c8dc4f82-e4e7-47a1-b5ea-c8229308b7c9-0 temp 
LIMIT 0, 500000
/**
output()
**/
;