odbtools/odbctest/mql/uino/084.multi.bucket.mql

select 
S_INFO_WINDCODE, S_INFO_CODE, S_INFO_NAME, S_INFO_COMPNAME, 
S_INFO_COMPNAMEENG, S_INFO_ISINCODE, S_INFO_EXCHMARKET, S_INFO_LISTBOARD, 
S_INFO_LISTDATE, S_INFO_DELISTDATE, S_INFO_SEDOLCODE, CRNCY_CODE, 
S_INFO_PINYIN, S_INFO_LISTBOARDNAME, IS_SHSC, S_INFO_COMPCODE, 
OPDATE, OPMODE, AShareEODPrices, AShareAuction, 
AShareAfterEODPrices, AShareValuationIndicator, AShareEVIndicator, AShareYield, 
AShareWeeklyYield, AShareMonthlyYield, AShareEODDerivativeIndicator, AShareMoneyFlow, 
AShareL2Indicators, AShareTechIndicators, AshareintensitytrendADJ, Ashareintensitytrend, 
AShareEnergyindexADJ, AShareEnergyindex, AShareswingReversetrendADJ, AShareswingReversetrend 
from /dsq_wind/a_share_description limit 10
/**
output()
**/
;


SELECT 
stock.id AS "stock_id", 
stock.name AS "stock_name", 
stock.symbol AS "stock_symbol",
share_market_data.find(name='pct_change_ave_60m') as "pct_change_ave_60m",
share_market_data.find(name='turnover_m') as "turnover_m"
FROM /dsq_stock2/a_stock stock 
WHERE stock.name like '*宁德时代*'
WITH TIMEOUT = 60m
/**
output()
**/
;


select * from /dsq_wind/a_share_description
/**
output()
**/
;

select 
S_INFO_WINDCODE, S_INFO_CODE, S_INFO_NAME, S_INFO_COMPNAME, 
S_INFO_COMPNAMEENG, S_INFO_ISINCODE, S_INFO_EXCHMARKET, S_INFO_LISTBOARD, 
S_INFO_LISTDATE, S_INFO_DELISTDATE, S_INFO_SEDOLCODE, CRNCY_CODE, 
S_INFO_PINYIN, S_INFO_LISTBOARDNAME, IS_SHSC, S_INFO_COMPCODE, 
OPDATE, OPMODE, AShareEODPrices, AShareAuction, 
AShareAfterEODPrices, AShareValuationIndicator, AShareEVIndicator, AShareYield, 
AShareWeeklyYield, AShareMonthlyYield, AShareEODDerivativeIndicator, AShareMoneyFlow, 
AShareL2Indicators, AShareTechIndicators, AshareintensitytrendADJ, Ashareintensitytrend, 
AShareEnergyindexADJ, AShareEnergyindex, AShareswingReversetrendADJ, AShareswingReversetrend 
from /dsq_wind/a_share_description limit 10
/**
output()
**/
;