Query Engine

Analytical queries run on ClickHouse. The SQL console is not public yet; the engine and the tables are the same ones the API reads.

Dialect

ClickHouse SQL. Use toStartOfHour, count(), sum() and INTERVAL. Do not expect PostgreSQL-only functions to work.

What you can query

Live datasets: arc.blocks, arc.transactions, arc.logs, token.transfers. Building and Coming Soon tables are absent, not empty.