I was assuming that SAMPLE BY weekly (w) is not supported. I also read some stackoverflow articles where it was described as not being supported
I ran this query though and its working fine
SELECT
time,
symbol,
first(open) as open,
max(high) as high,
min(low) as low,
last(close) as close,
sum(volume) as volume
FROM candles
WHERE symbol = 'NQ'
SAMPLE BY 1w ALIGN TO CALENDAR
ORDER BY time
QuestDB version:
8.1.1
OS, in case of Docker specify Docker and the Host OS:
Official docker image
File System, in case of Docker specify Host File System:
.
Full Name:
Abdou
Affiliation:
None
Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?
To reproduce
I was assuming that SAMPLE BY weekly (w) is not supported. I also read some stackoverflow articles where it was described as not being supported
I ran this query though and its working fine
QuestDB version:
8.1.1
OS, in case of Docker specify Docker and the Host OS:
Official docker image
File System, in case of Docker specify Host File System:
.
Full Name:
Abdou
Affiliation:
None
Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?
Additional context
No response