081.bucket.conds.or.mql 569 B

123456789101112131415
  1. SELECT stock.name AS "stock_name", stock.symbol AS "stock_symbol",
  2. 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"
  3. FROM /dsq_stock2/a_stock stock
  4. WHERE
  5. 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)
  6. OR
  7. 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)
  8. LIMIT 0, 500000 WITH TIMEOUT = 60m
  9. /**
  10. output()
  11. **/
  12. ;