A practical guide to querying DateTime columns in ClickHouse using the NYC taxi dataset. Covers key functions including toStartOfHour, toStartOfFifteenMinutes, formatDateTime, dateDiff, toDayOfWeek, and countIf. Demonstrates real-world use cases: bucketing trips by hour, analyzing 15-minute rush hour windows, computing average taxi speeds using dateDiff, and comparing weekday vs weekend trip patterns using window functions and the lag function.
Table of contents
Importing the New York City taxi dataset #Trips by hour #Rush hour in 15-minute windows #What does rush hour feel like? #Weekdays vs weekends #Sort: