odbtools/odbctest/mql/uino/087.bucket.unit.mql

SELECT 
id,
stock.name AS "company_name", 
stock.symbol AS "stock_symbol",
stock.share_market_data.time('2025-06-30 00:00:00','2025-06-30 23:59:59').find(name = 'net_assets_today') AS "net_assets" 
FROM /dsq_stock2/a_stock stock 
WHERE share_market_data.time('2025-06-30 00:00:00','2025-06-30 23:59:59').find(name = 'net_assets_today').unit('avg', '1d').assert($1 > 1e+12) 
LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
**/
;

SELECT 
stock.name AS "company_name", 
stock.symbol AS "stock_symbol", 
stock.share_market_data.time('2025-06-30 00:00:00','2025-06-30 23:59:59').find(name = 'net_assets_today') AS "net_assets" 
FROM /dsq_stock2/a_stock stock 
WHERE share_market_data.time('2025-06-30 00:00:00','2025-06-30 23:59:59').find(name = 'net_assets_today').find(value > 1e+12).unit('avg', '1d').assert($1 > 1e+12) 
LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
**/
;