odbtools/odbctest/mql/uino/092.bucketcond.mql

SELECT stock.id AS "stock_id", stock.name AS "stock_name", stock.symbol AS "stock_symbol", stock.share_market_data AS "market_data" 
INTO /temp_stock_market_value_3d81d785-a103-4a64-9a3c-f6cce0e39ff9-0 
FROM /dsq_stock2/a_stock stock LIMIT 0, 500000 WITH TIMEOUT = 6m;


SELECT temp.stock_id AS "stock_id", temp.stock_name AS "stock_name", temp.stock_symbol AS "stock_symbol" 
FROM /temp_stock_market_value_3d81d785-a103-4a64-9a3c-f6cce0e39ff9-0 temp 
WHERE temp.market_data.time('2025-05-15 00:00:00','2025-06-15 00:00:00').find(name = 'total_mv').avg().assert($1 > 1e+07) 
LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
**/
;