26.5M tick forex, trả lời trong vài millisecond.
Một lab thực hành 90 phút: nạp khoảng 26.5M tick forex từ object storage, chạy các query phân tích thị trường thực tế, và thử AI Assistant cùng Agents tích hợp sẵn. Tuỳ chọn: dashboard trực tiếp trên dữ liệu của chính bạn.
What you will do
Create a free ClickHouse Cloud service and open the SQL Console — about five minutes, and the only prerequisite for everything that follows.
One CREATE TABLE for 26.5M forex ticks, and why base and quote lead the sort key — the decision you will feel in module 04.
The same 26.5M ticks loaded twice: ClickPipes, the managed pipeline you would use in production, then the s3() one-liner — and when to reach for which.
Seven queries against 26.5M ticks, each replacing a page of SQL: approximate counts, topK, OHLC candlesticks, percentiles, -If combinators, argMax, and the sort key finale.
Hand the full-scan query from module 04 to the ClickHouse Assistant and watch it diagnose the missing sort key, then offer a skip index and a projection with ready-to-run SQL.
Point ClickHouse Agents at the service you just loaded and ask questions in natural language — it writes the SQL, runs it, and draws the chart.
Run a containerised dashboard on your laptop against your own ClickHouse Cloud service, and watch the query time and rows scanned change as you filter.
Where to take the trial next, and the fallbacks for anything that went wrong along the way.