| 123456789101112131415 |
- SELECT stock.name AS "stock_name", stock.symbol AS "stock_symbol",
- stock.share_market_data.time('2025-07-18 00:00:00','2025-07-18 23:59:59').find(name = 'pct_change_m').unit('avg', '1d') AS "market_data"
- FROM /dsq_stock2/a_stock stock
- WHERE
- share_market_data.time('2025-07-18 00:00:00','2025-07-18 23:59:59').find(name = 'pct_change_m').unit('avg', '1d').assert($1 > 50)
- OR
- share_market_data.time('2025-07-18 00:00:00','2025-07-18 23:59:59').find(name = 'pct_change_m').unit('avg', '1d').assert($1 < -50)
- LIMIT 0, 500000 WITH TIMEOUT = 60m
- /**
- output()
- **/
- ;
|