Şöyle yaparız
SELECT
window_start,
window_end,
ticker,
ROUND(MAX(price),2) AS high,
ROUND(MIN(price),2) AS low
FROM TABLE(TUMBLE(
TABLE trades_ordered,
DESCRIPTOR(trade_ts),
INTERVAL '5' SECONDS
))
GROUP BY 1,2,3
;
Hiç yorum yok:
Yorum Gönder