

SELECT count(1) from /dsq_stock/a_stock_price WITH TIMEOUT = 12m
/**
output()
**/;

MATCH (industry_lv1:/dsq_stock/stock_industry_category_lv1)
<-[:public_company_belongs_to_industry_stock_industry_category_lv1*1..1]-
(company:/dsq_stock/public_company) 
-[:public_company_to_a_stock_price]->
(price:/dsq_stock/a_stock_price)
with timeout=5m
/**
output()
**/;

MATCH (industry_lv1:/dsq_stock/stock_industry_category_lv1)
<-[:public_company_belongs_to_industry_stock_industry_category_lv1*1..1]-
(company:/dsq_stock/public_company) 
-[:public_company_to_a_stock_price]->
(price:/dsq_stock/a_stock_price)
RETURN industry_lv1.name as "lv1_name", company.id AS "company", price.open_price as "open_price", price.close_price as "close_price"
with timeout=5m
/**
output()
**/;


match 
(company:/dsq_stock/public_company where id='public_company:920819')
-[:public_company_to_a_stock_price*1..1]->
(price:/dsq_stock/a_stock_price) 
with timeout=5m
/**
output()
**/;


MATCH (industry_lv1:/dsq_stock/stock_industry_category_lv1)
<-[:public_company_belongs_to_industry_stock_industry_category_lv1*1..1]-
(company:/dsq_stock/public_company) 
-[:public_company_to_a_stock_price]->
(price:/dsq_stock/a_stock_price)
RETURN industry_lv1.name as "lv1_name", company.id AS "company", price.open_price as "open_price", price.close_price as "close_price"
INTO /zhonghong77765433 with timeout=5m
/**
output()
**/;
