Blockchain Data Infrastructure

Stop scraping APIs. Query billions of transactions directly.

We provide direct ClickHouse access to indexed blockchain data—Solana DEX trades, HyperLiquid perpetuals, and Polymarket prediction markets. No rate limits. No pagination. Just SQL.

:::info Free Trial Request a 7-day trial — no commitment required. :::

What We Index

16 billion+ rows indexed and growing.

Why Direct Database Access?

Speed

Run complex aggregations across billions of rows in seconds. ClickHouse is built for analytical queries.

-- Count pump.fun trades in the last hour
SELECT count(*) FROM pumpfun_all_swaps
WHERE block_time > now() - INTERVAL 1 HOUR
-- Returns in ~200ms

Flexibility

No predefined endpoints. Write any query you need—joins, window functions, custom aggregations.

-- Find wallets that traded the same token across multiple DEXs
SELECT signing_wallet, count(DISTINCT source) as dex_count
FROM (
    SELECT signing_wallet, 'raydium' as source FROM raydium_all_swaps WHERE base_coin = 'TOKEN'
    UNION ALL
    SELECT signing_wallet, 'meteora' as source FROM meteora_swaps WHERE base_coin = 'TOKEN'
)
GROUP BY signing_wallet HAVING dex_count > 1

Completeness

Every transaction. Every field. Historical data back to January 2024 for Solana.

Quick Start

1. Get Credentials

Request access or message @inventandchill on Telegram.

2. Connect

Use any ClickHouse client—DBeaver, Python, or direct HTTP.

import clickhouse_connect
 
client = clickhouse_connect.get_client(
    host='157.90.130.44',
    port=8123,
    username='your_user',
    password='your_pass'
)
 
df = client.query_df("SELECT * FROM raydium_all_swaps LIMIT 10")

3. Query

Browse table schemas and start exploring.

Pricing

All plans include direct support via Telegram.

Who Uses This

• Traders building execution algorithms and MEV strategies
• Researchers studying market microstructure and whale behavior
• Funds backtesting strategies on historical data
• Builders creating dashboards, bots, and analytics tools

Contact

Telegram: @inventandchill Email: [email protected] Website: web3engineering.co.uk