DEV Community

Discussion on: Building ClickHouse Dashboard and crunching WallStreetBets data πŸ’ΈπŸ€‘

neskodi profile image
Sergio Neskodi

Thanks Igor! Totally makes sense now. I didn't know that your source dataset contained only one candle per day. In this case, taking the average is fully reasonable.

I imagined something like my dataset where I have one-minute candles and I must aggregate them by day.

Also, thank you for taking time to expand your answer with examples of aggregation. Very useful indeed!