🖱 ClickHouse
← All demos
Simulated demo
Tables
📊
events
(2.4B rows)
📊
pageviews
(890M rows)
📊
sessions
(112M rows)
📊
orders
(6.2M rows)
SELECT toStartOfHour(ts) AS hour, count() AS events, uniqExact(user_id) AS unique_users FROM events WHERE ts >= now() - INTERVAL 24 HOUR GROUP BY hour ORDER BY hour DESC LIMIT 10
▶ Run query