// arc · indexer

Arc Historical Data Indexer

Decoded Arc activity - stablecoin transfers, token metadata and contract events - in a SQL-queryable ClickHouse warehouse instead of thousands of RPC calls.

Arc · indexer● live
access
SQL
gas token
USDC
01.WHAT'S INCLUDED// Arc · indexer
  • Direct ClickHouse SQL over decoded history
  • Stablecoin transfers with sender, recipient, amount
  • ERC-20 token identities and metadata
  • Contract events decoded, not raw logs
  • Gas and EIP-1559 fee fields on every row
  • Custom REST endpoints, quoted per scope
// factsSPEC
Coverage
transfers · tokens · decoded contract events
Chain
Arc - Circle Layer 1, USDC as native gas
Refresh
continuous updates
Interfaces
ClickHouse SQL + custom REST
Database name
arc
Free trial
up to 24h, no card
02.HOW IT WORKS// query it like a database
query.sqlclickhouse · arc
1SELECT wallet, SUM(size) AS vol
2FROM arc.fills
3WHERE ts > now() - INTERVAL 1 HOUR
4GROUP BY wallet
5ORDER BY vol DESC LIMIT 20
→ 200 OK · 82ms · joins, CTEs, window fns
// HOW TO QUERY
Connect with any ClickHouse client — DBeaver, DataGrip, psql, or the Python client — against the arc database, then write SQL with joins, CTEs, and window functions.
// INTERFACES
Direct ClickHouse SQL, or a custom REST endpoint shaped to a recurring query (quoted per scope).
03.FAQ// 3 questions
Why index a chain that already has fast RPC?

Because RPC answers one question at a time. Arc produces a block roughly every half second, so a question like "every USDC transfer above a threshold last month, grouped by counterparty" is tens of thousands of RPC calls and a pile of decoding. In SQL it is one query.

What about the USDC decimals trap?

It is handled at index time. USDC on Arc behaves as 18-decimal native gas and as a 6-decimal ERC-20, a difference of 10^12 that silently corrupts naive pipelines. The warehouse stores raw integers and records which convention each column follows, so the ambiguity never reaches your query.

How is the Arc indexer priced and provisioned?

It is not on sale yet - the Arc indexer is in build. Tell us on Telegram which tables you need and roughly how you will query them, and you go to the front of the queue when it opens. Billing, when it opens, is the same as everything else here: crypto-only, monthly and prepaid.

Get Arc Historical Data Indexer.

Set up over Telegram with an engineer — endpoint, token, tuning.