// fomo · indexer

Fomo Historical Data Indexer

Fomo social-trading activity - traders, the wallets behind them, their trades, positions and realized PnL - in a SQL-queryable ClickHouse warehouse.

Fomo · indexer● live
access
SQL
indexed by
trader
01.WHAT'S INCLUDED// Fomo · indexer
  • Direct ClickHouse SQL over the activity history
  • Traders resolved to their on-chain wallets
  • Trades with token, side, size and timestamp
  • Positions and realized PnL over any window
  • Custom REST endpoints, quoted per scope
// factsSPEC
Subject
traders and their activity, not blocks
Networks covered
Solana and the major EVM chains
Coverage
wallets · trades · positions · realized PnL
Refresh
continuous updates
Interfaces
ClickHouse SQL + custom REST
Database name
fomo
Free trial
up to 24h, no card
02.HOW IT WORKS// query it like a database
query.sqlclickhouse · fomo
1SELECT trader, count() AS trades
2FROM fomo.trades
3WHERE block_timestamp > now() - INTERVAL 1 HOUR
4GROUP BY trader
5ORDER BY trades 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 fomo 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// 4 questions
What makes this different from a normal wallet API?

The unit of analysis. A generic on-chain API answers questions about an address or a transaction hash. This one is organised around the trader: a person maps to the wallets they actually trade from, so one lookup returns a whole trading profile across networks instead of a pile of unattributed addresses.

Which networks does it cover?

Fomo traders operate across Solana and the major EVM networks, and the indexer follows them rather than a single chain. That is the point: a trader who buys on one network and sells on another is one story, not two.

What can I build with it?

Copy-trading and follow signals, smart-money screens, leaderboard and performance analytics, token-level flow and holder-quality studies. Because it is plain SQL, the same warehouse backs notebooks, BI tools and production services.

How is the Fomo indexer priced and provisioned?

It is not on sale yet - the Fomo 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 Fomo Historical Data Indexer.

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