Real-Time Market Analytics
26.5M forex ticks, answered in milliseconds.
A 90-minute hands-on lab: load ~26.5M forex ticks from object storage, run real market-analytics queries, and try the built-in AI Assistant and Agents. Optional live dashboard on your own data.
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.