example.sql

/*
If last close exists: open = last_close, else open = first(price)
*/
SELECT 
time_bucket('1 day', time) AS bucket,
symbol,
CASE 
	WHEN LAST(price_close, time) IS NOT NULL THEN LAST(price_close, time)
	ELSE FIRST(price_open, time)
END AS price_open
FROM stocks_intraday
GROUP BY bucket, symbol
LIMIT 10