Backtest with real trades
Study historical market behavior and evaluate a strategy before you put capital behind it.
Ask your own questions of trading data. Query raw market tables with SQL to research strategies, test ideas, and build products on your terms.
EXAMPLE QUERY · SOLANA
SELECT block_time, direction, base_token, quote_token
FROM pumpswap_all_swaps
LIMIT 5;Explore the underlying trades. Follow your own hypothesis.
BUILT FOR OPEN-ENDED RESEARCH
A fixed endpoint returns a fixed answer. SQL lets you filter, join, and aggregate the available tables around the question your team is actually exploring.
Study historical market behavior and evaluate a strategy before you put capital behind it.
Examine swaps, fills, positions, and token activity to turn a hunch into a testable hypothesis.
Feed research, dashboards, and models with the market data your product needs.
FOUR DATASETS FOR YOUR QUESTIONS
Select a dataset in your GetBlock account. Each dataset has its own subscription and tables.
Swaps, token launches, liquidity activity, and more.
Market metadata and filled orders for prediction market research.
Order fills, wallet positions, and perpetual market activity.
Token creations, pool activity, and on-chain trades.
FROM IDEA TO QUERY
Pick the market and access period that fit your work.
Use your GetBlock user ID and API key over the ClickHouse HTTPS protocol.
Run read-only SQL against the tables, then refine your research in the tools you already use.
Market SQL provides query access, not trading signals or a live event feed.
ACCESS THAT FITS THE EXPERIMENT
Pricing is per dataset. Select your dataset and plan in the GetBlock account.
$0 / 2 hours
Explore one dataset and run your first queries.
$29 / 24 hours
Give a focused idea a full day of investigation.
$299 / 1 month
Keep your research and analytics moving.
One free trial per account, per dataset. Query limits apply to each access plan.
GOOD TO KNOW
Have a particular research workflow in mind?
Choose your market, connect your tools, and explore the data behind your idea.