select
id,
share_market_data.time('2025-06-16 00:00:00','2025-07-16 00:00:00').find(name = 'dividend_yield').avg()
FROM /dsq_stock2/a_stock
WITH TIMEOUT = 60m
LIMIT -1
/**
output()
**/
;


SELECT 
stock.id AS "stock_id", 
stock.name AS "stock_name", 
stock.symbol AS "stock_symbol"
FROM /dsq_stock2/a_stock stock 
WHERE share_market_data.time('2025-06-16 00:00:00','2025-07-16 00:00:00').find(name = 'dividend_yield').avg().assert($1 > 5) 
LIMIT 0, 500000 
WITH TIMEOUT = 60m
/**
output()
**/
;

SELECT 
stock.id AS "stock_id", 
stock.name AS "stock_name", 
stock.symbol AS "stock_symbol" 
FROM /dsq_stock2/a_stock stock 
WHERE share_market_data.time('2025-08-16 00:00:00','2025-09-16 00:00:00').find(name = 'dividend_yield').avg().assert($1 > 5) 
LIMIT 0, 500000 
WITH TIMEOUT = 60m
/**
output()
**/
;

SELECT 
stock.id AS "stock_id", 
stock.name AS "stock_name", 
stock.symbol AS "stock_symbol" 
FROM /dsq_stock2/a_stock stock 
WHERE share_market_data.time('2025-07-16 00:00:00','2025-08-16 00:00:00').find(name = 'dividend_yield').avg().assert($1 > 5) 
LIMIT 0, 500000 
WITH TIMEOUT = 60m
/**
output()
**/
;

SELECT 
stock.id AS "stock_id", 
stock.name AS "stock_name", 
stock.symbol AS "stock_symbol" 
FROM /dsq_stock2/a_stock stock 
WHERE share_market_data.time('2025-06-16 00:00:00','2025-07-16 00:00:00').find(name = 'dividend_yield').avg().assert($1 > 5) 
LIMIT 0, 500000 
WITH TIMEOUT = 60m
/**
output()
**/
;

SELECT 
stock.id AS "stock_id", 
stock.name AS "stock_name", 
stock.symbol AS "stock_symbol" 
FROM /dsq_stock2/a_stock stock 
WHERE share_market_data.time('2025-05-16 00:00:00','2025-06-16 00:00:00').find(name = 'dividend_yield').avg().assert($1 > 5) 
LIMIT 0, 500000 
WITH TIMEOUT = 60m
/**
output()
**/
;

SELECT 
stock.id AS "stock_id", 
stock.name AS "stock_name", 
stock.symbol AS "stock_symbol" 
FROM /dsq_stock2/a_stock stock 
WHERE share_market_data.time('2025-04-16 00:00:00','2025-05-16 00:00:00').find(name = 'dividend_yield').avg().assert($1 > 5) 
LIMIT 0, 500000 
WITH TIMEOUT = 60m
/**
output()
**/
;

SELECT 
stock.id AS "stock_id", 
stock.name AS "stock_name", 
stock.symbol AS "stock_symbol" 
FROM /dsq_stock2/a_stock stock 
WHERE share_market_data.time('2025-03-16 00:00:00','2025-04-16 00:00:00').find(name = 'dividend_yield').avg().assert($1 > 5) 
LIMIT 0, 500000 
WITH TIMEOUT = 60m
/**
output()
**/
;

select
id,
share_market_data.time('2025-07-16 00:00:00','2025-08-16 00:00:00').find(name = 'dividend_yield').avg()
FROM /dsq_stock2/a_stock
WITH TIMEOUT = 60m
LIMIT -1
/**
output()
**/
;

SELECT 
stock.id AS "stock_id", 
stock.name AS "stock_name", 
stock.symbol AS "stock_symbol" 
FROM /dsq_stock2/a_stock stock 
WHERE share_market_data.time('2025-08-16 00:00:00','2025-09-16 00:00:00').find(name = 'dividend_yield').avg().assert($1 > 1) 
LIMIT 0, 500000 
WITH TIMEOUT = 60m
/**
output()
**/
;